Better Matomo Data Visualization in Metabase

February 8, 2023

better matomo analytics with metabase

What is Matomo

Matomo is an open-source analytics platform that allows businesses to track and analyze website traffic and user behavior. It can provide a wide range of strategic data that can be used to inform business decisions, including:

  1. Website traffic data: insights into website traffic, including the number of visitors, page views, and time spent on the site. This data can be used to understand how well a website is performing and identify areas for improvement.
  2. User behavior data: insights into user behavior, including the pages that users visit, the actions they take, and the devices they use. This data can be used to understand user needs and preferences and tailor the website experience accordingly.
  3. Marketing data: Matomo can provide data on marketing campaigns, including the number of clicks, conversions, and revenue generated. This data can be used to assess the effectiveness of marketing efforts and optimize campaigns.
  4. E-commerce data: Matomo can provide data on e-commerce transactions, including the number of orders, average order value, and conversion rate. This data can be used to understand the performance of e-commerce initiatives and identify areas for improvement.

Get comprehensive insights

  1. Product development: By analyzing data on user behavior, businesses can identify features that are most popular and areas for improvement. This can help businesses to prioritize product development efforts and create a better user experience.
  2. Marketing strategy: By analyzing data on user acquisition and retention, businesses can identify the most effective marketing channels and campaigns. This can help businesses to optimize their marketing budget and allocate resources more effectively.
  3. Pricing strategy: By analyzing data on conversion rates and customer lifetime value, businesses can identify the optimal pricing strategy for their products or services.
  4. Customer service: By analyzing data on customer support interactions, businesses can identify common issues and improve their customer service processes.

A data visualization tool plugged on Matomo can provide valuable insights that can inform a range of data-driven decisions and help your business to optimize your performance.

How to connect Matomo to Metabase

  1. We create a script to fetch Matomo’s data using the Live.getLastVisitsDetails API
  2. Create a PostgreSQL database and feed it in real time with this script
  3. Add this database as a new data source in Metabase and start building your dashboard