PlaybookAnalytics & Reporting

A dashboard that drives decisions, not just reports

Weekly reviews answer 'is this campaign on pace?' Monthly reviews answer 'is the system compounding?' This playbook gives you both cadences, the ten-metric dashboard, the analysis tactics and the metric-to-action table.

8 pages · 7 parts · 3 min video · Excel dashboard · PDF · 8 pages · Performance-Dashboard.xlsx · No email required

20 min

Weekly pacing review

8–10

Metrics on the front screen

1

Written decision per review

What you get

By the end of this playbook, your team can:

Split your reporting into a fast weekly pacing check and a strategic monthly system review.

Build a single-screen dashboard of eight to ten metrics, each showing a trend rather than a static number.

Run a 20-minute weekly review that ends with one written decision every time.

Judge retention, channel mix and lifetime value monthly with LTV:CAC and churn.

Use ratios and segmentation so you understand why a number moved before acting on it.

Translate each metric movement into a specific growth action using a ready-made decision table.

Step 01

The Weekly vs Monthly Rhythm

Different questions need different review cycles.

Weekly reviews answer 'is this campaign on pace?' — total raised, new donors, average gift, conversion rate, cost per donor: numbers that tell you whether to adjust spend or creative this week. Monthly reviews answer 'is the system actually compounding?' — repeat donor rate, monthly churn, donor LTV, LTV:CAC: numbers that only mean something once you see them move over weeks.

Two cadences, two jobs

Weekly (tactical & fast): pace, cost per donor, conversion. Monthly (strategic & trended): retention, churn, LTV:CAC, channel mix.

Checklist

  • A fixed weekly slot exists for the pacing review
  • Weekly review looks at the current campaign only
  • A fixed monthly slot exists, separate from the weekly one
  • Both reviews end with a written decision, not just a look
  • The same people own each cadence every cycle

Do

  • Keep the two cadences genuinely separate
  • Protect the slot in the calendar like a client meeting
  • End every review with something written down

Don't

  • Debate strategy in the weekly pacing check
  • Judge retention on a single week of data
  • Skip a cycle because 'nothing changed'

KPIs to track

  • Review completion rate

    Whether the rhythm is actually being kept

  • Decisions logged per month

    Whether reviews are producing action

  • Time from signal to action

    How fast the team responds to drift

Troubleshooting

  • Reviews keep getting cancelled

    Shorten the weekly to 20 minutes and give it a single owner

  • Every review turns into a strategy debate

    Move strategic questions to the monthly slot only

Step 02

The Core KPI Dashboard

One screen, ten numbers — everything else lives one click deeper.

The front screen exists to be scanned in seconds. Every card shows the number and its trend against the last period, so a problem is visible without anyone running a query. Detail belongs one level down, not on the main view.

A weekly front screen

Total raised $8,240 ▲12% · New donors 146 ▲6% · Avg gift $56 ▼3% · Conversion rate 3.8% ▲0.4pt · Cost per donor $24 ▼$3 — all versus last week.

Checklist

  • No more than 8–10 metrics on the front screen
  • Every card shows a trend, not just a static number
  • Dashboard updates on the same day every week
  • One person is accountable for keeping it current
  • Deeper breakdowns are one click away, not on the front screen

Do

  • Show the comparison period on every card
  • Refresh on a fixed day so the view is trusted
  • Name a single owner for data accuracy

Don't

  • Cram every available metric onto one screen
  • Show raw numbers with no comparison
  • Let the dashboard go stale between campaigns

KPIs to track

  • Dashboard freshness

    Whether anyone can trust what's on screen

  • Metrics on the front screen

    Whether the view is still scannable

  • Dashboard views per week

    Whether the team actually uses it

Troubleshooting

  • Nobody looks at the dashboard

    Too many metrics — cut to the ten that change decisions

  • Numbers are disputed in meetings

    Assign one owner and one refresh day; document the definitions

Step 03

