If you want to send your analytics data from Piwik PRO to your SFTP server, you can use our paid service. Once your data is uploaded to the server, you can use it as you wish.
In this article, we’ll explain how to set up your integration.
Before you start
Here are some things to know before you start:
- For daily exports, we start exporting data at 4 AM (UTC) and deliver it within a few hours. The exact time depends on the amount of data. It’s not possible to change the export time.
- For hourly exports, we export your data every hour and deliver it within that hour. The exact time depends on the amount of data.
- If you’re exporting data from Google Ads, it’ll be delayed for both daily and hourly exports since Google delivers their data to us at 8 PM (UTC).
- You can change your export setup, but there will be a delay in applying the changes because exports are scheduled in advance.
Integrate with an SFTP server
To integrate with your SFTP server, follow these steps:
- Get in touch with your account manager or use this form to contact us. They’ll assist you in processing the payment for this service.
- Reach out to our support team, and they’ll set up a secure connection for you to share the following information:
- login
- host
- (Optional) dir_path. If not provided, defaults to home directory.
- (Optional) port. If not provided, defaults to 22.
- Time zone for each site. If not provided, the data will be exported using the site’s time zone set in Administration > Sites & apps > Data collection > Time zone.
- Frequency: daily or hourly
- (Optional) If you have a firewall, just let us now and we’ll send you the list of IP addresses to allowlist. But keep in mind that in some rare cases these addresses might change. If you notice any missing files, just contact our support team.
- We’ll generate a private and public key pair. We’ll send the public key to you, and you’ll need to upload it to your server. We’ll also place the private key in the configuration file for exports.
- Once we receive all the information from you, we can establish a connection between Piwik PRO and your SFTP server and start uploading your data.
- All done!
Export details
Scope
We export your data in raw format. The raw data schema is saved as three files: sessions (sample CSV file), events (sample CSV file) and Google Ads integration. You can choose the website as well as the dimensions and metrics that you want to export.
You can also find a full list of columns containing dimensions and metrics in our developer documentation: reports, Google Ads, SharePoint.
Frequency
We can export your data on a daily or hourly basis.
Format
We upload your data using gzip-compressed CSV files.