What is the CTR formula?

The CTR formula is: CTR (%) = (Number of Clicks ÷ Number of Impressions) × 100. This gives you the percentage of people who clicked on your ad, link, or content after seeing it. For example, if your ad received 500 clicks from 25,000 impressions, your CTR = (500 ÷ 25,000) × 100 = 2.00%.

How is CTR calculated?

CTR is calculated by taking the total clicks your ad or link received, dividing by the total impressions (times it was shown), and multiplying by 100. Ad platforms like Google Ads, Facebook Ads, and email marketing tools calculate this automatically. A higher CTR indicates your content is relevant and engaging to your audience.

How to calculate organic CTR?

To calculate organic CTR, go to Google Search Console → Performance → select 'Search results'. Divide total clicks by total impressions and multiply by 100. You can also calculate CTR per query, per page, or by position. Organic CTR varies significantly by position — industry studies suggest the #1 result averages around 28% CTR while the #10 result averages around 2.5%.

How to calculate CTR in Excel?

In Excel, use the formula =A2/B2 where A2 contains your clicks and B2 contains your impressions. Format the result cell as a percentage (Ctrl+Shift+%). For a precise percentage with two decimal places, use =ROUND(A2/B2*100,2)&'%' to display values like '1.50%'. You can also use Excel tables and PivotTables to calculate average CTR across multiple campaigns or date ranges.

CTR Calculator

Clicks

150

Impressions

10K

Compare Campaign

Add a second campaign to compare

Click-Through Rate

1.50%

Below average for Google Search Ads150 clicks ÷ 10,000 impressions × 100 = 1.50%

CTR

1.50%

Google Search Ads

Rating

below-average

vs Google Search Ads avg

Clicks

150

clicks

Impressions

10K

impressions

What Is CTR (Click-Through Rate)?

Understanding the most important metric in digital advertising

CTR (Click-Through Rate) is the percentage of people who click on your ad, link, or content after seeing it. It is the single most important metric for measuring how engaging and relevant your content is to your audience. A high CTR means your message resonates — a low CTR means it is being ignored.

CTR is used across every digital channel: Google Search Ads, Display Ads, Facebook & Instagram Ads, Email Marketing, YouTube Ads, LinkedIn Ads, and organic search results. Each channel has its own benchmark for what constitutes a "good" CTR — a 2% CTR on Google Search is below-average, while 2% on Facebook Ads is good.

The CTR Formula

CTR = (Clicks ÷ Impressions) × 100

Example: 150 clicks ÷ 10,000 impressions × 100 = 1.50% CTR

How to Calculate CTR

Every CTR formula — including reverse calculations

Calculate CTR

CTR (%) = (Clicks ÷ Impressions) × 100

Calculate Required Clicks

Clicks = ⌈(Target CTR% × Impressions) ÷ 100⌉

Rounded up (ceiling) to ensure the target CTR is met or exceeded.

Calculate Maximum Impressions

Impressions = ⌊(Clicks ÷ Target CTR%) × 100⌋

Rounded down (floor) — this is the maximum number of impressions allowed for the chosen click count and target CTR. Fewer impressions produce a higher CTR.

How to Calculate CTR in Google Sheets / Excel

Use this simple formula in any spreadsheet:

=A2/B2

Where A2 contains your clicks and B2 contains your impressions. Format the cell as a percentage to display the CTR value. For example, 150 in A2 and 10,000 in B2 will show 1.50%.

What Is a Good CTR? Benchmarks by Channel

Average click-through rates across major advertising channels

Channel	Poor	Below Avg	Average	Good	Excellent
Google Search Ads	<1%	1–<3%	3–<5%	5–<10%	≥10%
Google Display Ads	<0.3%	0.3–<0.5%	0.5–<0.6%	0.6–<1%	≥1%
Facebook Ads	<0.5%	0.5–<1%	1–<1.5%	1.5–<3%	≥3%
Instagram Ads	<0.3%	0.3–<0.5%	0.5–<0.8%	0.8–<1.5%	≥1.5%
Email Marketing	<1%	1–<2%	2–<3%	3–<5%	≥5%
YouTube Ads	<0.3%	0.3–<0.5%	0.5–<1%	1–<2%	≥2%
LinkedIn Ads	<0.3%	0.3–<0.5%	0.5–<0.8%	0.8–<1.5%	≥1.5%
Organic Search	<1%	1–<3%	3–<5%	5–<10%	≥10%

Google Search Ads

Poor

<1%

Below

1–<3%

Avg

3–<5%

Good

5–<10%

Exc.

≥10%

Google Display Ads

Poor

<0.3%

Below

0.3–<0.5%

Avg

0.5–<0.6%

Good

0.6–<1%

Exc.

≥1%

Facebook Ads

Poor

<0.5%

Below

0.5–<1%

Avg

1–<1.5%

Good

1.5–<3%

Exc.

≥3%

Instagram Ads

Poor

<0.3%

Below

0.3–<0.5%

Avg

0.5–<0.8%

Good

0.8–<1.5%

Exc.

≥1.5%

Email Marketing

Poor

<1%

Below

1–<2%

Avg

2–<3%

