Hello,
We need help to develop a Google spreadsheet to use as a benchmark with competitors.
The spreadsheet should have the following colums:
Link - website to benchmark
Alexa Rank - scrap with xPath the alexa rank of the website in the first column
Approx traffic (v/d) - Scrape with xPath from http://www.mydnstats.com/
Linking root domains - From opensiteexplorer.org
Domain authority - From opensiteexplorer.org
Position SERP on Keyword1 - I'll put a keyword in the header and I need to know in which position they rank
Keyword 2
Keyword 3
It should be very easy to perform using xPath and importXml. You can distribute in different sheets if you want. Also if you find more items to benchmark we can give you a bonus