CTR calculator

Enter clicks and impressions to see your click-through rate.

Enter clicks and impressions to see your CTR.

Everything is worked out in your browser, and nothing you type is sent anywhere.

What the result means

CTR is how often your ad earns a click from the people who see it. It judges the ad and its targeting, not what happens after the click, so read it beside your conversion rate.

The formula

CTR = clicks ÷ impressions × 100

A worked example

An ad group is shown 12,000 times and gets 240 clicks. Dividing clicks by impressions and multiplying by 100 gives a CTR of 2.00%.

How to calculate CTR in Google Sheets

Get your Google Ads clicks and impressions into Google Sheets, refreshed on a schedule.

Start free trial

30 days of Plus, free from sign-up. No card needed.

Sign in with Google or a work or school Microsoft account.

Add to Google Sheets

Prefer to stay in Google Sheets? Add the add-on and start from the Extensions menu.