This site uses cookies and other tracking technologies to make possible your usage of the website, assist with navigation and your ability to provide feedback, analyse your use of our products and services, assist with our promotional and marketing efforts, and provide better user experience.

By using the website, you agree to our Privacy policy

Accept and continue


Report a bug

7652 3
SEO 4 min read September 23, 2016
client use case

How We Used Serpstat To Rank Our Project

Analyzing competitors to gather keywords, create URLs and build a sitemap.
About us:
Let's start with an introduction. My name is Thomas Harvey and my companion is Chris Chedgzoy. We've been involved with SEO for quite a while and know our way around the subject.Both, me and Chris are moderators on SEO Chat forums, if you have any questions about SEO just head there and forum members, including us, will be more than happy to help.
The Project We Worked On (
Recently we launched a platform that takes a load of feeds from around the web and allows users to search for products inside our platform. Chris built it from scratch and we already have over 1.5 million products in our database, and that's without counting the products from eBay, that are also included in our search. Oh, and connection to Amazon is in in works at the moment.Our website is called Zebo, feel free to give it a go and share your feedback with us.
Using Serpstat To Collect Data
The problem we're currently facing is that we have no navigation system. So whilst we could show results for any query, we had no way of getting them indexed. To solve this problem we decided to see how similar services worked on it. Here's a snippet of our competitor's data that we found with Serpstat:
Our competitor is indexed and ranking for 42,463 results in the UK. We exported this data to work with it further.
In the spreadsheet we can see the positions and keywords. We took all of their keywords and added them it to our query search. We also used a find and replace function to replace spaces with underscores. So the keywords column would now be filled with everite_watch or graffiti_bedding. Then used the queries on our domain to get the following URLs:
Creating Sitemap
Next step was creating a sitemap. I used Screaming Frog for this. It takes the list of all URLs and checks them for errors, to see if any of the URLs are out of place and etc. Here's a small sample I created to show you what it should look like.
In this example we have 99 URLs and every single one of them is working. We then simply upload the sitemap (or append it to our sitemap_index.xml) then tell search engines to crawl the sitemap again.
A quick recap of what we did:

  1. Found our competitors with Serpstat by analyzing our domain
  2. Took competitors top keywords
  3. Appended keywords to our domain
  4. Created sitemap
  5. Uploaded and fetched the sitemap.
If you have any questions, feel free to contact me, I'll be happy to help.
If you have a use case you want to share with us, contact us and pitch your idea. We'll gladly publish more content from our clients.

Rate the article on a five-point scale

The article has already been rated by 0 people on average out of 5
Found an error? Select it and press Ctrl + Enter to tell us

Share this article with your friends

Sign In Free Sign Up

You’ve reached your query limit.

Or email
Forgot password?
Or email
Back To Login

Don’t worry! Just fill in your email and we’ll send over your password.

Are you sure?


To complete your registration you need to enter your phone number


We sent confirmation code to your phone number

Your phone Resend code Queries left

Something went wrong.

Contact our support team
Or confirm the registration using the Telegram bot Follow this link
Please pick the project to work on

Personal demonstration

Serpstat is all about saving time, and we want to save yours! One of our specialists will contact you and discuss options going forward.

These may include a personal demonstration, a trial period, comprehensive training articles & webinar recordings, and custom advice from a Serpstat specialist. It is our goal to make you feel comfortable while using Serpstat.




We are glad of your comment
Upgrade your plan

Upgrade your plan

Export is not available for your account. Please upgrade to Lite or higher to get access to the tool. Learn more

Sign Up Free

Спасибо, мы с вами свяжемся в ближайшее время

View Editing


You have run out of limits

You have reached the limit for the number of created projects. You cannot create new projects unless you increase the limits or delete existing projects.

I want more limits