Konabayev
Marketing AnalyticsMarketing ROIMarketing StrategyAnalytics

Marketing ROI: Formula, Worked Example and Worksheet

·10 min read
Last updated on
Marketing ROI: Formula, Worked Example and Worksheet

How do you calculate marketing ROI?

Marketing ROI compares attributable gross profit with the full cost of the marketing activity: (attributable revenue × gross margin − marketing cost) ÷ marketing cost × 100. Include media, people, creative, agencies and allocated tools. State the period and attribution method. A revenue-to-spend ratio does not establish profit, and attributed revenue does not establish what marketing caused.

This guide uses an authored, hypothetical B2B campaign to make the calculation reproducible. It contains no client results or industry-average return claims. The November 5 revision removes unsupported channel benchmarks and vendor price comparisons from the earlier version.

Download the worked ROI worksheet (CSV). It contains the inputs and calculated outputs below; replace the assumptions with finance-approved figures before using it for a budget decision.

What is marketing ROI?

Marketing ROI is a defined return calculation, not a property a channel has in isolation. A useful report names the activity, cost boundary, outcomes assigned to it, time window and uncertainty.

This guide uses gross profit after cost of goods or service delivery, before marketing cost as its return basis. The result is a return before other operating costs and taxes. If finance uses contribution margin instead, name that basis and include the appropriate variable costs. Do not mix those return definitions in one comparison.

MeasureCalculationWhat it can tell you
ROASAd-attributed revenue ÷ ad spendRevenue credit per advertising dollar
Revenue-to-marketing-cost ratioAttributed revenue ÷ full marketing costRevenue coverage of the defined cost
Marketing ROI on gross profit(Attributed gross profit − full marketing cost) ÷ full marketing costReturn on the stated margin and attribution assumptions
Incremental marketing ROI(Incremental contribution − incremental marketing cost) ÷ incremental marketing costReturn on an estimated causal contribution
CACDefined acquisition costs ÷ acquired customersAcquisition cost for the stated cohort

A high-ROAS campaign can still lose money when margins are low or production and acquisition operations are expensive.

Google Ads’ ROI explanation also compares profit with costs, but its physical-product example divides by production plus advertising costs. This worksheet instead measures return on the marketing investment after applying gross margin. The denominator differs, so label the basis before comparing the percentages.

How to calculate marketing ROI

Define the cohort, reconcile revenue and margin, include every marketing cost once, then calculate the return. Keep the assumptions beside the result so another person can reproduce it.

1. Define the cohort and accounting period

Choose a campaign, customer cohort or channel and record when its costs and outcomes are measured. B2B leads created this month may close later. Keep cohort-to-date results separate from a calendar-month finance report.

Use a consistent revenue basis: recognized revenue, billed contract value and cash received are different measures. A signed annual contract is not automatically cash collected or profit earned this month. Reconcile refunds, cancellations and taxes as appropriate to the chosen basis.

2. Include the full cost once

CostEvidenceAllocation question
Media and sponsorshipsInvoices and platform billingDoes this belong to this campaign and period?
Creative and contentSupplier invoices or production recordsIs the asset used by several campaigns?
People and agenciesAgreed time allocation and feesAre shared sales or delivery costs already counted elsewhere?
Software and dataSubscription and usage recordsWhich share supports this activity?
Events and distributionVenue, travel and distribution invoicesHave follow-up and staff costs been included?

Record the allocation method before comparing campaigns. Do not charge a shared production cost in full to several channels, and do not exclude it from every channel. Keep the basis stable between reporting periods.

3. Reconcile attributed outcomes

Join accepted leads, qualified opportunities and closed deals using stable identifiers where permitted. Deduplicate deals across marketing and sales reports. Reconcile the revenue basis with finance before calculating profit.

Report unlinked deals and missing margin data as unknowns. A lead, opportunity, pipeline amount, won contract and received payment are separate stages. If sales have not matured, show those stages and a forecast separately; forecast pipeline is not realized ROI.

Use the marketing measurement checklist to identify the evidence and handoffs to verify first.

4. Calculate and disclose the assumptions

Attributed gross profit = Attributed revenue × Gross margin rate
Profit after marketing = Attributed gross profit − Full marketing cost
Marketing ROI (%) = Profit after marketing ÷ Full marketing cost × 100

If marketing cost is zero, the percentage is undefined. If revenue or margin is unknown, do not replace it with an industry average and present the result as measured profit.

