Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesMarketing & GrowthMarketing Finance & Unit EconomicsMarketing Budget Planner

SpreadsheetMarketing Finance & Unit EconomicsFree

Marketing Budget Planner

Budget each channel by quarter, log spend as it happens, and see remaining budget, pacing, cost per lead and cost per customer by channel.

Shown with sample data

Colour

Marketing Budget Planner

Budget each channel by quarter, log spend as it happens, and see remaining budget, pacing, cost per lead and cost per customer by channel.

Annual budget
$92,100
Spent to date
$59,650
Budget used
65%
Cost per customer
$441.85
All channels
Cost per customer by channel
  • PR$1,500
  • Events$825
  • Paid search$594.74
  • Paid social$415.52
  • Content & SEO$327.27
  • Email & CRM$38.71
Spend by quarter
  • Q1$17,700
  • Q2$19,950
  • Q3$15,300
  • Q4$6,700

How to use it

  1. 1Allocate the annual budget by channel and quarter on the Budget sheet.
  2. 2Log every bill on the Spend log with date, channel, supplier and amount.
  3. 3Each month, update leads and customers by channel from your CRM.
  4. 4Each quarter, move budget from channels with high cost per customer to the ones that convert.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Plan where your marketing money goes and prove what it returns. Set a budget for each channel by quarter, log every invoice and ad bill in the spend log, and the planner shows spend to date, remaining budget and whether each channel is pacing ahead of or behind the year. Add the leads and customers each channel produced and it works out cost per lead and cost per customer, so you can move money to what works. A quarterly view compares budget with actual spend.

Who it’s for

  • Annual marketing planning
  • Managing agency and ad spend
  • Reporting return on spend to finance

What’s included

  • Budget sheet: Budget, spend, pacing and results by channel.
  • Spend log sheet: Every marketing bill and ad charge.
  • By quarter sheet: Budget against actual spend for each quarter.

How to use it

  1. 1Allocate the annual budget by channel and quarter on the Budget sheet.
  2. 2Log every bill on the Spend log with date, channel, supplier and amount.
  3. 3Each month, update leads and customers by channel from your CRM.
  4. 4Each quarter, move budget from channels with high cost per customer to the ones that convert.

Tips

  • Keep 10% of the budget unallocated for tests and opportunities.
  • Compare cost per customer with customer lifetime value, not just cost per lead.

Questions

What is pacing?

Spend to date compared with the share of the year that has passed. Ahead means you will run out early at this rate.

How is quarterly spend worked out?

From the date of each entry on the Spend log.

Related searchesmarketing budgetchannel budgetspend trackingmarketing plancost per leadcac

Details

Format
Spreadsheet
Category
Marketing Finance & Unit Economics
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetMarketing Finance & Unit EconomicsFree

Marketing Budget Planner

Budget each channel by quarter, log spend as it happens, and see remaining budget, pacing, cost per lead and cost per customer by channel.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Marketing Finance & Unit Economics
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More marketing finance & unit economics templates

View all
Marketing ROI Calculator2 sheets

Total spend

$121,000

Blended CAC

$1,921

Overall ROI

228%

Gross profit by channel
$120k
$88k
$76k
$50k
$38k
Organic searchPaid searchEmailPartnersPaid social
SpreadsheetMarketing Finance & Unit Economics

Marketing ROI Calculator

Return on each channel from spend, leads and customers, with payback and what to scale or cut.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