Template

Campaign report: a template for following up a prospecting campaign

A free template for reporting a prospecting campaign as a funnel by send cohort, with counts next to the rates, a comparison with the previous cohort and a decision on the next change.

A campaign report that says "40% reply rate" tells you nothing until you know whether that's 4 out of 10 or 80 out of 200. This template reports the campaign as a funnel by cohort: everyone contacted in the same week or the same batch. Every stage has the count next to the rate, so a good rate on ten contacts doesn't look like a result.

Compare each cohort with the previous one, write down what you changed, and decide on one thing to change next time. Copy the template and fill it in once the cohort has had time to reply.

The template

CAMPAIGN REPORT
Campaign: [name]
ICP: [the profile the list was built on]
Channels: [email / phone / LinkedIn, and in what order]
Cohort: [e.g. contacted November 3–7]    Compared with: [previous cohort]
Owner: [name]    Report written: [date]

1. THE FUNNEL
Rate = count at this stage divided by count at the stage before.
Reached = the call connected or the email was delivered.

| Stage                          | Count | Rate from previous | Previous cohort (count) |
|--------------------------------|-------|--------------------|-------------------------|
| Contacted                      |       | -                  |                         |
| Reached                        |       |                    |                         |
| Human reply                    |       |                    |                         |
| Positive reply                 |       |                    |                         |
| Meeting booked                 |       |                    |                         |
| Meeting held                   |       |                    |                         |
| Accepted by sales / qualified  |       |                    |                         |
| Opportunity                    |       |                    |                         |

Rules:
- Count humans, not autoreplies. Out-of-office replies and bounces are not replies.
- A meeting counts as held only if it happened. A rescheduled meeting counts when it takes place.
- Don't change more than one thing per cohort.

2. WHAT WE CHANGED SINCE LAST COHORT
Change: [one thing, e.g. new opener, new title, new channel order]
Everything else the same? [yes / no, what else changed]

3. BEST AND WORST
Best message/opener: [text]    Replies: [count out of count]
Worst message/opener: [text]    Replies: [count out of count]

4. REASONS FOR NO
| Reason                       | Count |
|------------------------------|-------|
| Already has a solution       |       |
| Not the right time           |       |
| Wrong person                 |       |
| No budget                    |       |
| Other: [write it]            |       |

5. DATA QUALITY
Bounced emails: [count]    Wrong numbers: [count]    Wrong person at the right company: [count]

6. DECISION FOR NEXT COHORT
One change: [what]
Why: [which number in the funnel made you pick it]

How to fill it in

1. The funnel by cohort

Don't report the campaign as one lump from launch to today. That mixes contacts who got their first email yesterday with those who've had a month, and the rates drop just because the list grows. A cohort is a group that started at the same time, so it can be compared with the next one.

  • Count first, rate second. "3 of 4 meetings held" and "75%" say the same thing, but only the first shows that the sample is small.
  • Rate from the previous stage. That shows you where the funnel leaks. A rate of everyone contacted hides whether the problem is that you don't reach people or that they don't want to meet.
  • Let the cohort finish. Write the report once most people have had time to reply, not the day after the send.

2. What you changed

Without that line, nobody can read the report a month from now. Write down the change before you see the numbers, so you don't explain a random difference with it after the fact.

3. Best and worst

Write the actual text, not "short email" or "question opener". Give the replies as a count out of a count, because a message that went to eight people can't be compared with one that went to eighty.

4. Reasons for no

A no with a reason is information. If "wrong person" dominates, it's the list or the title that needs to change, not the message.

5. Data quality

Bounces and wrong numbers aren't a no. They show how good the list was and belong on a line of their own, so they don't drag down the reached rate without anyone understanding why.

6. The decision

One change per cohort. If you change the opener, the title and the channel order at the same time, you won't know what made the difference. Sometimes the right decision is to change nothing and run the same setup on a new cohort, when the numbers are too small to say anything.

A fictional example

This example and every number in it are made up. A software company calls and emails operations managers at healthcare companies. Cohort: contacted during week 44. Change since the previous cohort: a new opener that asks how they plan schedules today instead of presenting the product.

StageCountRate from previousPrevious cohort (count)
Contacted60-60
Reached4270%45
Human reply921%6
Positive reply556%3
Meeting booked480%2
Meeting held375%2
Accepted by sales267%1
Opportunity150%1

Reasons for no: already has a solution 2, not the right time 1, wrong person 1. Data quality: 3 bounced emails, 2 wrong numbers.

Four booked meetings against two looks like doubling, but it's two meetings. The decision for the next cohort: keep the new opener and change nothing else, so the next 60 contacts show whether the difference holds.

How Funnelfeedr helps

  • The week's numbers in one place. A weekly sales digest covers calls, meetings and deals, so you have the basis for the report when it's time to write it.
  • Autoreplies sorted out. The inbox detects bounces and out-of-office replies, so they aren't counted as human replies. Research & Outreach
  • Fewer no-shows. With booking pages, a no-show creates a rebooking task, so "booked" can become "held". Scheduler
  • Call from the list. With the dialer you call the cohort straight from the list. Dialer
Want to see the week's sales numbers without counting them yourself? Book a demo →

See the week's numbers without counting them yourself

We'll show you how calls, meetings and deals come together in a weekly sales digest, and how the inbox sorts out bounces and out-of-office replies.