Fetching 25K+ Rows of GSC Data using GSC API🚀 with Python🐍

After watching this video you will be able to access more than 25K rows of data from Google Search Console. Then you could build a data frame, and export the data to CSV or Excel. You will also learn how to user Dimensions and Dimension Filters in GSC API. 💯

💡Timeline:
00:00 Thank you for the positive response and previous feedback.
00:28 Connecting on Social
02:10 Addressing the feedback
03:45 Project Page & Comment Section for GSC API x Python
05:38 Recap of Previous Video

💡Simplifying the previous code:
06:10 Starting of Explanation of 2nd Video
07:58 Consolidating & Simplifying the code from 1st Video
09:26 Shoutout to Rakesh Patel
10:30 Accessing GSC Data using the single API call

💡Writing While Loop for 25K+ rows of Data
12:26 Challenge of Accessing more than 25K+ rows of data
12:50 Python Operators, Conditions, String, List, Dictionary, For Loop, While Loop
15:26 Logic of While Loop to fetch 25K+ rows using multiple API calls.

💡Using Pandas & Building Dataframe:
25:24 How to Build a Dataframe using Pandas?
34:44 Export to CSV or Excel

💡Using Dimensions and Dimension Filters:
36:44 Using Dimensions
39:44 Using Dimensions Filters
Using Dimension Filters

43:54 Closing Remarks

[arthurroder]

Thanks a lot again! Awesome, straightforward video 🙌

[mukeshwarsingh]

Really Thanks bro for Helping. These starters Guide is not actually for Starts, you made it simple for us. Thanks

[wastelandia]

Amazing, thank you! I was suffering with this for quite some time =D

[Yooyolo]

Awesome. Your video recording is really helpful. As a fish, it will be more helpful for fish if you can add some tips on operating buttons in your video.

[rabihbadr]

Great job man. Thank you for the great content.

[moellerseo]

Keep up the good work my friend. How do you like to work with python? I have tried options like PythonAnywhere and running a linux system on my windows PC.

[Moonshine]

Thank you so much for this great content! Can you please do a tutorial next to show how to we can push this into Adobe Analytics? i.e. import organic google search data to Adobe Analytics?

[mudit]

First of all would like to commend you Mihir for such a brilliant video explaining the GSC API, I could automate a lot of stuff my team does following you. Just one suggestion the condition you put in the beginning startRow == 0 or startRow % 25000 == 0 are the same you can do with only startRow % 25000 == 0 because when startRow is Zero then the parameter 0 % 25000 will also evaluate to 0. Therefore two conditions are not required.

[SreevathsaBV]

@TheMihirNaik Thanks again for putting this together. Really insightful. Quick question, does the query limit of 25k applies to per query sent across to API or is it per property? Please share what the dead end of the query limit is.

[sardarabdullahkhawar]

Should the email that is used to create Google Search Console Account and the email used to create GCP account be identical? or we can use separate email to create GCP account?

[SaraswathiMoram]

Great video, Thank you for sharing with us. I have created file, but its not downloading.

[pragneshshrimal]

Thank you for the helpful video. Could you help me in extracting data that has been 'excluded by the 'noindex' tag'? Can you provide guidance on the appropriate filter and dimensions to use?

[waqashussain]

And how to pull this data in Bigquery ? Kindly help