How to Calculate Click Through Rate: CTR Calculation Formula That Help You
You calculate CTR by dividing clicks by impressions and multiplying by 100. That gives you a percentage.
Here is the click through rate formula:
CTR = (Total Clicks ÷ Total Impressions) × 100
That’s it. If your ad showed up 1,000 times and 50 people clicked, your CTR is 5%. But knowing this formula is only half the story. The other half? Figuring out whether your number is good, bad, or somewhere in between.
What Is Click Through Rate?
Click through rate measures how many people actually clicked on something after seeing it. Could be a Google ad, an email link, a Facebook post, a YouTube thumbnail, or an organic search result. The concept stays the same across all of them.
Simply the impressions tell you how many eyeballs saw your content. Clicks tell you how many people cared enough to take action. CTR connects those two numbers and gives you one clean percentage that says this is how interesting your stuff is to real humans.
I’ve watched businesses obsess over traffic numbers and ignore CTR completely. Big mistake. A page getting 100,000 impressions with a 0.3% CTR is barely doing anything. Meanwhile a well written meta description on a smaller page pulling 8% CTR is crushing it.
CTR doesn’t just tell you about clicks, it also tells you about relevance. And search engines like Google pay very close attention to that.
How to Calculate CTR Step by Step
Step 1: Find your total impressions
An impression happens every time your ad, link, or listing shows up on someone’s screen. Every single time. If one person sees your ad three times, that counts as three impressions.
Step 2: Find your total clicks
A click is when someone actually taps or clicks on your link. Now here’s where it gets a little tricky. Some platforms track unique clicks (one click per person) and some track total clicks (every single click, even if the same person clicked five times).
Step 3: Divide clicks by impressions and multiply by 100
That turns your decimal into a percentage.
Example. Your Google Ads campaign got 10,000 impressions and 200 clicks.
CTR = (200 ÷ 10,000) × 100 = 2%
But here is something most people miss: if you’re calculating email CTR, you should subtract bounced emails from your total sends first. Bounced emails never reached anyone, so counting them as impressions makes your CTR look worse than it actually is.
Real CTR Calculations across Different Platforms
The formula doesn’t change, but the context does. Let me show you how this plays out on different channels.
Google Ads (PPC)
Say your search ad for “running shoes” gets shown 5,000 times and earns 150 clicks.
CTR = (150 ÷ 5,000) × 100 = 3%
For pay per click advertising, that 3% is actually decent. And here is something worth knowing: Google uses your CTR to calculate your Quality Score. Higher Quality Score means lower cost per click and better ad placement. So your CTR literally saves you money.
Facebook Ads
Your sponsored post reaches 50,000 people in their news feeds. 600 people click.
CTR = (600 ÷ 50,000) × 100 = 1.2%
For Facebook Ads, anything between 0.9% and 1.6% is considered normal. Social media CTR tends to run lower than search because people aren’t actively looking for what you’re selling. They’re scrolling through cat videos. Your ad is interrupting them.
Email Marketing
You send a newsletter to 8,000 subscribers. 400 bounce. Of the 7,600 that arrive, 380 people click a link inside.
CTR = (380 ÷ 7,600) × 100 = 5%
An email click through rate of 5% is solid. Remember what I said earlier about subtracting bounced emails? Do that. Otherwise your number will be off.
YouTube
Your video thumbnail gets 20,000 impressions and 1,400 people click to watch.
CTR = (1,400 ÷ 20,000) × 100 = 7%
For YouTube impressions click through rate, anything between 2% and 10% is the normal range. A strong thumbnail and a curiosity driven title make all the difference here.
What Counts as a Good Click Through Rate?
I get asked this constantly, and the answer is: it depends. A 2% CTR might be incredible for one business and terrible for another. Context matters more than any single number.
But you probably still want some benchmarks. Fair enough. Here is what the data looks like across channels:
| Channel | Average CTR | Good CTR |
| Google Ads (Search) | 3% to 5% | Above 5% |
| Google Ads (Display) | 0.35% to 0.50% | Above 0.50% |
| Facebook Ads | 0.9% to 1.6% | Above 1.6% |
| Email Campaigns | 2% to 3% | Above 4% |
| YouTube | 2% to 10% | Above 7% |
| TikTok Ads | 1% to 3% | Above 3% |
| Organic Search (Position 1) | ~39.8% | Varies by query type |
| Organic Search (Position 5) | ~5.1% | Varies by query type |
Look at the gap between display ads and search ads. Someone searching “buy running shoes” on Google has intent. Someone scrolling Instagram does not. Your display ad CTR will almost always be lower, and that is completely normal.
My advice is stop comparing yourself to random internet benchmarks. Compare your current CTR to your own past performance. If you went from 1.2% to 1.8% in three months, that is progress worth celebrating.
CTR vs Conversion Rate: Why High Clicks Don’t Always Mean Sales
Here is something that trips up almost every beginner. A high click through rate does not guarantee a high conversion rate.
Your CTR gets people to your site. Your conversion rate measures how many of those visitors actually do the thing you want, buy a product, sign up for a trial, download your ebook, whatever. Two completely different jobs.
I’ve seen ads with a 12% CTR and a 0.2% conversion rate. The headline was amazing but the landing page was a disaster. All those clicks cost money and produced almost nothing. So always track both numbers together. A healthy campaign needs a decent CTR AND a solid conversion rate. Also keep an eye on your bounce rate. If people click through but leave immediately, something is broken between what your ad promises and what your page delivers.
Why CTR Matters for SEO and Paid Ads
CTR is not just a vanity metric. It has real consequences. For PPC campaigns, your CTR directly affects your Quality Score on Google Ads. A higher Quality Score means you pay less per click and your ads show up in better positions. So improving CTR literally puts money back in your pocket.
For organic search, the relationship is a bit murkier. Google hasn’t officially confirmed that organic CTR is a direct ranking factor. But pages that get higher than expected click rates for their position tend to move up over time. Whether that’s causation or correlation, the pattern is consistent enough that smart SEOs pay attention to it.
And for email marketing? A strong CTR means your subscribers actually find your content worth clicking. Low email CTR over time is a warning sign that your audience is tuning out.
When a High CTR Is a Problem
I know this sounds weird, but a super high CTR can be a red flag.
Picture this. A luxury watch brand runs an ad with the headline “Best Watches Under $50.” They get an insane click through rate because everyone loves a deal. But the cheapest watch on their site costs $3,000. All those clicks are wasted money from people who were never going to buy.
Now you need to make sure your CTR comes from the right audience. Misleading headlines and clickbait might boost your numbers but they’ll tank your return on investment and wreck your cost per acquisition. You want clicks from people who are actually a good fit for what you sell.
Six Ways to Improve Your Click Through Rate
Okay so you’ve calculated your CTR and it’s not where you want it. Here are the moves that actually work.
1. Write Headlines People Can’t Ignore
Your title tag or ad headline is the first thing anyone sees. If it’s boring, nobody clicks. Use specific numbers, ask questions, or highlight a clear benefit. “Save 3 Hours a Week on Reports” beats “Report Software Solution” every single time.
2. Make Your Meta Descriptions Work Harder
For organic search, your meta description is basically a tiny sales pitch sitting right under your title in Google. Write it like you’re convincing a friend to click. Include your main keyword naturally and tell people exactly what they’ll get.
3. Run A/B Tests on Everything
A/B testing is how you stop guessing and start knowing. Test two versions of a headline. Test different call to action buttons and test images. Change one thing at a time so you know exactly what made the difference.
4. Get Your Targeting Right
Audience segmentation sounds fancy but the idea is simple: show the right message to the right people. A fitness app shouldn’t show the same ad to 20 year olds and 55 year olds. Different audiences respond to different messaging. Behavioral targeting and demographic targeting help you narrow things down.
5. Fight Back Against SERP Features
Featured snippets, People Also Ask boxes, and knowledge panels all steal clicks from traditional organic results. Your move? Structure your content to win those features yourself. Use clear question and answer formats. Target long tail keywords that have fewer SERP features competing for attention.
6. Think About AI Search Changes
AI Overviews and AI Mode in Google are starting to answer questions directly in search results. That means fewer clicks for everyone. Your best defense? Create content that AI can’t replicate: original data, interactive tools, real experience, stuff that makes people want to visit your actual site.
How to Calculate CTR in Excel
A lot of marketers track their campaigns in spreadsheets. If that’s you, here is the exact formula you need.
Put your clicks in column A and impressions in column B. In column C, type:
=(A2/B2)*100
That gives you the CTR as a percentage. Drag it down for as many rows as you need. Done in ten seconds. No special tools required. If you want to get a little fancier, you can format column C as a percentage and just use =A2/B2 instead. Excel handles the multiplication for you.
Some Mistakes to Calculate the CTR That Waste Your Budget
After working with dozens of campaigns across different industries, I see the same errors over and over.
Now Go Do Something with These Numbers
Knowing how to calculate CTR is only valuable if you act on what the numbers tell you. Run the formula on your last campaign right now. Compare it to your benchmarks. If the number is low, start with your headlines and meta descriptions because those are the fastest wins. And remember the CTR is a starting point, not a finish line. Pair it with conversion data, watch your bounce rate, and keep testing.
FAQs
How do you calculate click through rate?
Divide the number of clicks by the number of impressions and multiply by 100. The formula is CTR = (Clicks ÷ Impressions) × 100. If your ad got 75 clicks from 3,000 impressions, your CTR is 2.5%.
What is a good CTR for Google Ads?
For search ads, a good Google Ads CTR is typically between 3% and 5%. Anything above 5% is excellent. Display ads average much lower, around 0.35% to 0.50%.
How do I calculate CTR in Excel?
Use the formula =(clicks cell/impressions cell)*100. For example, if A2 has clicks and B2 has impressions, type =(A2/B2)*100 in cell C2.
What is the difference between CTR and conversion rate?
CTR measures how many people clicked on your link. Conversion rate measures how many of those visitors completed a desired action like purchasing or signing up. You need both to evaluate a campaign properly.
Does CTR help improve Quality Score?
Yes. In Google Ads, your expected CTR is one of the main factors that determine your Quality Score. A higher Quality Score leads to lower cost per click and better ad positions.
What is unique CTR vs total CTR?
Unique CTR counts each person only once, no matter how many times they clicked. Total CTR counts every individual click. Unique CTR gives you a more accurate picture of how many different people engaged with your content.
Is CTR a ranking factor for SEO?
Google hasn’t confirmed organic CTR as a direct ranking factor. But data consistently shows that pages with higher than expected click rates tend to climb in search results over time.
What is a good YouTube CTR?
The average YouTube impressions CTR falls between 2% and 10%. A strong thumbnail with bold visuals and a curiosity driven title usually pushes CTR toward the higher end of that range.
How do SERP features affect my CTR?
Featured snippets, People Also Ask boxes, and AI Overviews can all reduce your organic CTR by answering queries directly on the search page. The best response is to structure your content so you win those features yourself.
Can a high CTR be bad?
Absolutely. If misleading ad copy attracts clicks from people who will never buy, you’re wasting your ad budget and hurting your return on ad spend. Quality of clicks matters just as much as quantity.
