Tableau integration

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 or Google Ads..
    • 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.
    • Available from 16.0.0 Google Ads: This scope stores dimensions related to data from Google Ads. If you use the incremental refresh in Tableau, the received data will be 2 – 3 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, and for Google Ads data will be 2 – 3 days late.

Set up automatic data refresh for Tableau Online

When you’re using Tableau Online and want to automatically refresh your data from Piwik PRO, you need to set up Tableau Bridge (legacy). The bridge will connect Tableau Online with Tableau Desktop and let you securely use API keys needed for the refresh.

To set up automatic data refresh for Tableau Online, follow these steps:

  1. Open Tableau Desktop.
  2. Navigate to Data > your connected data set > Publish to Server…
    Piwik PRO automatic data refresh for Tableau Online
  3. Install Tableau Bridge (legacy) on your desktop or Windows Server (recommended).
  4. Log in to Tableau Bridge (legacy) using your Tableau Online account.

    Note: To set up the bridge, you’ll need the following permissions in Tableau: creator, site administrator creator, server administrator.

  5. Set up a Tableau Bridge (legacy) schedule in Tableau Online.

    Note: We recommend that you set up incremental refresh because it’s faster. Also don’t set it up more often than once a day because incremental refresh is pulling data for finished days.

    Note: The refresh will run only when the machine with Tableau Bridge (legacy) is turned on and connected to the same network you’re using to access Piwik PRO API and Tableau Online.

  6. In Tableau Bridge (legacy), type in your API credentials from Piwik PRO:
    • User Name: client ID 
    • Password: client secret
    Piwik PRO automatic data refresh for Tableau Online
  7. Here’s how your setup for Tableau Bridge (legacy) should look like:
    Piwik PRO automatic data refresh for Tableau Online
  8. Now your web data from Piwik PRO will be automatically updated in Tableau Online.

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