Marketing ROI Formula: How to Calculate Your Return on Marketing Investment

The marketing ROI formula is (Revenue minus Marketing Cost) divided by Marketing Cost, multiplied by 100. Expressed as a percentage, it measures how much net profit your marketing investment generates. A ratio of 5:1 means your marketing returns five dollars for every dollar spent -- a strong benchmark for businesses.

TL;DR: What Is Marketing ROI?

• Marketing ROI measures how much profit your marketing activities generate relative to their cost. The basic formula is (Revenue - Marketing Cost) / Marketing Cost x 100, expressed as a percentage.
• A 5:1 ratio is considered strong marketing ROI. A 2:1 ratio is roughly break-even after overhead and cost of goods sold. These are benchmarks, not hard rules -- your target depends on margins and business model.
• Marketing ROI is not the same as ROAS. ROAS measures revenue per dollar of ad spend at the channel level. Marketing ROI measures net return on total marketing investment, including staff, tools, and agency fees.
• Two formula variants exist: the simple revenue-based version and the gross-profit version. The gross-profit variant is more accurate because it accounts for the cost of delivering what you sold.
• Attribution is the hardest part. With multiple channels touching each customer journey, choose an attribution model and apply it consistently.

What Is the Marketing ROI Formula?

The marketing ROI formula tells you whether your marketing investment is generating a net gain or loss:

Marketing ROI = (Revenue - Marketing Cost) / Marketing Cost x 100

Marketing cost covers ad spend, agency retainers, software subscriptions, content production, and marketing salaries. Revenue is total sales attributed to those marketing efforts over the same period.

Here is an example. Spend $10,000 on marketing and attribute $50,000 in revenue: ($50,000 - $10,000) / $10,000 x 100 = 400%, or a 4:1 ratio. For every dollar invested, you earn four dollars back.

If positive, marketing generates more revenue than it costs before overhead. If negative, costs exceed attributed revenue and something needs to change.

What Is the Difference Between Simple ROI and Gross-Profit ROI?

The simple formula uses total revenue. The gross-profit variant replaces revenue with gross profit (Revenue minus COGS):

Marketing ROI (gross-profit) = (Gross Profit - Marketing Cost) / Marketing Cost x 100

This distinction matters most for low-margin businesses. Consider a retailer with $50,000 revenue, $40,000 COGS, and $10,000 marketing cost:

• Simple ROI: ($50,000 - $10,000) / $10,000 x 100 = 400% -- looks great
• Gross-profit ROI: ($10,000 - $10,000) / $10,000 x 100 = 0% -- actually break-even

For most businesses, the gross-profit variant is more useful. For pure software companies with near-zero marginal costs, the two formulas converge and the simple version is a reasonable proxy.

What Is a Good Marketing ROI Ratio?

The most cited benchmark is 5:1 -- five dollars of revenue per dollar of marketing spend. At this level, marketing generates net contribution after COGS and some overhead. 2:1 is break-even territory: after COGS and overhead, there is often little to no net profit left.

These are not absolute. A SaaS company with 80% margins might thrive at 3:1, while a retailer with 30% margins might need 5:1+ to break even. Your target should reflect your unit economics -- gross margin, customer lifetime value, and payback period. Channel maturity also matters: new channels often start negative, and the trend direction counts as much as the absolute number.

How Do You Calculate Marketing ROI in Excel?

Set up in under five minutes:

1. Enter revenue. Cell A1: label "Revenue". Cell B1: the dollar amount.
2. Enter marketing cost. Cell A2: label "Cost". Cell B2: total marketing spend.
3. Enter the formula. Cell A3: label "ROI". Cell B3: =(B1-B2)/B2.
4. Format as percentage. Select B3, apply percentage format (Ctrl+Shift+%). You will see, for example, 400%.

For multi-channel tracking, expand horizontally: Column B for Facebook, C for Google Ads, D for email, E for content, and F for totals. In each channel's ROI row, use the same formula. The total column uses SUM across columns.

To add a time dimension, create separate tabs per month or quarter, then use =AVERAGE('Jan:Mar'!B3) in a summary tab. Apply conditional formatting with a green-yellow-red color scale on ROI cells for at-a-glance channel health.

What Are the Biggest Marketing ROI Attribution Challenges?

Attribution is where most ROI calculations break down. The formula is simple; deciding which revenue to credit to which channel is the hard part.

Multi-touch journeys. A customer might discover you via organic search, click a retargeting ad, open three emails, and convert through branded search. Last-click credits the final touch; first-click credits the first. Multi-touch distributes credit, but requires sophisticated tracking. Each model yields different ROI numbers for the same spend.

Offline conversions. Revenue that originated from a LinkedIn ad but closed over a sales call can disappear from digital attribution entirely. See our offline conversion tracking guide for closing this gap.

Long sales cycles. In B2B, a deal might take six to eighteen months to close. Monthly ROI reporting for long-cycle businesses produces misleading results. Use a rolling-twelve-month view.

Brand awareness spend. Top-of-funnel activities -- content, events, brand campaigns -- generate trust that fuels conversions through other channels. Last-click attribution makes these look like zero ROI when they did the heavy lifting. Pick a model and stick with it. Our attribution models guide covers the tradeoffs.

What Does Marketing ROI Look Like Across Different Channels?

Marketing ROI varies significantly by channel because each has a different cost structure, audience intent, and measurement profile:

Google Ads produces predictable ROI because search intent is explicit. See our Google Ads campaign structure guide.

