Hi. I’ve built a product that provides a reporting-ready clickstream for data warehouses built on top of BigQuery or Clickhouse. I’m trying to asses how much would it make sense to add support for Matomo tracking protocol. I’ll only pick it up if there’s at least some interests from the community. I saw the initial traction while reviewing this feature request: https://github.com/matomo-org/matomo/issues/17697
How would the setup look? It’s all about calling:
_paq.push(['addTracker', “https://d8a.tech/…/matomo.php”, ‘123‘]);
So, no need to reimplement all the events.
What are the benefits?
- Optimized database schema without redundant joins, available almost realtime
- Scalable database backend (we all know the limitations of MySQL and MariaDB while handling millions of events per month)
- Support for anonymous tracking with session scope even with disabled cookies
- You still keep Matomo reporting for the known analytics use cases. If you want to dig deeper, you use the data warehouse without the need to pre-aggregate data to get reports.
Let me know your thoughts! 