How To Create A Content Strategy For A Travel Project Using Serpstat: TripMyDream Experience
How To Automate And Speed Up Your SEO Tasks With Serpstat API: A Step-By-Step Guide From Flatfy

There are more and more diverse tasks, and time goes on at the same speed. In this article, I'll show you how we automate the performing of SEO tasks using the API and save a lot of time.

To work effectively on all of our projects, the team is continually testing various tools for digital marketing, especially those that have an API.
Serpstat now has a massive database of keywords and links, but most importantly - one of the most convenient APIs. This is necessary because working with a large number of sites requires a constant storing of a lot of data in one place and analyzing it.
In this article, I will show you how to use the Serpstat API using real estate projects as an example. I'll also try to prove that even with a little knowledge of development and the ability to use Google and StackOverflow, you can simplify your daily routine work and gain an advantage over competitors.
Further, in this section, we will do everything as if I didn't know about development, but could search on Google. I want to inspire beginners to develop and learn. So, let's go:
And what do SEOs love most? Correctly! Tables. In this article, we will use Google Spreadsheets.
To work with data in tables, we use functions, but in the function "= serpstat (give me data)" is missing, and therefore we create our own.
If we google "google sheets custom function," we'll find a manual that talks about App Script.

Code "Formula 1":
We put that theory to the test.



Leave a request, and our experts will advise you on the development of your project, share training materials, and offer test access to Serpstat!

The easiest way to use the API is to create various reports. Let's create a simple Dashboard using the "Formula 2" code to analyze competitors with the following parameters:
This is how the mini-report looks like with the number of keywords, traffic, and ads in contextual advertising for competitors in real estate.

For example, the variables would be: sites (column A), API key Serpstat (cell G2), and search engine (cell H2).
Now we need to make requests to one of the attributes from the JSON array. JSON has a nesting (tree structure), which we will share with slashes.
For example, you need to get the number of keywords on a site. To do this, we will use the formula = IMPORTJSON (F2, "result/keywords") (cell B1). If we want to get traffic, then change our request to = IMPORTJSON (F2, "result/traff").

For example, take the code "formula 1".
It has several features that we will need. You can see all these features in the pop-up when entering the formula and in the comments of the code developer.
An important feature for us is the ability to get several JSON keys at once and receive data on them.
We want to find out the top 100 for several queries quickly. For example, I do this very often for a quick check for the clustering of queries. There is a request, and I don't know which page it will work best for. I get tops for several queries and compare their intersection directly in the spreadsheet. Thus, you don't need to run KeyAssort to cluster multiple requests, and you don't need to spend time opening numerous tabs with Google to compare tops.
Go to http://api.serpstat.com/v3/keyword_top and make the formula = ImportJSON (F2,"/result/top/position,/result/top/url") - note that we used two keys separated by commas: /result/top/position and /result/top/url.
Thus, we get two columns with data: positions from the top 100 and the URLs.

In this example, there is another feature - additional parameters. noHeaders allows us to remove the extra headers and get just the data. We write in column A the keys we need for verification, and "stretch" the formula further in column B.


Leave a request, and our experts will advise you on the development of your project, share training materials, and offer test access to Serpstat!
Flatfy has a rule - if a task arises several times, and it can be automated, we automate it. Many companies buy new equipment for employees to increase productivity, but few people think how much time an employee can spend collecting data instead of analyzing it and switching tabs instead of viewing all the data in one place.
By automating the processes of data collection, we improve the quality of tasks, get more time for priority tasks, and project development.
Using Serpstat API saves hours of work time. Using such simple automation, you can save at least one working hour per day for an SEO specialist.
Learn how to get the most out of Serpstat
Want to get a personal demo, trial period or bunch of successful use cases?
Send a request and our expert will contact you ;)
Recommended posts
Cases, lifehacks, researches and useful articles
Don’t you have time to follow the news? No worries!
Our editor Stacy 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.
Comments