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 your new AI Data Analyst. It lets you extract from PDFs, import your business data, and analyze it using plain language.

Signup for free

Import your business data

Extract from PDFs and images, import from files, marketing tools, databases, APIs, and other 3rd-party connectors.

Know more

Analyze it with AI

Ask AI✨ any question about your dataset - from VLOOKUPs to forecasting models - 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