Free tool
CTR calculator
CTR = clicks ÷ impressions × 100. Use the click-through rate formula to work out CTR, plan clicks and impressions, find the CTR you need for a target CPC, and test whether one ad really beats another.
Use clicks and impressions from the same ads and dates. Add the cost to see CPC and CPM.
Each click cost 1.25, and 1,000 impressions cost 12.50 (CPM).
Get these numbers from your own ad accounts in Claude or ChatGPT
Start free3-day free trial · no card needed
CTR formula: how to calculate click-through rate
Click-through rate (CTR) is the share of ad impressions that turned into a click. CTR = clicks ÷ impressions × 100. Google gives the same sum, clicks ÷ impressions, with its own example: 5 clicks from 100 impressions is a 5% CTR.1 Take clicks and impressions from the same ads and the same dates, or the percentage won't mean much.
Formula: CTR = clicks ÷ impressions × 100
Worked example
Say an online bag shop's ads were shown 60,000 times and got 600 clicks. 600 ÷ 60,000 × 100 = 1% CTR, or 10 clicks for every 1,000 impressions. The campaign cost $750, so each click cost $1.25 and each 1,000 impressions cost $12.50.
The answer is a percentage, so a CTR of 0.5% means one click for every 200 impressions. If you find percentages below 1% hard to picture, the calculator also shows clicks per 1,000 impressions.
How to calculate CTR in Excel or Google Sheets
Put clicks in column B and impressions in column C. In column D, enter =B2/C2 and format the column as a percentage. Use =IFERROR(B2/C2,"") for rows that have no impressions yet.
For the CTR of several ads or campaigns together, add up all the clicks and all the impressions first, then divide. Averaging each row's CTR gives an ad with 200 impressions the same weight as one with 200,000, and the result is wrong.
CTR in Google Ads, Meta (Facebook) Ads and Search Console
In Google Ads, CTR is a column on ads, keywords and listings. It also feeds into the keyword's expected CTR, "which is a component of Ad Rank".1 Expected clickthrough rate is also one of the three parts of Quality Score: "the likelihood that your ad will be clicked when shown".2
Meta reports more than one CTR, and they measure different clicks. CTR (all) is "the percentage of times Accounts Center accounts saw your ad and performed a click (all)". Link CTR counts only "an inline link click", and outbound CTR only "an outbound click".3 Both are subsets of all clicks, so CTR (all) is always at least as high as the other two. When you compare a Meta campaign with a Google one, or with last month's report, check which CTR you're reading.
Google Search Console uses the same formula for organic search: "Click-through rate: the calculation of (clicks ÷ impressions)".4 So the calculator works for search results too, as long as clicks and impressions come from the same report.
How many clicks will my ads get?
Turn the formula around to plan. Expected clicks = impressions × CTR. 60,000 impressions at a 1% CTR should bring about 600 clicks. Add a conversion rate in the Clicks mode and it estimates sales or leads too: at 2%, 600 clicks become about 12 orders.
To work backwards from a goal, impressions needed = clicks wanted ÷ CTR. For 600 clicks at 1% you need 60,000 impressions. Add the CPM you expect and the Impressions mode shows the budget, here $750 at a $12.50 CPM. The CPM calculator does the same planning from the budget side.
These are estimates. CTR moves from week to week, so use a recent average from the same campaign type rather than a number from another account.
What CTR do you need for a target cost per click?
When you pay for impressions, CTR decides what each click costs. Cost per click = CPM ÷ (10 × CTR%), so the CTR you need for a target CPC is CPM ÷ (10 × target CPC).
The bag shop pays a $12.50 CPM and wants clicks for $1 or less. 12.50 ÷ (10 × 1) = 1.25% CTR. At its current 1% CTR it pays $1.25 per click, so it needs a better ad or a cheaper audience to hit the target. The Target CPC mode does this sum and compares it with your current CTR. To find a sensible target in the first place, the CPC calculator works out the highest CPC your margin and conversion rate can pay.
Is the CTR difference real? A/B testing two ads
Two equally good ads will still end up with slightly different CTRs. The A/B test mode checks whether the gap between them is bigger than chance would produce, using a standard two-proportion z-test.
Ad A gets 600 clicks from 60,000 impressions (1%). Ad B gets 720 from 60,000 (1.2%), a 20% lift. The test gives p = 0.0009: a gap that size would rarely happen by chance, so B is very likely the better ad. Now shrink the test. Ad A gets 60 clicks from 6,000 impressions and ad B gets 66 from 6,000, a 10% lift. Here p = 0.59, so the gap could easily be noise. Keep both running.
The test assumes both ads ran over the same dates and placements. We'd also wait for at least a few hundred clicks per ad before cutting one. Testing new ads against the old ones is part of the ads check in our Google Ads audit checklist.
What is a good CTR?
Google's own answer is that "a good CTR is relative to what you're advertising and on which networks".1 Published averages disagree with one another, and an average from another industry tells you little about your own ads.
We'd judge CTR by whether the clicks turn into sales at a cost you can afford. A high CTR on searches you don't want just spends money faster. If clicks come from the wrong searches, negative keywords fix that before any change to the ad. Then check the money. The ROAS calculator works out the most you can pay in ads per order, and the Target CPC mode above tells you what CTR gets you there.
Compare CTR within one platform, one campaign type and one placement over time. When CTR falls while impressions hold steady, we'd look at the ad first: people may have seen it too often, or the audience may have changed.
CTR calculator FAQ
What is the formula for CTR?
CTR = clicks ÷ impressions × 100. 600 clicks from 60,000 impressions is a 1% click-through rate.1
How do you calculate CTR as a percentage?
Divide clicks by impressions and multiply by 100. In a spreadsheet, use =clicks/impressions and format the cell as a percentage.
Is a 2% CTR good?
It depends on the platform, the placement and what you sell. Judge it by what the clicks cost and whether they turn into sales. Google says a good CTR is relative to what you're advertising and where.1
Can CTR be higher than 100%?
Not when clicks and impressions come from the same report, ads and dates. If you see one, the clicks and impressions were most likely taken from different places.
What is the difference between CTR and conversion rate?
CTR is clicks ÷ impressions: how many people who saw the ad clicked. Conversion rate is conversions ÷ clicks: how many of those clicks bought or signed up.
How do I calculate click-through rate for email?
Use the same sum with emails delivered in place of impressions: clicks ÷ delivered × 100. Clicks ÷ opens is a different metric, the click-to-open rate.
Does CTR affect Quality Score in Google Ads?
Yes. Expected clickthrough rate is one of the three components of Quality Score, alongside ad relevance and landing page experience.2
Sources
- Clickthrough rate (CTR): Definition, Google Ads Help.
- About Quality Score for Search campaigns, Google Ads Help.
- Ad Campaign Insights (Marketing API reference), Meta for Developers.
- What are impressions, position, and clicks?, Search Console Help.