Hi all,
Sorry for this newbie question, but my Google searches were only getting me so far
I’m currently experimenting on loading my Piwik data into Excel to create a dashboard to share with colleagues. The reason for using Excel and not the Piwik widgets is because we have multiple analytics sources which I want to combine in one dashboard.
So far I’m very happy with the Piwik API as it allows me to pull live data from Piwik into an Excel XML table which I can then use for some analyses and chart generation. However, I seem to be stuck a bit.
I succeeded in pulling the individual API’s into Excel, but would love to have a custom API that provides certain data, rather than the standard sets. As an example, I would like to get the unique visitors, visits, etc. but not the Actions per visit. How can I do this? I tried the Bulk API, but my Excel skills are proving a bit limited as I don’t know how to import the array into separate columns in Excel. Also, I can imagine the URL will become massive if I want to retrieve for instance 10+ different variables?
Thanks in advance for your help!