Weekly Review

A 20-minute pacing check, not a deep-dive.

The weekly review exists to catch a campaign drifting off pace early enough to fix it. It should be fast, focused on the current campaign, and end with one clear decision.

A real weekly note

'Week 2 of 4: 38% of goal raised, on pace for 76% by close. Cost per donor up $3 — check if the cold audience needs a refresh before Friday's push.'

Checklist

  • Total raised compared against the campaign's expected pace
  • Cost per donor checked against last week, not just the target
  • Landing page conversion rate reviewed for sudden drops
  • Underperforming channel or creative flagged, if any
  • One action written down before the review ends

Do

  • Project forward to close, not just report to date
  • Compare week-on-week, not only against target
  • Assign an owner and a date to the action

Don't

  • Turn it into a full channel deep-dive
  • Review campaigns that already closed
  • Finish without a decision

KPIs to track

  • Pace vs goal

    Whether the campaign will land where it needs to

  • Week-on-week cost per donor

    Whether efficiency is drifting

  • Conversion rate trend

    Whether the page or offer is holding up

Troubleshooting

  • Campaign ends short with no warning

    Project to close every week instead of only reporting to date

  • Reviews run 60+ minutes

    Restrict scope to the current campaign and five metrics

Step 04

Monthly Review

Where you check if the whole system is actually compounding.

The monthly review looks across campaigns, not inside one. This is where retention, channel mix, and lifetime value get judged — questions that need weeks of data to answer honestly.

A real monthly note

'Repeat donor rate holding at 22%, up from 18% last quarter. LTV:CAC now 3.2:1, driven mostly by the monthly-giving upgrade sequence — worth doubling budget there next month.'

Checklist

  • Repeat donor rate and monthly churn reviewed against last month
  • Donor LTV and LTV:CAC ratio recalculated
  • Channel mix reviewed — where revenue actually came from
  • One under- and one over-performing channel identified
  • Budget reallocation decision made for next month

Do

  • Compare against last month and last quarter
  • Attribute revenue by channel before reallocating
  • Log the budget decision with an owner and review date

Don't

  • Judge a channel on one month alone
  • Reallocate budget without looking at retention
  • Repeat the weekly campaign review at a monthly interval

KPIs to track

  • Repeat donor rate

    Whether retention work is compounding

  • LTV:CAC ratio

    Whether growth is sustainable at current spend

  • Monthly donor churn

    How fast the recurring base is leaking

Troubleshooting

  • Revenue growing but LTV:CAC falling

    You're buying growth — shift budget toward retention and owned channels

  • Channel mix unclear

    Fix attribution and tracking before making budget calls

Step 05

KPI Analysis Tactics

A number moving is not the same as understanding why.

Most dashboards report numbers; few explain them. Real analysis means asking why a number moved before deciding what to do about it. Two tactics carry most of the weight: ratios over raw numbers, and segmenting before concluding.

Ratios and segments

'200 new donors' means nothing alone; '200 new donors at $18 cost per donor, down from $24' is a real signal. And a flat overall conversion rate can hide one channel improving while another declines.

Checklist

  • Every headline number has a paired efficiency ratio
  • Numbers compared to the same period last cycle
  • A moving metric is segmented before a conclusion
  • Seasonal or one-off events are noted next to the number
  • The 'so what' is written down, not just the number

Do

  • Pair every volume metric with an efficiency ratio
  • Break a metric down by channel before concluding
  • Annotate one-off events directly on the report

Don't

  • Report raw totals with no ratio
  • Draw conclusions from a blended average
  • Ignore seasonality when comparing periods

KPIs to track

  • Cost per donor by channel

    Where efficiency actually sits

  • Conversion rate by segment

    What a flat blended average is hiding

  • Period-over-period comparison

    Whether a move is real or seasonal

Troubleshooting

  • Metrics look flat but results feel off

    Segment by channel — offsetting moves are cancelling out

  • Team disagrees on what a number means

    Write the 'so what' next to every number in the report

