This is the second post in a series about how marketers are leveraging Trifacta, authored by Trifacta’s VP of Marketing, Will Davis, following our first post on onboarding marketing data. In this post, we discuss how Trifacta is being used to prepare data for marketing analytics.
When I’m presented with marketing findings, one of the first things I ask is “How accurate is the data?” I can’t act upon data that’s based on guesswork. And I certainly can’t act upon data that hasn’t been properly cleansed to address missing or insufficient information. Increasingly, however, I’m also looking for data that draws upon multiple sources to arrive at a more nuanced conclusion—it isn’t helpful to determine marketing campaign performance on the basis of one activity, for example, but across an omni-channel view. But for a marketing team with limited data expertise, delivering these advanced insights can be a tall order.
The Advancement of Marketing Analytics
Today, marketing data spans many different applications and platforms and comes in a variety of formats. There’s social media data stemming from Facebook, Twitter, and LinkedIn, clickstream and Adroll data found via Google Analytics, lead-related data from marketing automation platforms…the list goes on. And there’s different ways to slice and dice this data, whether in terms of clicks, shares or views, or by filtering out certain lead categories and touch points to understand multi-touch attribution . As marketers, it’s our job to not only determine which data is needed for the initiative at hand, but also how to best source, cleanse, and consolidate that specific set of data into a format for consumption.
What makes that so challenging is that the spreadsheet tools marketers typically depend on weren’t built to tackle complex data. They don’t allow for marketers to import JSON formats, which is inevitable when working with Twitter data, for example, let alone join that data with a CSV file downloaded from email automation platforms. Oftentimes, marketers must outsource data preparation work to a more technical team, leading to delays in analysis, or worse yet, abandoning the initiative altogether. And this can have an impact far beyond the marketing team. Since marketing data is often the first checkpoint for the health of the company—forecasting everything from current customer engagement to future sales—a lack in insights can cause a ripple effect downstream.
I’ve been excited to see many Trifacta customers leveraging our data preparation platform to tackle complex marketing data and join it with several different sources. With Trifacta, they’re uncovering powerful marketing insights that help steer course for the organization.
A Global Packaged Goods Company Drives Marketing with Trifacta
One such customer is one of the world’s leading food packaging companies, with over 100 consumer brands that span 100 countries. Their marketing organization largely rests upon data to make informed decisions about everything from accurately pricing products to the effectiveness of campaigns to creating the right branded recipes that correspond to certain product. In one such initiative, they wanted to better understand the performance of these recipes, specifically understanding what types of recipes were being shared or reposted among which demographics and during what time of the year.
What was challenging about this initiative was not only the complex type of data they needed to leverage, but also that the team needed to analyze raw text in order to classify recipes and read through their comments. Previously, they were leveraging SQL, but even that was a challenging means to tackle such complex data. With Trifacta, the total data transformation time has been roughly been cut in half, based on the ability to quickly and intuitively transform data (and not have to Google answers to solve error messages or relearn syntax). Now, they’re able to glean much more information from their recipe performance, and focus on recreating recipes that receive ample engagement.
Trifacta for Marketing Analytics
In order to perform marketing analytics, there are a lot of necessary pieces—a good team, for one, the right data, and a visual means to display findings to stakeholders. But somewhere in between all of that, Trifacta plays a key role of allowing teams to visually understand and format increasingly complex data. With Trifacta, marketers can work off of an interface that is more advanced than Excel, but that doesn’t ask them to be, in order to level up the initiatives they take on. It’s a new source of power for marketers to become even more data-driven.
To get a sense for the other features that make Trifacta a great fit for preparing data for marketing analytics, watch our demo focused on marketing analytics. After watching, we welcome you to try out the technology yourself—Sign up for our free cloud version of Trifacta Wrangler.
Finally, to learn more about how another company, Malwarebytes, is transforming their marketing data onboarding operations with Trifacta, watch the video below: