Start with a funnel you can explain
For an established service business, a meaningful monthly review follows a buyer from an ad or other first touch through inquiry, qualification, appointment and eventual sale. It also shows what was not measured. An impressive number of impressions tells you reach, not whether a phone call was answered.
On mobile, swipe to see the full table →
| Stage | Definition | Common source of error |
|---|---|---|
| Visits and ad clicks | Interactions reported by the ad or site platform | Different platforms count and attribute events differently |
| Inquiries | Distinct people requesting information | Duplicates, spam, repeat calls, missed form delivery |
| Qualified inquiries | People who meet a documented service and capacity definition | Qualification criteria change between staff members |
| Booked appointments | A real appointment exists on the intended calendar | A booking-page visit incorrectly counted as a booking |
| Held appointments | The buyer actually attended or the consultation occurred | Cancellations and no-shows counted as attended |
| Won business | A sale is confirmed under your accounting rules | Quotes and estimated pipelines reported as revenue |
Questions worth asking at every review
- Which sources generated inquiries, and which sources cannot be attributed reliably?
- How many inquiries had a first meaningful response, and how quickly?
- How many met the company's documented fit criteria?
- What happened to those who did not book—were they declined, unreachable or pending?
- How many appointments were held, how many proposals were sent, and how many customers were won?
- What are the next specific changes, who owns them and when will we know whether they helped?
Be skeptical of big percentages with tiny denominators
A jump from one appointment to two is a 100% increase, but it may be too small to guide a major budget change. Ask for the actual counts and timeframe beside every percentage. Seasonality, market conditions, changes to sales staffing and delayed purchases complicate attribution.
Where automated reporting stops
Ad and analytics platforms may record that a form was submitted, not whether the customer was eligible or whether an estimator returned the call. CRM data helps when the team records the outcome consistently. Offline sales, multiple devices and privacy settings can also leave gaps. A trustworthy partner labels unknowns rather than inventing precise return on investment.
A monthly review you can use tomorrow
Ask the team for one page that lists spend, distinct inquiries, qualified inquiries, actual bookings, held appointments, confirmed sales, unresolved handoffs and the next three actions. Do not demand an elaborate dashboard before you can trust the underlying records. See the inquiry-risk calculator to explore assumptions, but do not substitute it for these measurements.
Example one-page report — numbers are illustrative only
Consider a local company with a hypothetical month of $2,400 in ad spend, 100 attributed inquiries, 45 qualified inquiries, 18 confirmed bookings, 14 held appointments and 6 won customers. An honest report shows each count separately. It can calculate $24 per attributed inquiry, approximately $53 per qualified inquiry, and $400 per known won customer from that attributed cohort. It cannot establish profit or actual advertising incrementality without the corresponding costs, revenue, timing and attribution controls.
Suggested monthly row: Reporting period · source · spend · distinct inquiries · qualified inquiries · confirmed bookings · held appointments · won customers · qualified-lead definition · exclusions/unknowns · next action and owner. For a cancellation, subtract it from the active-bookings view, but preserve its event history for reconciliation.
Getting from CRM outcomes back to the ad platform
A platform tag can usually measure a form event, but qualification and held appointments occur later in the business process. Google's enhanced conversions for leads documentation describes importing relevant offline outcomes through supported tools, subject to the platform's privacy and data-use requirements. An email address or click ID is not by itself proof of a qualified sale. Verify deduplication, attribution windows, cancellations and the actual source record before upgrading a conversion from secondary observation to campaign optimization.
Monthly owner question: Which single change did we make, who was responsible, and which observed outcome will tell us whether that change was worth keeping? If the report has thirty charts but cannot answer that, it's missing the decision.
Keep exploring
These resources are free to use. No email address, appointment, or purchase is required. Browse all resources, or ask Northstart a question. If you want a fully managed operation rather than another tool to manage yourself, see what the Growth System includes.