Step 06

Turning Analysis Into Growth Actions

A dashboard that doesn't change a decision is just decoration.

Each metric movement maps to a likely action. Using a standing decision table removes the debate and turns the review into a short sequence of choices.

The decision table

Cost per donor rising with flat volume → refresh creative or audience before raising budget. Conversion falling with stable traffic → audit the landing page, not the ad. Repeat donor rate flat 2+ months → revisit thank-you and impact-update cadence. LTV:CAC improving → safe to increase acquisition budget on the winning channel. One channel far cheaper per donor → reallocate there before scaling the underperformer. Monthly churn rising → check the monthly-giving engagement stream.

Checklist

  • Each metric has a pre-agreed default action
  • Owner assigned to every action logged
  • Deadline attached to each action
  • Previous month's actions reviewed for outcome
  • Budget shifts recorded with the reason behind them

Do

  • Agree the action table before you need it
  • Fix the downstream leak before raising spend
  • Review last cycle's actions at the start of the next

Don't

  • Increase budget on a channel with rising cost per donor
  • Blame the ad when the landing page is the leak
  • Log actions with no owner or date

KPIs to track

  • Actions completed vs logged

    Whether the review actually changes anything

  • Impact of last cycle's decision

    Whether your action table is right

  • Budget reallocated per month

    How responsive the spend actually is

Troubleshooting

  • Same problem appears every month

    The logged action was never owned — assign a name and a date

  • Actions taken but nothing improves

    Wrong lever — segment the metric before choosing the action

Step 07

Full Example, Assembled

One month, both cadences, one real decision.

Assembled, a month looks like four fast weekly pacing checks feeding one strategic monthly review that ends in a single logged budget decision with an owner and a review date.

March, assembled

Total raised $34.1k ▲15% MoM · New donors 612 ▲9% · Repeat rate 22% ▲4pt · LTV:CAC 3.2:1 ▲0.4 · Monthly churn 4.1% ▼1.2pt. Decision logged: owned-channel LTV:CAC is the strongest in the portfolio — shift 15% of next month's Meta budget into growing the email/WhatsApp list instead of pure cold acquisition. Owner: Grownex Team. Review: April monthly.

Checklist

  • Four weekly notes recorded across the month
  • Monthly dashboard shows month-on-month movement on every card
  • Raised trend and LTV:CAC by channel both charted
  • One decision logged with a clear rationale
  • Owner and review date attached to the decision

Do

  • Keep the weekly notes short and dated
  • Chart LTV:CAC by channel, not just overall
  • Write the rationale, not only the decision

Don't

  • Log more than one or two major decisions per month
  • Leave a decision without a review date
  • Present month-end numbers without the trend

KPIs to track

  • Month-on-month movement per metric

    Whether the system is compounding

  • LTV:CAC by channel

    Where the next budget dollar should go

  • Decisions logged and reviewed

    Whether reporting is driving real change

Troubleshooting

  • Great dashboard, flat growth

    No decision is being logged — force one written call per month

  • Decisions never get reviewed

    Put the review date on the calendar when the decision is logged

Who it's for

Built for teams who need a system, not more tactics.

  • Fundraising leads who report numbers but struggle to turn them into decisions.

  • Digital teams running multiple channels who need a single source of truth.

  • Charities with dashboards nobody acts on, or none at all.

  • Boards and managers who want a consistent monthly view of whether growth is compounding.

Take the playbook with you

PDF · 8 pages · Performance-Dashboard.xlsx · 8 pages · 7 parts · 3 min video · Excel dashboard

Get the Fundraising Growth Audit

A scored review of your donation journey, tracking and paid media — with the three changes most likely to lift income in the next 90 days.

Request the audit

Fundraising growth notes, twice a month

Practical tests, donor journey teardowns and benchmark data from live charity campaigns. No fluff, unsubscribe any time.