An executive social media dashboard should fit on one page with eight tiles, each answering one question a CMO actually asks. If a tile doesn't lead to a decision, cut it. Once your data sources are connected, the layout below takes about 30 minutes to fill in each month.
TLDR: Use eight tiles: reach, engagement rate, follower change, link clicks, conversions, top post, cost per result, and a "what we change next" note. Compare each number to the last period and to a target, and keep the commentary to one line per tile.
The eight tiles, in reading order
Executives read top left to bottom right. Put the business result first and the effort last.
| # | Tile | The question it answers | Show it as |
|---|---|---|---|
| 1 | Conversions | Did social produce leads or sales? | Number, with change vs last month |
| 2 | Cost per result | What did each result cost? | Currency per lead, sale or signup |
| 3 | Link clicks | Is social sending people to us? | Number and click-through rate |
| 4 | Reach | How many people saw us? | Number, trend line |
| 5 | Engagement rate | Do they care? | Percent vs your own median |
| 6 | Follower change | Is the audience growing? | Net change, not total |
| 7 | Top post | What worked? | Thumbnail and one metric |
| 8 | What we change next | What will you do with this? | One sentence |
Notice what's missing: the total follower count. It's a vanity number that only ever goes up. Net change is the one that tells you something.
Give every number a comparison
A number on its own is a question. A number with a comparison is an answer. For each tile, show:
- Last period: the previous month, as a percent change.
- Target: the line you agreed in advance.
- A colour rule: green at or above target, amber within 10%, red below. Write the rule at the bottom of the page so nobody argues about it.
For engagement, set the target against a realistic line. In Mydrop's September 2026 data, the median engagement rate per post was 3.08% on Instagram, 2.98% on TikTok and 1.11% on Facebook. The middle half of Instagram posts ran between 1.06% and 6.71%. A target above 6.7% is a stretch goal, not a KPI.
Keep platforms to one row, not one page
A CMO doesn't need five platform pages. Add a single strip under the tiles with one line per platform: reach, engagement rate and clicks. If one platform drives most of the result, say so in the "what we change next" tile.
Send platform detail as an appendix only when someone asks. The one page stays one page.
Write the commentary last, and make it one line
Each tile gets a single sentence that says why the number moved, not what the number is. The reader can see the number.
- Weak: "Reach was 214,000."
- Strong: "Reach rose 18% because the product-launch Reel was shared in DMs."
If you can't explain a move, say so and name who's looking into it. Executives trust "we don't know yet" more than a confident guess that turns out to be wrong.
Build it once and let it refresh
A template only saves time if nobody retypes the numbers. Two ways to get there:
- A spreadsheet connected to exports. Free, but someone has to paste fresh data every month and fix broken formulas.
- A reporting tool. In Mydrop, social media reports can be built as white-label PDFs with a share link and scheduled delivery, so the page lands in the executive's inbox on the first of the month. If you run several brands, the performance view lets you compare accounts against their own medians in one table.
Whichever you choose, freeze the layout. Changing the tiles every month makes trends impossible to read.
Fill in the eight tiles for last month today
Open last month's numbers and fill in the table above, even by hand. Set one target per tile and write one sentence of commentary for each. Show it to one executive and ask which tile they'd remove. That feedback shapes the template better than any design.
For the metrics behind the tiles, read the 4 metrics that actually prove ROI, or try Mydrop free to automate the monthly send.
Google review
Trustpilot review
Product Hunt comment
