If you want to use data from Piwik PRO in Klipfolio, you can use our API to connect the two tools. The setup is easy and does not require much technical knowledge from you. Once connected, you’ll be able to access and view your Piwik PRO data in Klipfolio dashboards and reports.
To integrate with Klipfolio, follow these steps:
Note: In this example, we’ll get the number of sessions per day for the last 60 days.
1. Log in to Klipfolio.
2. Go to Data Sources.
3. Click Create a new data source.
4. Choose REST/URL.
5. Enter the following information:
- Query URL: https://example.piwik.pro/api/analytics/v1/query/
Note: Replace example with your account name in the query URL.
- Data Format: CSV
- Encoding: UTF-16
- Method: POST
- Body:
{
"relative_date": "last_60_days",
"website_id": "SITE_OR_APP_ID",
"offset": 0,
"limit": 100,
"format": "csv",
"columns": [
{
"column_id": "timestamp",
"transformation_id": "to_date"
},
{
"column_id": "sessions"
}
],
"order_by": [
[
1,
"desc"
]
],
"filters": null,
"metric_filters": null
}Note: Replace SITE_OR_APP_ID with your ID. Where to find it?
Tip: For more about API queries, see our API documentation.
6. In Query Parameters, enter the following parameters:
- First parameter:
- Name: Authorization
- Value: Bearer [auth_token]
- Type: Header
- Second parameter:
- Name: Content-Type
- Value: application/vnd.api+json
- Type: Header
7. In Authentication (OAuth, 2-Step, X-WSSE, or Basic), enter the following information:
- Type: 2-Step Authentication
- Username: Keep it empty
- Password: Keep it empty
- Response: Text
- Method: POST
- Body:
{
"grant_type": "client_credentials",
"client_id": "YOUR_CLIENT_ID",
"client_secret": "YOUR_CLIENT_SECRET"
}Note: Get your API credentials and replace your client ID and client secret in the code.
- Parameters:
- Name: Content-Type
- Value: application/vnd.api+json
- Type: Header
- Auth URL: https://example.piwik.pro/auth/token
Note: Replace example with your account name in the query URL.
- Token Path: “access_token”:”(.*?)”
Note: Include quotes in the token path.
8. Click Get data.
9. Select Model your data on the confirmation screen and click Continue.
Note: If you receive an error message, check to see if the Data Format is set as CSV.
10. Make sure Klipfolio recognizes the date column as a date and the session column as a number.
11. (Optional) Rename your connection.
12. Click Save and Exit.
13. All done! You can now use data from Piwik PRO in Klipfolio.
