Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Marketing Analytics and Reporting › Beginner

Restructuring a Monthly Report for a Dental Group

A practice run at turning a data dump into a report. For an invented group of dental practices you sort a long export into outcome metrics, drivers and operational detail, write the summary and the explanations, agree the decisions, and move everything else to a dashboard the team can check for itself.
ExerciseBeginner levelModule 2: Reports people read5 minUpdated

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.

Illustrative example — not a real result

Pearlgate: an extract of the current export (this month / last month)

SourceMetricThis monthLast month
Google AdsSpend; impressions; clicks; click-through rate£6,200; 210,000; 5,400; 2.6%£5,900; 198,000; 5,100; 2.6%
Google AdsPlatform conversions (calls and forms)410380
Meta adsSpend; reach; link clicks; form leads£2,300; 88,000; 1,900; 140£2,300; 91,000; 2,100; 150
Business ProfileViews; calls; direction requests31,000; 620; 90029,500; 600; 870
WebsiteSessions; bounce rate; online bookings (new and existing patients)14,800; 52%; 19014,100; 51%; 215
Organic socialFollowers; likes4,120; 1,3504,060; 1,290
Booking systemNew patients booked (online; phone)236 (112; 124)248 (128; 120)
Booking systemNew patients attended205221
FinanceMedia 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 (ROI) 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.

  1. Sort every metric in the export into: results table, channel table, dashboard only, or drop.
  2. Calculate the outcome figures the owners need and give each a status against target.
  3. Write the summary, with the main reason for the month's result.
  4. Write the decisions: made, and requested from the owners, each with an owner.
  5. 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.

Illustrative example — not a real result

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.

KPITargetActualLast monthStatusNote
New patients booked260236248MissedHarbourside calendar closed nine days
Cost per new patient booked (CPA)≤ £45£42.37 (£10,000 ÷ 236)£39.11On trackRising because bookings fell, not spend
Attendance rate90%86.9% (205 ÷ 236)89.1%At riskWatch next month
First-year return≥ 150%154%183%On track205 × £310 × 40% = £25,420; (£25,420 − £10,000) ÷ £10,000
Online bookings (new)—112128DriverCalendar gap
Phone bookings (new)—124120DriverPartly absorbed the gap
ChannelSpendChannel KPIChangeNote
Google Ads£6,200New-patient bookings from tracked calls and formsSteadySpend up 5% with demand
Meta ads£2,300Form leads 140−7%Lead-to-booking rate to be checked
Business Profile£0Calls 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.

Pages this lesson applies

Terms used on this page

Also related

Related