/social-analytics-report

name: social-analytics-report
description: "Unified social media analytics report — consolidates YouTube, Instagram, and LinkedIn data into one cross-platform HTML dashboard. Compares engagement, followers, top content across all platforms. Use when user says 'social analytics', 'social media report', 'social report', 'social metrics', 'cross-platform', or any reference to unified social media performance."

Social Analytics — Consolidated Cross-Platform Report

Routine that pulls data from ALL connected social platforms (YouTube, Instagram, LinkedIn) and generates a single comparative HTML report.

**Always respond in English.** **Agente:** @pixel

Workflow

Step 1 — Collect data from all platforms (silently)

Execute the scripts for each integration and capture the results:

YouTube (all accounts)

python3 {project-root}/.claude/skills/int-youtube/scripts/youtube_client.py summary
python3 {project-root}/.claude/skills/int-youtube/scripts/youtube_client.py recent_videos 1 10

Instagram (all accounts)

python3 {project-root}/.claude/skills/int-instagram/scripts/instagram_client.py summary
python3 {project-root}/.claude/skills/int-instagram/scripts/instagram_client.py recent_posts your_account 10
python3 {project-root}/.claude/skills/int-instagram/scripts/instagram_client.py recent_posts secondary_account 10

LinkedIn (all accounts)

python3 {project-root}/.claude/skills/int-linkedin/scripts/linkedin_client.py summary

If any platform fails or has no data, include in the report as "No data — platform not configured or API limited" without breaking the report.

Step 2 — Consolidate cross-platform metrics

Calculate:

1. **Total followers** (sum of all accounts across all platforms) 2. **Total publications** in the period (YouTube videos + Instagram posts) 3. **Average engagement rate** weighted by platform 4. **Platform with highest growth** (follower delta, if previous report exists) 5. **Platform with highest engagement** (compare engagement rates)

Step 3 — Build comparison table

One row per account:

| Platform | Account | Followers | Delta | Posts | Engagement | Best Content | |------------|-------|-----------|-------|-------|------------|-----------------| | YouTube | Your Channel | 7.450 | — | 27 | 7.0% | "Evo v3 chegando" | | Instagram | your_account | 686 | — | 18 | 3.9% | "Evo V3 funcionalidades" | | Instagram | secondary_account | 273 | — | 76 | — | — | | LinkedIn | Your Profile | — | — | — | — | Perfil apenas |

Step 4 — Top cross-platform content

Rank the top 10 content from ALL platforms by engagement (likes + comments / views or followers). Show:

• Platform
• Title/caption (summary)
• Views or reach
• Engagement %
• Link

Step 5 — Compare with previous period

Read the previous report in `workspace/social/reports/consolidated/` if it exists. Calculate deltas for:

• Followers per platform
• Average engagement
• Publication volume

Step 6 — Cross-platform insights

Generate analysis with:

• Which platform is growing the most?
• Which content type performs best where? (video on YouTube vs image on Instagram)
• Publication frequency per platform
• Recommendations: where to invest more content, which format to prioritize
• Platforms without data (LinkedIn posts, etc.) — what is missing to unlock

Step 7 — Generate HTML

Read template `.claude/templates/html/custom/social-analytics-report.html` and fill all `{{PLACEHOLDER}}`.

`{{REPORT_TYPE}}` depende da frequência:

• Daily: "Daily"
• Weekly: "Weekly"
• Monthly: "Monthly"

For comparison table rows:

<tr>
  <td><span class="badge blue">YouTube</span></td>
  <td>Your Channel</td>
  <td class="right">7.450</td>
  <td class="right delta up">+32</td>
  <td class="right">27</td>
  <td class="right">7.0%</td>
  <td>Evo v3 chegando...</td>
</tr>

For platforms without data:

<tr style="opacity:0.5">
  <td><span class="badge muted">LinkedIn</span></td>
  <td>Your Profile</td>
  <td class="right">—</td>
  <td class="right">—</td>
  <td class="right">—</td>
  <td class="right">—</td>
  <td style="color:var(--text-muted)">API limited — profile only</td>
</tr>

For `{{MISSING_INTEGRATIONS}}` — if any platform is not configured:

<div class="highlight-card" style="border-color: rgba(102,112,133,0.3);">
  <div class="title" style="color: var(--text-muted);">Pending Integrations</div>
  <div class="body">
    <ul style="list-style:none;padding:0;">
      <li>LinkedIn — Posts and Company Page (requires Community Management API)</li>
      <li>Twitter — Not configured</li>
    </ul>
  </div>
</div>

Step 8 — Save

workspace/social/reports/consolidated/[C] YYYY-MM-DD-social-analytics.html

Create directory if it does not exist.