If you are looking for a free and simple way to track your rankings for a few keywords and store this data, here is a Google Spreadsheet you’ll like.
What it does:
We are using Google Spreadsheets „ImportXML“ function to scrape the top 100 Google Rankings for our target keywords. We created a Google Docs Script with a few lines of code that does the work for us.
This script creates a new column every time it’s executed, inserts the current rankings and time/week to this new column and also checks if your rankings have risen or dropped and changes the color to green or red. If you set up the email alert it will also let you know when your rankings drop.
How to set it up:
1. Get the Spreadsheet here and make a copy of it otherwise you won’t be able to edit it.
2. Enter your target domain, tld for Google, language, results for country, and activate the email alert. Basically, just fill in the green cells.
3. Enter your target keywords. Start with cell B13 and make sure that you dont add more then 50 keywords (because of Google ImportXML restrictions). If you need to track more then 50 keywords just create a new spreadsheet.
4. Copy D13 (the blue cell) and paste it in all rows that you filled with a keyword. Now you should see your current rankings.
5. Click on Tools -> Script Editor
6. From the Script Editor, choose Resources -> Current project’s triggers
– Click the link that says No triggers set up. Click here to add one now.
– Under Run, select the function you want executed on schedule.
– Under Events, select Time-driven.
– Choose if you like to track your ranking daily or weekly and save the trigger.
7. Have fun with the Rank Tracker.