Matomo to BigQuery or other access to raw data

General questions
1

Hi all,

I am currently exploring ways to enhance our analytics capabilities, and I am particularly interested in gaining access to the raw data collected by Matomo for further analysis. My goal is to connect Matomo to Google BigQuery to leverage its powerful capabilities for handling large datasets.

I would appreciate any insights or guidance from the community on the following:

  1. Connecting Matomo to Google BigQuery:
  • Has anyone successfully connected Matomo to Google BigQuery to access raw data?
  • Are there specific plugins or tools, like Tableau integrations, that streamline this process?
  1. Alternative Methods for Accessing Raw Data:
  • Aside from Google BigQuery, are there other recommended methods for accessing raw data from Matomo?
  • Are there plugins or third-party tools that simplify the extraction of raw data for external analysis?

Thank you in advance for your time and assistance!
Best regards,
Viktor

2

You can either query the data directly if you’re self hosted, or Matomo now offer a BigQuery export (I am guessing for Cloud customers). Matomo has some guides on the SQL to use. See How do I integrate Matomo data with a Customer Data Platform (CDP) or Business Intelligence Tool (BI)?

If you’re self hosted (and ideally on GCP) you can also export from MySql to BigQuery yourself by replicating using Cloud Data Fusion

I can’t add links I’m afraid bit a quick google search will get you on your way.

1 Like