Why this matters
A report that lists everything tells its reader nothing. The owners pick the number that worries them most, and the meeting argues about it instead of deciding anything.
The monthly marketing report template fixed the sections and the two tables a report needs. The comparison of reporting and business intelligence separated what one platform's numbers can answer from questions that need joined data. The monthly reporting pack procedure set out how the numbers are pulled and checked. This exercise applies the first two.
The group and its current report
Pearlgate Dental Clinics is an invented group of four dental practices owned by three dentists. Marketing aims to fill new-patient appointments. An agency runs the ads and sends a monthly export; a coordinator adds figures from the booking system. The owners read it between patients.
Pearlgate: an extract of the current export (this month / last month)
| Source | Metric | This month | Last month |
|---|---|---|---|
| Google Ads | Spend; impressions; clicks; click-through rate | £6,200; 210,000; 5,400; 2.6% | £5,900; 198,000; 5,100; 2.6% |
| Google Ads | Platform conversions (calls and forms) | 410 | 380 |
| Meta ads | Spend; reach; link clicks; form leads | £2,300; 88,000; 1,900; 140 | £2,300; 91,000; 2,100; 150 |
| Business Profile | Views; calls; direction requests | 31,000; 620; 900 | 29,500; 600; 870 |
| Website | Sessions; bounce rate; online bookings (new and existing patients) | 14,800; 52%; 190 | 14,100; 51%; 215 |
| Organic social | Followers; likes | 4,120; 1,350 | 4,060; 1,290 |
| Booking system | New patients booked (online; phone) | 236 (112; 124) | 248 (128; 120) |
| Booking system | New patients attended | 205 | 221 |
| Finance | Media plus agency fee | £10,000 | £9,700 |
Targets from the plan: 260 new patients booked; cost per new patient booked of no more than £45; 90% of booked new patients attend; first-year return on marketing (ROIProfit relative to cost.) of at least 150%, measured as treatment margin minus marketing cost, over marketing cost. Average first-year treatment value is £310 per attended new patient and the agreed treatment margin is 40%. The booking system log shows the Harbourside practice's online calendar showed no new-patient slots for nine days while a dentist was on leave.
What belongs in the report
The test for each row is whether a practice owner would make a decision from it. Outcome metrics with a target belong in the results table, outcomes first and drivers beneath. Each channel gets one line judged on its role. Everything that explains a channel's day-to-day running belongs on a dashboard the agency and the coordinator check weekly, because that is platform reporting, fast and useful to the people running the channel. Questions the export cannot answer, such as which channel brings patients who return for treatment, need booking and ad data joined, and belong on a list for later rather than in this report.
Task
Write your answer before reading the worked answer.
- Sort every metric in the export into: results table, channel table, dashboard only, or drop.
- Calculate the outcome figures the owners need and give each a status against target.
- Write the summary, with the main reason for the month's result.
- Write the decisions: made, and requested from the owners, each with an owner.
- List the questions the current export cannot answer and say what they would need.
Worked answer
Sorting. New patients booked, cost per new patient booked, attendance rate and first-year return go in the results table, with online and phone bookings beneath as drivers. Google Ads, Meta and the Business Profile each get one channel line. Impressions, click-through rate, reach, link clicks, Business Profile views, direction requests, sessions and bounce rate move to the dashboard. Followers and likes are dropped from the report; nobody has set a target for them. Platform conversions move to the dashboard too, because they count calls of any length and forms from existing patients, so they cannot stand in for new patients.
Pearlgate: the restructured report
Summary. We booked 236 new patients against a target of 260, down from 248. The shortfall is almost entirely online bookings at Harbourside, whose calendar showed no new-patient slots for nine days during staff leave; phone bookings rose. Cost per new patient stayed within target at £42.37, and first-year return was 154%, just above target. We ask the owners to approve a rule that keeps online slots open during leave.
| KPI | Target | Actual | Last month | Status | Note |
|---|---|---|---|---|---|
| New patients booked | 260 | 236 | 248 | Missed | Harbourside calendar closed nine days |
| Cost per new patient booked (CPACost of each conversion.) | ≤ £45 | £42.37 (£10,000 ÷ 236) | £39.11 | On track | Rising because bookings fell, not spend |
| Attendance rate | 90% | 86.9% (205 ÷ 236) | 89.1% | At risk | Watch next month |
| First-year return | ≥ 150% | 154% | 183% | On track | 205 × £310 × 40% = £25,420; (£25,420 − £10,000) ÷ £10,000 |
| Online bookings (new) | — | 112 | 128 | Driver | Calendar gap |
| Phone bookings (new) | — | 124 | 120 | Driver | Partly absorbed the gap |
| Channel | Spend | Channel KPI | Change | Note |
|---|---|---|---|---|
| Google Ads | £6,200 | New-patient bookings from tracked calls and forms | Steady | Spend up 5% with demand |
| Meta ads | £2,300 | Form leads 140 | −7% | Lead-to-booking rate to be checked |
| Business Profile | £0 | Calls 620 | +3% | Steady |
Decisions. Made: the coordinator now checks each practice's online calendar every Monday. Requested: the owners approve covering online new-patient slots from another practice during leave (owners, by the next partners' meeting).
Later questions. Which channel brings patients who attend and go on to treatment, and the true cost of a treated patient by channel, both need ad, booking and treatment data joined on a shared key. That is business intelligence, not a reporting fix, and goes on the list with the data it would need.
Common mistakes
- Keeping every row "just in case". A row with no target and no decision belongs on the dashboard.
- Reporting platform conversions as patients. The ad platform counts actions, not new patients.
- A summary that restates the table. It should give the reason and the decision.
- Return without margin. Treatment value is not profit; apply the agreed margin first.
Next, check your understanding in the monthly marketing reporting checkpoint, or return to the beginner marketing analytics level.
