Reporting on Organic Search Ranking Distribution in Looker Studio
In this video, we'll guide you step-by-step on how to create a report that reveals how many keywords your website is ranking for across different position ranges on Google Search, using the free tools Looker Studio and Google Search Console.
What You'll Learn:
Adding the Google Search Console connector: Easily connect your data and gain insights into your keyword rankings and traffic.
Harness the power of case statements: Use advanced techniques to categorize and analyze your data.
Blending a datasource to itself: this peculiar technique allows you to do things with the Search Console data source that are impossible to achieve otherwise.
The steps in this video are outlined in this blog post (https://twooctobers.com/blog/how-to-r..., including the code for the case statement.
00:00 Intro
00:41 Adding the Search Console connector
01:33 Configuring a case statement to create position ranges
04:24 Creating a self-blend data source
06:02 Configuring the chart