Product-Led Growth (PLG) & User ActivationPlaybook3 min readUpdated September 2026

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:

  1. 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.
  2. Divide each channel's spend by its closed deals and sort the list, so the cheapest cost per closed deal sits at the top.
  3. Mark each channel as having room to grow or showing a ceiling, based on whether cost per lead rose when spend increased.
  4. Protect budget for channels with strong cost per closed deal and clear room to grow, and hold flat the ones with a visible ceiling.
  5. 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.

Executive Capability Standard

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)

1. Learn:Pull last quarter's spend and closed deals by channel into a simple sheet and calculate cost per closed deal for each one by hand.
2. Do Manually:Build the full three-column worksheet yourself once, including the room-to-grow assessment, before handing the format off to anyone else.
3. Delegate:Have a marketing operations analyst maintain the worksheet quarterly and flag any channel whose cost per closed deal shifted meaningfully.
4. Automate:Connect ad platform and CRM data so cost per closed deal recalculates automatically by channel instead of being rebuilt by hand each quarter.
5. Buy:Bring in a fractional RevOps or finance consultant, or ask Martha, MeetMyCMO's AI CMO, to sanity check the split before you lock next quarter's budget.

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.

BILL

A tool like BILL helps keep actual vendor and channel spend reconciled against what you budgeted, so the numbers feeding the worksheet match what really went out the door.

Visit BILL→

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