How do I integrate Matomo data with a Customer Data Platform (CDP) or Business Intelligence Tool (BI)?

Matomo collects detailed user and interaction data, which is structured in real-time into individual visitor profiles and aggregated reports. This data can be accessed and integrated with other platforms using Matomo’s flexible APIs or direct database connections.

Customer Data Platform (CDP)

Matomo can function as a Customer Data Platform (CDP) by aggregating user data across touchpoints and exposing it through APIs.

If you are using a dedicated CDP, you can seamlessly integrate Matomo raw users and interaction data (clickstream) in your CDP by using either the raw data APIs, or the SQL connector. Learn more about how to make Matomo Analytics raw data available to a data warehouse.

Business Intelligence Tool (BI)

Matomo integrates well with BI tools such as like Tableau, Power BI, Looker, Zoho Analytics, QlikSense, and Oracle Analytics Cloud.

  • For Matomo On-Premise, the most flexible option is direct SQL access to your Matomo database (MySQL/MariaDB). This allows you to write custom queries against raw tracking data and feed it directly into tools like Power BI or Tableau.
  • For Matomo Cloud, direct SQL access is not available. Instead, you can enable the Data Warehouse Connector to make raw tracking data available externally for querying with SQL.
  • In both cases, you can use the Matomo Reporting API to extract raw data.
Previous FAQ: How to import Matomo data into Microsoft Power BI Desktop