Compare inquiry cohorts after their booking delay has matured

Identify the timing problem in the report

Recent inquiries often have less time to become work than older inquiries. If an owner compares this week's unfinished quotes with last month's settled jobs, the difference can look like a campaign decline even when handling is similar. Start by recording inquiry creation, quote, booking, and completion dates separately. A job completed today may belong to an older acquisition period, so calendar totals alone cannot settle today's acquisition efficiency.

Source checks: Find your conversion lag reporting data · Understand your conversion tracking data

Create cohorts from a consistent acquisition event

Choose a stable starting event, such as the date a distinct inquiry was accepted, and group records by week or another practical period. Retain source attribution only when reliably available. Record current stage and its latest change date. Do not move a lead into the current cohort because a member of staff followed up again. The initial acquisition date and later operational updates answer different questions.

Choose comparison ages using business evidence

Review how long past suitable inquiries took to book and complete, including those still unresolved. Select one or more practical checkpoint ages and explain them as management choices. Google's conversion-lag view can add platform context, but it may represent a different outcome than booked service work. Avoid a universal 'all leads should book in seven days' rule for services with longer quotes, supplier delays, or customer decisions.

Build a cohort table with pending outcomes

For each group, show distinct inquiries, qualification, bookings, completions, cancellations, and still-pending records at the stated age. If marketing spend can be assigned reliably to the cohort, calculate stage costs. Keep unattributed work and shared-spend uncertainty separate. A pending record is neither a confirmed loss nor a completed sale. Make that visible rather than allocating it to whichever category makes the result look stronger.

Investigate delays without rewriting the history

A slower cohort can reflect availability, missing quote information, supplier lead time, or weaker service fit. Review the reason with staff and record it. Changing a stage definition mid-report can create artificial improvement, so preserve the original definition and note any actual process change. A higher booking rate after longer observation does not mean the original report was wrong; it may mean its outcomes were correctly labeled incomplete.

Compare like-aged results and update the decision

Review cohorts at similar maturity before changing acquisition spend on the basis of booking cost. Update later outcomes as they occur and retain the review date. If the business needs an earlier decision for cash-flow reasons, show that it is based on partial evidence. The final report should separate acquisition quality from normal outcome delay and identify whether the next task belongs to advertising, quoting, scheduling, or follow-up.

Worked example: illustrative figures

For example, two cohorts each contain 20 inquiries. At seven days, Cohort A has 4 bookings and 12 pending quotes; Cohort B, already reviewed at 30 days, has 10 bookings and 2 pending quotes. Comparing 20% with 50% immediately would mix ages. When Cohort A reaches 30 days, it has 9 bookings, or 45%, and 3 pending quotes. The remaining one-booking gap deserves investigation, but the earlier 30-point difference largely reflected unequal observation time. These are illustrative stage records, not a promise that pending quotes will convert.

Questions about this task