Social Media Report Template: Free CSV with Example

What is in the report template

One file, six sections, in the order a reader needs them. The top is for the person who reads one screen, the rest is for the person who wants the proof.

• REPORT DETAILS

  Brand, period, who prepared it, the one goal for the period and the date the numbers were pulled.

• SCORECARD

  One row per network per metric, with the previous period, this period, the change and the target.

  Columns: Network, Metric (the network's own name), Previous period, This period, Change, Change (%), Target, Note

• TOP POSTS AND ONE MISS

  Your best three posts and your worst one, each with a one sentence reason you can act on.

  Columns: Rank, Date, Network, Format, Post title or link, Metric used, Result, Why it did well or badly

• WHAT WE LEARNED

  Four questions, answered after the numbers, including which number not to trust.

• NEXT PERIOD

  Three actions at most, each naming the metric it should move.

  Columns: Action, Owner, Due date, Metric it should move, Network, Status

• WHERE THE NUMBERS CAME FROM

  The screen, the date range and any estimate flag behind each network’s figures, so a number can be checked later.

  Columns: Network, Screen or report used, Date range selected, Date pulled, Estimated or delayed?, Notes

How to fill in the report, step by step

1. 1

   Write the goal first

   Put one sentence in REPORT DETAILS: what this period was meant to achieve. A report with no goal is a list of numbers, and the reader cannot tell whether they are good.

2. 2

   Pick three to five metrics per network

   Choose by the goal, not by what the dashboard shows first. Reach for awareness, interactions for response, followers for growth, clicks for traffic. The table below gives each network’s own name for them.

3. 3

   Pull the numbers on one day

   Read every network on the same day and set the same date range. Write that day in WHERE THE NUMBERS CAME FROM. Networks revise recent figures, so a number pulled on the 1st can differ from one pulled on the 3rd.

4. 4

   Fill the scorecard, then the change

   Enter the previous period and this period from the network’s screen, then work out the change as this period minus the previous one. Copy the network’s metric name exactly, and never add one network’s figure to another’s.

5. 5

   List the top three posts and one miss

   Use the metric from your goal to rank posts. For each, write why in one sentence a colleague could act on. “People liked it” is not a reason; “the first line named the product” is.

6. 6

   Write the takeaways last, then the next steps

   With the numbers in front of you, answer the four WHAT WE LEARNED questions, then set up to three actions in NEXT PERIOD. Next month’s report starts by checking whether they moved their metric.

Sample Street Bakery posts on Instagram and Facebook. This is its September scorecard with the change worked out, the top post, and what the owner took from it.

Sample Street Bakery is an invented business. Every number in this example is made up to show the arithmetic, and none of them is a benchmark for your business or for any network.

The owner’s three takeaways: process Reels reach more people than photos of finished loaves; Facebook slipped in the two weeks without the weekly event post; next month is two Reels a week and the Friday event post back on the plan. Notice that Instagram’s Viewers and Facebook’s Reach sit on separate rows. They are different measures, so the report never adds them into one “reach” figure.

What to measure, and where each network shows it

We opened each network’s own help page on October 15, 2026 and wrote down where it says to find the numbers and what it calls them. Copy the name in the second column into the scorecard exactly, because the names are not interchangeable (see the next two tables). Where a network publishes nothing, the table says so.

Same word, different number: why you cannot add networks together

“Engagement” means a different set of actions on each network, and “views”, “viewers”, “reach” and “impressions” count different things. A report that adds Instagram interactions to X engagements is adding two measures that were never meant to match. Keep one scorecard row per network and metric, and compare each against its own past.

What “engagement” counts

What “views” and “reach” count

X is left out of the second table on purpose. The page we read defines impressions in terms of ads being served, so we do not claim more for it than it says.

Five mistakes that make a social media report useless

• Adding unlike numbers

  Views, viewers, reach and impressions are not interchangeable, and each network defines them differently. Keep a row per network and metric, as the table below shows.

• Reporting everything the dashboard offers

  A reader remembers three numbers. If the scorecard has forty rows, the one that matters is buried.

• No target, no previous period

  A number alone is not good or bad. The change and the target are what turn it into a finding.

• Explaining nothing

  The top posts section is where a report earns its keep. A reason you can repeat is worth more than a chart.

• Ending without a next step

  If no action names a metric to move, next month’s report has nothing to check.