How to build a social media report that answers something
The average social media report is forty slides and answers nothing. Start from the decision, put four numbers on the first page and give every one of them a comparison.

The average social media report is forty slides and answers nothing. Everyone involved knows it, and it gets sent anyway.
The problem is almost never the data. It is that nobody agreed on the question before building it.
Start from the decision, not the metrics
A report exists to support a decision. Before opening any tool, write down the decision it feeds. Whether to run the campaign again. Whether the new format works. Whether the sponsorship was worth the fee. Each of those needs a different report, and none of them needs all the metrics.
Tell us the decision you need to support and we will tell you which figures answer it.
Tell us the decision you need to support
The four numbers that belong at the top
Volume, reach, engagement and concentration. In that order, on the first page, with the comparison against the previous period next to each. Volume is how much was said. Reach is how many times it was seen. Engagement is how much it provoked. Concentration is whether a few posts carried it or the load was spread.
Everything after that page is evidence for those four. If a chart does not support one of them, it is decoration.
Why a comparison is not optional
A number without a reference point cannot be judged. Forty thousand mentions is meaningless on its own. Give every headline figure a comparison: the previous period, the same period last year, or a competitor measured identically. Without one, the reader invents their own reference and usually gets it wrong.
If it is the first report and there is nothing to compare against, say so. That is more useful than a number floating on its own.
The composition section nobody includes
Split the conversation by format and put the share of volume next to the share of reach. Posts with an image, posts with a link, replies against originals, verified accounts against the rest.
The interesting result is always a mismatch. A format that is 20% of the posts and 60% of the reach is telling you exactly what to do next quarter.
This is the section clients remember, and it takes one table.
How to handle the peak
Most reports show a daily line chart and stop there. For anything that happened over hours rather than weeks, that chart hides the finding. Group by hour instead and identify when it peaked. Then line the peak up against what you did: a post, a press release, a speaker going on stage. That connection is the whole point of having the timeline.
Making the report checkable
The reports that survive scrutiny are the ones where someone can verify a figure. That means naming the query, the period and the source, and being able to hand over the underlying rows on request. If the methodology section fits in two lines, it should be there.
We deliver the report and the dataset behind it, gathered within the Twitter compliance rules, so any number in it can be traced back to the posts it came from.
A structure that works
Four numbers and their comparison. Timeline with the peak identified. Top posts and top accounts. Composition by format. One page of what it suggests doing. Six sections, and the last one is the one people read. Tell us what you need to report on and we will build it around that.