Facebook and Instagram Ads produce lower average ROI but scale faster. Creative is what matters most. Customers often see a social ad then convert through search, so reading Facebook ROI in isolation understates its true contribution.

Email marketing shows the highest ROI on paper because marginal send cost is near zero. The catch: that ROI does not reflect the cost of building the list. Even with list-building costs factored in, email is typically the strongest channel for most businesses.

Content and SEO follow a J-curve: negative ROI for the first six to twelve months, then rising returns as content ranks. It is also the hardest channel to attribute because conversion may happen weeks after the initial visit.

What Are the Most Common Marketing ROI Mistakes?

Even experienced teams make systematic errors when calculating marketing ROI:

1. Using revenue instead of gross profit. If your product costs $60 to make and $10 to ship, a $100 sale leaves $30 in gross profit. An ROI calculated on $100 overstates the true return dramatically.
2. Counting only ad spend as marketing cost. Marketing cost includes agency fees, in-house salaries, software subscriptions, and freelancer fees. Leaving out half your costs inflates ROI.
3. Changing attribution models without restating historical data. Switching from last-click to data-driven attribution makes channel ROI numbers jump or drop for reasons unrelated to performance. Always restate prior periods under the new model.
4. Expecting instant ROI from long-cycle channels. Content, SEO, and brand building take months to show returns. Measuring them on a thirty-day cycle guarantees cutting investments that would have paid off later.
5. Ignoring incrementality. Some sales attributed to marketing would have happened anyway -- existing customers reordering or word-of-mouth referrals. True ROI measures incremental revenue that would not have occurred without the marketing. Holdout tests isolate this.
6. Over-optimizing for the ROI ratio. A 10:1 ROI on a $1,000 budget returns $1,000. A 3:1 ROI on a $100,000 budget returns $200,000. Growth-stage companies benefit more from total dollar return than from ratio efficiency.

Key Takeaways

• The marketing ROI formula is (Revenue - Marketing Cost) / Marketing Cost x 100. A 5:1 ratio (400%) is strong; 2:1 (100%) is break-even. Your target depends on margins, costs, and business stage.
• Use the gross-profit variant for more accuracy: (Gross Profit - Marketing Cost) / Marketing Cost x 100. The simple revenue formula ignores COGS and overstates returns for low-margin businesses.
• Marketing ROI is not ROAS. ROAS tracks channel-level ad efficiency. Marketing ROI measures total return on all marketing investment including staff, tools, and overhead.
• Attribution is the hardest part. Multi-touch journeys, offline conversions, long sales cycles, and brand awareness spend complicate revenue assignment. Pick an attribution model and apply it consistently.
• Channel ROI varies widely. Email often produces the highest ratio, content compounds over time, Google Ads is predictable, and social ads are scalable. Read each channel in context.
• Common mistakes -- using revenue instead of gross profit, undercounting costs, ignoring incrementality, expecting instant returns -- all inflate ROI. Fix these before adding sophistication.

For industry-specific ROI benchmarks, see our guide on marketing ROI benchmarks by industry.

Frequently Asked Questions

What Is the Marketing ROI Formula?

The marketing ROI formula is (Revenue minus Marketing Cost) divided by Marketing Cost, multiplied by 100 to express it as a percentage. For example, if you spend $10,000 on marketing and generate $50,000 in attributed revenue, your marketing ROI is 400%, or a 4:1 ratio. A more accurate variant uses gross profit instead of revenue: (Gross Profit minus Marketing Cost) / Marketing Cost x 100.

What Is a Good Marketing ROI?

A 5:1 ratio (400%) is widely considered a strong marketing ROI. At this level, marketing is generating net contribution after COGS and some overhead. A 2:1 ratio (100%) is roughly break-even -- after subtracting COGS and overhead, there is typically little to no net profit. The right target depends on your margins, customer lifetime value, and business model. A SaaS company with high margins might do well at 3:1, while a low-margin retailer might need 6:1 or higher.

What Is the Difference Between Marketing ROI and ROAS?

ROAS (Return on Ad Spend) measures revenue generated per dollar of ad spend at the channel level. Marketing ROI measures net return on total marketing investment at the business level, including ad spend, agency fees, marketing salaries, software subscriptions, content production, and all other marketing-related costs. A campaign can show a strong ROAS of 5:1 but a weak marketing ROI of 1.5:1 once you add the cost of the team, tools, and creative that supported it.

How Do You Calculate Marketing ROI in Excel?

Set up three rows: Total Revenue in B1, Marketing Cost in B2, and the formula =(B1-B2)/B2 in B3. Format B3 as a percentage. For multi-channel tracking, expand columns across for each channel (Facebook, Google, email, content) and add a total column. Create separate tabs per time period and use a summary tab to average ROI across months or quarters. Apply conditional formatting with a green-yellow-red color scale for at-a-glance channel performance.

What Are Common Marketing ROI Mistakes?

The six most common mistakes are: using revenue instead of gross profit in the formula (overstating returns for low-margin businesses), counting only ad spend and ignoring staff, tool, and agency costs (undercounting the denominator), switching attribution models without restating historical data (breaking trend comparability), expecting instant ROI from long-cycle channels like content and SEO (canceling investments too early), ignoring incrementality (counting sales that would have happened anyway), and over-optimizing for the ROI ratio at the expense of total dollar return (protecting efficiency but sacrificing growth).

Related Articles

• Brand Tracking: How to Measure Brand Health and Share of Voice
• Marketing Ops Metrics: The KPIs That Measure Marketing Operations