Why this matters
A monthly export that nobody reads is a measurement, not a report. The social media reporting guide sets out what a report is for: a goal per platform, the metric that measures it, a comparison with the brand's own history and a decision section. None of that works if social visits cannot be traced to what the business sells, and that depends on link tagging done to a convention, which the guide to naming conventions and UTMs covers. This exercise joins the two: the report is only as honest as the links behind it.
The monthly data
Glasshouse Gallery is an invented glass and ceramics gallery. Exhibitions are ticketed online; talks and workshops are promoted through Facebook events linking to the same ticketing pages. The coordinator emails platform exports to the director monthly, and she does not know what to do with them.
The roles the gallery agreed at the start of the year: Instagram for consideration, meaning visits to exhibition pages and ticket sales; Facebook for community, meaning talk and workshop bookings from regular visitors; TikTok as an awareness pilot, meaning ReachUnique people who saw an ad. among people who have not seen the gallery before.
Glasshouse Gallery: October's raw data
Platform exports, October against the gallery's own six-month median:
| Platform | Measure | October | Six-month median |
|---|---|---|---|
| Reach | 41,000 | 35,000 | |
| Saves | 620 | 410 | |
| Link taps | 540 | 300 | |
| Event responses | 160 | 140 | |
| Comments | 95 | 110 | |
| TikTok | Views | 22,000 | 9,000 |
| TikTok | Share of views from non-followers | 74% | 61% |
Analytics sessions by source and medium, October:
| Source / medium | Sessions |
|---|---|
| instagram / social | 210 |
| Instagram / Social | 85 |
| ig / story | 40 |
| l.instagram.com / referral | 380 |
| facebook.com / referral | 150 |
| m.facebook.com / referral | 90 |
| tiktok.com / referral | 60 |
Ticketing system, October: 1,450 exhibition tickets sold online; 64 bought in sessions from any Instagram source (six-month median 48); 21 talk or workshop bookings from Facebook sources (median 26); 3 tickets from TikTok sessions.
Context: the "Salt and Glass" exhibition opened on 14 October, and the school half-term fell in the last week.
Choosing what to report
Start from the role, not the export. Each platform gets one goal metric, its KPIA metric tied directly to an objective., and only the supporting metrics that explain its movement. Instagram's goal metric is tickets from Instagram sessions; reach and saves explain it. Facebook's is bookings from Facebook sources; event responses and comments explain it. TikTok's is reach among non-followers; ticket sales from a pilot are context, not a target.
Compare each with the gallery's own median, not with a published benchmark, and note the context that explains any outlier. Report per platform; never add reach across platforms, because the definitions differ.
Task
- Write the question the October report answers, in one sentence, for the director.
- For each platform, state the goal metric, the October figure, the baseline and whether the month was typical, better or worse.
- Identify every problem in the analytics sources table and say what it does to the figures.
- Write a tagging convention for the gallery's social links: the values for source, medium, campaign and content, with the case and separator rules, and the links that need it.
- Write the report on one page: question, results against baseline, context, what was learned, decisions with owners and a check date.
- Add a line that the November report must open with.
Worked answer
The question. "Is each platform doing the job we gave it, and what do we change in November?"
Results. Instagram is better than typical on its goal metric and on both supporting metrics. Facebook is slightly below typical on bookings despite more event responses, so the responses are not turning into bookings. TikTok's pilot is reaching more new people than usual, which is what it was asked to do.
Tagging problems. The same source appears as instagram, Instagram and ig, and the medium as social,
Social and story, so one platform is split across several rows, and a non-standard medium may fall outside the
organic social channel. The largest Instagram row is an untagged referral, most likely the link in the bio. Every
Facebook and TikTok visit is untagged, so nobody can tell which post or event drove it.
The convention and the report's arithmetic
| Field | Value |
|---|---|
utm_source | instagram, facebook or tiktok, lower case |
utm_medium | social for every organic post; paid posts use the paid medium from the convention |
utm_campaign | exhibition-salt-and-glass-2026q4, talks-2026q4 |
utm_content | link_in_bio, story_link, event_page, post_caption |
Instagram sessions in October, all rows: 210 + 85 + 40 + 380 = 715. Tickets from them: 64, against a median of 48, up 16 or a third. Facebook sessions: 240, with 21 bookings against a median of 26.
Report decisions: tag the link in bio and every story link through the shared builder (coordinator, by 7 November); move Facebook talk posts to the event page link with a tagged URL, and test a reminder post two days before each talk (coordinator, review on 1 December); keep TikTok's pilot to two posts a week and report non-follower reach only until the January review (director).
What was learned. The exhibition opening and half-term explain part of Instagram's lift, so November will show whether it holds. Facebook responses without bookings point to the click from event to ticketing page, not the posts.
The November opening line. "Last month we agreed three changes; here is whether each was done and what happened." That closes the loop and makes the decision section worth reading.
Common mistakes
- Sending the export. A list of every metric hides the decision; pick one goal metric per platform.
- Benchmarks instead of the gallery's own history. Only the baseline says whether October was good.
- Ignoring mixed case and invented mediums. One platform split across rows understates it and confuses everyone.
- Leaving the bio link untagged. It is often the largest source of social visits and the hardest to trace later.
- No owner or date on decisions. Next month's report cannot check what nobody owned.
Before the capstone, run the gallery's accounts through the social media presence audit in your head: the reporting row is the one this exercise fixes. Then move on to the social media strategy capstone, or return to the intermediate social media level.
