Compare a Domain’s Rankings from Past Months

If one of your big goals is to grow rankings, you want different ways to show that. We’ve included stats throughout the SpyFu site that show how you’ve grown value (Recon Reports), how you’ve jumped in rankings from the past month (SEO Keywords – keyword rank gains), and trendlines of how you’ve ranked over time (Ranking History). Thanks to a customer who asked, we also shared a way to single out one month of rankings at a time. It helps you when you’re looking at a year-over-year comparison, using a single-month window.

We wanted to answer: How can I see my domain’s January 2016 rankings compared to January 25 for the same keywords?

I’ll use Barkbox.com as an example, because who doesn’t love puppy gifts?

1.  Download a domain’s ranking history

Type barkbox.com into the search bar and choose the SEO Research tab. There’s a drop down option for Ranking History. Click it.

The results page is where you’ll jump to step 2. But first a word about what you are seeing.

What if I Want Different Keywords?

The default results are “Top 10 Keywords,” but you can change the list using other filters on the chart.

  • Default keywords/Top 10 keywords
  • Keywords that fell from the top 10
  • New keywords
  • Keywords that gained ranks
  • Keywords that lost ranks
Filters in Ranking History

If you want to go for specific keywords that Barkbox.com has ranked for, go back to the default keywords view on the chart. You can go with either of two options:

  • Filter to matching keywords — Type “cheap” in the filter and load the chart with the top 10 keywords that match it. Go to step 2. OR
  • Use the “add” button — Located at the top of the keyword list on the left, it lets you manually load keywords onto the chart. Delete the others that you don’t need. Go to step 2. 
Exporting ranking history in SpyFu

2. Export the list to a spreadsheet

The point here is that you want to be able to sort. This is what breaks apart your most recent keywords. There is an export option just above the chart on the right hand side. Choose “Export as CSV.”

We’ll call this next one Step 2.5. Open the spreadsheet…

3. Sort by the “date” column

This is going to list every ranking we’ve captured for this domain. If you want to compare just two months to each other (or any time range you want), this is where you will narrow it down. Select all rows, and sort by the date column.

 

Exporting ranking history via CSV in SpyFu

 

4. Select all of the keywords from the most recent month

Just scroll until you see the dates change to the ones you want to compare.

You can sort and filter out any dates that don’t match what you want to compare. 

Here, I want to see January 2015 to January 2016, so I am going to delete everything else. (2014 and earlier, February 2015 to December 2015, and anything February 2016 and later) 

 

5. Work with your remaining data

Now you’ll have lists of keywords that ranked in January 2015 and January 2016. You can sort by the term to find similar (and grouped) keywords, and most 2015 keywords will line up next to their 2016 counterparts.

A spreadsheet wizard shared this idea when we asked in a similar post:

If you format the data as a table, then you can easily create a pivot table using the date and the term. It is easy to sort it either way. You can also slide the term over to sum area and get a quick count of terms by year and month. When the data is formatted as a table you also get some powerful filtering options, and it is easy to filter by date. Original comment and post.

Recommend Reading

Find a site’s past rankings