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

SpreadsheetMarketing Finance & Unit EconomicsFree

Marketing ROI Calculator

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

Shown with sample data

Colour

Marketing ROI Calculator

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

Total spend
$121,000
Blended CAC
$1,921
Overall ROI
228%
Channels to scale
3
Gross profit by channel
  • Organic search$119,700
  • Paid search$88,200
  • Email$75,600
  • Partners$50,400
  • Paid social$37,800
  • Events$25,200

How to use it

  1. 1Use the same period for every channel.
  2. 2Enter customer lifetime value and margin once, in the first row.
  3. 3Scale channels with LTV:CAC above 3.
  4. 4Fix or cut channels below 1.

In this workbook

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

About this template

Put every channel on the same scale. Enter spend, leads and new customers for each channel plus average customer value and gross margin; the sheet calculates cost per lead, acquisition cost, return on investment and LTV to CAC, and marks each channel Scale, Hold or Cut.

Who it’s for

  • Annual and quarterly budget decisions
  • Defending marketing spend to finance
  • Comparing brand and performance channels

What’s included

  • Channels sheet: One row per channel for the period.
  • Summary by Channel sheet: Spend and Gross profit and the number of entries for each channel, calculated from the Channels sheet.

How to use it

  1. 1Use the same period for every channel.
  2. 2Enter customer lifetime value and margin once, in the first row.
  3. 3Scale channels with LTV:CAC above 3.
  4. 4Fix or cut channels below 1.
Related searchesmarketing roireturn on marketing investmentchannel roicac paybackltv cac

Details

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

Download a copy

Downloads need a free account.

SpreadsheetMarketing Finance & Unit EconomicsFree

Marketing ROI Calculator

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

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
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More marketing finance & unit economics templates

View all
Marketing Budget Planner3 sheets

Annual budget

$92,100

Spent to date

$59,650

Budget used

65%

Cost per customer by channel
$1,500
$825
$594.74
$415.52
$327.27
PREventsPaid searchPaid socialContent & SEO
SpreadsheetMarketing Finance & Unit Economics

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.

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