Exporting data from Piwik PRO
June 12, 2018
There are times when you might need to retrieve data from Piwik, for example to use it in a different tool or present it in a document. Piwik PRO Cloud offers three methods to do that!
Downloading report data
Almost every report and widget in Piwik offers a possibility of exporting data in following formats: CSV, TSV, XML, Json, Php, RSS.
In order to export data locate the export button at the bottom of the report:
If you can see the button, it may be hidden, to show it click the expand button.
Clicking the export button will expand a choice of formats available for download. Click the format you like to start download.
More advanced but also more powerful method of retrieving data from Piwik PRO Cloud is by using Piwik PRO API. All of the available API methods can be found in your instance Account Settings (top left corner Menu of your Piwik PRO) under the API tab
First thing you will require is the authentication token. It is located at the top of the API page and is unique for every Piwik user. You should never share this token with anyone as it gives full access to your account and is equal to your password and login.
Next thing you’ll need to do is choosing the right method for your needs. Check the documentation as well as examples of each call available on the page to decide what will best suit your requirements.
Here’s an example of API call broken down to parameters:
This is just a sample of API call that can be made, feel free to explore the documentation in your Piwik PRO Cloud to learn more. If you’ll have any problems with the call, feel free to contact Piwik PRO Cloud support at firstname.lastname@example.org
In some cases pulling single reports might not be enough and you might require a complete database dump of your Piwik PRO Cloud instance. To get it, ask email@example.com or use the communicator in your instance lower right corner. You should receive the database dump in a workday in most cases.