
A marketing campaign template is a plan for one campaign, from the brief to the results. The spreadsheet below has six linked sheets: a one-page brief, a channel plan with budget and pipeline targets, a timeline, a UTM builder, a results sheet and a short guide. Change the launch date and the timeline moves. Enter budgets and lead targets and it works out cost per lead, target opportunities and target pipeline, then tells you if the channels add up to the goal. No signup.
Download the Excel template (.xlsx)
When we checked Google for this term on 9 November 2026, the top results were project tools that want you to sign up (monday.com, GanttPRO, Nimble, BasicOps), a library advocacy plan from WebJunction, and HubSpot's marketing plan template, which sits behind a form. Most are task lists. None ties the channels to a pipeline number, and only monday.com mentions UTM tags, as a line in a setup step. This template is built for a B2B team that has to answer one question at the end: how much pipeline did the campaign create, and at what cost?
What is in the template?
How to use
Eight steps, and which cells are inputs (yellow) and which are formulas (purple).
Brief
Owner, goal in pipeline dollars, audience, buying committee, offer, message, proof, dates and the sales handoff rule.
Channel plan
Budget, target leads and lead-to-opportunity rate per channel. Cost per lead, target pipeline and a gap check are formulas.
Timeline
Fourteen tasks from week -6 to the 90-day review, with dates and bars that follow the launch date.
UTM builder
One row per link. It lowercases the values and builds the tagged URL with source, medium, campaign, content and term.
Results
Actual spend, leads, MQLs, opportunities and pipeline per channel against the plan, with cost per opportunity.
Copy the campaign plan as text
For a Google Doc or a Notion page, copy the outline below. The .xlsx has the same fields with the formulas and a filled sample.
CAMPAIGN BRIEF
Campaign name: [short name, also the utm_campaign value]
Owner (accountable): [one name]
Business goal: [$ pipeline or revenue] from [audience] by [date]
Audience (ICP): [company size, industry, tech, trigger event]
Buying committee: [champion], [economic buyer], [technical check], [daily user]
Problem and insight: [one sentence the buyer would agree with]
Offer: [what the buyer gets for their time or email]
Core message: [one line, matching your positioning]
Proof: [customer result or data you can show]
Call to action: [one primary CTA]
Dates: build from [date], launch [date], end [date], 90-day review [date]
Budget: $[total] (see channel plan)
Sales handoff rule: [what makes a lead sales-ready] -> [who gets it] within [time]
CHANNEL PLAN (one line per channel)
[Channel] | [Tactic] | [Owner] | Budget $[ ] | Target leads [ ] | Lead-to-opp [ ]% | Target pipeline $[ ]
TIMELINE (weeks from launch)
W-6 Brief approved, handoff rule agreed with sales
W-5 Target account list and audiences built; content outline
W-4 Landing page, form, UTMs, CRM campaign
W-3 Ads, emails and outbound sequence written and approved
W-2 Sales enablement: one-pager, talk track
W0 Launch: ads and invites live, outbound starts
W1-6 Weekly optimisation; event or webinar; follow-up
W8 End-of-campaign report
W20 90-day pipeline and revenue review
TRACKING
utm_campaign = [campaign-name]
utm_source / utm_medium per channel: [linkedin / paid_social], [google / cpc], [newsletter / email]
CRM campaign: [name]; lead source field: [value]
RESULTS (weekly)
[Channel] | Spend $[ ] | Leads [ ] | MQLs [ ] | Opps [ ] | Pipeline $[ ] | Cost per lead | Cost per opp How do you fill in the campaign brief?
The brief is the page everyone signs before anything is built. Each field has one job:
| Field | What good looks like | Common mistake |
|---|---|---|
| Owner | One name, accountable for the result | "Marketing team" |
| Business goal | "$400,000 of qualified pipeline from mid-market finance teams by 30 April" | A reach or follower goal with no link to revenue |
| Audience | Company size, industry, tech and a trigger event, from your ideal customer profile | "Decision makers" |
| Buying committee | Every role the campaign must reach: champion, budget holder, technical check, daily user | Writing only for the champion |
| Offer | Something worth an email or an hour: a teardown, a benchmark, a tool | "Book a demo" as the only offer |
| Core message | One line that matches your positioning statement | Three messages tested at once |
| Handoff rule | Which leads go to sales, to whom, and how fast, agreed with sales before launch | Agreed after the leads arrive |
Fill the audience row with a persona, not a job title list. Our buyer persona template covers the role-level detail, and the ICP template covers the company-level fields. For the creative work that follows the brief, hand the designer or writer a creative brief.
How do you set channel targets that add up?
Work backwards from the goal. For each channel, the Channel plan sheet multiplies target leads by your expected lead-to-opportunity rate and your average opportunity value. The total is your planned pipeline. Below the table, a check cell subtracts the brief's pipeline target. A red number means the plan does not reach the goal yet: raise targets, add budget, or lower the goal before launch, not after.
Illustrative, not benchmarks. Tallyhaus is a fictional expense software company, and its numbers are made up to show how the sheet works.
| Channel | Budget | Target leads | Lead-to-opp | Target opps | Target pipeline at $12,000 per opp |
|---|---|---|---|---|---|
| LinkedIn Ads | $14,000 | 120 | 8% | 9.6 | $115,200 |
| Google Ads | $6,000 | 45 | 10% | 4.5 | $54,000 |
| Email to house list | $0 | 160 | 5% | 8.0 | $96,000 |
| Outbound (SDRs) | $2,500 | 40 | 20% | 8.0 | $96,000 |
| Partner co-promotion | $3,000 | 50 | 12% | 6.0 | $72,000 |
| Content / SEO | $2,000 | 30 | 6% | 1.8 | $21,600 |
| Webinar platform + contingency | $3,000 | n/a | n/a | n/a | n/a |
| Total | $30,500 | 445 | 37.9 | $454,800 |
The plan clears the $400,000 goal by $54,800, about 15 times the spend in pipeline. Two things this table makes obvious. Outbound brings few leads but the highest conversion, so its pipeline matches email's on a quarter of the leads. And the house list costs nothing to email, which is why it is easy to over-send to. To set your own cost targets, run the numbers through our CPA calculator; to size the total budget against revenue, use the SaaS marketing budget calculator. For context, marketing budgets averaged 7.7% of company revenue in Gartner's 2025 CMO Spend Survey, flat on the year before.
How should a B2B campaign timeline run?
The Timeline sheet counts weeks from launch. Change the launch date in one cell and every start date, end date and bar moves with it.
| Weeks | Phase | What gets done |
|---|---|---|
| -6 | Plan | Brief approved. Handoff rule and lead routing agreed with sales |
| -5 | Plan and build | Target account list and audiences; content outline |
| -4 to -3 | Build | Landing page, form, UTMs and CRM campaign; ads, emails and sequence written |
| -2 | Build | Sales enablement: one-pager, talk track, objection notes |
| 0 | Launch | Ads and invites live; outbound starts |
| 1 to 6 | Run | Weekly optimisation, the live event, follow-up by marketing and the account executives |
| 8 | Review | End-of-campaign report |
| About 20 | Review | Pipeline and revenue review, 90 days after the end date |
The 90-day review is the row most templates leave out. B2B deals close weeks or months after the campaign that started them, so a report on the last day of the campaign shows leads and almost no revenue. Most of your market is not buying this quarter anyway: John Dawes of the Ehrenberg-Bass Institute estimates that up to 95% of business buyers are not in the market for a given product at any one time. A campaign is a push to the few who are, and a reminder to the rest.
How do you tag campaign links with UTMs?
Google's Analytics help on URL builders lists the parameters and says to always use utm_source, utm_medium and utm_campaign. Missing values show up as "(not set)" in reports.
| Parameter | Use it for | Example |
|---|---|---|
| utm_source | Where the click came from | linkedin, google, newsletter |
| utm_medium | The type of channel | paid_social, cpc, email |
| utm_campaign | The campaign name from the brief | close-in-3-days |
| utm_content | Which ad or link, when there are several | doc-ad-checklist |
| utm_term | The paid search keyword | month+end+close |
| utm_id | A campaign ID, recommended by Google if you import cost data | q1-27-close |
The UTM builder sheet turns your rows into tagged URLs and forces lowercase, so "LinkedIn" and "linkedin" do not become two sources. More on naming rules in our UTM parameters entry.
How do you report campaign results?
The Results sheet pulls budget and targets from the plan and compares them with what happened. In the Tallyhaus sample, the campaign spent $29,500, brought 412 leads and 32 opportunities, and created $384,000 of pipeline by the end date: about $72 per lead, $922 per opportunity and 13 times the spend in pipeline. It sits $16,000 short of the goal, so the cell turns red. Outbound created $96,000 of pipeline on $2,500 of spend, so the next campaign gives it more accounts.
Report on opportunities and pipeline, not on leads alone. A channel with cheap leads that never become opportunities is the most expensive one in the sheet. If paid search is part of the mix, our Google Ads examples show B2B ads worth copying, and our ROAS calculator works out the return once revenue comes in.
Which campaign types does it fit?
- Webinar or live teardown, like the sample: invites, a live session, then follow-up by sales.
- Product launch: swap the webinar row for launch-day channels and add a press release; our press release template covers that part.
- Trade show or field event: plan the campaign here and the costs in the event budget template.
- Account-based push to a named list: keep outbound and LinkedIn, drop broad search, and set targets per account tier.
If you want a team to plan and run the campaign, our paid ads service runs LinkedIn and Google campaigns against a pipeline goal, and our outbound service writes the account-by-account messages that the sample's best channel depends on.
Frequently asked
What should a marketing campaign plan include?
Eight parts: one owner, a business goal tied to pipeline or revenue, the audience and buying committee, the offer and core message, a channel plan with budget and targets per channel, a week-by-week timeline, a tracking plan (UTM tags and CRM campaign), and a results sheet that compares actuals with targets. The spreadsheet on this page has a sheet for each, already linked.
How do you write a marketing campaign plan?
Start with the brief: the goal in pipeline dollars, who you are trying to reach, and the one offer and message. Then work backwards from the goal to the channel targets (leads, opportunities, pipeline per channel) and check that they add up. Then build the timeline from the launch date backwards, tag every link with UTMs, and agree with sales how leads are handed over before anything goes live.
What is the difference between a marketing plan and a campaign plan?
A marketing plan covers a year or a quarter: positioning, budget split, channels and goals for the whole team. A campaign plan covers one push with a start and an end date, one offer and one message, such as a webinar series or a product launch. A marketing plan usually holds several campaigns.
Is there a marketing campaign template in Excel or Google Sheets?
Yes. The file on this page is an .xlsx that opens in Excel, and in Google Sheets if you upload it to Google Drive and open it there. The formulas (SUM, IFERROR, ROUND, LOWER and SUBSTITUTE) work the same in both. No signup is needed.
How long should a B2B marketing campaign run?
Long enough to reach the buying committee more than once and to see opportunities, not only leads. The template plans six weeks of build, eight weeks in market and a review 90 days after the end date, because B2B deals from a campaign usually close after it ends. Shorter pushes, like a single webinar, can run four to six weeks in market.
Which UTM parameters should every campaign link have?
Google Analytics says to always set utm_source, utm_medium and utm_campaign, and recommends utm_id and utm_source_platform too. Use utm_content to tell two ads or two links in one email apart, and utm_term for paid search keywords. Keep the values lowercase and agree one spelling per source, or the reports split one channel into several rows.



















