APIcal Way To Collect All Relevant Keywords In Your Niche
How to expand your keyword list quickly and easily? It's a question that every SEO who works on major projects asks himself sooner or later. My team and I hate wasting our time. Thus we developed a unique script for Google Spreadsheets based on Serpstat's API. In this article, we're sharing this script with you to make your life a bit easier. All you need is Google Spreadsheets and API access.
This script will be useful for PPC specialists, who are searching for new keywords for their ad campaigns, as well. Copy this spreadsheet to your Google Drive to start using it.
What data can you obtain via this script?
This script includes only those Serpstat API methods that are required for our goal. Here's what data you can get using this script:
- keywords that URL ranks for in Google search results;
- keywords that competitors' URLs rank for in top-10 but that are missing from the queried URL;
- results of full-text keyword search;
- results of full-text search suggestions search;
- related keywords (is available for all tariff plans except plan A).
Why Google Apps Script?
Google Apps Script – is user-friendly and easy-to-use. Let's cover its pros and cons.
Pros:
It's a cloud-based tool;
Independence of OS;
It's shareable, just copy it to your Google Drive.
Cons:
The script's working time is limited (no more than 6 minutes);
Data transfer capacity is also limited. However, this limitation affects only the method of getting keywords' info.
Pros:
It's a cloud-based tool;
Independence of OS;
It's shareable, just copy it to your Google Drive.
Cons:
The script's working time is limited (no more than 6 minutes);
Data transfer capacity is also limited. However, this limitation affects only the method of getting keywords' info.
How to use this script?
2
Open the first sheet called "Settings" and enter your API token, which can be found in your profile. Then choose the database you need.
3
Add the list of keywords and/or URL you want to get data for. Don't leave blank lines as the script stops working if it finds the gaps.
4
Set the filters to get the desired results.
5
Choose the method you need.
Click on Serpstat menu item and choose the method you need. Moreover, you can run multiple methods.
What methods are covered in this script?
Check queries quantity
Use this method to check the number of queries left for today. You'll get such a pop-up:
Get keys by URLs
This method returns keywords that URL ranks for in Google search results. As a result, you'll get the table with the following data on "Res by URL" sheet:
- found keywords;
- proper spelling if there are typos;
- PPC competition;
- volume;
- toponyms;
- SERP elements;
- URL that is used for this query.
Get missing keys by URLs
Shows a list of keywords that competitors' URLs rank for in top-10 but that are missing from the queried page. You'll get the following list of data on "Res Missing by URL" sheet:
- found keywords;
- PPC competition;
- volume;
- toponyms;
- SERP elements;
- connection strength, which shows how many competitors from top-20 search results have this keyword.
Get keys by keyword
This method uses a full-text search to find all keywords that match the queried term. For every keyword found you'll see its volume, CPC, and level of competition. Here's what you'll get on "Res by Key" sheet:
- found keywords (here's our search keyword suggestion tool);
- proper spelling if there are typos;
- PPC competition;
- volume;
- toponyms;
- SERP elements;
- social networks in search results;
- the keyword that was analyzed.
Get suggestions by keyword
This report lists autocomplete suggestions for the keyword you requested (full-text search). Here's what data you'll find on "Res Suggestion" sheet:
- found keywords;
- toponyms;
- the keyword that was analyzed.
Get related keys by keyword
This report gives you a comprehensive list of related keywords whose SERP is similar to the one the requested keyword has (only for B and C plans).
Finally, you'll get the following data on "Res Related" sheet:
Finally, you'll get the following data on "Res Related" sheet:
- found keywords;
- proper spelling if there are typos;
- PPC competition;
- volume;
- toponyms;
- SERP elements;
- connection strength, which shows how many mutual pages from top-30 search results the initial and the found keyword have;
- the keyword that was analyzed.
Get keywords info
This report provides you with the keyword overview showing its volume, CPC, and level of competition. This script can process just 280 keywords at a time because of Google Apps Script limitations.
The data you'll find on "Key Info" sheet:
The data you'll find on "Key Info" sheet:
- keywords;
- PPC competition;
- volume;
- toponyms;
- SERP elements;
- social networks in search results;
- CPC;
- the number of found results.
As I've already said you can run multiple methods, but mind that it's better not to run more than 2, because of API's limitation of 10 simultaneous requests/second.
Let's analyze the results. For 12 URLs and 25 keywords, I got 2 352 relevant keywords for 2 minutes. The filter setting that I used is on the right. As original keywords and URLs are listed as well, we can easily cluster the gained keywords.
How to improve this script?
Check out this video vlog to learn more about Serpsta's API:
Speed up your search marketing growth with Serpstat!
Keyword and backlink opportunities, competitors' online strategy, daily rankings and SEO-related issues.
A pack of tools for reducing your time on SEO tasks.
Found an error? Select it and press Ctrl + Enter to tell us
Discover More SEO Tools
Backlink Cheсker
Backlinks checking for any site. Increase the power of your backlink profile
API for SEO
Search big data and get results using SEO API
Competitor Website Analytics
Complete analysis of competitors' websites for SEO and PPC
Keyword Rank Checker
Google Keyword Rankings Checker - gain valuable insights into your website's search engine rankings
Recommended posts
Cases, life hacks, researches, and useful articles
Don’t you have time to follow the news? No worries! Our editor will choose articles that will definitely help you with your work. Join our cozy community :)
By clicking the button, you agree to our privacy policy.