Connect Piwik to Power BI

Connect Piwik PRO in Catchr with the account domain, Client ID and Client Secret and select the site or app. In Catchr’s Power BI query builder, select sessions, visitors and page performance and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping site, period and the scope of unique visitor counts clear in the model.

No. This Catchr source connects to Piwik PRO using its account domain and client credentials. Matomo is a separate product, although the names share a history. If your data is in Matomo, use the Matomo connector and its connection settings instead.

Catchr exposes sessions, visitors, bounces, custom events, goal revenue, ecommerce orders and revenue, cart activity, and campaign dimensions. Consent-related fields are also available where collected. Choose metrics that match your tracking setup and the level of detail of your chart; fields being listed does not mean every site has populated them.

Piwik PRO distinguishes data scopes such as sessions and events. Some field combinations conflict because they describe different levels of activity. Start with a valid combination for the report you need, then add dimensions gradually. Separate incompatible analyses into different charts instead of forcing them into one table or treating an error as missing traffic.

Use a date dimension grouped by year and month, and check that the chart’s date range covers the months you want to compare. Avoid grouping by month name alone across several years. For visitors, request the count at the intended period rather than adding daily distinct counts, which can count returning people several times.

The site-level bounce rate uses bounces divided by sessions, while the page-level bounce-rate field uses bounces divided by entries for that page. A page can be visited within an ongoing session without being the entry page. Select the rate appropriate to your chart and avoid averaging page percentages to obtain a site-wide rate.

Yes. Add Google Ads to compare costs with tracked goals or ecommerce outcomes. Keep campaign tagging consistent and align date ranges, currencies, and the chosen revenue field before creating relationships. Differences in attribution and tracking mean that Piwik PRO outcomes need not equal advertising-platform conversion totals.