GSC Data Visualization 🚀 using Plotly 🐍, No of Queries & URLs by Date

After watching this video, you will be able to transform the existing data frame to create new metrics like the Count of Queries, Count of Pages etc. You will also learn to filter the current Dataset by Row Values in a Column.
Finally, you will learn to plot charts using Plotly Library.
✅ Github Code Link:
github.com/TheMihirNaik/googl...
✅Google Search Console API Overview: developers.google.com/webmast...
✅Plotly Express in Python:
plotly.com/python/plotly-expr...
✅Pandas:
pandas.pydata.org/
Link to this Playlist : • Google Search Console ...
💡Timeline:
00:00 Recap of what's been done so far
01:14 Overview of this video
02:24 Why building these custom metrics from GSC data is important?
05:00 Initiating the Google Colab for this video
💡Timeline:
08:24 Preparing Simple Dataframe for GSC Data
10:40 Peak into GSC Data Sampling
13:18 Fetching GSC Data & Building Dataframe
14:10 Plotly Brief Overview
💡Timeline:
16:14 Grouped by Date - Simple GSC Line Chart
20:30 Plotting a Simple Line Chart using Grouped By Date DF
💡Grouped by Date & Page - Unique URLs/Pages Count:
21:42 Grouped by Date & Pages - Preparing Dataframe
24:38 Plotting a Plotly Chart for the Unique URL Count by Date
25:12 Fetching Data for only one Country using Dimension Filters
26:48 Plotting a Chart with the updated Data
💡Grouped by Date & Query- Unique Queries Count:
28:22 Fetching the GSC data for "Date" and "Query" Dimensions, Building DF
29:34 Grouped by Date & Query - Preparing Dataframe
30:22 Writing Code for Plotly Charts
31:08 Waiting to Fetch GSC Data & Explaining Dimension Filters for Query
32:54 GSC Data fetching of 1.3 MM rows of data is complete.
33:50 Generating a Plotly Chart for the Dataframe
💡Grouped by Date & Query- Unique Top 10 Position Queries Count:
34:34 Filtering the Previous Dataframe for only Top 10 Positions
36:20 Grouped by Date & Queries - Preparing DF
36:58 Writing Code for Plotly Charts & Generating Chart
💡Conclusion
38:03 Recap of the Video
39:27 Requesting Feedback & Social Connects

[@hubertcombomarketing2693]

Good video, thanks.

[@dhaundiyalcp]

Great going.

[@TheMihirNaik]

Thanks! 😀

[@user-tl4tg4yl2p]

awesome content.

[@TheMihirNaik]

Glad you enjoyed it

[@SuperWiini]

Great video! I'd like to know how to find out which queries exactly lost/gained position/traffic.

[@TheMihirNaik]

Thanks for the suggestion. I will write a script and publish soon.

[@jcchouinard]

Such a great tutorial! Well Done Mihir! 🙇

[@TheMihirNaik]

Thanks a lot JC!

[@stuarthoughton3517]

Great work Mihir! Super insightful video🔥🔥

[@TheMihirNaik]

Thank you 🙌