Matomo BigQuery Import

  • Own reports, e.g. in Google Datastudio

  • One-time costs for the setup

  • Easy data export to other systems

Matomo data import to BigQuery

The Matomo BigQuery Importer offers the possibility to integrate Matomo raw data into Google BigQuery in a simple form on a daily basis. From there, the data can be converted into a desired format and then displayed, for example, in Google Datastudio.

Matomo BigQuery ETL
Inhalt ausblenden

How does the Matomo BigQuery integration work?

The Matomo BigQuery Importer uses the Matomo API, which is output in the Live.getLastVisitsDetails module. This data is stored in JSON format in original schema in BigQuery. The solution is based on a Google Apps script, which can be linked to the BigQuery project.

Data usage in BigQuery

The possibilities for further use of the data in BigQuery are many. Here are some use cases that we implement on a daily basis.

  • Matomo data in Google Datastudio
  • Google Ads Conversion Import
  • Microsoft Ads Conversion Import

Datastudio Dashboard “Matomo Ecommerce

A Data Studio dashboard with the most important standard reports for websites, based on Google Universal Analytics reports.

For details on the data source, it is documented here.

Most important Ecommerce KPI in one view.

The most important Ecommerce key figures at a glance

Reports about User Sources, User Numbers, Time related Sales-Data

Reports on access sources, user numbers, period-related history data

Path analysis of accesses by path names, path lengths and duration to purchase.

Path analysis of accesses by path name, path length and duration until purchase.

Analysis of visitors by status, devicetype, network, screen resolution ....

Analysis of visitors by status, device type, network, screen size, etc.

Sales overview from Matomo by: Items and Categories

Report of sales from Matomo by: Item and Category.

Of course, it is easy to extract data from the BigQuery Importer data at hand, so that Google Ads conversions can be conveniently passed from Matomo to Google Ads. The transmitted data is “smart bidding” capable, so conversion based optimization methods continue to work. For this feature, there is also a standalone Google Ads Conversion Import Script for Matomo.

Microsoft Ads Conversion Import

Microsoft Ads also offers conversion import, similar to Google Ads. In this way, conversions that were generated via Bing and recorded in Matomo can also be transferred to Microsoft Ads. The transmitted data is “smart bidding” capable, so conversion based optimization methods continue to work.

Es gibt offene Fragen? Buchen Sie einen Beratungstermin.

You are currently viewing a placeholder content from Calendly. To access the actual content, click the button below. Please note that doing so will share data with third-party providers.

More Information
Unblock content Accept required service and unblock content

Frequently asked questions