Klipfolio integration

Needed permissions: owner, manage, edit & publish or edit

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.

Klipfolio integration

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.
    Klipfolio integration
  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.

    Klipfolio integration
  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
    Klipfolio integration
  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.

    Klipfolio integration
  8. Click Get data.
  9. Check Model your data on the confirmation screen and click Continue.
    Klipfolio integration

    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.
    Klipfolio integration
  12. Click Save and Exit.
  13. All done! Now you can use data from Piwik PRO in Klipfolio.
    Klipfolio integration

Was this article helpful?

Technical support

If you still have some questions, visit our community.
There’s always someone ready to help!

Back to help center