Social Media Reporting SKILL.md

This is the exact file agents read, including the credit header and licence notice. Save it as social-media-reporting/SKILL.md.

---
name: social-media-reporting
description: "Report organic social by goal: metrics for reach, engagement, growth, community, traffic, leads, sales, care, employer brand and video, consistent engagement rate definitions, UTM and self-reported tracking, dashboards, content analysis by format, topic, hook and voice, benchmarks, outlier handling and monthly reports that end with decisions. Use whenever someone asks for social media reporting, social media metrics, KPIs for organic social, engagement rate, social media ROI, social dashboards or how to report social results to leadership."
license: CC-BY-4.0
metadata:
  author: Afeez Adebayo
  author_url: https://afeezadebayo.com
  author_linkedin: https://www.linkedin.com/in/afeez-adebayo/
  author_x: https://x.com/za_icon
  source: https://afeezadebayo.com/skills-md/marketing/social-media/social-media-reporting/
  category: marketing
  subcategory: social-media
  version: "1.0.0"
  created: "2026-10-10"
  updated: "2026-10-10"
---

# Social Media Reporting

Social reports often fill slides with follower counts, impressions and likes, then leave leadership asking what any of it means for the business. Platform analytics change definitions, organic reach varies week to week and much of social's value (dark social sharing, brand familiarity, trust) never appears as a tracked click. Good reporting picks metrics that match each platform's goal, separates signal from noise, combines native analytics with web and CRM data, and ends with decisions.

This skill builds organic social reporting: metrics by goal, consistent definitions, data sources, dashboards, content performance analysis, benchmarks, attribution approaches including self-reported answers, cadence and decisions. Paid social reporting sits in the Performance Marketing `paid-media-reporting` skill.

## Operating principles
1. **Metrics follow goals.** Awareness, engagement, community, traffic, leads, sales, hiring and support each need different measures.
2. **Rates over raw counts.** Engagement rate, save rate and click rate allow fair comparisons.
3. **Patterns over single posts.** Analyse formats, topics and hooks, not just viral outliers.
4. **Connect to the business.** Web analytics, CRM and self-reported attribution show what social contributes.
5. **Every report ends with decisions.** What to do more of, less of and next.

## Metrics by goal
| Goal | Primary metrics | Supporting metrics |
|---|---|---|
| Awareness and reach | Reach among target audience, non-follower reach, video views | Impressions, share of voice |
| Engagement | Engagement rate, saves, shares or sends, meaningful comments | Likes, reactions |
| Audience growth | Net follower growth, follows from posts, target-role followers | Profile visits |
| Community | Active members, replies, member-to-member answers | Sentiment |
| Traffic and leads | Link clicks, social sessions, sign-ups, demo requests | Engaged sessions |
| Sales | Conversions and revenue from social, codes, shop sales | Assisted conversions |
| Customer care | Response time, resolution rate, satisfaction | Volume by issue |
| Employer brand | Applications citing social, career page visits from social | Employee post reach |
| Video | Average watch time, completion rate, retention | Views |

## Engagement rate definitions
| Definition | Formula | Note |
|---|---|---|
| By reach | Engagements ÷ reach | Best for comparing posts |
| By impressions | Engagements ÷ impressions | Common in some tools |
| By followers | Engagements ÷ followers | Useful for benchmarking accounts |
Choose one definition, document it and use it consistently.

## When to use, and when not to
Use it to set up social dashboards, prepare monthly or quarterly reports, justify investment, compare platforms and guide content decisions.

Don't use it for paid social performance (the Performance Marketing skills) or overall marketing attribution (the Growth Marketing `growth-reporting` skill).

## Inputs to ask for, in one message
1. Goals per platform.
2. Native analytics exports (6 to 12 months).
3. Web analytics with UTM-tagged social traffic and conversions.
4. CRM or sales data where social influences deals.
5. Listening and community data.
6. Audience for the report and decisions they make.

## Workflow

### Step 1. Agree goals and metrics
One or two primary metrics per platform; consistent definitions.

### Step 2. Set up tracking
UTM conventions for every link, link-in-bio tools with tracking, conversion events, a self-reported field ("How did you hear about us?").

### Step 3. Build the dashboard
Platform metrics, web outcomes, community and care metrics, trends over time.

### Step 4. Analyse content
Group posts by format, topic, hook and voice; compare rates.

### Step 5. Benchmark
Against your own history first, then peers where data is comparable.

### Step 6. Connect to outcomes
Social sessions, conversions, assisted conversions, self-reported answers, branded search trends.

