ChirplyHow do you turn call volume into a useful lead report?
Define calls, unique callers, qualified opportunities and booked next steps separately. Label repeated calls and non-opportunity calls before calculating rates. A useful report keeps the denominator beside each metric and preserves a path back to the underlying records.
An agency needs to explain what eight recorded calls produced. This invented ledger separates repeat calls, existing-customer support and a wrong number from new opportunities. It demonstrates a reporting convention rather than an automatic qualification claim about Chirply.
Dataset and download
Download example CSVOpen the CSV in a spreadsheet and keep the original as a reference. Make a working copy for your own review. Downloading saves a local file; it leaves your CRM and communication settings unchanged.
| call_id | caller_key | purpose | qualified_new_opportunity | booked | data_type |
|---|---|---|---|---|---|
| CALL-1 | A | new inquiry | yes | yes | synthetic |
| CALL-2 | B | new inquiry | yes | no | synthetic |
| CALL-3 | A | repeat follow-up | no | no | synthetic |
| CALL-4 | C | existing customer support | no | no | synthetic |
| CALL-5 | D | new inquiry | yes | yes | synthetic |
| CALL-6 | E | wrong number | no | no | synthetic |
| CALL-7 | F | new inquiry | yes | no | synthetic |
| CALL-8 | G | new inquiry | no | no | synthetic |
Field definitions
- call_id / caller_key
- Each call has one identifier; caller_key groups repeats for this synthetic exercise. Real identity matching needs an explicit rule.
- purpose
- The reviewed reason for the call, recorded independently of whether it became an opportunity.
- qualified_new_opportunity
- yes marks the first qualifying new opportunity for that caller in this cohort. Repeat follow-up is not a second opportunity.
- booked
- A verified booked next step attributed once to that opportunity. Track sales and collected revenue as separate downstream outcomes.
Reproduce the method
1. Agree on qualification
Write the service-fit and next-step criteria with the client. Define how repeat callers, support calls and wrong numbers will be labeled. Keep the criteria stable within the reporting period and retain reviewed evidence behind each classification.
2. Reconcile volume and people
Count eight call IDs and seven distinct caller keys. Caller A appears twice. Keep both call records for workload reporting while counting the unique caller once for reach. Do not assume an actual phone number always represents a single person.
3. Count outcomes once
The yes rows identify four qualified new opportunities and two bookings. Confirm that repeated calls have not duplicated either outcome. Record a booking only when there is evidence of the next step, rather than inferring it from call duration.
4. Present a decision
Report the call volume, unique callers, qualification definition and booked-next-step rate together. For this example the booking rate is 2 ÷ 4 = 50% of qualified opportunities. Review the two qualified opportunities without a booking for an appropriate next action under your team's follow-up process.
Expected results
- Eight calls and seven unique caller keys; caller A has two records.
- Four qualified new opportunities and two bookings.
- Booked-next-step rate is 50% of qualified opportunities. Bookings per recorded call is 25%; these are different denominators.
Interpret the result
Call volume describes demand and handling workload; qualified opportunities describe fit under the chosen rule. A support call can be valuable service work while belonging outside a new-business denominator.
Booked appointments, attended appointments and sales are distinct outcomes. Connect later results by a stable opportunity or appointment identifier before reporting revenue.
Review a sample of the classifications with the client. Report any unknown outcomes as unknown rather than automatically counting them as failures or successes.
Troubleshooting
Repeated calls inflate the opportunity count
Use a stable opportunity identifier and a declared first-qualifying-event rule. Preserve all call IDs while counting each opportunity once.
Two reports show different conversion rates
Write the numerator and denominator beside each rate. Compare reporting periods, qualifying criteria and outcome cutoff before choosing which report to use.
If the CSV does not appear immediately, check your browser's downloads list. Import it as UTF-8 with comma-separated fields if your spreadsheet opens it in one column.
Questions about this example
Does a long call automatically qualify?
Call duration can support review, but qualification needs your agreed criteria and evidence. A long support conversation and a short qualified inquiry can have different business purposes.
Can I report revenue from the booked count?
Use verified downstream sales and collected amounts for revenue. A booking count alone does not establish either.
Sources and next steps
The methodology and synthetic rows were authored for this resource and checked against the linked definitions and product guides. Product setup and provider conventions remain documented at their sources. Cite this page's address and review date when sharing the exercise; keep the synthetic-data label with copied rows.