Tableau integration

Available from 15.5.0

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

When you want to use data collected by Piwik PRO in Tableau, you need to integrate one product with another. The integration uses the web data connector for Tableau and takes a few clicks to complete. After it’s done, you can comfortably visualize your data in Tableau.

Tableau with data from Piwik PRO

To integrate with Tableau, follow these steps:

  1. Open Tableau Desktop.
  2. Go to Connect > Web Data Connector.
  3. Enter this URL: http://<your_account_name>.piwik.pro/analytics/tableau-connector changing <your_account_name> to your account name.
    Tableau integration with Piwik PRO
  4. Click Enter.
  5. You’ll see our setup screen.
    Tableau integration with Piwik PRO
  6. Log in to Piwik PRO.
  7. Go to Menu > User panel.
  8. Navigate to API Credentials.
  9. Click Generate new credentials.
  10. Name the credentials and click OK.
  11. Copy the created client ID and client secret. They won’t be available for you after closing the window.

    Note: If you plan to update your data in the future, save your client ID and client secret securely. You won’t need to create new credentials then.

  12. Paste the client ID and client secret in the web data connector.
    Tableau integration with Piwik PRO
  13. Click Authorize.
  14. Choose the site, app or meta site from which you want to import data.
    Tableau integration with Piwik PRO
  15. Choose a scope: events or sessions.
    • Events: This scope stores dimensions related to events. If you use the incremental refresh in Tableau, the received data will be 1 – 2 days late.
    • Sessions: This scope stores dimensions related to sessions. If you use the incremental refresh in Tableau, the received data will be 1 – 2 days late.
    Tableau integration with Piwik PRO
  16. Click Next.
  17. Choose dates and dimensions that you want to import.
    Tableau integration with Piwik PRO

    Note: Timestamp, session ID, event ID and visitor ID are always imported. They don’t appear on this list.

  18. Click Next.
  19. Optionally, add filters.
    Tableau integration with Piwik PRO
  20. When you’re done, click Finish.
  21. The connector will now download the data schema.
  22. Open a worksheet in Tableau and wait while the connector imports all your data.

    Note: Importing data may take from several minutes to several hours. This time depends on the size of the data set.

  23. When the import is finished, you can start your analysis.

    Note: After connecting your data, you can update it at any time by using the incremental refresh in Tableau. You’ll need to authorize the update using API credentials. Also, keep in mind that for events and sessions the received data will be 1 – 2 days late.

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