How to Calculate Google Ads ROAS (and Why Raw Revenue Misleads)
The direct answer to how to calculate Google Ads ROAS is to divide your ad-attributed revenue by your total ad spend. In Google Ads, that ratio appears as the ‘Conv. value / cost’ column. But after managing over $12M in annual ad spend for DTC and B2B accounts, I insist raw ROAS is incomplete without margin context.
When I first audited a furniture retailer’s account, they celebrated a 4.0 ROAS. The founder considered it a win. Yet their 22% gross margin meant each ad dollar returned only $0.88 of gross profit after product cost. They were scaling a loss. That early mistake shaped my profit-aware framework.
To calculate Google Ads ROAS correctly, use ROAS = Conversion Value ÷ Ad Cost. Then immediately filter by margin. A 3.0 ROAS is not inherently ‘good’—it’s only good if your break-even threshold is lower. We’ll quantify that below.
Raw ROAS tells you how much revenue you generated per ad dollar. Profit-aware ROAS tells you whether you should keep the lights on.
Most top-ranking articles stop at the division step. They miss that Google’s reported revenue often includes full-price sales later discounted, or excludes shipping which erodes margin. The calculation is simple; the data hygiene is not.
The Profit-Aware ROAS Formula: Turn Revenue Into Real Profit
The profit-aware method multiplies raw ROAS by gross margin. The complete formula: Profit-Aware ROAS = (Revenue × Gross Margin) ÷ Ad Spend. If you prefer ratios, True ROAS = Raw ROAS × Margin%. This single tweak separates vanity metrics from financial truth.
Gross margin is (Revenue − COGS) ÷ Revenue, not net profit. For a $100 product with $60 COGS, margin is 40%. If Google Ads drove $1,000 revenue on $250 spend, raw ROAS = 4.0. Profit-aware ROAS = 4.0 × 0.40 = 1.6. You earned $1.60 gross profit per $1 spent.
The thing nobody tells you about Google Ads reporting is that ‘Conv. value’ frequently pulls retail price without subtracting discounts or returns. In one account, 14% of converted revenue was refunded within 60 days, silently inflating ROAS by that exact percentage until we reconciled.
Break-Even ROAS: The Number You Actually Need
Break-even ROAS is the inverse of gross margin: Break-Even ROAS = 1 ÷ Gross Margin. A 40% margin business must achieve at least 2.5 ROAS to cover product costs. Below that, every click burns cash; above it, you fund overhead.
This answers a frequent query: is a 2.5 ROAS good? At exactly 40% margin, 2.5 is survival, not success. For a 70% margin digital product, 2.5 is comfortably profitable. The same number flips meaning with margin.
Below is the benchmark matrix I deploy in every audit. It maps margin to break-even raw ROAS and judges the popular ‘300% ROAS’ (3.0) claim:
- 10% margin → Break-even 10.0 → 3.0 ROAS loses money fast (is 300% roas good? No)
- 20% margin → Break-even 5.0 → 3.0 ROAS still unprofitable
- 33% margin → Break-even 3.0 → 3.0 ROAS breaks even (is 300% roas good? Only at this margin)
- 40% margin → Break-even 2.5 → 3.0 ROAS profitable (is 300% roas good? Yes, modestly)
- 50% margin → Break-even 2.0 → 3.0 ROAS solid
- 70% margin → Break-even 1.43 → 3.0 ROAS excellent
- 85% margin → Break-even 1.18 → 3.0 ROAS exceptional
I recommend setting a target profit ROAS = break-even × 1.3 to cover fixed costs. That nuance is absent from competitor calculators.
Contribution Margin vs Gross Margin
Advanced practitioners should note gross margin excludes fulfillment, payment fees, and returns. Contribution margin subtracts those variable costs too. For accurate profit-aware ROAS, I often use contribution margin. A 40% gross margin can drop to 25% contribution after $8 shipping per order—changing break-even from 2.5 to 4.0 ROAS.
In a subscription box account, gross margin was 55% but contribution fell to 30% after pick-pack costs. Raw 3.0 ROAS looked great; profit-aware using contribution was 0.9—a loss. Always ask what costs are baked into your denominator.
Case Study: From 3.0 Raw to 1.1 Profit-Aware
One client sold fitness equipment at $300 AOV, 35% gross margin. Google reported 3.0 ROAS on $20k spend → $60k revenue. Exciting. But returns ran 18%, and credit card fees took 3%. Effective contribution margin was 22%. True profit-aware ROAS = 3.0 × 0.22 = 0.66. They were losing $0.34 per ad dollar.
We cut wasted branded spend, shifted to high-margin accessories, and lifted contribution to 38%. At same raw 3.0, profit-aware became 1.14. That case is why I never trust a screenshot of ‘Conv. value / cost’ without a margin appendix.
Step-by-Step: Calculate True ROAS in Google Sheets
We offer a free Sheets template that auto-calculates true ROAS from ad spend, revenue, and margin. You input three cells; it outputs raw, profit-aware, and break-even. If you want instant web-based math, our Google Ads ROAS Calculator mirrors the logic with margin sliders.
Manual setup: A2 = Ad Spend, B2 = Revenue, C2 = Margin%. D2 = =B2/A2 (raw). E2 = =(B2*C2)/A2 (profit-aware). F2 = =1/C2 (break-even). Apply to rows. The discipline is auditing inputs weekly against bank deposits.
One edge case: if you sell mixed-margin baskets, use weighted average margin. I once used blended 35% for a grocery client, but high-margin cheese subsidized low-margin milk, hiding that milk campaigns lost money. Segment by category.
What’s a Good ROAS on Google Ads? Margin-Based Benchmarks
The search query ‘What’s a good ROAS on Google Ads?’ invites generic answers like 4:1. In my agency’s dataset of 60+ accounts, profitable scaling happened only when raw ROAS exceeded break-even by ≥20%. That’s the real benchmark.
Consider 300% ROAS (3.0). Is 300% ROAS good? For e-comm with 30% margins, 3.0 yields profit-aware 0.9 before fixed costs—net loss. For services at 80% margin, 3.0 is stellar. The metric is relative, not absolute.
Another query: is a 2.5 ROAS good? As shown, 2.5 equals break-even at 40% margin. Lower margin = loss; higher = profit. I coach clients to demand a ‘target profit ROAS’ = break-even × 1.3 to fund overhead and growth.
Segment by campaign type too. Brand search often shows 10+ ROAS but cannibalizes organic traffic. Cold prospecting may sit at 1.8 yet drive new-customer LTV that triples true return. Raw ROAS alone can’t capture that—you need margin and LTV modeling.
ROAS by Industry (Realistic Ranges)
From client work, typical raw ROAS ranges before profit: grocery 1.5–2.5 (margins thin), apparel 2.5–4.0, SaaS 4.0–8.0, local services 3.0–6.0. But ‘good’ means above break-even contribution. A SaaS at 8.0 with 80% margin is fantastic; a grocery at 2.5 with 10% margin is disastrous.
I advise benchmarking against your own history, not industry averages. Pull three months of spend and contribution, compute profit-aware ROAS, and set that as your baseline. Then improve 10% quarterly.
Is $20 a Day Good for Google Ads? Micro-Budget Reality
Small business owners ask: is $20 a day good for Google Ads? At $600 monthly, you’re in micro-budget territory. It’s not inherently good or bad—it’s constrained. With $20/day and a $2 average CPC, you get ~10 clicks/day, maybe 0.3 conversions/day at 3% CVR. That’s 9 conversions/month.
From experience, Target ROAS bidding fails at this spend because Google’s documentation suggests ~30 conversions/month per campaign to exit learning. At $20/day with $50 CPA, you get ~12—too few. Manual CPC or maximize clicks with tight geo works better.
The micro-budget trade-off: you can test keyword intent, but not scale. I ran $20/day campaigns for a local plumber that validated emergency-repair keywords, but we only scaled after proving LTV and raising to $75/day. Treat $20 as tuition, not profit center.
Also, at $20/day, a single invalid click or bot can wreck a day’s data. Use IP exclusions and click fraud monitoring. The smaller the budget, the larger the relative noise.
Exact Google Ads Column Setup for Accurate ROAS
To calculate Google Ads ROAS inside the UI, surface the right columns. Open Campaigns, click ‘Columns’ → ‘Modify columns’ → ‘Conversions’. Add ‘Conv. value’, ‘Cost’, and ‘Conv. value / cost’. This ratio is native ROAS. Without it, you’re flying blind.
Practitioner caveat: conv. value only populates if you set conversion values in Tools → Conversions. Assign constant or dynamic values via GTM or CMS. I’ve seen accounts where the column showed 0 because values were left at default ‘1’—making ROAS look like 1:1 always.
Dynamic vs Static Conversion Values
Static values (e.g., every purchase = $50) are easy but inaccurate for varied carts. Dynamic values pass actual order total. For lead-gen, use offline import to assign real deal values. Misvalued revenue is the top tracking pitfall I audit.
Verifying Conversion Value with GTM
In Google Tag Manager, use a data layer variable for transaction total. Fire the conversion tag only on purchase confirmation, not on cart add. I once found a tag firing on page view, double-counting revenue and showing 6.0 ROAS where true was 3.0. Debug with Preview mode always.
Attribution Window Effects on ROAS
Google’s default attribution (last click, 30-day view) can shift ROAS by 15–40% versus data-driven. Longer windows credit more conversions to upper-funnel ads, lowering apparent ROAS on branded terms. Choose the model that matches your sales cycle; B2B may need 90-day windows.
For accurate calculation, pull ‘Conv. value / cost’ under the same attribution you use for bidding. Mixing models creates false positives. I standardize clients on data-driven once they have volume, else position-based.
Tracking Pitfalls That Inflate or Deflate Your ROAS
Most people don’t realize Google counts conversion value at conversion time, not revenue recognition. If you sell annual subscriptions but count full value upfront, ROAS looks amazing while cash lags. I recommend valuing at first payment only, then import renewal values later.
Other pitfalls: duplicate conversions from multiple touchpoints (set ‘count once’ for same action), refund adjustments not fed back, cross-device lag. For call extensions, integrate call tracking with duration thresholds so 5-second misdials aren’t revenue.
Returns and Refunds: The Silent ROAS Killer
An e-comm account showing 4.0 ROAS but with 20% return rate effectively has 3.2 true revenue ROAS. If margins are 30%, profit-aware drops from 1.2 to 0.96. Feed refund data back via adjustments or offline import. Google supports conversion adjustments for value and status.
I schedule a monthly refund reconciliation: pull refunded orders from Shopify, match to GCLID where possible, send adjustment. This alone corrected a client’s ‘profitable’ campaign that was actually losing 8% after returns.
Offline Conversions and CRM Latency
Offline conversions are special. If sales close in CRM over 30 days, import with correct values and dates. Failure understates true ROAS for long-cycle campaigns—I’ve seen B2B accounts appear at 1.2 but climb to 4.0 after offline import. That’s a massive blind spot.
The most dangerous ROAS is the one that looks healthy because your tracking is incomplete.
Also watch for currency mismatches in international campaigns. A €100 conversion valued as $100 inflates US-rooted ROAS by current exchange rate. Set currency at account level correctly.
From Raw ROAS to Target ROAS Bidding: When It Makes Sense
Google’s Target ROAS bidding automates bids toward a desired return. But it’s no fix for poor margin math. Set target based on break-even + buffer, not guessed ‘4.0’.
Compare three approaches: Manual CPC (control, low data needs), Target ROAS (algorithmic, needs 30+ conversions/month), Maximize Conversion Value (similar, no fixed target). For $20/day account, manual or maximize clicks wins. For $10k/month store with 50% margin, Target ROAS at 2.5 is ideal.
Why Target ROAS Can Stall Spend
The algorithm throttles bids to hit efficiency. If you set target too high (e.g., 5.0 in a 2.0 break-even market), it may slash impressions to protect ROAS, choking growth. I’ve lowered targets from 4.0 to 2.8 and doubled volume while staying profitable.
Edge case: bundles with varying margins break single targets. Split campaigns by margin tier. I split a client’s catalog into ‘high >50%’ and ‘low <30%' with targets 2.0 vs 4.0—profits rose 18% without extra spend.
Remember, Target ROAS can also overvalue branded traffic. Use portfolio targets or exclude brand from shared budgets to avoid skewed learning.
Free Profit-Aware ROAS Sheets Template and 7-Day Audit
We published a free Sheets template that auto-calculates true ROAS from ad spend, revenue, and margin—available via our calculator resources. It flags red if profit-aware ROAS <1.0. For quick checks, the Google Ads ROAS Calculator is faster.
How the Sheets Formula Works (Exact Cells)
Template tabs: ‘Input’ (spend, revenue, margin), ‘Output’ (raw, profit-aware, break-even), ‘Benchmark’ (matrix). Formulas use ARRAYFORMULA to scale rows. We pre-loaded conditional formatting: green if profit-aware >1.3, red if <1.0.
To apply everything, run this 7-day audit:
- Day 1: Export last 30 days spend and revenue per campaign from Google Ads.
- Day 2: Verify conversion values match actual order totals post-discount in analytics.
- Day 3: Calculate gross margin per product line; map to break-even ROAS using matrix.
- Day 4: Add ‘Conv. value / cost’ column; note discrepancies vs your Sheet.
- Day 5: Import offline conversions if B2B or long cycle.
- Day 6: Set target ROAS = break-even × 1.3 in a test campaign only.
- Day 7: Review profit-aware ROAS table; pause campaigns below 1.0.
This process rescued three accounts from premature scaling. It’s not glamorous, but margin-aware math is the only honest way to judge ad success.
Final Thought: ROAS Is a Means, Not the Mission
Calculating Google Ads ROAS is easy; interpreting it is the craft. I’ve shared the profit-aware formula, benchmark matrix, column setup, and micro-budget reality because those fill the gaps that sink accounts. Use the template, question every revenue number, and let margin be your compass.
If you take one framework: compute break-even ROAS before judging any campaign. Then layer target profit. That’s how you turn Google Ads from a guessing game into a predictable lever.