End-to-End Clinic Marketing Analytics: From Ads to Visits, CAC and LTV
Connect ad spend to inquiries, bookings and attended first appointments. Then add repeat visits over a common observation period. This shows which channels generate inquiries, which bring in new patients and which recover their acquisition costs.
- MPB agency
- Published
- All regions
- Russian / English
- For clinics
1. Define funnel stages and data sources
Take spend from advertising accounts, inquiries and bookings from the CRM, and attended visits and payments from the practice management or accounting system. Join the records using internal identifiers. One inquiry can involve several contacts and one booking can be rescheduled. Agree on deduplication and status rules before calculating metrics.
Write down when each status applies. For instance, count a form inquiry after the system accepts it, a booking when a time is confirmed and a first visit after a new patient attends. Keep treatment and personal information in approved internal systems.

2. Identify where patients drop off
Compare conversion between adjacent stages for the same period and allow enough time for bookings and visits to occur. Many inquiries with few bookings are a reason to check traffic quality, availability and inquiry handling. Many bookings with few visits are a reason to check cancellations, no-shows and confirmations.
| Stage | Count | What to check |
|---|---|---|
| Unique inquiries | 150 | Duplicates, missed contacts and sources |
| Inquiries with a booking | 90 of 150 (60%) | Opening hours and inquiry handling |
| Attended visits | 60 of 90 (about 67%) | Confirmations and no-shows |
| New patients who attended a first visit | 30 of 60 | The definition of a new patient |
3. Calculate CAC and LTV for the same cohort
Channel CAC is acquisition spend divided by new patients attributed to that channel who attended a first appointment. In this example, spend of 24,000 currency units divided by 30 new patients gives a CAC of 800. If spend only includes media, label it advertising CAC. Add the agreed acquisition costs to report full CAC.
Start with observed value over 90 days from the first visit. If the same 30 patients generated 48,000 in revenue, that is 1,600 per patient. With 21,000 in variable costs, contribution before acquisition costs is 900 per patient. Compare contribution with CAC to assess payback. This simplified example excludes fixed costs.
Compare cohorts with the same observation window. Call the result 90-day value if you only tracked the first 90 days. Show the share of bookings with an unknown source separately.
4. Build your first report for one service
Choose one service, location and period. Reconcile a sample of inquiries with bookings in the practice system, then add a decision column for each channel. Fix gaps in tracking and verify the underlying records before changing budgets.
- Document the cohort definition, observation window and attribution rule.
- Report inquiries, bookings, visits and new patients separately.
- Recheck the report after changes to forms, telephony or the practice system.