Google Universal Analytics (UA) is scheduled for full shutdown on July 1st, 2024. Google recommends exporting your data directly from the UA interface or, for UA 360 customers, via BigQuery export. However, the UA interface limits downloads to 5,000 records at a time, making comprehensive backups tedious for websites with larger traffic volumes. This article explore 3 free tools that can be used to automate the backup of your UA Reports.
Google Analytics
| 4
min read
Google Analytics is sending out reminders about the complete shutdown of Universal Analytics (UA) services and APIs on July 1st, 2024. Many organizations have migrated to GA4 or GA4 alternatives like Matomo, Plausible Analytics, or SEAL Metrics. But what about your historical UA data? Google's only suggestion is to manually export reports – a daunting task for websites with 10-15 years of data. There's no Takeout option.
Web Analytics
| 15
min read
Matomo, formerly known as Piwik, is a powerful and Free and Open Source web analytics platform that offers website owners a comprehensive insight into their online traffic, user behavior, and digital marketing effectiveness. This guide will give you the step by step instructions to setup and configure Matomo in Ubuntu 22.04
Security
| 5
min read
Passwords are a critical aspect of cybersecurity and play a significant role in protecting sensitive information from unauthorized access. However, managing passwords is a significant challenge for many organizations. Passwords are often shared among multiple users and frequently forgotten or lost. This article will discuss some potential issues organizations face when managing passwords and how Passbolt, a free and open-source password manager, can help address these challenges.
Productivity Tools
| 5
min read
Redmine is a flexible, free and open source project management tool with powerful features like multiple project management, customizable workflows, and the Agile plugin. It's also more cost-effective than other project management tools like Jira. This article talks about how we use Redmine since 2010 for our projects.
Productivity Tools
| 3
min read
Mattermost is a secure free software real-time chat service for team communication and effective collaboration. We at Zyxware have used Mattermost for many projects. Here are some statistics and facts on our experience using Mattermost for the past few years.
Technical Q&A
| 3
min read
From MySQL 5.7 onwards, the error SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column will appear if any non aggregated columns are in the select list, which is not in the group by clause. This article discusses one such use case with Mautic and how we solved it.
Symfony
| 3
min read
Some of you might have seen this error message while trying to upgrade Mautic in your system:
"[Symfony\Component\Debug\Exception\ClassNotFoundException]
Attempted to load class "ZipArchive" from the global namespace.
Did you forget a "use" statement?" while upgrading Mautic version.