Worked example: 5× ROAS and 28.6% marketing ROI

These numbers are hypothetical, in USD, for one campaign cohort. Assume the full $30,000 of recognized revenue is assigned to the campaign, the gross margin is 60%, and all costs below belong to that cohort. This is an attributed calculation; incrementality has not been measured.

InputAmount
Attributed recognized revenue$30,000
Gross margin60%
Ad spend$6,000
Creative production$3,000
Allocated people cost$4,000
Allocated software cost$1,000
Full marketing cost$14,000
  1. Attributed gross profit: $30,000 × 0.60 = $18,000.
  2. Profit after marketing: $18,000 − $14,000 = $4,000.
  3. Marketing ROI: $4,000 ÷ $14,000 × 100 = 28.6%, rounded.
  4. ROAS: $30,000 ÷ $6,000 = 5×.
  5. Revenue-to-full-cost ratio: $30,000 ÷ $14,000 = 2.14×, rounded.

Calling 5× ROAS “500% marketing ROI” would ignore the margin and $8,000 of other marketing costs. The CSV includes the inputs and outputs so you can reproduce the arithmetic.

Break-even revenue

For a positive, constant gross-margin assumption:

Break-even revenue = Full marketing cost ÷ Gross margin rate

Here, $14,000 ÷ 0.60 = $23,333.33, rounded. This covers the included marketing cost at the assumed margin. It is not a company-wide break-even point and excludes costs outside this model.

Attribution sensitivity

How much of the attributed revenue would have happened without the campaign? The ledger cannot answer that question. These three assumed incremental shares hold cost and margin fixed:

Assumed incremental share of $30,000Scenario revenueScenario gross profitScenario ROI
50%$15,000$9,000−35.7%
75%$22,500$13,500−3.6%
100%$30,000$18,00028.6%

These are sensitivity scenarios, not a measured confidence interval or evidence that one share is correct. A positive attributed return can still leave a budget decision uncertain.

Marketing ROI by channel

Use the same cost, margin and cohort rules across channels. Change the evidence collected to match the buying journey instead of assigning an assumed “typical ROI.”

ChannelCosts to includeInterpretation check
SEO and contentResearch, production, maintenance, technical work, tools and staffConnect landing pages to accepted outcomes; visits and AI citations are not revenue
Paid search and socialMedia, creative, management and acquisition operationsReconcile platform credit with deduplicated deals; account for existing demand and conversion lag
EmailAudience acquisition where applicable, production, software and operationsDistinguish new sales from purchases customers might have made without the email
Organic socialProduction, distribution and community workRecord referrals and assisted paths without summing overlapping credit
EventsSponsorship, venue, travel, staff and follow-upFollow a defined lead cohort through sales; pipeline is an intermediate outcome

For content, use the content ROI calculator to explore explicit inputs. For organic acquisition, use the SEO ROI calculator. Outputs remain scenarios until the inputs and attribution assumptions are supported by records.

The marketing analytics statistics dataset provides separately sourced observations about measurement practices. It should not be converted into an expected campaign return.

For AI search, Google’s AI features guidance says a supporting page must be indexed and eligible for a search snippet. Those are visibility prerequisites. Track resulting visits, accepted leads and reconciled sales separately before assigning any financial return to AI visibility.

Marketing ROI benchmarks by industry

A useful benchmark must match your profit, cost and measurement definitions. Before using one, establish whether it measures profit ROI, revenue-to-cost return, ROAS or allocated pipeline. Record its date, population, sample size, geography, business model, margin treatment and cost coverage. An unsourced range cannot tell you whether a campaign is viable.

Compare with an internal baseline on the same basis and the business’s return and payback requirements. This guide does not establish average ROI or CAC for SaaS, healthcare, financial services or e-commerce.

Marketing attribution and ROI

Attribution allocates credit across interactions; the allocation alone does not establish the campaign’s incremental profit. Google Analytics defines attribution as assigning credit to ads, clicks and other factors along the path to an action. Last-touch, first-touch and multi-touch are different allocation concepts; this does not mean every platform offers all three. Choose a reporting convention, name it and retain the underlying deal totals for reconciliation. Models can incorporate experimental evidence, but an attributed revenue total alone is not a measurement of your campaign’s incremental profit.

For an incremental question, consider a properly designed experiment with an appropriate comparison group. Decide the assignment method, outcome, sample requirements, conversion lag and analysis plan first. A before/after change alone can reflect seasonality, demand, other campaigns or measurement changes.

