Okay as you can probably tell that I am a PiWik junkie. Once it comes out of beta I will probably replace the existing Branica counter server with PiWik but I digress.
I have been some testing of the PiWik URL API and Google Spreadsheets. But Google Spreadsheets seems very limited to me. So I tried out EditGrid and it seems more mature than Google's offering - I guess for now. Google had this hard limit of only 50 ImportXML calls (even though their doc says 500) and a wierd UI thing with columns. You have to manually insert columns if you go past column U while EditGrid is more Excel like. In general EditGrid is more Excel like which to me is a good thing.
So anyways I wanted to create a report that simply shows the trend like this:
This report of course goes beyond 50 individual API calls so Google Spreadsheets would not work. I am liking EditGrid and need to learn more since it has macros and an API to boot.
I'll post the spreadsheet to but for this report to work you need to be use an admin or super user token so I'll have to just show the shell. So when you view it, it will have a bunch of errors. You'll need to
open an account at EditGrid - it is free for personal use and do a "save as" to use it with your PiWik data. Here it is:
PiWik Multiple Site Template - Online Spreadsheets - EditGrid
Enjoy and please let me know if you have any issues.