- 11
- 24 157
Mihir Naik
Canada
Приєднався 13 чер 2010
Learn to automate the parts of your SEO Workflow using GSC API, Customized Python Scripts, GenAI(LLMs) and more!
How to Optimize Title & Meta Description for Higher Organic CTR using GSC API & LLM (OpenAI GPT-4o)?
Learn how to use Google Search Console data to optimize Title and Meta Descriptions for Higher Organic CTR.
✅ Google Colab Link: colab.research.google.com/drive/1KBdFLNl0eMEFgkM9BKTBKV47z5tck9ew?usp=sharing
✅ Google Search Console API Playlist: ua-cam.com/play/PLRxix0vq5JYndBbrJKbmVjyd4vp1W80_Y.html
✅ SEO Workflow Automation Playlist: ua-cam.com/play/PLRxix0vq5JYlxPfFN_OxKwEZgqXDG2Z7M.html
GSC Explorer App : www.gscexplorer.app/
Join the FREE Newsletter for more videos:
www.mihirnaik.com/newsletter/
Let's connect on Socials:
LinkedIn : www.linkedin.com/in/mihir23192/
Twitter : mihir23192
✅Google Search Console API Overview: developers.google.com/webmaster-tools/about
✅Plotly Express in Python: plotly.com/python/plotly-express/
✅Pandas: pandas.pydata.org/
💡Timeline:
00:00 Recap of what's been done so far
✅ Google Colab Link: colab.research.google.com/drive/1KBdFLNl0eMEFgkM9BKTBKV47z5tck9ew?usp=sharing
✅ Google Search Console API Playlist: ua-cam.com/play/PLRxix0vq5JYndBbrJKbmVjyd4vp1W80_Y.html
✅ SEO Workflow Automation Playlist: ua-cam.com/play/PLRxix0vq5JYlxPfFN_OxKwEZgqXDG2Z7M.html
GSC Explorer App : www.gscexplorer.app/
Join the FREE Newsletter for more videos:
www.mihirnaik.com/newsletter/
Let's connect on Socials:
LinkedIn : www.linkedin.com/in/mihir23192/
Twitter : mihir23192
✅Google Search Console API Overview: developers.google.com/webmaster-tools/about
✅Plotly Express in Python: plotly.com/python/plotly-express/
✅Pandas: pandas.pydata.org/
💡Timeline:
00:00 Recap of what's been done so far
Переглядів: 396
Відео
How to Check 🚀 the Indexing Status of Sitemap URLs in Bulk using 🐍 GSC URL Inspection API?
Переглядів 4295 місяців тому
The script will help you check the Indexing Status of all your XML Sitemap URLs in Bulk using GSC URL Inspection API. You could expand this code to further adapt to your needs. ✅ GitHub Code Link: github.com/TheMihirNaik/google-search-console-api-using-python/blob/main/6 - GSC URL Inspection API.ipynb ✅ Link to this Playlist: ua-cam.com/play/PLRxix0vq5JYndBbrJKbmVjyd4vp1W80_Y.html Join the FREE...
How to do 🚀SERP-based Keywords Clustering using 🐍Python?
Переглядів 1,1 тис.10 місяців тому
Learn how to do SERP-based Keyword Clustering for as low as $1.6 for 1000 keywords. This is the cost of using ValueSERP API to scrape the Top 10 Ranking URLs for each keyword. I'm also showcasing how I used Google's Cloud Functions to host the SERP-based Keywords Clustering login in Serverless function, and how you could also think of various use cases that are worthy of having an endpoint that...
Efficiently Filtering List of Keywords using Stemming & Lemmatization
Переглядів 24511 місяців тому
When doing keyword research, we gather keywords from various sources like Keyword Research Tools like ahrefs/semrush, Google Auto Complete, Google Related Searches, Google Search Console Queries, Google Ads Search Term and more. Then we go through reviewing them one by one before we do keyword mapping. I did share the script for SERP-based Keyword Clustering but to prepare the list of keywords ...
Calculate Organic CTR by Position 🚀 for Brand vs Non Brand Queries using GSC API & 🐍 Python
Переглядів 440Рік тому
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/google-search-console-api-using-pyt...
How to Identify Rankable Content Topics in minutes? SEO Automation
Переглядів 1 тис.Рік тому
I use Google Autocomplete API to gather all the search queries for a keyword, then use ValueSERP API to scrape search results, and my custom SERP-based Clustering API to receive the Clustered Keywords, and then use Plotly Express to Visulize. Use OpenAI API to use GPT-4 to generate Content Brief that relies on the clusters you just created. Google Colab Link : colab.research.google.com/drive/1U...
Visualize Branded vs Non Branded Queries 🚀 using GSC API & 🐍 Python
Переглядів 646Рік тому
Learn how to plot charts for Branded and Non-Branded Queries over time. Uncover unique insights like No. of Unique Queries ranking for Brand vs Non-Brand Queries. Also explore the metrics like Clicks, Impressions, CTR and Position. ✅ Github Code Link: github.com/TheMihirNaik/google-search-console-api-using-python/blob/main/4 - Plotting_Branded_vs_Non_branded_Queries_using_GSC_API_&_Python.ipynb...
GSC Data Visualization 🚀 using Plotly 🐍, No of Queries & URLs by Date
Переглядів 959Рік тому
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/google-search-console-api-using-python/blob/main/Visualize_GSC_Da...
Fetching 25K+ Rows of GSC Data using GSC API🚀 with Python🐍
Переглядів 2,4 тис.Рік тому
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. 💯 ✅GitHub Link: github.com/TheMihirNaik/google-search-console-api-using-python/blob/main/GSC_API_25k+_Data,_Export_to_CSV,_Dimensions_.ipynb...
Tutorial : Google Search Console API🚀using Python🐍 with Google Colab
Переглядів 16 тис.Рік тому
After watching this video you will be able to access four basic features of Google Search Console API. 💯 This video goes into detail explaining GSC API Authentication and Authorization as well as different features such as Search Analytics, Sites, Sitemaps, URL Inspection etc. ✅GitHub Link: github.com/TheMihirNaik/google-search-console-api-using-python/blob/main/GSC_API_Access_using_Python_v1.i...
I do agree you are top!
Thank you for everithing. I came here searching for a solution to extent the 1000 limits about the Indexing report (I wanna know the complete list of URLs than has a "worng" status) Do you know if it is possible using phytom? there are a solution using the API? Maybe I want to much, But again thank you for your content!!!
I am making a postman call but when I click on the incoming url "404. That’s an error. The requested URL was not found on this server. That’s all we know." error i checked eveything especially redirect_uri but not solved :(
@@g_ddd I am not sure I understand why are you making a Postman call.
@ Oh ive solved my problem after sent this comment thank you for helping and answered my question 🙏 (The reason i use postman that i dont use python right now i have to code backend with C#, i wonder if your video would help me, that's why i watched and it helped thanks again)
Thanks a lot again! Awesome, straightforward video 🙌
thx :)
need some help got an error and dont know how to move forward
@@TheLoveTips1 make sure you change APIs to yours.
Thank you. This is super valuable.
Glad it was helpful!
Mihir, thank a lot!!! It's work! Really work! This tutorial is hands down one of the best I’ve come across. It gave me the clear guidance I needed to successfully work with the GSC API!
Thanks Man, You are super!
This is amazing Mihir!!! Super powerful. I think the bulk version would be extremely helpful, but the logic shared here alone is already super valuable!
I Would like to have a tool for bulk urls.
Sure, I will plan for it.
Hi Mihir, great tutorial and thank you for the effort you are putting, but I got an error while inspecting URL with search console API, upon inspecting it further i came to know that for url inspection you need indexing api, so my question is can we not inspect a url using search console api? Thank you and keep up the great work!
@@SEOWizard-x9n there is a video for checking indexing status. I have explained it there.
@@SEOWizard-x9n ua-cam.com/video/TxmLOu_-lkQ/v-deo.htmlsi=GO_u9e6o0lGUrBnx Here it is.
@@TheMihirNaik Thank you so much will check it out!
404 for the github
Thanks for letting me know. I just updated the link. It should be working now.
Hey, I watched and applied all of your codes, and I just want to say - It's amazing, and a big thanks for the help I received. I know python but not much experience with API, but your codes were just amazing. Also, it upgraded the way I code. Seeing your code, I realized I can write mine ones better and robust. Keep doing it :)
Wow wtf... Lovely tutorial
Thanks!
The code is mindblowing and more than I can comprehend especially when getting familiar with APIs. Anyone finding the link, here is it - colab.research.google.com/drive/1UEyeLPRG7juSKwVfDAoaW83KP7KnhUFU
Awesome video. Groupby two columns was new to me. Overall, loved it and learnt something new :)
Amazing. Made it easy to visualize and understand Plotly, and also using express made it easier for me to undestand. Loved it :) I also asked ChatGPT to help me plot all three line charts on a single graph, and it's amazing how support from big brother help me push even further.
Really Thanks bro for Helping. These starters Guide is not actually for Starts, you made it simple for us. Thanks :)))))
@Mihir - won't the first graph also contain 0 impression URLs since we didn't filter for that specifically?
If the URL has no impression then it won't be reported. GSC only reports URLs where Google has shown any impression.
Mihir, I just cannot thank you enough for this video! The OAuth documentations are so confusing. I spent quite a few days on google, ChatGPT, Gemini, Claude, and lots of videos, but none can get me through the Google OAuth. Your video trump them all!
Thank you for sharing this amazing and value able content. It was very hard for me to understand by Google API documentation but you make possible. May I know how we can export 404 pages by Search Console API?
Thank you! Unfortunately GSC API doesn't allow exporting 404 pages.
I can't believe how you're delivering such great value for free. It's amazing, and let me thank you for your work and knowledge philosophy. It's something I admire from the programming world.
Mihir, this was by far one of the best tutorials I have ever gone through. It was exactly what I needed to understand how to successfully call the GSC API, which is not at all easy to understand via the GSC documentation.
@@robertodelgado1234 glad you liked it and I very much appreciate you leaving this comment. 🥳
Very helpful video. How & where to learn about dealing with database? Where to begin as a first timer?
I have been thinking of making a video for the same but I am not sure if it would be of interest for many. I would suggest looking into MongoDB. It has a product called MongoDB Atlas. It is a free cloud database that you can connect from Google Colab and save data easily.
@@TheMihirNaik Thanks for replying. Will definitely check it. Some times when we think this won't be of any use to anyone, many would be waiting for or won't know that they need it.
we missed you, bro. It's been a long time. Please don't take too long with your videos; they're very useful.
Hi Mihir, Thank you for your great and helpful videos! I really appreciate the effort you put into them. Could you consider making a video on bulk URL removal from Google Search Console? It would be incredibly useful! Thanks again!
Unfortunately the URL removal functionality is not available in API.
Can I do it with google jasn api
Plz quickly response sir??
Sir yi Direct URL kaha sa aya.???
Hello, thank you for this file and Video I have a question, is only the code enough in the API section? Or other things like gl and hl should be changed I tried several times, but it can't worked
Yeah the code should be enough. You just need to change it with your ValueSERP API.
Hey Mihir, I have an issue with the authorization. After the URL is generated and opened I get this: "Error 400: invalid_request Request details: redirect_uri=urn:ietf:wg:oath:2.0:oob flowName=GeneralOAuthFlow" Would you, or anyone else in here be able to assist? I changed the REDIRECT_URI = "localhost" and I managed to get further but when I want give access to my gmail account it cannot load the localhost. Would you be able to assist here?
Nice work Mihir this is amazing. 🙌 Do you have any plans to consolidate URL data with Queries? Looking at performance of a particular page-type instead of site-wide could also be valuable.
Yeah I plan to add more views/reports. Feel free to share more ideas. Specifically regarding your ask, I am planning to add Page Segments and Query Segments so there will be reports for the same.
Thank you so much, Mihir! Your work is truly impressive. 🌟 I'm inspired by your innovative approach to leveraging programming in the SEO industry. 💻🚀 Keep up the amazing work! 💪
@@vaibhavaggarwal2448 Thank you so much Vaibhav. I very much appreciate you leaving this comment.
Keep Bulding!
spectacular!!
I’m also building kinda similar tool! Kudos to your efforts!
Thanks Vaibhav. All the best for you tool. Let me know when you are done. I would love to check out.
This is great, is there a way we can see your cloud based function to understand what is happening under the hood?
thanx again Mihir
Good video, thanks.
Thanks again Mihir
Very interesting, but I can barely hear you.
Sorry about that. I tried to do better with other videos.
@@TheMihirNaik I I got myself some good quality headphones and I don't have a problem anymore. Great content, I will find it very useful in my work. It's good that you are here. Sending thanks from Poland.
Hey, great video! Is it possible to access this colab? I couldn't find it on your site. Thanks
Apologies for not putting the links. I have updated the description with link to Colab and Deck.
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.
Can you give the link for the dataset
Amazing, thank you! I was suffering with this for quite some time =D
Glad you found it helpful.
Great video, Thank you for sharing with us. I have created file, but its not downloading.
What happened?
Hi Mihir. where can I find my redirect URI?
The redirect URI is the same for everyone. The one I have given in the code.
sir I'm getting this error-> An error occurred while saving your app The request has been classified as abusive and was not allowed to proceed Request ID: 7497052440829625583
Hey @mihir naik , is there any api through which the search console api is enabled without doing manually
Sorry Lavanya, I'm not sure I'm getting your question.