Report a bug

Cancel
3159   16  
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 (zebo.co.uk)
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.
Found an error? Select it and press Ctrl + Enter to tell us
Subscribe to our newsletter
Keep up to date with our latest news, events and blog posts!

Comments

Sign In Free Sign Up

You’ve reached your query limit.

Or email
Forgot password?
Or email
By clicking 'Sign Up Free' I agree to Serptat's
Terms of Service and Privacy Policy
Back To Login

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

Are you sure?
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 adivce from a Serpstat specialist. It is our goal to make you feel comfortable while using Serpstat.

Name
Email
Phone
Skype or Google Hangouts
Comment

Upgrade your plan

Sign Up Free

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

Invite
E-mail
Role
Message
Optional

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

Christmas is a time for miracles.

You are almost on the finish line of our Christmas quest. The last brick of your lego-promocode is left on the way up 55% discount.

Did not find previous lego-bricks? Fill the form anyway.

Name
Email
Phone
Skype or Google Hangouts
Write your discount code