If an experiment is impractical, show the attribution result with its limitations and sensitivity analysis. Do not choose whichever model gives the largest return. The B2B attribution guide explains observed paths and incremental impact.

CAC and payback

CAC = Defined marketing and sales acquisition costs ÷ New customers acquired
Simple CAC payback = CAC ÷ Monthly gross profit per customer

A hypothetical $6,000 CAC and $500 monthly revenue at an 80% margin give $6,000 ÷ ($500 × 0.80) = 15 months. This simple payback assumes stable revenue and margin and ignores discounting. Churn, expansion, collection timing and changing cost to serve require a more detailed cash-flow model. No universal payback threshold is established here.

How to improve marketing ROI

Start with the largest evidenced obstacle to a useful decision or completed customer journey:

  1. Repair measurement failures. Check that accepted leads and won deals are captured once and assigned to the correct source. Preserve raw records when excluding suspicious traffic from an analysis.
  2. Fix confirmed conversion failures. Reproduce form, checkout or handoff failures before estimating their loss. Verify the repair, then compare outcomes over suitable periods.
  3. Review unit economics. Compare margin, cost to serve and cash timing. More attributed revenue can coexist with a worse return.
  4. Test reallocations. Historical average return is not necessarily the return on the next dollar. Define a bounded change and a decision rule rather than cutting an arbitrary share of spend.
  5. Include retention carefully. Separate realized contribution from forecast lifetime value and avoid crediting the same customer profit to acquisition and retention twice.

When analytics, CRM and finance disagree, a marketing audit should identify the reconciliation gap before recommending more spend. For implementation help, review the AI marketing audit scope and booking process.

Marketing ROI tools

Choose tools for evidence you cannot yet reconcile. Web analytics can record observed visits and conversion events; CRM records can track accepted leads and deals; accounting or payment records establish the revenue and collection basis. A spreadsheet can calculate ROI once those inputs are defined.

Before buying attribution software, test a reconciled deal sample. Check integrations, identity matching, refunds, currencies, exportability and missing-data handling. Verify current capabilities and prices for the quoted plan. A dashboard labelled “ROI” does not prove its cost and profit definitions match yours.

Common marketing ROI mistakes

  • Calling revenue or pipeline profit.
  • Comparing different windows, currencies or margin definitions.
  • Counting one deal in several channel totals without reconciliation.
  • Treating an AI citation or worksheet download as proof of a sale.
  • Substituting a generic average for missing customer outcomes.
  • Choosing the timeframe that makes the return look positive.
  • Reporting a forecast as realized return or a scenario as an experiment.

Frequently asked questions

What is a good marketing ROI?

A useful threshold depends on cost scope, margin, uncertainty, cash timing and available alternatives. Compare like-for-like results with a documented hurdle. A high revenue-to-spend ratio alone does not establish a profitable campaign.

What is the difference between ROI and ROAS?

ROAS divides ad-attributed revenue by advertising spend. This ROI calculation first applies gross margin and subtracts the full marketing cost, then divides by that cost. In the worked example, 5× ROAS corresponds to 28.6% attributed marketing ROI.

Can you calculate ROI before deals close?

You can model scenarios, but label them as forecasts. Report accepted leads, opportunities and pipeline separately from recognized revenue and received payments. Revisit the cohort as sales mature instead of presenting pipeline as realized return.

How do you calculate SEO or content ROI?

Apply the same profit-and-cost formula to a defined cohort and time horizon. Include production, distribution, maintenance, tools and people. State the revenue attribution method and whether incrementality was measured. Traffic growth alone does not establish ROI.

Does changing attribution improve ROI?

Changing attribution can change channel credit without changing total revenue, profit or cost. Reconcile the same deal totals and evaluate the effects of actual business changes separately.

What if marketing cost is zero or revenue is missing?

ROI is undefined when its cost denominator is zero. If revenue, margin or full costs are missing, report available measures and missing inputs instead of publishing a precise profit return.

Last verified: November 2026. The worksheet arithmetic and the three linked Google documentation pages were checked on November 5. Campaign figures are authored hypothetical inputs, not client outcomes or industry benchmarks.

AI Marketing Revenue Leak Audit

$500 founding audit with a revenue leak map and 30-day fix plan.

View service details

Google Preferred Sources

See more of my research in Google

Add Konabayev.com as a preferred source to find more fresh marketing and AI research in Google Search.

Have a relevant product or documented use case? View sponsorship formats and editorial requirements.