5.3Reporting & dashboards
The essentials in 30 seconds
- 1 page, 5 minutes: objectives → numbers (indicators) → 3 findings max → dated actions — decides, not decorates.
- Curves, not blocks: 6-12 month trends, bars to compare, indicators vs targets — 1 chart = 1 message.
- Number + story: each number has its cause and its decision — we tell what we do next.
Threaded mini-case — Nour wins budget
Nour runs the monthly: objectives (50k views, 4% engagement, 200 clicks), numbers (62k green, 3.1% red, 240 green), finding (reach OK via Reels, low engagement), decision (1 question post per week + test). Sequel of cases 5.1-5.2 — Nour moves from listening to reporting that decides.
Sequel of cases 5.1-5.2 — Nour moves from listening to reporting that decides.
1. The one-page report
Objectives (reminder) → numbers (green/red indicators) → findings (3 max) → actions (dated): one page, read in 5 minutes, that decides. Nour sends it monthly and presents it in 15 min.
Reporting that does not decide decorates: each red leaves with action, owner and budget if needed.
2. Visualize: curves, not blocks
6-12 month curves (trends), bars (compare formats and networks), indicators (vs targets), zero raw tables: executives read the slope, not the rows. One chart = 1 message.
Nour archives 12 months: the series tells the strategy better than any isolated point.
3. Tell the story: number + story
“Reach ×2 thanks to behind-the-scenes Reels (3/week) → we double down”: each number has its cause and its decision. Reporting tells what we do next, not what happened.
It also proves the value of social media work: visible results, progress toward objectives, justified investment.
🔎 Concrete example — Monthly report that wins budget
Nour's page, read in 5 minutes.
Objectives: 50k views, 4% engagement, 200 clicks.
Numbers: 62k OK | 3.1% low | 240 OK.
Finding: reach OK (Reels), engagement low (few questions).
Decision: +1 question post/week + test -> checked next month.Takeaway: the red has an action, the action a budget.
Lesson: archive: 12 months tell the strategy.
Section vocabulary
- Reporting
- Gathering KPIs in a clear document to track, decide and prove.
Simple example: Nour's monthly page sent then presented in 15 min.
What it is not: 20 pages of raw tables never read.
Reflex: does my page read in 5 minutes?
- Dashboard
- A synthetic, visual view of key KPIs, at a glance.
Simple example: Nour's green/red indicators + 2 twelve-month curves.
What it is not: a flood of numbers with no visuals.
Reflex: would an executive understand without explanation?
- Goal-oriented
- Each indicator is read vs the set goal.
Simple example: 62k for 50k targeted: Nour ticks green and explains.
What it is not: numbers with no reminder of objectives.
Reflex: which objective does this number inform?
- Comparative
- 6-12 month trend + gap to target, never an isolated point.
Simple example: 3.1% for 4% targeted, falling 2 months: Nour acts.
What it is not: a month's number with no past or target.
Reflex: where is the curve and where is the target?
- Action-oriented
- Each gap commands a lesson + dated recommendation.
Simple example: Low engagement -> 1 question post/week + test.
What it is not: noting the red without deciding.
Reflex: does each red have action + owner?
In practice — Build a social media report
- Gather your key KPIs in a synthetic visual (charts), not a flood.
- Make it goal-oriented: progress vs set goals.
- Make it comparative: trends + targets.
- Conclude with actions (Excel, exports or Power BI): lessons + recommendations.
Ready-to-say script — presenting the red (1 min)
“Engagement at 3.1% for 4% targeted, falling for two months: likely cause, too few question posts. I propose 1 question post a week plus a small test; we check next month. Who approves?”
Say in review: fact, gap, cause, action, deadline — then note the decision.
Copy-paste template — 1-page reporting
MONTH'S OBJECTIVES: _______________
NUMBERS (indicators vs targets): _______________
FINDINGS (3 max): _______________
CAUSE + DATED DECISION (per gap): _______________
ARCHIVING (month kept): _______________Small business / tight budget
Nour does everything in a spreadsheet: native exports + 2 charts, zero paid tool.
SME Algiers
Nour presents to the manager in 15 min: 1 printed page, 3 findings, 2 decisions.
Multi-network volume
If several networks: 1 curve per network + bars per format, still 1 page.
Power BI link
When data grows: automate curves and indicators, keep the same page.
✓ Best practices
- Keep 1 page, readable in 5 min.
- Show curves + indicators, never raw data.
- End each gap with cause + decision.
✗ Common pitfalls
- The 20 pages of tables.
- The isolated point with no trend.
- Reporting as decoration with no decision.
Key takeaways
- Good reporting: synthetic, goal-oriented, comparative, action-oriented.
- An isolated number says nothing: trend + gap to objective does.
- Excel, exports or Power BI by volume.
- Reporting manages and proves the value of the work.
48h challenge — apply tomorrow
Build your 1-page reporting of the month (template above): objectives, indicators, 3 findings, 1 dated decision per red.
- I can structure 1 page that decides.
- I read trend + gap, not isolated points.
- My month's reporting is ready to present.
Frequently asked questions
What is reporting for, beyond looking pretty?
Managing on facts (adjusting), proving value (justifying time and budget), aligning (common view) and tracing (comparing periods). The pretty serves substance: making information clear and convincing.
Which tools for reporting?
Native + spreadsheet to start (often enough), Power BI to automate on large volumes, scheduling tools to centralize. Choose by need, not fashion.
Nour delivers 20 pages of raw tables with no decision. Verdict?