How-To Guide

What should a social media report template include?

A copyable monthly template: eight report sections, one row per account, what each metric means per network, and what the numbers can honestly show.

8 min read

By the Superdirector editorial team. Written November 14, 2026. The worked numbers in the column section are a fictional layout example: no account data, customer result or industry average is claimed.

At a glance

What a monthly social media report template should include

Eight parts cover it: a one-paragraph summary, followers and net new followers, impressions or reach per account, engagement, link clicks, top and bottom posts, audience notes, and one sentence on what changes next month. Keep one row per account, put the change from the period before beside each number, and report each network in its own counting rules.

  • Copy the column grid into a sheet at cell A1 and keep one tab per month.
  • Pull private metrics, such as link clicks on X, during the reporting month; they do not stay available forever.
A numbered list of the eight report parts, from the summary line through followers, reach, engagement, clicks, top posts and audience to what changes, in reading order.

Original diagram of the eight report parts in the order a reader meets them, drawn from the outline in this article rather than from any platform report.

Superdirector

Make it work for your brand

Find it. Remake it. Post it. Superdirector turns the viral formats in your niche into your brand's carousels, X posts and video scripts, and keeps the calendar full.

What should a social media report template include?

A monthly report is one page of answer and one grid of evidence. The answer tells the reader what happened and what you will do about it; the grid holds the numbers that justify both. A template earns its keep by fixing what goes first, what gets compared and where the answer lives, so the only work left each month is filling rows.

  1. A summary line with the period, the headline result and one sentence of plan.
  2. Followers: the total per account and the net change over the period.
  3. Impressions or reach, per account, never summed across networks.
  4. Engagement: the actions posts earned, counted per post type.
  5. Link clicks: the visits the posts sent to your site.
  6. Top and bottom posts, with dates, so keep-and-stop decisions have evidence.
  7. Audience notes: who responded and what they asked about.
  8. What changes next period: one sentence, one decision the reader is asked to make.

Eight parts also cover most buyer questions directly: the summary answers what happened, the follower and reach rows answer whether more people saw the work, engagement and clicks answer whether it did anything, and the last row names the decision. Everything else in a report should earn a place against one of those questions.

Start with the eight parts, not a metrics dump

The fastest way to make a report unread is to send every reader the same wall of numbers. The working pattern is to give each part a question to answer and a reader who cares about it first, then let the other readers look for their own row.

PartThe question it answersWho reads it first
Summary lineWhat happened to the result this period?Everyone; it is the only row guaranteed to be read
Followers and net newIs the audience getting bigger or thinner?The team running the accounts
Impressions or reachHow many people saw the work?Team and client together
EngagementDid the content make people act?The content team
Link clicksDid any of it send a visit?Sales, or the founder
Top and bottom postsWhat should we repeat and stop?The content team
Audience notesWho is responding and what do they ask?Product, service, or the founder
What changesWhat do you want me to decide?Everyone

Cut any column that no row above justifies. A template with twenty metrics invites a report nobody reads, and the reader who skims it learns nothing except that the month is over.

The monthly columns: one row per account

The working sheet is one row per account per period. Copy the column grid below into a spreadsheet at cell A1, keep one tab per month so the previous period sits beside this one, and put the change for every column inside its own cell rather than at the foot of the sheet.

ColumnWhat it tells youWhere to find it
FollowersTotal followers on the last day of the periodThe account's own analytics surface
Net new followersFollowers gained minus followers lostThe account's analytics, growth view
Impressions or reachHow many times, or how many people, saw the postsThe network's analytics, per account only
Posts publishedHow many posts went out, and in which formatsYour publishing calendar
EngagementActions the posts earned on each formatThe network's per-post analytics
Link clicksVisits the posts sent to your siteThe network's private click metrics, or your site analytics
Top and bottom postsThe three that did most and the two that did leastSort the per-post table by the metric that matters
What changesOne sentence of plan and one decisionYou; this row is the point of the report

A filled month, so the shape is clear before you paste anything. Every figure below is a fictional example written to show the layout; none describes a real account, a customer or an industry average.

AccountFollowersNet newReach (vs period before)Top postPostsEngagementLink clicksWhat changes
Instagram2,340+9618,400 (up from 15,100)Photo set, 3 Nov9612141Keep weekly photo sets
X1,480-2426,000 (down from 31,500)Text post, 12 Nov2240296Cut reactive quoting
LinkedIn812+113,100 (down from 3,400)Founder note, 5 Nov68823Post the note format twice

Read the example the way a reader would: the X row is the interesting one. Reach fell while posts published stayed high, which points at frequency or format rather than reach luck, and the next-period sentence names exactly that. A report that ends after reach would have hidden the only decision in the month.

What each metric means where you pull it

The same word counts differently on each network, which is why one report row per account stays unmixed. The table condenses the official definitions; each page is linked so the wording can be checked at the source.

MetricInstagramXYouTube
ImpressionsDeprecated for media created after July 2, 2024; older media report total times seenEvery screen appearance, and the same user viewing twice counts twiceThe thumbnail shown for more than 1 second with at least half of it visible
Unique audienceReach: unique Instagram users who saw the mediaNot a public metricUnique viewers, estimated for the selected date range
ViewsTotal plays of the media objectOne total view count per video, aggregated across every post that shares itA view counts the moment playback starts, in every format
ClicksProfile taps and story link tapsLink clicks are non-public metricsSite clicks sit in traffic sources, not a public count

Two consequences follow. First, an Instagram reach number and an X impressions number cannot be added into one row, so the template keeps them side by side instead. Second, the numbers a link-click report needs are private on X, which is the next section's problem: private metrics do not wait for you.

