I am trying to collect historical Alexa TrafficHistory ([url removed, login to view]) for a few sites from using the AWIS API. That is, for each site I want on daily basis going back a few years: PageViewsPerUser, PageViewsPerMillion, Rank, reachPerMillion
I have my AWIS accounts with an accessKeyId and secretAccessKey (you will need your own to check your code)
I attach PHP code that used to work to do this until Amazon deprecated signature version 0 and now only accepts signature version 2. I have tried without any success to modify the example AWIS PHP code ([url removed, login to view] >> Download >> [url removed, login to view]) which is designed for other AWIS data (Rank, Links in Counts, etc).
WHAT NEEDS TO BE DONE
Take the attached file ([url removed, login to view]) and modify it so it will work again. I will be running it in from a Win 7 x64 command line with PHP 5 installed, and so the modified code should work here (to run from command line: php [url removed, login to view] > [url removed, login to view] which will create the output file [url removed, login to view] which will have traffic stats for [url removed, login to view] for 01/2008-07/2013; the url and the dates are the parameters in the code). I can parse the resulting XML though a bonus can be given if you add PHP or Perl code to convert the output to CSV.
This should be super easy for any PHP programmer. I think the only change needed is with the signature which can probably be determined from the example AWIS PHP code listed above. I imagine this could be done in a hour or less, and I would like to have working code by this weekend.