Search DAS42.com

Get Started

Business Insider publishes original journalism and aggregated content across business, finance, technology, and lifestyle.

The company runs on two revenue models at once: advertising and subscription. Both depend on clean, fast reporting.

The Challenge

A platform Business Insider couldn’t fully leave.


Business Insider was overspending on its data stack, and Google BigQuery was the biggest line item.

But BigQuery wasn’t optional. Google Analytics data only comes through at that level of detail if you stay on BigQuery. Business Insider also wanted to keep other Google tools in place, including Google Cloud Storage and Looker. The company needed to migrate its data warehousing and reporting to Snowflake and govern its new Snowflake spend, without breaking its relationship with Google’s tools.


Ad revenue split across three systems

The advertising revenue team pulled data from Google Analytics, Google Ad Manager, and Permutive separately. Page loads lived in one tool. Impressions lived in another. Nothing sat side by side. Comparing traffic trends against revenue meant manual work across three separate interfaces – further complicated by differing time zones and discrepancies in categorization.

The Solution

Migrating without losing what Google provides.


DAS42 migrated the advertising revenue team’s data and reporting from BigQuery to Snowflake.

That included ingesting new sources, Permutive and Salesforce among them, and moving existing workloads over. Google Analytics and Google Cloud Storage stayed in place. DAS42 cleaned and modeled the data in both Snowflake and Looker so the team could work with it in new ways without driving costs back up.


One model instead of three

DAS42 built metrics that pulled from multiple sources at once: page loads from Google Analytics, impressions from Google Ad Manager. That normalization broke down the tool-by-tool silos that had kept the advertising revenue team from seeing the full picture in one place. End users across verticals could also query aggregated data cheaply and still drill into granular detail when a question called for it.


Governing spend as it happens

DAS42 audited the new Snowflake environment and found where spend was disproportionate: specific ingestions, specific tools, specific data science models. Once the team addressed those, DAS42 worked with Business Insider’s data engineers to set up weekly cost check-ins along with custom reporting and alerts to keep spend visible going forward. DAS42 also helped design data archival policies for historical data no longer in active use.

The Results

A single view of ad revenue.


The advertising revenue team could see Google Analytics, Google Ad Manager, and Permutive data side by side: page loads, impressions, clicks, revenue, page views, and ad slots clicked.

That allowed the team to compare traffic and revenue trends directly instead of reconciling three tools by hand. Reporting on aggregated data now runs automatically where it can, giving the team faster answers without extra manual work.

Budget freed for advanced use cases

DAS42’s audit found where Snowflake investment was disproportionate: specific ingestions, specific tools, specific data science models. Addressing those redirected 23% of that investment, month over month, toward higher-value work instead of losing it to inefficiency. On the BigQuery side, archival policies DAS42 designed for historical data cut Business Insider’s monthly storage costs by 27%.