| 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:
- Total followers (sum of all accounts across all platforms)
- Total publications in the period (YouTube videos + Instagram posts)
- Average engagement rate weighted by platform
- Platform with highest growth (follower delta, if previous report exists)
- 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.
