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.
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?
“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