CTR Formula
The complete guide to the click-through rate formula, with examples and Excel templates
CTR = (Clicks ÷ Impressions) × 100The CTR formula is: CTR = (Clicks ÷ Impressions) × 100. This click-through rate equation measures the percentage of people who clicked on your ad, link, or content after seeing it. CTR is expressed as a percentage—for example, 150 clicks from 10,000 impressions gives you a 1.5% CTR.
Example Calculation
- • Your ad was shown 10,000 times
- • 150 people clicked on it
- • CTR = (150 ÷ 10,000) × 100
Click-Through Rate (CTR) is one of the most important metrics in digital marketing. The CTR formula—also known as the click-through rate equation—measures how effective your ads, emails, search results, or links are at generating clicks. Whether you need to calculate CTR for Google Ads, Facebook campaigns, YouTube thumbnails, or email marketing, the formula is always the same. Here's everything you need to know.
CTR vs. Conversion Rate: What's the Difference?
Two metrics, different goals
Measures how many people clicked your ad after seeing it.
Goal: Traffic & Interest
1,000 impressions, 50 clicks = 5% CTR
Measures how many people took action (bought/signed up) after clicking.
Goal: Sales & Leads
50 clicks, 5 purchases = 10% CVR
A high CTR with low CVR often indicates your ad attracts clicks but your landing page doesn't convert. A low CTR with high CVR suggests your targeting is precise but reach is limited.
Why Is My CTR Low?
Common causes and quick fixes
What's a Good CTR?
CTR benchmarks vary by platform and industry. Here are general guidelines:
- Google Search Ads3-5%
- Google Display Ads0.5-1%
- Facebook Ads0.9-1.5%
- Email Marketing2-5%
- YouTube4-10%
- Google Search Ads3-5%Higher for branded terms
- Google Display Ads0.5-1%Lower due to passive viewing
- Facebook Ads0.9-1.5%Varies by industry
- Email Marketing2-5%Depends on list quality
- YouTube4-10%Thumbnail CTR
Real-world calculation examples
See the Formula in Action
Your product page was viewed 8,500 times. 127 visitors clicked "Add to Cart".
Result: 1.49% CTR
This is slightly below average for e-commerce (typical: 2-3%). Consider improving product images or adding urgency elements.
Your ad for "best running shoes" appeared 15,000 times. 525 people clicked.
Result: 3.50% CTR
Excellent! This beats the 3.17% Google Ads average. Your headline and ad copy are resonating with searchers.
How to Calculate CTR Step by Step
- 1
Count Your Clicks
Find the total number of clicks your ad, email, or link received. This data is usually available in your analytics dashboard.
- 2
Count Your Impressions
Find the total number of times your content was displayed or viewed. Also called 'views' or 'reach' in some platforms.
- 3
Divide Clicks by Impressions
Take your click count and divide it by your impression count. This gives you a decimal number.
- 4
Multiply by 100
Multiply the result by 100 to convert it to a percentage. This is your CTR.
CTR Formula in Excel
To calculate CTR in Excel or Google Sheets, use this simple formula:
=(A2/B2)*100Where A2 contains clicks and B2 contains impressions. Format the cell as a percentage for cleaner display.
Frequently Asked Questions
What is the formula for CTR?
The CTR formula is simple: CTR = (Clicks ÷ Impressions) × 100. This gives you a percentage showing how many people clicked after seeing your content. For example, if 200 people click on an ad shown 10,000 times, your CTR is 2%. This formula works across all platforms—Google Ads, Facebook, email, YouTube thumbnails—making it universal for measuring engagement.
How do you calculate CTR manually?
To calculate CTR manually, follow these four steps: First, count your total clicks from your analytics dashboard. Second, count total impressions (views). Third, divide clicks by impressions—this gives you a decimal like 0.015. Finally, multiply by 100 to convert to percentage (1.5%). Pro tip: always use the same time period for both numbers to get accurate results.
What is the CTR formula in Excel?
In Excel or Google Sheets, use the formula =(A2/B2)*100 where A2 contains clicks and B2 contains impressions. Alternatively, use =A2/B2 and format the cell as a percentage. If you see #DIV/0! error, your impressions cell is empty or zero. For multiple rows, copy the formula down. Want cleaner reports? Use =ROUND(A2/B2*100,2) to limit decimal places.
Is 5% CTR good?
A 5% CTR is excellent for most platforms and usually puts you in the top 10% of advertisers. For Google Search Ads, the average is 3.17%, so 5% is outstanding. For Facebook Ads where 1% is typical, 5% is exceptional. However, context matters—retargeting campaigns should beat cold traffic. Always compare your CTR to your own historical data first, then industry benchmarks.
How can I improve my CTR?
To boost CTR, start with your headline—add specific numbers and benefits instead of generic claims. Match your message to user intent (someone searching "buy" wants different content than someone searching "compare"). Use strong calls-to-action like "Get Quote" or "Shop Now". Test at least 2-3 variations for one week each. Finally, check your mobile performance separately—60% of clicks happen on phones.
What does CTR stand for and what is the formula?
CTR stands for Click-Through Rate. The formula is CTR = (Total Clicks ÷ Total Impressions) × 100. It works for any digital channel: if your Google ad got 300 clicks from 12,000 impressions, your CTR is 2.5%. The formula is the same whether you call it click rate, click-through rate, or CTR—it always means clicks divided by views, times 100.
People Also Ask
Related Tools
CTR Calculator Team Free Marketing Tools
We build free, accurate marketing calculators based on industry-standard formulas and publicly available benchmark data from WordStream, Mailchimp, and other trusted sources.
Last updated: March 2026 · Data sources: WordStream Industry Benchmarks (2024), Mailchimp Email Marketing Reports, YouTube Creator Academy