Reconstructing historical data using BigQuery
Imagine having a database with your platform or product subscription’s data. The table has the subscriptions creation date, and if they’ve been cancelled, you have that date too – but how can you know how many active subscriptions you had on any given day in the past? You can’t. At least, not without reconstructing the […]
Simplify your UTMs with dynamic IDs
UTMs are essential for tracking the performance of your paid ad campaigns and ensuring accurate data flows into your analytics platform. Dynamic IDs allow you to automate the generation of UTM parameters, reducing manual errors and creating a seamless tracking experience across multiple advertising platforms. This guide provides recommended UTM structures for popular ad platforms, […]
The GA4 UTM Strategy
Tired of conflicting reports between your paid ad platforms and Google Analytics 4? This kind of data discrepancy can make it nearly impossible to trust your numbers or optimize your campaigns effectively. Google Analytics 4 (GA4) eliminates this confusion by allowing you to import clicks, impressions, and cost data directly into its platform. This not […]
How to choose and implement KPIs
While tons of articles explain what KPIs are, and how to choose them, few actually dive into the practical side of how to implement them and what it looks like in real life. This guide aims to bridge that gap, offering not just a step-by-step approach to selecting KPIs, but also a clear roadmap for […]
The Modern UTM Strategy
The traditional UTM approach just isn’t cutting it anymore – it’s time-consuming and often leads to inaccurate data which leads to bad decisions and a suboptimal marketing ROI. This article aims to solve these problems by introducing The modern UTM strategy that saves time and streamlines tracking and data analysis. I’ll show you how to […]
