Let's be honest: every marketing team dreams of being data-driven (and judging by the "shared beliefs" in this group, I bet a lot of you are leading the charge!). At SaaSJet, we were no different.
We had strategic plans, metrics, and a mountain of spreadsheets. But here's the thing: with information scattered across a million tools and limited data visibility, measuring success and optimizing campaigns felt like navigating a thick fog.
This article shares our journey of transforming marketing data into a decision-making engine. Our approach isn't fancy or groundbreaking, but it's downright compelling and, more importantly, implementable by any team: over the last year, we've seen substantial growth in key performance indicators, such as a 151.92% increase in trials for mature products. Additionally, the proportion of users we can accurately attribute to specific channels has surged by 54%. Basically, our marketing efforts are now 54% more measurable and, you guessed it, data-driven.
What did we do? Let's break it down into steps that you can implement in:
We started with a fundamental step – ensuring UTM parameters were applied to all external content promoting our products. This simple step provided crucial insights into campaign performance and user acquisition channels. So, we revisited past content like articles, videos, posts, and infographics to add missing UTM tags. Now, we can allocate resources more effectively by concentrating on methods that provide the best return on investment thanks to this data-driven strategy.
Next, we unified all trials, subscriptions, and other product metrics into a single source of truth: the Google BigQuery cloud database. This consolidation made it a breeze to access and analyze data, making it super easy for us to work with data without needing the dev team on speed dial. Plus, by having one unified database, we ensured everyone across the company had access to accurate and up-to-date information.
Our amazing developers are rockstars, but let's be real – sometimes their data analysis tools felt like trying to decipher ancient Egyptian hieroglyphics. That's why we collaborated with them to integrate product usage events into the familiar world of Google Analytics 4. This way, us mere mortals in marketing can analyze user behavior and make data-driven decisions for our campaigns without needing a PhD in data decryption or a Rosetta Stone.
Using Looker Studio, a business intelligence system, we brought all the data streams together. This allowed us to create comprehensive marketing dashboards combining data from every corner of the marketing universe – traffic and events from Google Analytics 4 with campaign breakdowns by channel, product metrics from BigQuery, organic traffic from Search Console, YouTube channel analytics – you name it, it was there.
These dashboards displayed real-time and historical trends (weekly or monthly) alongside the KPIs we were striving for. This eagle-eye view allowed us to monitor progress towards our goals and identify areas where we could be even better.
But here's the coolest part: we even integrated Jira tasks and product releases into the dashboards. This provided a holistic view of how our marketing activities were impacting product usage and sales.
For example, we could instantly see if a new feature launch led to a surge in user trials or if it accidentally triggered churn. This data-driven approach empowered us to make informed decisions and optimize our campaigns on the fly.
The fanciest dashboards are nothing without a team that knows how to use them. That's why we actively promoted analytical thinking and data-driven decision-making across the team. We held workshops, created clear documentation explaining the dashboards, metrics, and their interpretation, and even whipped up some fun training videos (because who doesn't love a good explainer?).
The result? A team of data-savvy marketers who can not only look at data but also use it to make informed decisions and achieve marketing goals.
Transforming marketing data into a decision-making engine requires a strategic yet practical approach. By implementing UTM parameters, centralizing data in Google BigQuery, integrating product usage events into Google Analytics 4, building informative dashboards with Looker Studio, and fostering a data-driven culture, our team transformed into a data-driven dream team.
We hope our story inspires your teams to embark on their own data-driven journeys. Remember, it's not about fancy tricks or crazy inventions but about taking small steps that can make a big difference in your teamwork game.
Share what questions you have or what challenges you're facing in the comments below – we'd love to hear from you!
What questions do you have, or what challenges are you facing?
Share in the comments below – we'd love to hear from you!
Halyna Kudlak _SaaSJet_
Marketing Team Lead
SaaSJet
Ukraine
2 accepted answers
4 comments