blog post

Explore your Matomo analytics KPI with PowerBI : How-to, templates and metrics

Florian Cabirol
November 28, 2023
Explore your Matomo analytics KPI with PowerBI : How-to, templates and metrics

Quick steps to create a Matomo report with Google Sheets:

You can easiliy create a Matomo report following this step :

  1. Get informations from the data integration from our Matomo connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Matomo data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Matomo report with Looker Studio:

You can easiliy create a Matomo report following this step :

  1. Get informations from the data integration from our Matomo connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Matomo at the end of the page.

The tutorial

Quick steps to create a Matomo report with PowerBI:

You can easiliy create a Matomo report following this step :

  1. Get informations from the data integration from our Matomo connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Matomo at the end of the page.

The tutorial

Welcome to our comprehensive tutorial where we guide you through integrating your Matomo marketing data with PowerBI. By the end of this tutorial, you will possess the knowledge to seamlessly connect your Matomo account to PowerBI and transform your raw data into visually impactful analytics.

How to connect your Matomo account to PowerBI

Add a source on Catchr

Navigate to the Catchr homepage and find Source on the left-hand menu. Click the Add a Source button situated in the upper right corner. From here, choose the desired platform, in this case, Matomo, and complete the identification process to link your Catchr and Matomo accounts.

Catchr Add a Source

Create the request to transfer Matomo data to PowerBI

  • Within Catchr, select the API option on the left menu.
Catchr API Selection
  • Switch the export format to "PowerBI" at the outset.
Export Format Selection
  • In the "Source" tab, pinpoint Matomo as the platform of choice for data exportation.
Source Platform Selection
  • Identify the specific account(s) from which you aim to extract data and KPIs. Multiple accounts can be aggregated if necessary.
Account Selection
  • Opt for the desired metrics and dimensions crucial to your request. Feel free to select multiple options.
Metric and Dimension Selection
Additional Metric and Dimension Selection
  • Warning: Adherence to our templates' requisite dimensions and metrics is crucial for automatic data loading on Catchr. Templates, once populated with your specified metrics and dimensions, can be customized further.
  • Select a reporting period for your Matomo data, choosing either a custom or predefined time frame.
Time Period Selection
  • Enhance your request specificity by integrating filters, which can be added in multiples.
Filter Addition
  • Additional platform-specific options can be threaded into your request.
Request Options
  • Once configured, the request URL materializes on the top bar. Use the "Preview" function for a glimpse of the actual data.
Request URL and Preview
  • Post-preview, and once content with the output, the URL is ready to be transferred into PowerBI. Do copy this URL.
Data Preview
URL Copying

Import the Matomo data and KPI to PowerBI

In PowerBI Desktop, reach out for Get Data and then select Web. Stay in basic mode and insert the request URL procured in the prior steps. Upon clicking OK, PowerBI initiates the data import which might take a few moments. Once your data is in PowerBI, employ PowerBI Query for query refinements and field type modifications. Now you can craft your dashboard from the imported data and share your insights.

PowerBI Get Data
Inserting the URL

In the PowerBI Web App, provide your dataset by publishing it from the desktop app, then construct a new report harnessing the dataset found within the published collection.

In sum, this guide has equipped you with the knowledge to integrate Matomo data into PowerBI. Leverage these insights for deeper analysis and share your findings across teams, ensuring all stakeholders are informed and empowered.

Example of metrics you can utilize with the PowerBI Integration for Matomo

When incorporating your Matomo data within PowerBI, a suite of marketing metrics becomes available, offering a broad spectrum for in-depth analysis and strategic decision-making. For instance, metrics such as ‘Visits Evolution’ and ‘Pageviews Evolution’ enable you to monitor traffic trends over time. With the integration, you can employ PowerBI's data visualization capabilities to craft comprehensive dashboards that reveal the dynamics of user engagement on your platforms.

Furthermore, the ability to examine financial metrics like ‘Revenue’ and ‘Product Revenue Evolution’ within the context of PowerBI’s analytic tools opens up a world of possibilities for forecasting and performance assessment. By correlating these financial indicators with web activities, such as ‘Unique Purchases’, businesses can identify consumer behaviors that lead to conversions and refine their marketing strategies accordingly.

Connecting with the user experience becomes easier too. Engagement metrics like ‘Actions Per Visit’ and technical ones such as ‘Avg. Page Load Time’ bring to light areas of your digital presence that are performing optimally or require improvement. All these insights, combined with the collaborative nature of PowerBI, make the Matomo-PowerBI integration an asset for any data-driven marketing team.

For a complete list of the metrics you can extract from Matomo and utilize in PowerBI, visit the Catchr metrics directory at here.

Bonus : Your free Template Matomo - Visits / Behaviours / Acquisition Template

In this Matomo template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Matomo template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Matomo

Explore your Matomo analytics KPI with PowerBI : How-to, templates and metrics

Learn to integrate Matomo with PowerBI for advanced analytics in our step-by-step guide, and unlock powerful insights from your marketing data for strategic decision-making.

Florian Cabirol

Top KPI you need to follow with Matomo

Matomo KPIs offer a perfect solution to enhance your website in terms of growth and performance. Read our latest blog and learn how you can use them for your benefit!

Florian Cabirol

Connect Matomo to Looker Studio : How-to, templates and metrics

In this guide, you'll learn how to connect Matomo web analytics with Looker Studio to gain deeper insights into your website's performance.

Maxence PERRIN

How to move your website data from Matomo to Google Sheets

Learn how to move your Matomo analytics data seamlessly to Google Sheets using Catchr.io Add-on. Streamline your marketing analysis and reporting today!

Florian Cabirol