If you manage Google Ads accounts long enough, you start doing math in your head before the report even loads. You see 340 clicks and 12,000 impressions and you already know the CTR is somewhere around 2.8% before you open a spreadsheet. That instinct comes from repetition, not talent – and the fastest way to build it is to actually understand what’s happening behind every metric in your dashboard, not just where the number sits.
This is a working reference for every formula you’ll actually use while running Google Ads campaigns – from the basics like CTR and CPC to the numbers that determine whether a campaign is genuinely profitable, like break-even ROAS and CAC payback period. Bookmark it, use it while you’re building reports, and pull it up the next time a client asks why their “good ROAS” campaign somehow isn’t making money.
What This Formula Library Covers
Google Ads reporting throws a lot of acronyms at you, and most guides either stop at the definition or bury the math in jargon. This one is organized by what the formulas are actually used for:
- Performance formulas – CTR, CPC, CPM, conversion rate
- Cost and efficiency formulas – CPA, ROAS, ROI, break-even ROAS
- Customer value formulas – CAC, LTV, AOV, churn rate
- Profitability formulas – profit margin, net profit
- Auction and visibility formulas – impression share and its lost variants
- Bidding formulas – the math Google’s automated bidding is trying to solve for
Every section includes the formula, a plain-English explanation of what it tells you, and a worked example using realistic numbers so you can see how it plays out in an actual account.
Core Performance Formulas
These are the metrics you’ll see on the first tab of almost any Google Ads report. They tell you how your ads are performing at the auction and click level, before any conversion data enters the picture.
Click-Through Rate (CTR)
Formula: CTR = (Clicks ÷ Impressions) × 100
CTR tells you what percentage of people who saw your ad actually clicked it. It’s the first signal of whether your ad copy, headline, and targeting are actually resonating with the audience you’re bidding on.
Example: A search campaign gets 45,000 impressions and 990 clicks in a month. CTR = (990 ÷ 45,000) × 100 = 2.2%. Whether that’s good depends heavily on industry and campaign type – a Search campaign for a high-intent keyword should be pushing well past that, while a Display campaign at 2.2% would actually be strong. If you want to sanity-check your number, the average CTR by industry breakdown and is 2% CTR good in Google Ads post both go into this in more detail. Our CTR calculator does the math instantly if you’d rather not run it by hand every time.
Cost Per Click (CPC)
Formula: Average CPC = Total Cost ÷ Total Clicks
CPC is simply what you paid on average for each click, and it’s a downstream result of your bid, Quality Score, and competition – not a number you set directly (outside of Max CPC bidding).
Example: You spend $1,400 and get 350 clicks. Average CPC = $1,400 ÷ 350 = $4.00. This number by itself doesn’t tell you if the campaign is working – a $4.00 CPC on a keyword that converts at 8% can be far more profitable than a $1.50 CPC on a keyword that never converts. CTR and CPC move together in ways worth understanding; the CTR vs CPC comparison covers why a higher CTR often pulls your CPC down through Quality Score.
Cost Per Thousand Impressions (CPM)
Formula: CPM = (Total Cost ÷ Total Impressions) × 1,000
CPM matters most on Display and video campaigns where you’re paying primarily for visibility rather than clicks. It’s also useful for comparing the raw cost of reach across platforms.
Example: A Display campaign spends $600 and generates 240,000 impressions. CPM = ($600 ÷ 240,000) × 1,000 = $2.50. The CPM calculator is handy when you’re comparing bids across ad groups that use different bidding strategies.
Conversion Rate
Formula: Conversion Rate = (Conversions ÷ Clicks) × 100
This is where clicks turn into something that actually matters to the business – a purchase, a lead, a signup. A campaign can have a fantastic CTR and still lose money if the conversion rate is weak, because you’re paying for traffic that never does anything once it lands.
Example: 350 clicks produce 21 conversions. Conversion Rate = (21 ÷ 350) × 100 = 6%. If that number looks low compared to what you expected, the issue is rarely the ad itself – it’s usually the landing page, the offer, or a mismatch between search intent and what’s on the page. Checking search intent against your actual landing page content is worth doing before touching bids; the keyword intent checker can help spot that mismatch early.
Cost and Efficiency Formulas
Once you know how people are interacting with your ads, the next layer is understanding what those interactions cost you relative to what they’re worth.
Cost Per Acquisition (CPA)
Formula: CPA = Total Cost ÷ Total Conversions
CPA tells you what it actually costs to generate one conversion – a sale, a lead, an app install, whatever your conversion action is set up to track.
Example: You spend $1,400 and generate 21 conversions. CPA = $1,400 ÷ 21 = $66.67. Whether $66.67 is acceptable depends entirely on what that conversion is worth downstream, which is exactly why CPA on its own is an incomplete metric. Run your own numbers with the CPA calculator.
Return on Ad Spend (ROAS)
Formula: ROAS = (Revenue From Ads ÷ Ad Spend) × 100
ROAS is probably the most-watched metric in ecommerce Google Ads accounts, and also one of the most misunderstood. A 400% ROAS sounds great until you realize it doesn’t account for product cost, shipping, payment processing, or overhead.
Example: A campaign spends $2,000 and generates $8,000 in tracked revenue. ROAS = ($8,000 ÷ $2,000) × 100 = 400%. That’s a strong number on the surface, but whether it’s actually profitable depends on your margins – which is the entire point of the next formula. The ROAS calculator handles this quickly, and if you want the fuller picture, what counts as a good ROAS for ecommerce and why ROAS can look good but still not be profitable both dig into the gap between a healthy-looking ratio and actual profit.
Break-Even ROAS
Formula: Break-Even ROAS = (1 ÷ Profit Margin) × 100
This is the ROAS you need just to cover your costs – anything above it is genuine profit, anything below it means every sale is costing you money even though the campaign “looks” like it’s working.
Example: Your product has a 25% profit margin. Break-Even ROAS = (1 ÷ 0.25) × 100 = 400%. Notice that this matches the ROAS example above – which means that campaign is running right at break-even, not comfortably profitable, despite a headline number that most people would celebrate. This is exactly the trap covered in break-even ROAS explained. Calculate yours with the break-even ROAS calculator before you set any target ROAS bid strategy.
Return on Investment (ROI)
Formula: ROI = ((Revenue – Cost) ÷ Cost) × 100
ROI and ROAS get used interchangeably by people who haven’t run the numbers, but they answer different questions. ROAS looks at revenue relative to ad spend only. ROI looks at actual profit relative to total investment, which can include product cost, fulfillment, and other overhead if you build it into the “cost” figure.
Example: Using the same $2,000 spend and $8,000 revenue, but this time factoring in $5,000 of product and fulfillment cost on top of ad spend (total cost = $7,000): ROI = (($8,000 – $7,000) ÷ $7,000) × 100 = 14.3%. That’s a very different story than the “400% ROAS” headline number. The ROAS vs ROI breakdown walks through when to use each one, and the ROI calculator is set up to run this exact comparison.
Customer Value Formulas
Google Ads formulas don’t stop at the campaign level. If you’re managing a business (not just an ad account), you need to know what a customer is worth over time, not just what they cost to acquire.
Customer Acquisition Cost (CAC)
Formula: CAC = Total Acquisition Cost ÷ Number of New Customers
CAC is broader than CPA – it typically includes total marketing and sales cost, not just ad spend, divided by actual new customers rather than conversion events (which can include repeat purchases).
Example: A business spends $12,000 across ads, tools, and a portion of sales team time in a month, and acquires 80 new customers. CAC = $12,000 ÷ 80 = $150. The full CAC calculation guide covers what should and shouldn’t be included in that numerator, since this is where most people get the formula wrong. Run the math with the CAC calculator.
Customer Lifetime Value (LTV)
Formula: LTV = Average Order Value × Purchase Frequency × Customer Lifespan
LTV estimates how much revenue a customer generates over the entire relationship with your business, not just their first purchase. This is what makes a $150 CAC either reasonable or alarming.
Example: Average order value is $60, customers buy 4 times a year on average, and stay a customer for roughly 2.5 years. LTV = $60 × 4 × 2.5 = $600. Against a $150 CAC, that’s a 4:1 LTV:CAC ratio – generally considered healthy. The good LTV:CAC ratio guide explains why 3:1 to 5:1 tends to be the sweet spot, and why higher isn’t automatically better (it can mean you’re underinvesting in growth). The LTV calculator handles the multiplication for you.
Average Order Value (AOV)
Formula: AOV = Total Revenue ÷ Number of Orders
AOV feeds directly into both LTV and ROAS calculations, and it’s one of the more overlooked levers for improving overall account profitability – raising AOV through bundling or upsells can improve your effective ROAS without touching your bids at all.
Example: $24,000 in revenue from 400 orders. AOV = $24,000 ÷ 400 = $60. The AOV calculator is worth checking monthly – a slow AOV decline is often the first sign that your ads are attracting lower-intent traffic even while conversion rate holds steady.
Churn Rate
Formula: Churn Rate = (Customers Lost During Period ÷ Customers at Start of Period) × 100
Churn isn’t strictly a Google Ads metric, but it directly affects your customer lifespan assumption in the LTV formula, which means it indirectly affects how much you can afford to spend on acquisition.
Example: A SaaS business starts the month with 500 customers and loses 15. Churn Rate = (15 ÷ 500) × 100 = 3%. For context on what’s typical, SaaS churn rate benchmarks breaks this down by company stage and pricing tier. The churn rate calculator is quick if you’re tracking this monthly.
CAC Payback Period
Formula: CAC Payback Period (months) = CAC ÷ (Average Monthly Revenue Per Customer × Gross Margin)
This tells you how many months it takes to recoup what you spent acquiring a customer – a critical number for subscription and SaaS businesses where cash flow, not just eventual profitability, determines whether growth spending is sustainable.
Example: CAC is $150, average monthly revenue per customer is $25, and gross margin is 80%. Payback Period = $150 ÷ ($25 × 0.80) = 7.5 months. Whether that’s acceptable depends on your business model and funding situation – CAC payback period explained covers typical benchmarks by business type.
Profitability Formulas
These formulas move past ad performance entirely and look at what’s actually left after everything is paid for – which is ultimately the number that matters most.
Profit Margin
Formula: Profit Margin = ((Revenue – Cost of Goods Sold) ÷ Revenue) × 100
Example: A product sells for $60 and costs $42 to produce and ship. Profit Margin = (($60 – $42) ÷ $60) × 100 = 30%. This 30% figure is what you’d plug directly into the break-even ROAS formula above. The profit margin calculator makes this quick to run per SKU.
Net Profit
Formula: Net Profit = Total Revenue – Total Expenses (COGS + Operating Costs + Ad Spend + Other Overhead)
Example: $24,000 in revenue, $16,800 in COGS, $2,000 in ad spend, and $2,500 in other operating costs. Net Profit = $24,000 – ($16,800 + $2,000 + $2,500) = $2,700. This is the number that should ultimately decide whether a campaign gets more budget, not the ROAS dashboard alone. Try the net profit calculator to model this against different spend levels.
Impression Share and Auction Formulas
Impression share metrics tell you how much of the available auction volume you’re actually capturing – useful for diagnosing whether a campaign’s ceiling is budget, competitiveness, or something fixable.
| Metric | Formula | What It Tells You |
| Search Impression Share | Impressions Received ÷ Total Eligible Impressions × 100 | What percentage of available auctions you’re showing up in |
| Search Lost IS (Budget) | Estimated impressions missed due to budget ÷ Total eligible impressions × 100 | Whether you’re losing volume because you’re capped on spend |
| Search Lost IS (Rank) | Estimated impressions missed due to Ad Rank ÷ Total eligible impressions × 100 | Whether you’re losing volume because of bid or Quality Score, not budget |
Example: A campaign shows 62% impression share, with 20% lost to budget and 18% lost to rank. That split matters for decision-making – if most of the loss is budget-related, raising daily budget is the direct fix; if it’s mostly rank-related, the problem is more likely bid strategy or Quality Score, and simply adding budget won’t solve it.
Bidding Formulas
Even with automated bidding strategies like Target CPA and Target ROAS doing the heavy lifting, understanding the math behind them helps you set realistic targets instead of guessing.
Target CPA logic: Google’s system tries to get you as many conversions as possible while keeping your average CPA at or near your target. Setting Target CPA = Break-Even CPA ÷ 1 will typically get you volume at the edge of profitability rather than comfortably inside it – most accounts set targets 10-20% below their break-even CPA to leave margin for fluctuation.
Target ROAS logic: Target ROAS (%) = Break-Even ROAS + Desired Profit Margin Buffer. If your break-even ROAS is 400% and you want a comfortable profit cushion, setting a target of 500-550% gives the algorithm room to optimize while still protecting margin.
Neither of these bidding strategies performs well without at least 15-30 conversions in the lookback window, and both tend to underperform if you set targets far outside your account’s historical CPA or ROAS – Google’s algorithm needs a realistic target to actually learn from, not an aspirational one.
Worked Example: Full Campaign Walkthrough
Here’s how these formulas connect in a real scenario. Imagine an ecommerce brand selling a $60 skincare product with a 35% profit margin, running a single Search campaign.
Monthly data:
- Impressions: 50,000
- Clicks: 1,100
- Ad Spend: $3,300
- Conversions: 55
- Revenue: $3,850 (average order value stays close to $70 due to some upsells)
Working through it step by step:
- CTR = (1,100 ÷ 50,000) × 100 = 2.2%
- Average CPC = $3,300 ÷ 1,100 = $3.00
- Conversion Rate = (55 ÷ 1,100) × 100 = 5%
- CPA = $3,300 ÷ 55 = $60.00
- ROAS = ($3,850 ÷ $3,300) × 100 = 116.7%
- Break-Even ROAS = (1 ÷ 0.35) × 100 = 285.7%
This is where the story changes. A 116.7% ROAS is nowhere near the 285.7% break-even point, which means this campaign is losing money on every sale despite having a respectable CTR and conversion rate. The problem isn’t visible anywhere in the top-line metrics – it only shows up once break-even ROAS enters the picture. The fix here isn’t “more traffic,” it’s addressing CPA relative to margin, whether through bid adjustments, tighter keyword targeting, or improving AOV through bundling.
This is the exact scenario covered in what counts as a bad ROAS – a number that looks mediocre but not alarming on its own can actually mean the campaign is underwater once real costs are factored in.
Common Mistakes When Using These Formulas
Treating ROAS as a profitability metric. ROAS only measures revenue against ad spend. It says nothing about product cost, refunds, shipping, or overhead. Two campaigns with identical ROAS can have completely different actual profit if their margins differ.
Calculating CAC using ad spend alone. CAC should reflect the full cost of acquiring a customer, including tools, salaries, and agency fees where relevant – not just what you spent in the Google Ads platform.
Ignoring attribution windows. A conversion rate or CPA calculated on a 1-day click window will look very different from the same account measured on a 30-day window, especially for higher-consideration purchases. Always check which window a report is using before comparing numbers across campaigns or time periods.
Averaging CTR or conversion rate across very different campaign types. Blending Search and Display CTR into one number is close to meaningless, since the two channels operate at completely different baseline rates – Display CTR is naturally much lower even when performing well.
Setting Target CPA or Target ROAS without enough historical data. Automated bidding strategies need conversion volume to learn from. A target set on a campaign with 5 conversions a month is closer to a guess than a data-driven decision.
Forgetting that impression share loss has two separate causes. Assuming all lost impression share is a budget problem (and raising spend accordingly) when it’s actually a rank problem wastes money without fixing the underlying issue.
Building Your Own Google Ads Formula Dashboard
Once you’re comfortable with these formulas individually, the real value comes from tracking them together over time rather than checking them one at a time inside the Google Ads interface. A simple dashboard – even a spreadsheet – that pulls CTR, CPC, conversion rate, CPA, ROAS, and break-even ROAS side by side for each campaign makes it much easier to spot when a metric drifts before it becomes a real problem.
If you’re managing several accounts or want this without building a spreadsheet from scratch, the marketing KPI dashboard tool is built for exactly this, and the broader marketing KPI formula library extends beyond Google Ads into the full set of metrics most marketing teams track monthly.
It’s also worth setting up clean UTM tracking before you start pulling this data together, since mismatched or missing UTM parameters are one of the most common reasons reported revenue doesn’t match what Google Ads shows. The UTM builder and the UTM parameter cheat sheet are both useful references for keeping that consistent across campaigns.
Understanding these formulas is what separates reading a dashboard from actually managing a campaign. The numbers on their own don’t tell you what to do next – it’s the relationships between them, like ROAS against break-even ROAS, or CAC against LTV, that turn a report into an actual decision. Keep this page bookmarked, and if you want to explore more of QuickMarketingTools’ calculators built around these exact formulas, the full marketing and advertising calculators collection and complete tools directory are both good places to start.
Frequently Asked Questions
What’s the difference between CPA and CAC?
CPA is a campaign-level metric measuring cost per conversion within the ad platform. CAC is a business-level metric measuring the full cost of acquiring a customer, often including sales, tooling, and overhead beyond just ad spend.
Is a higher ROAS always better? Not necessarily.
A very high ROAS can sometimes indicate a campaign is being too conservative with targeting, missing volume it could profitably capture at a slightly lower ROAS. The right target depends on your break-even ROAS and how much profit margin yu want to protect above it.
How often should I recalculate break-even ROAS
Any time your product costs, margins, or fulfillment costs change – price increases, new shipping rates, or new suppliers can shift your break-even point meaningfully, and a break-even ROAS calculated six months ago may no longer reflect current reality.
Why does my Google Ads conversion rate not match my ecommerce platform’s conversion rate?
This usually comes down to attribution windows, different definitions of a “conversion,” or tracking gaps such as ad blockers and cookie restrictions. It’s worth comparing the two periodically rather than assuming they’ll always match exactly.
Can I use these formulas for Performance Max campaigns?
Yes – the formulas themselves don’t change based on campaign type. What changes with Performance Max is visibility into the individual levers (like impression share by placement), since Google reports less granular data for these campaign types than for standard Search campaigns.
