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 Google Data Studio, you need to integrate one product with another. The integration uses a community connector for Google Data Studio and is easy to set up. After the integration is complete, you can comfortably build reports and dashboards in Google Data Studio.

Google Data Studio

Integrate Piwik PRO with Google Data Studio

To integrate with Google Data Studio, follow these steps:

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

    Note: Our connector hasn’t been verified yet by Google, but you can use it safely.

  2. Name your data source.
  3. Click Authorize.
    Google Data Studio integration (authorize)
  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 or app that you want to connect to Google Data Studio.
    Google Data Studio (select your site or app)

    Note: View permissions or higher are needed to choose a site or app. If you don’t see a site or app 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 Google Data Studio. You can see a list of metrics and dimensions from Piwik PRO that you can use to create reports and dashboards.

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

Change the connected site or app in Google Data Studio

To change the connected site or app in Google Data Studio, follow these steps:

  1. Go to Google Data 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 or app that you want to connect to Google Data Studio.
    Google Data Studio integration (select a site or app)

    Note: View permissions or higher are needed to choose a site or app. If you don’t see a site or app 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 Google Data Studio

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

  1. Go to Google Data 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, Google Data Studio shows data for the last 28 days.

  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 Google Data Studio and use metrics and dimensions on the right to create other elements in your report.

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

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