Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Social Media Marketing › Intermediate

Building a Monthly Social Report for a Gallery

An exercise in turning an invented gallery's platform exports and analytics data into a one-page monthly report that a director will read. You choose a goal metric for each platform, compare the month with the gallery's own history, repair its link tagging so social visits can be traced to ticket sales, and end with decisions.
ExerciseIntermediate levelModule 3: Reporting and audits5 minUpdated

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 Reach among people who have not seen the gallery before.

Illustrative example — not a real result

Glasshouse Gallery: October's raw data

Platform exports, October against the gallery's own six-month median:

PlatformMeasureOctoberSix-month median
InstagramReach41,00035,000
InstagramSaves620410
InstagramLink taps540300
FacebookEvent responses160140
FacebookComments95110
TikTokViews22,0009,000
TikTokShare of views from non-followers74%61%

Analytics sessions by source and medium, October:

Source / mediumSessions
instagram / social210
Instagram / Social85
ig / story40
l.instagram.com / referral380
facebook.com / referral150
m.facebook.com / referral90
tiktok.com / referral60

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 KPI, 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

  1. Write the question the October report answers, in one sentence, for the director.
  2. For each platform, state the goal metric, the October figure, the baseline and whether the month was typical, better or worse.
  3. Identify every problem in the analytics sources table and say what it does to the figures.
  4. 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.
  5. Write the report on one page: question, results against baseline, context, what was learned, decisions with owners and a check date.
  6. 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.

Illustrative example — not a real result

The convention and the report's arithmetic

FieldValue
utm_sourceinstagram, facebook or tiktok, lower case
utm_mediumsocial for every organic post; paid posts use the paid medium from the convention
utm_campaignexhibition-salt-and-glass-2026q4, talks-2026q4
utm_contentlink_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.

Pages this lesson applies

Terms used on this page

Also related

Related