Klipfolio integration

When you want to use data collected by Piwik PRO in Klipfolio, you can use our API and connect to Klipfolio. The setup is easy, and you don’t need much technical knowledge. After the connection is set, you can access data from Piwik PRO and use it on dashboards and reports in Klipfolio.

To integrate with Klipfolio, follow these steps:

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. Check Model your data on the confirmation screen and click Continue.
   

   

   Note: If you receive an error message, check if the Data Format is set as CSV.

10. Check if Klipfolio recognizes the date column as a date and the session column as a number.
11. Optionally, rename your connection.
    

    

12. Click Save and Exit.
13. All done! Now you can use data from Piwik PRO in Klipfolio.