CTR Formula
How to calculate CTR by hand, in Excel or Google Sheets, and with the free CTR calculator
The CTR formula is CTR = (Clicks ÷ Impressions) × 100. It shows the percentage of impressions that turned into clicks. For example, 150 clicks from 10,000 impressions equals 1.5% CTR. In Excel or Google Sheets, use =A2/B2 and format the cell as a percentage.
- Formula:CTR = (Clicks ÷ Impressions) × 100
- Example:CTR = 1.50%
- Spreadsheet:=A2/B2
CTR = (Clicks ÷ Impressions) × 100The CTR formula is CTR = (Clicks ÷ Impressions) × 100. It shows the percentage of impressions that turned into clicks. For example, 150 clicks from 10,000 impressions equals 1.5% CTR. In Excel or Google Sheets, use =A2/B2 and format the cell as a percentage.
Example Calculation
- • Your ad was shown 10,000 times
- • 150 people clicked on it
- • CTR = (150 ÷ 10,000) × 100
Click-Through Rate (CTR) measures how many people clicked after seeing your ad, email, search result, thumbnail, or link. The CTR formula is the same across channels, but the context changes: Google Ads, email campaigns, YouTube thumbnails, and organic search all use different benchmark ranges.
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 and Google Sheets
Put clicks in A2 and impressions in B2. Use this formula, then format the cell as Percent:
=A2/B2If you want a numeric percentage instead of cell formatting, use =A2/B2*100. For reports, use =IFERROR(A2/B2,0) to avoid divide-by-zero errors when impressions are blank.
Want the number without doing the math?
Open the CTR calculator to enter clicks and impressions, get the percentage instantly, and compare the result against benchmarks.
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