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:

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.

Step 9 — Telegram

Notify: reply(chat_id="YOUR_CHAT_ID", text="...") Format:

📊 Social Analytics — {period}
👥 Total followers: {N} ({delta})
📹 YouTube: {subs} sub | {eng}% eng
📸 Instagram: {followers} fol | {eng}% eng  
💼 LinkedIn: profile connected
🏆 Top: "{best content}" ({platform}, {eng}%)