Rockerbox Product Manager Eddie Chou on Data Warehousing

Behind all the product improvements and advancements of Rockerbox, there’s a team of smart, driven professionals with a passion for solving the problems of digital-first businesses. 

In this blog post, we talk with Rockerbox Product Manager Eddie Chou about the recent release of our Data Warehousing feature, which allows organizations to easily sync Rockerbox data to AWS Redshift, Google BigQuery, or Snowflake where they can use that data to uncover business-critical insights and enable data-driven decision making. 

Tell us about yourself, Eddie, and your role at Rockerbox.

I’m a Product Manager at Rockerbox, and have been here for just over 3 years. Earlier at Rockerbox, I led technical integrations with partners (ad platforms, agencies, data providers, etc.) and managed onboarding our first 50 customers. 

Before Rockerbox, I worked in SaaS and start-ups for 15 years. I’ve always loved finding interesting ways for technology to solve problems and how quickly the industry evolves. 

2. What problems were these Data Warehousing integrations aiming to solve? 

During a marketer’s maturity evolution, they eventually all encounter a common set of pain points:

• They struggle to evaluate marketing performance holistically, as each channel comes with its own unique tracking and reporting challenges.
• All their marketing data sits in different locations, and consolidating that is very manual and/or expensive.
• Their engineering resources are limited towards—at best—maintaining the status quo as opposed to building net-new capabilities that benefit the marketing team.

Rockerbox Data Warehousing alleviates these pain points by consolidating disparate marketing data and connecting to where our customers are working today (in their own warehouses and BI tools like Looker, Tableau), all with self-service capabilities that don’t require engineering resources. 

3. How else do people currently solve this problem and what are the downsides to those approaches? 

Customers looking for our Data Warehousing integrations come to us in order to solve a complex process, which includes:

• Pulling data from each and every ad platform they work with
• Reconciling the performance of each platform given each platforms’ innate limitations
• Deduping marketing performance data across these platforms
• Building an ETL process to pipe this data into their data warehouse
• Running queries and/or plugging in BI tools to generate insights

Many of these steps are manual, and those that can be automated require engineers to build and maintain. As a marketer’s channel mix becomes more complex, so too does their process required to understand how well their marketing is performing. 

Oftentimes we hear from marketers that they have completely different approaches for some hard-to-track channels, like Direct Mail or Linear TV, and they have no way to evaluate performance compared to online channels. This is not ideal as there’s overlap between these channels. 

4. What ultimately happens if these problems aren’t addressed?

Ultimately marketers will suffer the consequences of suboptimal marketing decisions: poor performance, wasted budget, running expensive tests, and—perhaps worst of all—frustrated employees that are tired of repetitive, low-value work. 

5. How does Data Warehousing help solve these challenges?

In short, we take care of the repetitive work. If you have already built out a warehouse where your team is evaluating your marketing data, then we want to meet you where you’re already working by getting you access to all the powerful data we’ve consolidated.

1. Through our 200+ integrations, we’re already connected to the ad platforms you work with, and we will track performance and spend. 
2. We have plug’n’play integrations to report on each step in your users’ journeys—from upper funnel conversion events like add to cart down to purchase or subscription
3. Rockerbox then consolidates this all into one view in our platform. With a centralized view of your marketing and conversion data, you now know for each conversion which channel brought the user from the very first visit to the last touch prior to purchase. 
4. With Warehousing, we’re taking all this data we’ve curated and sequenced, and put the power of this data into your hands

6. What’s the most exciting element of Data Warehousing?

It can be daunting to learn about a new feature like “Data Warehousing Integrations” that reads as quite technical. For marketers, our goal is to take that anxiety away. Let us focus on the technical integrations—we love doing it (and it’s aligned with my own intro!). Instead, spend your energy on what you do best: building your business through smart marketing decisions. 

7. Who could Data Warehousing benefit the most? 

Rockerbox is built to support marketers throughout their maturity, from those just getting started running their first ad campaigns to juggling millions of dollars in marketing spend per year. For Data Warehousing specifically, so long as you’re using one of our supported warehouse platforms—Snowflake, Redshift, and BigQuery—then you’re a great fit—Doubly so if your team is tired of building and maintaining costly ETL processes. 

Get the insights you need in the platforms you already use.

Reach out to our team to learn more about how Data Warehousing could enable smoother processes and more helpful marketing insights at your organization.