Export a report (classic)
Every time you want to use a spreadsheet to work with your data you can export one from a report. It can help you with in-depth researches of your website, as well as with collecting data from various reports. You can simply put together several reports with various metrics and keep only the data most important to you.
To export data from the report, follow these steps:
- Hover over the left down corner of the report, until you see the icons for various tools.
- Click on the export tool icon and select the format file.
- Open the exported file in a spreadsheet — Excel, Google Spreadsheet, Numbers, and more.
If you want to use data in a spreadsheet, you can export the report to a CSV, TSV (Excel), or XML file. For more advanced tools, use a JSON, or PHP file format.
Tip: You can receive any report straight to your mailbox. To schedule an email report go to Menu > Analytics settings > Email reports and set up a new report. The report can be set to recur every day, week or month.
Export data with API
More advanced but also more powerful method of retrieving data from Piwik PRO 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:
- First line is always the same as it defines your Piwik PRO Cloud domain as well as the fact that we’re using the
- Next is the name of the method mentioned above.
- In the third line idSite parameter defines the website that the call will be made for. Every website in your Piwik has its own unique ID number, you can find them in the Administration menu under the Websites tab.
- Fourth line defines a period of data that will be checked, available periods are: day, week, month, range. In the fifth line there is a date field which specifies the time of the above period.
- Sixth line is the format that you want the data in.
- At the end there is an authentication token mentioned above.
This is just a sample of API call that can be made, contact us if you need help with different cases.
In some cases pulling single reports might not be enough and you might require a complete database dump of your Piwik PRO instance. To get it, contact us via an email or in-app chat. You should receive the database dump in a workday in most cases.