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.

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 is a good CTR for Google Ads?

The average CTR for Google Search Ads is 3.17% across all industries. A 'good' CTR is typically 4-6%, while 6%+ is considered excellent. However, industries like legal services often see higher CTRs (4-5%), while e-commerce may be lower (2-3%). Always compare to your industry average.

Does CTR affect SEO ranking?

Yes, organic CTR can indirectly influence SEO. Google uses RankBrain to measure user engagement signals. If your search result consistently gets more clicks than competitors, Google may interpret this as a relevance signal and boost your ranking. However, CTR alone isn't a direct ranking factor.

Can CTR be higher than 100%?

No, CTR cannot exceed 100% because you cannot have more clicks than impressions. If your analytics shows CTR over 100%, it usually indicates: (1) bot or invalid click activity, (2) tracking/reporting errors, or (3) duplicate impression counting issues. Investigate immediately.

CTR Calculator

CTR Formula

The complete guide to calculating Click-Through Rate

÷× 100=

CTR = (Clicks ÷ Impressions) × 100

The CTR formula is: CTR = (Clicks ÷ Impressions) × 100. Click-Through Rate measures the percentage of people who clicked on your ad, link, or content after seeing it.

Advanced CTR Calculator

Calculate CTR, required clicks, or needed impressions

Clicks

Impressions

CTR

Full Calculator →

CTR vs. Conversion Rate: What's the Difference?

Two metrics, different goals

CTR (Click-Through Rate)

Measures how many people clicked your ad after seeing it.

(Clicks ÷ Impressions) × 100

Goal: Traffic & Interest

1,000 impressions, 50 clicks = 5% CTR

CVR (Conversion Rate)

Measures how many people took action (bought/signed up) after clicking.

(Conversions ÷ Clicks) × 100

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%

Real-world calculation examples

See the Formula in Action

E-commerce Product Page

Your product page was viewed 8,500 times. 127 visitors clicked "Add to Cart".

CTR = (127 ÷ 8,500) × 100 = 1.49%

Result: 1.49% CTR

This is slightly below average for e-commerce (typical: 2-3%). Consider improving product images or adding urgency elements.

Google Search Ad Campaign

Your ad for "best running shoes" appeared 15,000 times. 525 people clicked.

CTR = (525 ÷ 15,000) × 100 = 3.50%

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)*100

Excel / Sheets

Where A2 contains clicks and B2 contains impressions. Format the cell as a percentage for cleaner display.

Frequently Asked Questions

Related Tools

CTR Calculator

Calculate your CTR instantly

Use Now

Email CTR Calculator

Email marketing CTR

Use Now

YouTube CTR Calculator

Video thumbnail CTR

Use Now

Ready to Calculate Your CTR?

Use our free calculator to get instant results

Try CTR Calculator

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: December 2025 · Data sources: WordStream Industry Benchmarks (2024), Mailchimp Email Marketing Reports, YouTube Creator Academy

CTR Formula

Advanced CTR Calculator

CTR vs. Conversion Rate: What's the Difference?

Why Is My CTR Low?

What's a Good CTR?

See the Formula in Action

How to Calculate CTR Step by Step

CTR Formula in Excel

Frequently Asked Questions

People Also Ask

Related Tools

CTR Calculator

Email CTR Calculator

YouTube CTR Calculator

Ready to Calculate Your CTR?

CTR Calculator Team Free Marketing Tools