Mihir Naik
Mihir Naik
  • 9
  • 16 693

Відео

How to do 🚀SERP-based Keywords Clustering using 🐍Python?
Переглядів 5023 місяці тому
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
Переглядів 1544 місяці тому
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
Переглядів 3397 місяців тому
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
Переглядів 6778 місяців тому
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.
Visualize Branded vs Non Branded Queries 🚀 using GSC API & 🐍 Python
Переглядів 545Рік тому
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/Plotting_Branded_vs_Non_branded_Queries_using_GSC_API_&_Python.ipynb Let...
GSC Data Visualization 🚀 using Plotly 🐍, No of Queries & URLs by Date
Переглядів 776Рік тому
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🐍
Переглядів 1,7 тис.Рік тому
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
Переглядів 12 тис.Рік тому
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...