Google Search Console

Organic CTR Tool

Check how your website's pages perform in terms of CTR, compared to market benchmarks.

100% spreadsheet
Connected to your data
Daily+ refresh
Embed everywhere

About Organic CTR Tool

This Organic CTR tool will help you check the search CTR performance of (a group of) pages from your website against the current market benchmarks, based on each page's average position.

You can do so by filtering for specific groups of pages and types of queries (branded vs non-branded).

To use this template, all you need to do is to:

  • Connect your Google Search Console property
  • Enter the period of analysis (e.g. last 90 days)
  • Input the condition to filter pages (e.g. page contains '/templates/')
  • Input your brand name (e.g. 'Rows')
  • Use the dropdown to select if you want to check only branded vs non-branded traffic (leave blank if you're going to include both types of keywords).

The table will immediately update to display filtered results from your Google Search Console account, including the difference to the market benchmark in the last column.

CTR market benchmarks are created via linear interpolation and exponential decay models using data from Backlinko. Check them on the respective page.

How it works

How it works

Get started

Click on 'Use template' and start using it right away. No forms, no signup. Your data first.

Connect your Google Search Console account

Once landed on the spreadsheet, follow the instructions to connect the required integration and pick your account.

Customize the template and schedule refresh

Once the integration has been connected, all tables will update automatically with your own data. Click on 'Edit Source' to change the retrieved data and automate the data refresh. You can then insert a chart or a pivot table, add a column or personalize formats, using all the regular functions and shortcuts that make spreadsheets great.

Embed tables and charts

Click on the option menu to embed tables and chart on your Notion, Confluence or any other iframe-ready documents.

Use Template

Questions and answers

Can I use Rows for free?

Yes, Rows comes with a Free plan that includes unlimited spreadsheets and templates, unlimited workspace members, up to 10 guests and up to 50 integration tasks per month. Discover more about our pricing plans.

More than an Organic CTR Tool

Rows is the easiest way to import, transform and share data in a spreadsheet.

Signup for free

Import data from anywhere

Unleash your data: import from files, marketing tools, databases, APIs, and other 3rd-party connectors.

Know more

Analyze with the power of AI

Unlock the power of AI on your data: ask the AI Analyst ✨ any question about your dataset and surface key insights, trends, and patterns.

Know more

Collaborate and Share

Seamlessly collaborate and share stunning reports with dynamic charts, embed options, and easy export features.

Know more