A booking is a starting point—not the whole result.
“20 meetings booked” tells a client that conversations were scheduled. It does not tell them how many happened, met the agreed requirements, were accepted by sales or became opportunities.
This outbound reporting template keeps those outcomes separate. It also keeps unknowns visible, so an unreviewed meeting does not become a rejection and an open opportunity does not become a lost deal.
Use it for a meeting-led B2B programme where sales and the delivery team need a shared view of performance. Agree the definitions before launch; do not change them halfway through a campaign to improve the reported result.
Report the stage reached, the evidence behind it and the action still required.
What you get
| Component | What it is for |
|---|---|
| Cohort input sheet | Record deduplicated contact totals, source references and a defined observation window. |
| Meeting register | Keep one first-meeting record per distinct account-and-project buying motion. |
| Opportunity register | Record eligible opportunities separately from meetings and track their commercial status. |
| Cost register | Allocate programme costs to the same group of prospects whose outcomes you are reporting. |
| Reporting dashboard | Calculate stage counts, conversion rates, pending reviews and cost per outcome. |
| Action register | Assign a next action, owner and review date instead of ending with a collection of numbers. |
| Worked example | Inspect a fictional campaign and a completed client-summary paragraph. |
Scroll across to read all columns on smaller screens.
The workbook is a reporting template, not a live CRM integration. It does not automatically import your contacts, classify replies, verify qualification or recover missing sales updates. Those inputs need a responsible owner and a reliable source.
Start with one cohort and one cutoff.
A cohort is a defined group followed through time. For this template, use prospects first contacted within a specified date range. Keep updating their later outcomes until the reporting cutoff.
For example, a cohort could contain prospects first contacted from 1–30 June, with outcomes recorded through 31 August. A meeting held in July can still belong to that June acquisition cohort.
This is different from an activity report listing everything that happened this week. Do not divide this week's held meetings by this week's new bookings unless the numerator and denominator refer to the same underlying group.
Before entering figures, record the client, campaign, first-contact window, outcome cutoff, currency and cost-allocation method. Each buying motion belongs to one primary acquisition cohort in this workbook.
These are as-of reports, not automatic time-travel reports. Save a dated snapshot before changing statuses or moving the cutoff forward. Moving the cutoff backwards without restoring the earlier source data will not reliably reproduce an earlier report.
Keep future appointments and pending reviews visible. Unfinished is not the same as unsuccessful.
Use a separate definition for every stage.
| Stage | Count it when | Do not substitute |
|---|---|---|
| Contacted prospect | One unique person was included in at least one outbound attempt in the cohort. | The number of messages or follow-ups sent. |
| Email-delivered recipient | The email source records at least one non-bounced delivery to that recipient by the cutoff. | Proof of inbox placement or human attention. |
| Human replier | A person responds; exclude automated replies and delivery notifications. | Every reply event, including repeated messages from the same person. |
| Positive replier | A human response expresses relevant commercial interest under an agreed classification rule. | Every referral, polite acknowledgement or request for generic information. |
| Booked first meeting | A time was agreed for a first commercial conversation linked to a distinct buying motion. | Every reschedule, attendee or follow-up call. |
| Held first meeting | That first commercial conversation took place. | An accepted calendar invitation. |
| Qualified-held meeting | The conversation happened and the mandatory qualification requirements have evidence. | Attendance, seniority or company size alone. |
| Sales-accepted held meeting | The responsible sales owner accepted the held meeting against the agreed standard. | An unreviewed meeting or an invoiceable event assumed to be accepted. |
| Opportunity | Sales documented a distinct potential purchase that passed its opportunity-entry criteria. | A booked call automatically turned into a deal record. |
| Won opportunity | The deal met the organisation's documented closed-won rule. | Recognised revenue or collected cash. |
Scroll across to read all columns on smaller screens.
Qualification is an evidence test. Sales acceptance is a recorded review decision. Billing follows the engagement agreement and stays separate from this reporting framework.
For a deeper qualification checklist, read what counts as a qualified appointment. For the information sales should receive, inspect the meeting handoff example.
The calculations inside the template
Use deduplicated counts from the same cohort and report the cutoff alongside them. Show “N/A” when a denominator is zero or an input is unknown. Enter an explicit zero only when the result is known to be zero.
| Metric | Calculation |
|---|---|
| Human-reply rate | Unique human repliers ÷ unique contacted prospects. |
| Positive-reply rate | Unique positive repliers ÷ unique contacted prospects. |
| Email delivery coverage | Unique email-delivered recipients ÷ unique email-contacted recipients. |
| Positive-replier booking conversion | Unique positive repliers subsequently credited with at least one booking ÷ unique positive repliers. |
| Booked-to-held rate | Held first meetings ÷ booked first meetings. |
| Held-to-qualified rate | Qualified-held first meetings ÷ held first meetings. |
| Held-to-accepted rate | Sales-accepted held first meetings ÷ held first meetings. |
| Accepted-to-opportunity conversion | Accepted buying motions with an eligible opportunity ÷ sales-accepted buying motions. |
| Cost per held meeting | Allocated programme cost ÷ held first meetings. |
| Cost per accepted meeting | Allocated programme cost ÷ sales-accepted held first meetings. |
| Cost per opportunity | Allocated programme cost ÷ eligible opportunities created. |
| Resolved-opportunity win rate | Won opportunities ÷ won plus lost opportunities. Show open opportunities alongside it. |
Scroll across to read all columns on smaller screens.
Multiply rate calculations by 100 for percentage presentation. Spreadsheet cells should store the fraction and use percentage formatting—not multiply twice.
Contacts and buying motions are different counting units. Several colleagues can attend one meeting. A meeting can also be booked without a preceding positive reply in the tracked channel. Do not divide all meetings by all positive repliers and present that mixed-unit ratio as a person-level conversion rate.
In this template, give each booking one credited prospect for the positive-replier booking measure. Count that prospect only once, and count them only when the positive reply came before the booking. Keep direct bookings in the meeting register even when they do not qualify for this particular numerator.
The starter model allows one opportunity per distinct buying motion. A genuinely separate purchase requires its own documented buying motion; adding another attendee does not.
For interpretation and forecasting, use the outbound metrics guide.
Worked example: 20 bookings, 12 sales-accepted meetings
Fictional teaching example. These figures are not LeadScorer results, industry benchmarks or a forecast.
This example follows one cohort of 1,000 unique prospects first contacted during June 2026. Its outcomes are recorded through 31 August 2026. All amounts are in USD. “Delivered” means the sending source recorded a non-bounced delivery; it does not establish inbox placement.
| Measurement | Example result |
|---|---|
| Unique contacted prospects | 1,000 |
| Unique email-contacted prospects | 1,000 |
| Unique email-delivered recipients | 960 |
| Unique human repliers | 80 |
| Unique positive repliers | 40 |
| Positive repliers subsequently credited with a booking | 18 |
| Distinct first meetings booked | 20 |
| First meetings held | 17 |
| Qualified-held meetings | 14 |
| Sales-accepted held meetings | 12 |
| Held meetings rejected by sales | 4 |
| Held meetings pending sales review | 1 |
| Not yet held: rescheduled, cancelled or no-show | 3 |
| Eligible opportunities created | 5 |
| Won / lost / still open | 1 / 1 / 3 |
| Initial opportunity value recorded | $60,000 |
| Signed contract value from the won opportunity | $12,000 |
| Recognised revenue / collected cash | Not recorded in this example |
| Allocated programme cost | $4,800 |
Scroll across to read all columns on smaller screens.
The 20 bookings include 18 credited to positive repliers and two direct bookings without a prior positive reply in the tracked data. That is why positive-replier booking conversion is 18 ÷ 40, not 20 ÷ 40.
The 17 held meetings include 12 accepted, four rejected and one pending review. Of the 14 qualified-held meetings, 12 are accepted, one is rejected and one is pending. Three other held meetings failed qualification and were rejected. Qualification and acceptance are not interchangeable labels.
| Calculated measurement | Example result |
|---|---|
| Human-reply rate | 8.00% |
| Positive-reply rate | 4.00% |
| Email delivery coverage | 96.00% |
| Positive-replier booking conversion | 45.00% |
| Booked-to-held rate | 85.00% |
| Held-to-qualified rate | 82.35% |
| Held-to-accepted rate | 70.59% |
| Accepted-to-opportunity conversion | 41.67% |
| Cost per held meeting | $282.35 |
| Cost per accepted held meeting | $400.00 |
| Cost per opportunity | $960.00 |
| Resolved-opportunity win rate | 50.00%, with three opportunities still open |
Scroll across to read all columns on smaller screens.
What this report tells the client:
The cohort generated 12 accepted conversations and five opportunities by the cutoff. One held meeting still needs a sales decision. Three bookings have not produced a held first conversation; their recorded outcomes explain why.
It does not establish that all $60,000 of initial pipeline value will close. It does not turn the $12,000 signed contract into recognised revenue or cash. It does not establish profitability without the relevant financial and delivery-cost information.
Stop counting the same outcome twice.
| Situation | Reporting rule |
|---|---|
| One prospect receives several follow-ups | Count one contacted prospect in the cohort; retain message volume separately. |
| One prospect replies three times | Count one human replier and, where appropriate, one positive replier. |
| A meeting is rescheduled | Update the original first-meeting record. Keep its original booking date and stable ID. |
| Three people attend the same discussion | Count one first meeting for that buying motion. |
| A discovery call is followed by a demo | Keep the demo as progression, not another acquired first meeting. |
| An opportunity has email and LinkedIn touches | Assign one primary acquisition cohort; record the other touches as non-additive context. |
| A held meeting has not been reviewed | Show it as pending sales review, not rejected. |
| An opportunity remains open at the cutoff | Keep it open. Do not count it as won or lost. |
Scroll across to read all columns on smaller screens.
Use stable buying-motion and opportunity IDs. The workbook checks for duplicate IDs, but deduplicating contact totals still happens in the source data before those totals are entered.
Match costs to the outcomes they funded.
Include the costs covered by your reporting scope: service fees, data, sending infrastructure, software, allocated internal work and other relevant programme expenses. Record how shared costs were allocated so the same amount is not charged in full to several cohorts.
If one software bill supports several cohorts, allocate it using a stated method and reconcile the allocations to the source bill. Do not divide an entire month's spend by a handful of outcomes from an unrelated period.
Record actual allocated cost separately from budgets or forecasts. Leave incomplete cost data visibly incomplete. In this template, cost-per-outcome calculations are withheld until the cohort's cost data is marked complete.
A programme's cost per meeting is not automatically its full customer acquisition cost. Signed contract value is not gross profit. Keep the report's financial labels explicit.
A client update you can adapt
Fictional summary based on the example above:
“By the 31 August cutoff, the June prospect cohort had produced 20 first-meeting bookings and 17 held conversations. Sales accepted 12, rejected four and has one review outstanding. Five accepted buying motions became opportunities: one won, one lost and three remain open. Allocated programme cost was $4,800, equivalent to $400 per accepted meeting and $960 per opportunity. The won opportunity has $12,000 in signed contract value; recognised revenue and cash collection are not included. Next, the sales owner will resolve the pending review, the campaign owner will audit the rejection reasons, and the opportunity owners will confirm dated next steps for the three open deals.”
Use the same structure for your own update: cohort and cutoff, stage outcomes, unresolved records, matched cost, commercial status and next action.
Do not add an explanation such as “targeting was poor” unless the underlying records support it. A metric identifies a question; reviewing the records helps establish the cause.
How to use the template
Six practical steps for client-ready outbound reporting
1. Set the reporting scope.
Choose one client, a defined acquisition cohort, an observation cutoff and one reporting currency.
2. Enter verified contact totals.
Deduplicate prospect records, exclude automated replies and keep your source references with the counts.
3. Update first-meeting outcomes.
Record attendance, qualification evidence, sales decisions and pending reviews against stable buying-motion IDs.
4. Link eligible opportunities and costs.
Use the opportunity-entry standard and document which costs funded the reported cohort.
5. Read the exceptions before the headline.
Resolve duplicate IDs, missing decisions, unpriced opportunities and other data-quality warnings.
6. Send an update with an action.
State what changed, what remains unresolved, who owns the next step and when it will be reviewed.
Using the download in Google Sheets
Download the workbook. In Google Sheets, create a spreadsheet and choose File → Import, upload the .xlsx, then choose the appropriate new-spreadsheet import option. Check the sample calculations and date formats after import before entering client data.
Google Sheets use requires your own Google account. Reading this page and downloading the workbook do not require a LeadScorer signup.
Frequently asked questions
Is this outbound reporting template free?
Yes. Read the guide and download the blank and example workbooks without submitting your email address. A Google account is required to use Google Sheets, not to download the files from LeadScorer.
Is this a cold email reporting template or a sales report?
It covers the handoff between the two. Contact and reply totals describe outreach; meeting and opportunity registers describe later sales progression. Email-specific delivery fields are separate from cross-channel outcomes.
Can I use it for LinkedIn outreach as well?
Yes. Identify the channel approach and leave email-only fields as not applicable where appropriate. Do not use email delivery coverage as a LinkedIn performance measure or count the same opportunity twice across channels.
What is the difference between qualified and sales-accepted?
Qualified means the required criteria have supporting evidence. Sales-accepted means the responsible sales owner has accepted the held meeting against the agreed standard. A qualified meeting can still be awaiting review.
What should I do with cancellations, no-shows and reschedules?
Keep their records. Update the attendance outcome and retain the original first-booked date and buying-motion ID. A reschedule is not another acquired meeting.
Can the sheet calculate everything automatically?
It calculates the reporting metrics from the inputs and registers you maintain. It does not connect to your CRM or sending platform, interpret conversations or verify that a sales decision is correct.
Are the example figures LeadScorer results or recommended benchmarks?
Neither. They are fictional teaching figures selected to demonstrate the formulas and stage distinctions. Judge your own results against consistent definitions, comparable cohorts and the commercial context.
Does pipeline value mean revenue?
No. Initial opportunity value, signed contract value, recognised revenue and collected cash are different measures. The template keeps them separate and leaves missing values visibly unknown.
Can I adapt the report for clients?
Yes. Adapt the working copy to your campaign, qualification rules and reporting requirements. Keep the underlying counting units and observation windows clear, and do not present the fictional example as a real campaign.
Definitions and implementation notes
The counting conventions and fictional example on this page form a practical reporting framework, not an industry study. The workbook requires verified inputs and human review. Client-specific qualification, acceptance and billing rules may differ. Excel-to-Sheets import instructions follow Google’s Excel and Sheets import documentation; check the calculations after importing.
Review qualification definitions and the meeting handoff example before adapting the report.
Check the rates behind your report with the B2B sales metrics calculator. Keep the reporting period and denominator consistent; an empty input is not evidence of zero activity.
Put your reporting standard in place before launch.
Start with what your sales team needs to accept—not just how many meetings you would like to book. Agree the account criteria, handoff evidence, reporting ownership and sales follow-through before the campaign begins.
This template is a reporting aid. Example figures and calculations do not guarantee appointments, opportunities, sales or financial returns.