### Step 7. Write the report
Summary, results versus goals, what worked, what didn't, decisions.

### Step 8. Review cadence
Weekly content check, monthly report, quarterly strategy review.

## Monthly report template
```
# Social report: <month>
## Summary (3 sentences: results, key insight, decision)
## Results versus goals by platform
## Top and bottom content (formats, topics, hooks)
## Community and care
## Business outcomes (traffic, leads, sales, applications)
## Listening highlights
## Decisions and next month's focus
```

## UTM convention
```
utm_source = platform (linkedin, instagram, tiktok, x, youtube)
utm_medium = social (organic) or employee or creator
utm_campaign = campaign or series name
utm_content = post format or specific post ID
```
Document the convention, use a link builder and audit links monthly; inconsistent tagging is the most common reason social traffic disappears into direct or referral in analytics.

## Content analysis table
| Group | Posts | Median reach | Median engagement rate | Saves per 1,000 reach | Clicks | Notes |
|---|---|---|---|---|---|---|
| Reels: customer stories | 12 | | | | | Best for new customers |
| Carousels: tips | 10 | | | | | Highest saves |
| Single images: product | 8 | | | | | Lowest reach |
Medians reduce the effect of one viral post.

## Benchmarks
Compare against your own last quarter and last year first, because audience, platform and format mixes differ widely between brands. Use industry benchmark reports only as rough context, and make sure definitions match before comparing.

## Self-reported attribution
Add "How did you hear about us?" to sign-up, demo and checkout forms with an open text field. Code answers monthly; social, creators and employee posts often appear far more than click tracking suggests.

## Decisions section
Every report lists: formats and topics to do more of, things to stop, tests for next month, resource shifts between platforms and tracking fixes needed.

## Reporting by audience
| Audience | Focus |
|---|---|
| Social team | Weekly content performance and tests |
| Marketing leadership | Monthly results versus goals and decisions |
| Executives | Quarterly business outcomes, trends and investment asks |

## Further reading
- Sprout Social Index: https://sproutsocial.com/insights/index/

## Edge cases and judgement calls
| Situation | What to do |
|---|---|
| Leadership wants ROI | Show outcomes with ranges, self-reported data and examples alongside costs |
| Platform changes metric definitions | Note the change and avoid misleading comparisons |
| One viral post distorts averages | Report medians and exclude outliers in trend analysis |
| Dark social sharing | Use self-reported attribution and branded search trends |
| Many platforms, small team | Report primary metrics only; drop vanity metrics |

## Handoffs to related skills
- Audit: `social-media-audit`
- Strategy and goals: `social-media-strategy`
- Community metrics: `community-building`
- Listening: `social-listening`
- Content and PR measurement: the Content, Copy and PR `content-pr-measurement` skill
- Paid social reporting: the Performance Marketing `paid-media-reporting` skill

## Worked example
A consumer brand's monthly social report showed follower counts and impressions across six platforms, and leadership questioned the budget. The new report set goals per platform, measured engagement by reach, saves and shares, tracked social sessions and conversions with consistent UTMs, added a "How did you hear about us?" field and analysed content by format and hook. Reports showed Reels with customer stories drove most new customers and TikTok tutorials drove most saves, while Facebook contributed little. Budget and time shifted accordingly, and leadership approved a creator programme based on the results.

## Output format
```
# Social reporting plan: <brand>, <date>
## Goals and metrics by platform
## Definitions
## Tracking setup
## Dashboard design
## Content analysis method
## Monthly report template
## Review cadence and decisions
```

## Common mistakes
- Reporting follower counts and impressions as success.
- Inconsistent metric definitions.
- Judging by single viral posts.
- No link to web or CRM outcomes.
- Reports without decisions.

## Questions to ask before you build
- What is each platform supposed to achieve?
- How are social links tagged and tracked?
- Who reads the report, and what will they decide?

## Self-check before you answer
- Are metrics tied to goals with consistent definitions?
- Is content analysed by patterns?
- Are business outcomes included?
- Does the report end with decisions?

---
Created by Afeez Adebayo, Marketing, SEO & Growth Expert
Website: https://afeezadebayo.com
LinkedIn: https://www.linkedin.com/in/afeez-adebayo/
X: https://x.com/za_icon
Source: https://afeezadebayo.com/skills-md/marketing/social-media/social-media-reporting/

Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). You may copy, share and adapt this skill, including for commercial use, as long as you credit Afeez Adebayo and link to the source URL above. Keep this notice in any copy or adapted version.