One Excel sheet for your goal, ICP, list size, sequence and metrics, so every launch starts with a plan.
Sample values shown. Replace them with your own.
The template brings the five parts of campaign planning onto one sheet. Yellow cells are yours to fill in and blue cells calculate for you. The values below are samples.
Pick one primary goal, then attach a number, a deadline and the offer you will lead with. Everyone knows what success means before any copy is written.
Define up to three segments so you can plan variations without opening a second file.
Enter your target and your expected rates. The sheet works out how many contacts to load.
contacts to load, from 10 meetings at a 25% meeting rate, 3% reply rate and 95% delivery rate. Sample assumptions, not benchmarks.
Map every touch with its channel, day, message angle, opener, call to action and status.
Set a target for each metric before launch, add actuals as results arrive, and read the gap column to decide what to change.
| Metric | Target | Actual | Gap | Review |
|---|---|---|---|---|
| Emails sent | Calculated | Weekly | ||
| Delivery rate | 95% | Calculated | Weekly | |
| Open rate | Calculated | Weekly | ||
| Reply rate | 3% | Calculated | Weekly | |
| Positive reply rate | Calculated | Weekly | ||
| Meetings booked | Calculated | Weekly | ||
| Cost per meeting | Calculated | Weekly |
Each section feeds the next. The goal sets the list size, the ICP shapes the sequence, and the metrics tell you whether to keep going or adjust.
Download the Excel templateStart with one primary goal, such as booked meetings, demo requests or replies from a target account list. Add a target number, a deadline and your offer. A goal like 10 qualified meetings in 30 days gives every other section something to be measured against.
Describe the buyer you want to reach: industry, company size, region, job title, the pain point you solve, and a trigger that makes outreach timely, such as a new funding round or a hiring push.
Enter your target meetings along with your expected meeting, reply and delivery rates. The template calculates how many contacts you need to load. Treat the rates as assumptions and replace them with your own history.
Map each touch by step, channel, day, message angle and call to action. The default layout has six steps over about 17 days, mixing email, LinkedIn and a call. Adjust the cadence to your buyer and use the status column to track what is drafted, approved and live.
Set a target for delivery rate, reply rate, positive replies, meetings booked and cost per meeting. As results come in, add actuals and let the gap column show where the plan and reality differ.
Planning on one sheet keeps strategy and execution connected, so handoffs between SDRs, marketers and managers need fewer explanations.
The goal, ICP, list, sequence and metrics stay together.
The formula ties your target to expected conversion rates, so you avoid loading far too few or far too many contacts.
A visible cadence keeps touches evenly spaced and makes it easy to compare one campaign with the next.
Targets and actuals sit side by side, so reviews start with the numbers instead of a search for them.
The sheet works best as a living document rather than a one-time form.
Check that the target is realistic for the list you can actually build. If the formula says you need 5,000 contacts and your ICP only has 800 matching accounts, adjust the goal or widen the ICP before you send anything.
A VP of Finance and a founder rarely respond to the same message. Use the message angle column to tailor each step to the pain point and trigger you wrote for that segment.
Compare actuals against targets on a fixed day. If delivery is low, fix the list first. If replies are low, revisit the message angle. If meetings are low, look at the offer and the call to action.
Download the free template and subscribe to Prospecting Penguin, our LinkedIn newsletter packed with ICP-building strategies, lead-gen insights and outreach tips.
The sheet tells you how many contacts to load. ReachStream helps you find verified contacts that match your ICP, so the list you size is the list you can build. New accounts can claim 100 free export credits.
An outbound campaign planning template is a structured sheet that captures the goal, target audience, list size, message sequence and success metrics for a campaign in one place. It helps teams agree on the plan before they start sending.
At minimum, a plan should include the campaign goal and deadline, the ICP, the number of contacts needed, the sequence of touches with timing and channels, and the metrics you will use to judge results. This template covers all five.
Work backwards from your target. Divide the number of meetings you want by the product of your meeting rate, reply rate and delivery rate. The template does this automatically once you enter your assumptions.
There is no single right number. The template starts with six touches over about 17 days, which you can lengthen or shorten based on your buyer, your channel mix and how your team handles follow-up.
Track delivery rate, reply rate, positive reply rate, meetings booked and cost per meeting. Set a target for each one before launch and compare actuals against it on a regular cadence.
ReachStream offers a free plan so you can test the platform, with paid plans as your outbound volume grows. See the pricing page for current plan details.
Enter your name and work email. Your Excel download starts right away.
Opens in Excel or Google Sheets. No spam.