Good

3–<5%

Exc.

≥5%

YouTube Ads

Poor

<0.3%

Below

0.3–<0.5%

Avg

0.5–<1%

Good

1–<2%

Exc.

≥2%

LinkedIn Ads

Poor

<0.3%

Below

0.3–<0.5%

Avg

0.5–<0.8%

Good

0.8–<1.5%

Exc.

≥1.5%

Organic Search

Poor

<1%

Below

1–<3%

Avg

3–<5%

Good

5–<10%

Exc.

≥10%

Benchmarks are directional only. Actual CTR varies by industry, audience, ad quality, and seasonality. Use these as reference points, not absolute targets.

Sources: WordStream Google Ads Benchmarks, WebFX PPC Benchmarks, Smart Insights Industry Benchmarks, Mailchimp Email Benchmarks, Advanced Web Ranking CTR Study

Benchmarks last reviewed: June 2026.

CTR vs Other Marketing Metrics

How click-through rate relates to CPM, CPC, CPA, and Conversion Rate

CTR → CPM

CTR measures engagement; CPM measures cost per 1,000 impressions. A high CTR with a low CPM is the ideal combination. Use our CPM Calculator to optimize impression costs.

CTR → ROAS

CTR affects your Return on Ad Spend. Better CTR means more clicks for the same budget — potentially improving ROAS. Use our ROAS Calculator to measure profitability.

CTR → CPV

For video ads, CTR and CPV (Cost Per View) are closely related. A strong CTR on a video thumbnail drives more views. Try our CPV Calculator for video campaigns.

CTR → Engagement Rate

On social media, engagement rate (likes, comments, shares) complements CTR. High CTR + high engagement = winning content. See our Engagement Rate Calculator.

How to Improve Your Click-Through Rate

7 proven strategies to increase CTR across all channels

Write Compelling Ad Copy

Use action verbs, numbers, and emotional triggers. Address the user’s pain point directly. For search ads, include the keyword in the headline. Well-crafted ad copy can meaningfully improve CTR compared to generic messaging.

A/B Test Everything

Test headlines, descriptions, images, CTAs, and landing pages. Run 2–3 variations simultaneously and let data decide the winner. Small copy tweaks can produce measurable CTR improvements over time.

Use Ad Extensions (Google Ads)

Sitelinks, callouts, structured snippets, and call extensions increase your ad’s screen real estate. Ads with extensions typically see higher CTR because they occupy more space in search results.

Target the Right Audience

Refine your audience targeting — narrow demographics, interests, and behaviors often produce higher CTR because the message is more relevant. Use remarketing lists for warm audiences.

Optimize for Mobile

Over 60% of clicks come from mobile devices. Ensure your ads and landing pages load fast on mobile. Use mobile-preferred ad copy with shorter headlines.

Write Better Subject Lines (Email)

For email marketing, the subject line is your ad headline. Use personalization, curiosity gaps, and urgency. Keep it under 50 characters. Emojis in subject lines can help improve open rates and click-through.

Improve Landing Page Relevance

Google Ads factors landing page experience into your Quality Score. A relevant, fast-loading landing page improves your ad rank and can lower your CPC — indirectly boosting effective CTR and ROI.

Common CTR Calculation Mistakes

Pitfalls that cause marketers to misjudge their performance

Confusing Impressions with Reach

Impressions count every time your content is displayed, including multiple views by the same user. Reach counts unique users. CTR calculated with reach instead of impressions will appear artificially inflated.

Comparing CTR Across Different Channels

A 2% CTR on Google Search Ads is below-average; a 2% CTR on Facebook Ads is good. Comparing CTR across channels without accounting for benchmarks leads to incorrect conclusions about campaign performance.

Ignoring Viewability

An impression is counted even if the ad wasn’t fully visible. Studies suggest a significant portion of display ad impressions may not be viewable. Your "true" CTR based on viewable impressions may be higher than reported. Check your ad platform's viewability metrics for campaign-specific data.

Optimizing for CTR Instead of Conversions

A high CTR with zero conversions is a waste of budget. Always evaluate CTR alongside conversion rate, CPA, and ROAS. Clickbait headlines boost CTR but kill conversion rates.

Not Segmenting by Device

CTR on mobile is typically higher than desktop for search ads, but lower for display ads. Segmenting by device reveals where your audience is most engaged and helps allocate budget effectively.

Frequently Asked Questions

Common questions about CTR, click-through rate calculation, and campaign optimization

Organic CTR is calculated the same way as ad CTR: (Clicks from organic search results ÷ Impressions in search results) × 100. You can find these metrics in Google Search Console under the Performance report. Filter by 'Search' type to see your organic clicks and impressions for each query. Based on industry CTR studies, organic CTR for position #1 commonly ranges 25–35%, dropping to 2–5% by position #10.

In Google Sheets, enter your clicks in cell A2 and impressions in cell B2. In cell C2, enter the formula =A2/B2 and format the cell as a percentage. This will display your CTR. For example, 150 in A2 and 10,000 in B2 will show 1.50%. You can drag the formula down to calculate CTR for multiple rows of campaigns. To automatically multiply by 100 for a percentage-like number without formatting, use =(A2/B2)*100.

