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

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.

Create the request to transfer Matomo data to PowerBI

• Within Catchr, select the API option on the left menu.

• Switch the export format to "PowerBI" at the outset.

• In the "Source" tab, pinpoint Matomo as the platform of choice for data exportation.

• Identify the specific account(s) from which you aim to extract data and KPIs. Multiple accounts can be aggregated if necessary.

• Opt for the desired metrics and dimensions crucial to your request. Feel free to select multiple options.

• 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.

• Enhance your request specificity by integrating filters, which can be added in multiples.

• Additional platform-specific options can be threaded into your request.

• Once configured, the request URL materializes on the top bar. Use the "Preview" function for a glimpse of the actual data.

• Post-preview, and once content with the output, the URL is ready to be transferred into PowerBI. Do copy this URL.

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.

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.

‍