Migrating my web analytics from Matomo to Umami
4 months ago
- #web-analytics
- #data-migration
- #open-source
- Author switched from Google Analytics to Piwik (later Matomo) in 2014 for web analytics.
- In 2022, started using Umami due to its modern UI and simpler hosting compared to Matomo.
- Matomo holds 10 years of analytics data for two websites, which the author didn't want to lose.
- No existing tool found to export data from Matomo to Umami, leading to the creation of a custom Python tool.
- The tool, matomo-to-umami, migrates data directly between databases (MySQL/MariaDB to PostgreSQL).
- Migration process included dry-run testing and sanity checks to ensure data accuracy.
- Successfully migrated over 1.3 million sessions and 2 million events from Matomo to Umami.
- Author now plans to decommission the Matomo instance, saving resources.
- The migration tool is open-sourced on GitHub for others to use.