Looker Studio (Google Data Studio) integration

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

When you want to use data collected by Piwik PRO and mix it with other data in Looker Studio (Google Data Studio), you need to integrate one product with another. The integration uses a community connector for Looker Studio and is easy to set up. After the integration is complete, you can comfortably build reports and dashboards in Looker Studio.

Google Data Studio

Integrate Piwik PRO with Looker Studio (Google Data Studio)

To integrate with Looker Studio, follow these steps:

  1. Open our data connector (called Piwik PRO Analytics) for Looker Studio.

    Note:

    • The current connector version is 1.0.7
    • Our connector hasn’t been verified yet by Google, but you can use it safely.
  2. Name your data source.
  3. Click Authorize.
    piwik pro connector
  4. Click Allow on the confirmation screen.
  5. In Account name, enter your account name.
    Google Data Studio (account name)

    Tip: Your account name is the first part of your account address: example in example.piwik.pro. For custom domains, check your account name under Piwik PRO > Menu > Administration > Settings > Subscription.

  6. Enter your client ID and click OK. Where to find it?
  7. Enter your client secret and click OK. Where to find it?
    Google Data Studio (client id and client secret)
  8. Click Next.
  9. Choose the site, app or meta site/app that you want to connect to Looker Studio.
    Google Data Studio (select your site or app)

    Note: View permissions or higher are needed to choose a site, app or meta site/app. If you don’t see it on the list, ask your teammate with the owner role in Piwik PRO to give you the right permissions.

  10. Click Connect.
  11. Now your site or app from Piwik PRO is connected to Looker Studio. You can see a list of metrics and dimensions from Piwik PRO that you can use to create reports and dashboards.

    Note: If you see data differences between Piwik PRO and Looker Studio, it may be because you used some transformations in Looker Studio. These transformations may aggregate data differently than Piwik PRO, hence the differences.

    Tip: You can create your own calculated fields and calculated parameters in Looker Studio. You can also turn on or off community visualizations.

Change the connected site, app or meta site/app in Looker Studio (Google Data Studio)

To change the connected site, app or meta site/app in Looker Studio, follow these steps:

  1. Go to Looker Studio > Data sources.
  2. Choose your data source from Piwik PRO.
  3. Click Edit connection.
    Google Data Studio integration (edit connection)
  4. Choose the site, app or meta site/app that you want to connect to Looker Studio.
    Google Data Studio (select your site or app)

    Note: View permissions or higher are needed to choose a site, app or meta site/app. If you don’t see it on the list, ask your teammate with the owner role in Piwik PRO to give you the right permissions.

  5. Click Reconnect.
  6. Click Apply to confirm connection changes.

Create a report in Looker Studio (Google Data Studio)

To create a report with data from Piwik PRO in Looker Studio, follow the steps:

  1. Go to Looker Studio > Data sources.
  2. Choose your data source from Piwik PRO.
  3. Click Create report.
  4. Confirm adding data to your report.
  5. You’ll see some sample data on the dashboard.
    Report in Google Data Studio

    Note: ​​By default, Looker Studio shows data for the last 28 days.

    Note: Segments are not exported.

  6. Click Add a chart and select Date range control. This will help you select date ranges for your data.
    Report in Google Data Studio
  7. Pick any widget from Looker Studio and use metrics and dimensions on the right to create other elements in your report.

    Tip: You can also use Looker Studio Explorer to explore your data using a single chart (Looker Data Studio > Data sources > Choose your data source from Piwik PRO > Explore).

Use filters with Piwik PRO Analytics data

When working with Piwik PRO data in Looker Studio, you can use filters the same way as in Piwik PRO dashboards or custom reports.

To add a new filter to your Looker Studio chart, follow these steps:

  1. Select a chart in your report.
  2. You’ll see the Setup tab on the right.
    Use Piwik PRO filters in Google Data Studio
  3. Scroll down and click Add a filter.
    Use Piwik PRO filters in Google Data Studio
  4. Click Create a filter.
    Use Piwik PRO filters in Google Data Studio
  5. Select the dimension that you want to filter with.
    Use Piwik PRO filters in Google Data Studio
  6. Click Save.
  7. The filter will be saved and applied to your chart.
    Use Piwik PRO filters in Google Data Studio
  8. Later, you can add the same filter to other charts in the report.

Note: Not all filter types are supported with Piwik PRO data. You can’t filter by the in list operator or partial regular expression matches. We’re working on adding support for filtering by the city dimension.

Update Looker Studio integration

We release updates to our Looker Studio integration once in a while. If the new version is available, you can switch to it in a few steps.

To update your Looker Studio integration, follow these steps:

  1. Check if the new version is available in our changelog. The current version is 1.0.7.

    Note: The version number is in the connector description. If the version number is not listed, it is below 1.0.7 and can be updated.

  2. Go to Looker Studio > Data sources.
  3. Click on the three-dot icon next to Piwik PRO Analytics (your current integration).
  4. Click Remove.
    looker studio (remove)
  5. Go through all the steps from this section: Integrate Piwik PRO with Looker Studio. You’ll install and set up the new version.
  6. Optionally, if you want to switch your current reports to the new data source, go to Reports.
  7. Pick a report you want to work with.
  8. Click Edit.
  9. Navigate to Resource > Manage added data sources.
  10. Click + Add a data source.
  11. In My data sources, choose Piwik PRO Analytics.
    looker studio (pick source)
  12. Click Add.
  13. Choose the widget in your report.
    looker studio (widget)
  14. In Data source, choose Piwik PRO Analytics.
    looker studio (data source widget)
  15. Done! Your report has now data sent over a new version of our integration.
    looker studio integration (data new integration)
  16. As the last step, you can remove Unknown from the data source list (it refers to the removed integration). Go to Resource > Manage added data sources and click Remove.
    looker studio integration (remove unknown)

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