A Simple Worksheet for Splitting a Marketing Budget That Actually Works
Most marketing budgets get split the same way every year: take last year's percentages, adjust a little, and move on. That approach quietly protects whatever channel got funded first, regardless of whether it's still the best place for the next dollar.
Here's a simple worksheet you can build in an afternoon that splits budget based on what's actually working now.
Vendors Covered in this Article
Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.
Column one: what each channel actually produced last quarter
List every channel you spent on, and next to each one record spend, leads produced, and how many of those leads turned into a closed deal, pulled from your CRM rather than the channel's own reporting. A channel's self-reported numbers and what actually shows up in your pipeline often disagree, sometimes by a lot.
This column alone tends to surprise people. A channel that felt important because it's visible, like a conference sponsorship or a broad awareness campaign, often produces less traceable pipeline than a quieter channel nobody talks about in meetings.
Include channels you stopped funding partway through the quarter too, not just the ones still active today. Knowing why a channel got cut, and whether that decision was based on real numbers or just a budget squeeze, matters for deciding whether to bring it back.
How do you calculate cost per closed deal by channel?
Divide each channel's spend by the number of closed deals it produced. This single number does more to guide next quarter's split than almost anything else on the worksheet, because it accounts for both cost and quality in one figure instead of treating a cheap, low-converting lead the same as an expensive, high-converting one.
Sort the worksheet by this column. The channels at the top of the list, cheapest cost per closed deal, are where your next incremental dollar is most likely to produce another deal. That doesn't mean fund only those channels, but it should carry real weight in the split.
Column three: how much room is left to grow each channel
A channel with a great cost per closed deal isn't necessarily a channel with room for more budget. Some channels have a ceiling, a limited audience size or a fixed inventory, where more spend just raises the cost without producing more deals.
For each channel, note whether you're seeing signs of that ceiling, like rising cost per lead as spend increased last quarter, or whether the channel has clearly absorbed more spend without losing efficiency. This column is what keeps you from overfunding a channel just because its past numbers looked good.
A simple way to test for the ceiling without guessing is to raise one channel's budget by a modest amount for a single month and watch what happens to cost per lead. If it holds steady, there's likely more room; if it climbs right away, you've found the ceiling without committing a full quarter of budget to finding out.
For example, suppose two channels show a similar cost per closed deal, but one is a small partner newsletter and the other is paid search. The newsletter has a limited audience, so doubling its budget would mostly buy repeat exposure to the same readers. Paid search still has unused keywords and audiences to reach. On the worksheet both look attractive, yet only the second has room to grow. A common mistake is to fund both equally because the cost numbers match. The decision rule: when two channels tie on cost per closed deal, put the next dollar into the one with the larger untapped audience, and test the other with a small increase.
How do you turn the worksheet into an allocation rule?
With those three columns filled in, a reasonable starting split looks like this: protect budget for channels with strong cost per closed deal and clear room to grow; hold flat the channels with good numbers but a visible ceiling; and cut or heavily test the channels with weak cost per closed deal, rather than funding them out of habit.
This won't be a perfect formula, and it shouldn't be treated as one. It's a structured starting point that replaces the default of copying last year's percentages, which is really the whole point of building the worksheet.
Use these checks as you fill in the worksheet:
- Record spend, leads and closed deals for each channel from your CRM rather than the channel's own reporting, so the numbers match what actually reached your pipeline.
- Divide each channel's spend by its closed deals and sort the list, so the cheapest cost per closed deal sits at the top.
- Mark each channel as having room to grow or showing a ceiling, based on whether cost per lead rose when spend increased.
- Protect budget for channels with strong cost per closed deal and clear room to grow, and hold flat the ones with a visible ceiling.
- Cut or heavily test channels with weak cost per closed deal instead of funding them out of habit, then revisit the split mid quarter.
Revisit the split mid-quarter, not just at planning time
Budget allocation isn't a once-a-year decision, even if the planning calendar treats it that way. Revisit the worksheet at the midpoint of a quarter and shift a modest amount of budget toward whatever's currently outperforming its cost per closed deal target, and away from whatever's clearly underperforming.
Small, frequent adjustments based on real data beat one big annual guess made months before the spend actually happens.
What Good Looks Like
Good budget allocation means every channel's funding level can be explained by its cost per closed deal and its room to grow, not by how much it got funded the year before.
Building The Capability (5-Stage Skill Ladder)
How to Get Started
Disclosure: We may earn a commission if you buy through some links on this page. It doesn't change what we recommend.
Frequently Asked Questions
How often should we rebuild this budget worksheet?
Rebuild the full worksheet quarterly, and do a lighter mid-quarter check using the same columns. A full annual rebuild alone means you're acting on stale data for most of the year, while checking it too often, like weekly, mostly measures noise instead of a real shift in channel performance.
What if a channel has a great cost per closed deal but a small total number of deals?
Look at the room-to-grow column before assuming you can just scale it up. Some channels perform well specifically because they're small and targeted, and pouring more budget in raises cost without producing proportionally more deals. Test a modest increase first rather than a large one.
Should brand awareness spend be judged by the same cost per closed deal metric?
Not directly, since brand spend usually isn't meant to produce an immediately traceable deal. Track it separately with its own goals, but cap it at a defined share of the total budget so it doesn't quietly grow at the expense of channels you can actually measure against pipeline.
Who should own filling out this worksheet?
Whoever owns the marketing budget should own the worksheet, but the underlying deal and pipeline data should come from whoever owns the CRM, usually sales operations or RevOps. Pulling numbers from two systems and reconciling them yourself is exactly the kind of task worth delegating once the format is set.
About the numbers
This guide doesn't quote a sourced benchmark. Figures in it are estimates or general guidance, so check them against your own numbers.
Related Guides
Which Conversion Benchmarks Actually Apply to Your Funnel
A guide to reading conversion rate benchmarks correctly: which published numbers are close enough to compare against, and which ones will mislead you.
Deciding Whether Community-Led Growth Fits Your Product
A decision guide for whether an owned community will actually drive growth for your product, and what it takes to run one instead of just launching one.
First Touch, Last Touch, or Multi-Touch: Which One Should You Actually Use
A plain-language walkthrough of first touch, last touch, and multi-touch attribution, and which one fits a small marketing team's real decisions.
Choosing the Right Content Syndication Channels
A comparison of the main ways to syndicate content, from partner newsletters to paid distribution networks, and how to tell which one fits your goal.
A Checklist for Organic Search Visibility, Beyond Keywords
A practical checklist covering the technical, content, and authority work that decides whether your pages actually rank, plus the pitfalls that undo it.
Building an Executive Marketing Dashboard Leadership Actually Reads
A worksheet walkthrough for building an executive marketing dashboard with the handful of numbers leadership actually needs, not everything you track.