Definitions condensed from Meta's Instagram media insights reference, X's API metrics documentation, and YouTube's own pages on key moments for audience retention and thumbnail impressions, each fetched November 14, 2026.

A four-row matrix comparing impressions, unique audience, views and clicks against the counting rule used by Instagram, X and YouTube.

Original diagram condensing each network's counting rule for four metrics, from the official Instagram, X and YouTube pages linked above and fetched November 14, 2026.

What the report can and cannot honestly show

A template is honest when it respects the windows each network actually keeps. Pull outside them and the cell either arrives late or quietly shows something other than what you meant.

  1. Instagram insight data can arrive up to 48 hours late, so a pull on the last evening of the month can still change; Meta also documents data stored for up to two years and story metrics that exist for only 24 hours.
  2. When Instagram insights do not exist for a metric, the API returns an empty data set rather than a zero, so a missing cell and a real zero are different facts and the report keeps them separate.
  3. X keeps non-public, organic and promoted metrics only for posts created within the last 30 days, so private numbers such as link clicks get pulled inside the reporting month or not at all.
  4. YouTube audience retention is a video-level report, which cannot be rolled up across a channel, and its data typically takes one to two days to process.
  5. YouTube counts a thumbnail impression only when it shows for more than 1 second with at least half the thumbnail visible, so a reach read of a low-impression video may just mean the thumbnail was never really seen.

The habit to adopt: when a number is missing, the cell stays empty or says not available. A missing number is not a zero, and estimating a figure the platform never sent turns the report from evidence into fiction.

A timeline of five pull limits, ordered from Instagram's 24-hour story metrics and 48-hour insight delay through YouTube retention processing and X's 30-day private window to Instagram's two-year storage.

Original diagram of the windows that decide when a metric can exist, from the platform limits stated and linked in this section.

Match the depth to the reader

One report sent to everyone suits nobody. The same grid serves three readers when the depth is matched to them, and the working pattern is to cut toward the summary rather than write a second document.

ReaderTheir versionEmphasizeCut
Client or partnerOne page, one row per accountGrowth, reach and the best postsFormats, internal tests, every miss
The content teamThe full grid plus the per-post tableFormats, timing, the bottom postsExecutive framing
LeadershipOne screen: summary, few figures, one decisionThe result, the change, where you standPost-level numbers

Cadence follows the same rule. A monthly report is the working record; a weekly look catches a post worth repeating while the catch is still useful; a quarterly version reads patterns and serves leadership. A campaign report is its own document, written when that campaign ran, with its own goal and spend inside it rather than buried in the monthly grid.

Compare, benchmark, and end with a next step

Numbers mean little on their own; a column earns its place by being compared with something. Three comparisons do most of the work, and each needs only arithmetic the sheet can compute.

  1. Period over period: each number beside the same number from the month before, in its own cell.
  2. Format over format: engagement per post type, so the report says which format earned its slot rather than only how much engagement arrived.
  3. Account over account, within reason: follower growth rate, not raw follower counts, so a small account is not read as losing.

Beyond your own trend, one honest external point beats a pile of averages: a competitor you actually track, or an industry benchmark you can name and cite elsewhere. Whatever you compare against, keep the sizes comparable. Raw numbers lack the context that a comparison provides, which is why the template holds a column for the comparison rather than a separate appendix that nobody opens.

Close with one recommendation tied to one figure: which format gets more slots, which gets fewer, or which question the next month must answer. A report that ends on numbers without a next step is a status update, not a plan.

Copy the template into a sheet

The template is deliberately plain so it travels: select the column grid in the third section, paste it into a spreadsheet at cell A1, and the columns land in separate cells. Replace the fictional example with your own rows, one per account, and open a new tab next month so the two periods sit side by side. The same grid pastes into a slide deck for the leadership version, with the summary sentence moved to the top and everything after the reach columns cut.

If posting runs through a service, the reporting work stays the same and only the collection changes. Superdirector runs a channel as an operated AI service and records what was published there; a platform's own reach and click metrics still come from that platform, read with the definitions and timing windows above. The template is for whoever reads the numbers and for whoever writes them.

Frequently asked questions

What should a social media report template include?

Eight parts cover a monthly report: a one-paragraph summary, followers and net new followers, impressions or reach per account, engagement, link clicks, top and bottom posts, audience notes, and what changes next month. Keep one row per account, compare each column with the period before, and never add reach or impressions across networks, because each network counts the same event differently.

How often should a brand send a social media report?

Monthly is enough for most small brands, with a short weekly look to catch a post that is working while it still matters. A quarterly version serves pattern-reading and leadership, and a campaign report belongs to the campaign, written separately when one ran.

Can I add impressions or reach together across networks?

No, and the official definitions explain why. Instagram reach counts unique people while impressions can count the same account several times. X counts a screen appearance every time, repeats included. YouTube requires a thumbprint of attention, one second and half the thumbnail visible, before an impression counts.

Where do the numbers come from without a paid dashboard?

Each network's own analytics surface holds them, and each publishes its metric definitions: Meta documents Instagram media insights, X documents public and non-public metrics, and YouTube documents views and thumbnail impressions in Studio help. The definitions in this article come from those pages.

What should the executive page keep?

One summary sentence with the period and the result, the few figures the reader acts on, where you stand against your own previous period or a competitor you actually track, and the one decision the report needs. Every other column waits in the full grid.

Related practical guides

Fill the template from one operated account

One AI-run operated account from Superdirector costs $199 a month, posts under account-level standing posting permission and reports weekly, so the template's monthly rows fill from one place with your review in the loop.