PiWik Multiple Site Reporting

[branica]

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.

[branica]

Looks like Editgrid will be dead soon - too bad!

EditGrid Blog

[eltrkbrd]

Any adivice on how to get Piwik multisite stats working with the template posted here on EditGrid?

I signed up and saved the template but something weird is going on.

I just can't figure it out.

Just curious, can you do the same thing in an excel spreadsheet?

I don't quit understand the formulas in use but something isn't right.

I installed the latest Piwik to my shared hosting server. Everything is working fine on that end and I copied the token_auth from the API section.

I tried pasting it in different fields in the EditGrid template along with the base URL of my piwik installation but alas, no love...

Ultimately, I have about 50-200 sites that I would like to create a combined webstats report on.

It is possible to create one SiteID in Piwik and then add multiple site URLs to that one site ID to get combined stats but it doesn't seem like such a clean way to do things...

Perhaps using the custom API and online spreadsheet as demonstrated here will give finer grain control over combined Piwik stats for multiple sites?

Cool forum by the way!

Thanks,
Steve

[branica]

Steve, EditGrid is basically dead. You could try using google documents instead.