Google Ads automatically calculates CTR for you. It's displayed in the 'CTR' column in your campaign, ad group, and keyword reports. The formula Google uses is: (Clicks ÷ Impressions) × 100. A 'click' is counted each time someone clicks your ad. An 'impression' is counted each time your ad is shown. You can segment CTR by device, location, time of day, and audience in the Google Ads reports tab.

Email CTR is calculated by dividing the number of unique clicks on links in your email by the number of delivered emails, then multiplying by 100. Email CTR = (Unique Clicks ÷ Delivered Emails) × 100. Most email marketing platforms (Mailchimp, HubSpot, Klaviyo) calculate this automatically. Based on email marketing benchmarks, the average email CTR across all industries is typically 2–3%. Don't confuse CTR with CTOR (Click-to-Open Rate), which uses opens instead of delivered emails.

As a general benchmark, a good CTR for Facebook Ads is 1–2%, with 1.5% being the average across all industries. Below 0.5% is poor, and above 3% is excellent. Facebook CTR varies by ad format — according to industry data, video ads typically see 0.5–1%, carousel ads 1–2%, and collection ads 1–3%. Industries like retail, fitness, and travel tend to have higher CTRs, while B2B and finance often see lower rates.

Based on Google Ads benchmarks, the average CTR for Google Search Ads is 3–5% across all industries. Position #1 often achieves 6–8% CTR, while position #4 drops to 2–3%. Industries with the highest search CTR include travel (5–7%), arts & entertainment (5–8%), and automotive (4–6%). B2B and legal services typically see lower search CTRs (2–3%). Branded keyword campaigns often achieve 10–30% CTR because users are already searching for the brand.

In digital marketing, CTR is calculated using the universal formula: (Total Clicks ÷ Total Impressions) × 100. The specific data sources depend on the channel: Google Ads for search/display, Facebook Ads Manager for social, Google Search Console for organic, and your email platform for email marketing. Most tools calculate CTR automatically. To calculate aggregate CTR across channels, sum all clicks and divide by sum of all impressions — don't average individual channel CTRs.

To calculate average CTR across multiple campaigns, sum the total clicks from all campaigns and divide by the total impressions from all campaigns, then multiply by 100. Do not average the individual campaign CTR percentages — that produces a mathematically incorrect result. For example, if Campaign A has 100 clicks from 10,000 impressions (1% CTR) and Campaign B has 50 clicks from 1,000 impressions (5% CTR), the correct average CTR is (100 + 50) ÷ (10,000 + 1,000) × 100 = 1.36%, not (1% + 5%) ÷ 2 = 3%.

To calculate impressions from CTR and clicks, rearrange the CTR formula: Impressions = (Clicks ÷ CTR%) × 100. For example, if you have 300 clicks and a 3% CTR, your impressions = (300 ÷ 3) × 100 = 10,000. This tells you the maximum impressions allowed for a given click count and target CTR. Use the calculator above and switch to the 'Maximum Impressions' solve-for mode to compute this automatically.

To calculate CTR as a percentage, divide your total clicks by total impressions and multiply by 100. CTR% = (Clicks ÷ Impressions) × 100. For example, 150 clicks from 10,000 impressions = (150 ÷ 10,000) × 100 = 1.50%. Most ad platforms display CTR as a percentage automatically. In spreadsheets, use the formula =A2/B2 and format the cell as a percentage. The calculator above computes CTR percentage instantly — just enter your clicks and impressions.

Facebook Ads Manager calculates CTR automatically and displays it in the 'CTR' column of your campaign reports. Facebook calculates CTR as (Clicks ÷ Impressions) × 100. Note that Facebook offers two CTR metrics: 'CTR (All)' includes all clicks (likes, shares, comments, link clicks), while 'CTR (Link Click-Through Rate)' only counts link clicks. For campaign performance, focus on 'CTR (Link Click-Through Rate)' or 'Outbound CTR.' The average Facebook Ads CTR is 1–1.5% across all industries.

You can calculate CPC (Cost Per Click) from CPM (Cost Per Thousand Impressions) and CTR using this formula: CPC = CPM ÷ (CTR% × 10). For example, if your CPM is $10 and your CTR is 2%, then CPC = $10 ÷ (2 × 10) = $10 ÷ 20 = $0.50. This relationship shows that a higher CTR with the same CPM results in a lower CPC, because you're getting more clicks for the same impression cost. Use our CPM Calculator to explore impression cost relationships further.

Embed CTR Calculator

Add this calculator to your website or blog for free.

Explore more calculators

Last updated Jun 15, 2026

CTR Calculator

What Is CTR (Click-Through Rate)?

How to Calculate CTR

What Is a Good CTR? Benchmarks by Channel

CTR vs Other Marketing Metrics

How to Improve Your Click-Through Rate

Common CTR Calculation Mistakes

Confusing Impressions with Reach

Comparing CTR Across Different Channels

Ignoring Viewability

Optimizing for CTR Instead of Conversions

Not Segmenting by Device

Frequently Asked Questions

Embed CTR Calculator

You Might Also Like