Calculate Organic CTR by Position 🚀 for Brand vs Non Brand Queries using GSC API & 🐍 Python

Calculate Organic CTR (Click-through rate) by Ranking Position and Visualize them by Brand vs Non-Brand Queries. I'm doing this using Google Search Console API & Python. This gives you the flexibility to incorporate this into your workflow of traffic analysis for a set of queries, a set of pages or individual pages.
✅ GitHub Code Link: github.com/TheMihirNaik/googl...
✅ Link to this Playlist: • Google Search Console ...
Join the FREE Newsletter for more videos:
www.mihirnaik.com
Let's connect on Socials:
LinkedIn: / mihir23192
Twitter : / mihir23192
✅Google Search Console API Overview: developers.google.com/webmast...
✅Google Search Console API Overview: developers.google.com/webmast...
✅Plotly Express in Python: plotly.com/python/plotly-expr...
✅Pandas: pandas.pydata.org/
💡Timeline:
00:00 Recap of what's been done so far
00:50 Intro to Organic CTR Curve for Brand vs Non-branded Queries
01:35 New Google Search Console Class Explanation
💡Sitewide Organic CTR by Position:
02:50 Run GSC Class the Code
04:00 Fetching the data to plot sitewide CTR
05:26 Rounding the Position Number
06:40 Group by Round Position
07:30 Calculate the CTR
08:20 Narrow down to Top 10 Position
08:55 Plot the Organic CTR Curve
💡Brand vs Non-brand Sitewide Organic CTR by Position:
10:20 Why do we need Brand vs Non-brand CTR Curves?
11:10 Label Queries by Brand vs Non-brand
13:12 Group by Keyword Type & Round Position
14:15 Calculate CTR by adding a Column to DF
14:20 Narrow down to the Top 10 Positions
14:36 Plotting a Chart for Brand vs Non-brand Organic CTR by Position
15:30 What more can you do with this script?

[@user-yw9tg4td4w]

Hi Mihir, this is very interesting. I would love to better learn Paid Search Cannibalisation. Is there a way to understand by how much my branded paid keyword cannibalize my organic branded search? The idea is to better understand the spending waste for paying for clicks that we would have got anyway. Thank you!

[@TheMihirNaik]

I have done something along those lines using Google Datastudio. I was able to join at Date & Query/Search Term, and I was able to clearly see the search terms where I was getting clicks and spending money.
I'm happy to talk and workout a custom solution for you. let me know.