Amazon Rankings Tracking with Excel

You can download the Amazon Rank Tracking prototype here: Amazon Rank Tracking Prototype. You must have the SEOTools for Excel plugin installed. The spreadsheet uses the XPathOnURL query to scrape Amazon’s search results.

For those of you on Amazon.co.uk, you can use the UK version of the spreadsheet.

rank tracking

Unfortunately, the Excel file operates slowly and requires a manual process for saving each day’s keyword rankings.

We had previously built the same spreadsheet in Google Docs using the their ImportXML query. Unfortunately the reliability of Google Docs has been quite poor recently. At the time of writing, It only retrieves about half of the ASINs ranking for a keyword. Also, the ImportXML query in the new Google Spreadsheets is very, very spotty. Even the example queries on Google’s help page do not work.

If you would like to collaborate on improving either the Excel file or the Google Doc, contact Nathan Grimm via email (first name at dnaresponse.com) or on Twitter @n8ngrimm.

Want a Better Amazon Rank Tracking Tool?

Nathan Grimm“We’ve partnered with Sellics to deliver a high-quality, automated, integrated amazon keyword ranking solution. Their tool starts at $10 per month and tracks not only rankings but also sales trends, reviews, live sales data, helps you optimize your PPC campaigns, and a lot more. Sellics is the best value in marketing analytics for Amazon sellers and I was not paid to say that.” ~Nathan Grimm

Give Sellics a try with their 7-day free trial

  • Vincent

    Awesome tool. I noted that the rankings factor in the sponsored listings as well. Are there any work arounds for that?

    • http://twitter.com/n8ngrimm Nathan Grimm

      In one sense, you want to know that there are sponsored listings above your results because that’s going to affect the value of your organic ranking. However it’s a bit misleading if you’re the #1 organic result but the rankings shows you at #3. I don’t have a workaround for that yet.

  • FernandoM

    I found an inconsistency using the tool but I believe it’s related more to Amazon search system. The search URL used on the prototype is not the same as if someone goes into Amazon website and uses the search box and it sometimes gives different results. I’ve tried several methods with the search box (for me it’s the most important because the majority of people will search this way) like searching 1 time, going back and forth the result pages (the url actually changes when you go back to the first one but results don’t), clicking on the search box “go” button twice (also changes the first page url but not the results). The only one that produces different results is the one used with the prototype so I wouldn’t recommend that structure (http://www.amazon.com/s?field-keywords=keyword). For comparison please check the attached image. I’m extracting the 9th item ASIN of each page generated by the link above and as you can see the ASIN extracted from the URL used on the prototype is the only one that brings a different result.

    Anyway it is a nice effort gave me a lot of ideas.

    Thanks,

    Fernando

    Edit: Don’t know where the image went. =( but basically this is the url structure if you go into the website and use the search box 1 time: http://www.amazon.com/s/ref=nb_sb_noss_1?url=search-alias%3Daps&field-keywords=gopro

    So you can see how different it is.

    • http://twitter.com/n8ngrimm Nathan Grimm

      Thanks for posting this. Depending on the query you use, Amazon will display results differently. Sometimes, they are listed vertically and others there is a grid of products. However, I’ve never observed the results coming up in a different order based on how they are displayed.

      I used the simplified URL structure for two reasons:
      1. I don’t know what rules Amazon uses to generate urls from a real-world search so I couldn’t program to tool to match their logic
      2. I would need to predict which style of result Amazon was going to serve and use a different XPATH query accordingly to extract the results. That’s above my pay-grade and I would guess that I don’t have access to the dataset that determines which type of results are going to be served.

      • FernandoM

        I agree, I thought it was something to keep in mind but as you said it would be difficult to predict the type of results because it varies for many reasons. I’ve being playing around a lot with this and I can certainly tell that Amazon logic is very korky.

        • md khairul islam

          Hello Sir,
          How are you?
          I came here with lot of opportunity. If you seller on amazon then I will help you to get first page rank of any keyword on amazon
          skype id: mb.mkh22@gmail.com

  • Krissybobs

    Just installed and tested this for Amazon UK – and hoorah! All is working well. Quick question, is it possible to also request the item_name (Product Listing Name) alongside the returned ASIN? If there’s an automated way to do this it would save a lot of manual copy+paste.

    • Ridoy Seo

      Hello Dear,
      I am Ridoy Kumar Dipto, I’m an amazon SEO expert for products ranking and Optimization . I have more than 3 years experience on this field . I’m well known about Amazon A9 Algorithm .
      If you have any keyword to rank then you can give me.
      My contacts Address
      Skype:ridoycmrpi76
      For More Discuss Please Add me.
      Thank you

  • Fonteneau Pam

    so good

  • chandandara

    Do you have something handy for amazon.in as well ??

  • Agy Yip

    Pretty cool! I tested this from Amazon US with a few keywords, it works very well. keep on tracking the serch terms

  • Constantine Kirillov

    Hi. SEO Tools xls plugin shows up with an error that a Pro version needs to be purchased to use HTML… The pro version is 79 EU per year… Which would be ok, but I do not know if the method will work… Can anyone confirm that the spreadsheet method works with a paid version of the SEO Tools Excel Plugin?

    • Dan K

      There is a 14 day trial version

  • Kaloyan Stolinov

    A very inexpensive Amazon keyword rank tracking tool is: http://amzkeywordrank.com/

    It’s a desktop software that works both on PC and MAC and it does not rely on any external databases – it checks your keyword rankings in real time on Amazon the same way you would do it manually and you can watch while it does it.
    You can check how ANY ASIN ranks for ANY KEYWORD, which means that you can not only track your products, but the competitor’s products as well.
    Each time you run it, it also logs your product’s vital data like current price, current sale price, current number of reviews and average review rating, BSRs for the categories the product is listed in.
    It is a very cheap app, compared to the other online Amazon keyword rank tracking services.

  • Matthew Henry

    Very helpful – thank you for providing. Especially nice to have provided excel as well since we’ve seen the same inconsistent reliability in Google Docs lately.

  • Ridoy Seo

    Hello Dear,
    I am Ridoy Kumar Dipto, I’m an amazon SEO expert for products ranking and Optimization . I have more than 3 years experience on this field . I’m well known about Amazon A9 Algorithm .
    If you have any keyword to rank then you can give me.
    My contacts Address
    Skype:ridoycmrpi76
    Mail: ridoykumardipto@gmail.com
    For More Discuss Please Add me.
    Thank you

  • Janie Ellington

    Nathan thnx for this sheet. But it definitely is slow and require some manual work on it. Still not bad for the free. how can we use this for other European marketplaces?
    I have been using a paid tool for Amazon tracking jobs http://www.amzinsight.com it does charge me $29 dollars monthly but then again it automates things.

    Can you please also share to at least fetch the item name with this spreadsheet? Thanks for sharing.

  • Amazon Products Ranking

    Hello,

    We are an amazon SEO Expert Company.
    We can rank amazon Products/Keywords on first page.
    We are ranking per keyword with low cost
    If you need our services please connect with our team.

    Our skype: AmazonProductsranking@gmail.com
    Whatsapp: 01831058030

    amazonSEO.webnode.com

    Our skype@ iamAzKcse

    Thanks