Retail Media Networks & Cloud Data Warehousing: An Introduction

Daisy McLogan
Daisy McLogan February 23, 2024

I'm a customer Data Architect at Census, and I help our customers implement best practices when it comes to cleaning, transforming, and activating their data.

Retail Media Networks (RMNs) are gaining significant traction in today's ever-evolving digital landscape. At the heart of this transformation is the use of Cloud Data Warehouses, revolutionizing the way businesses store, analyze, and utilize data. This guide aims to provide an in-depth understanding of Retail Media Networks, the role of Cloud Data Warehouses, and how to leverage technologies like Snowflake and Census Embedded to build robust RMNs atop your Data Warehouse or Data Lake.

Understanding Retail Media Networks

Retail Media Networks (RMNs) are digital advertising ecosystems owned and operated by retailers. They allow retailers to monetize their digital platforms by displaying targeted ads to shoppers. RMNs offer a variety of advertising formats, including display ads, sponsored product listings, native ads, and other types of online advertising.

Typically, RMNs exist at the intersection of retail commerce and media, making them an essential player in the digital advertising ecosystem. With the growing consumer shift towards e-commerce channels, RMNs are experiencing rapid expansion. They offer retailers additional revenue streams, improved retail footprint, and closed-loop reporting while providing consumers with better shopping experiences.

Rise of Retail Media Networks

The emergence of RMNs is primarily attributed to retailers like Amazon, Walmart, and Tesco, who capitalized on the surge in e-commerce and the demand for access to first-party data. Amazon, being a pioneer in this field since 2012, valued its advertising business at $37.7 billion globally in 2022. By 2026, Amazon is anticipated to claim a 13% share of the global digital advertising revenue.

Following Amazon's successful playbook, other retailers like Walmart and Target have also entered the RMN landscape, paving the way for more retailers and even pharmaceutical companies to join in the upcoming years.

Role of Cloud Data Warehouses in RMNs

In the context of RMNs, Cloud Data Warehouses play a pivotal role in harnessing the power of data. They serve as a centralized repository where vast amounts of first-party data related to consumer shopping habits, product preferences, and demographic information are collected, stored, and analyzed.

A Cloud Data Warehouse like Snowflake provides a robust, scalable, and secure environment for storing and processing enormous volumes of data. It offers comprehensive capabilities for data integration, transformation, and analysis, enabling retailers to derive actionable insights from their data.

Advantages of Cloud Data Warehousing

A Cloud Data Warehouse offers several advantages that are particularly beneficial for Retail Media Networks:

  1. Scalability: Cloud-based data warehouses like Snowflake can easily scale up or down based on the data volume, ensuring optimal performance and cost-efficiency.
  2. Real-Time Analytics: They provide real-time analytics capabilities, enabling retailers to monitor campaign performance and customer behavior in real-time.
  3. Data Security: Cloud Data Warehouses ensure high levels of data security with encryption, access controls, and regular backups.
  4. Integration Capabilities: They can seamlessly integrate with various data sources, business intelligence tools, and data processing frameworks, facilitating comprehensive data analysis.


Building Retail Media Networks with Snowflake

Snowflake provides a robust platform for building effective Retail Media Networks.  Its unique architecture Allows secure data sharing that enables person-level marketing without revealing PII or compromising privacy while maintaining the highest standards of governance. Access to unique datasets for enrichment ensures high performance, cost-efficiency, and flexibility, making it an ideal choice for RMNs.

Leveraging Snowflake for RMNs

Snowflake Launches Retail Data Cloud To Optimize Retailer Operations

Retailers can leverage Snowflake's capabilities to enhance their Retail Media Networks in several ways:

  1. Data Consolidation: Snowflake allows retailers to consolidate disparate data sources into a single platform, providing a unified view of customer data.
  2. Real-Time Analytics: With Snowflake, retailers can perform real-time analytics to monitor and optimize their ad campaigns.
  3. Data Sharing: Snowflake's secure data sharing feature allows retailers to share data with their partners without moving or copying data, ensuring data consistency and security.
  4. Integration: Snowflake can easily integrate with various data processing frameworks and business intelligence tools, facilitating comprehensive data analysis.

Building RMNs with Census Embedded

Census Embedded is a powerful tool that can help businesses build their own Retail Media Networks on top of their Data Warehouse or Data Lake. It provides a robust platform for data integration, transformation, and analysis, enabling businesses to derive actionable insights from their data.

With Census Embedded, businesses can create custom data models, perform real-time analytics, and automate data workflows. It also offers advanced capabilities like data synchronization, version control, and data lineage tracking, ensuring data accuracy and consistency.

By leveraging Census Embedded, businesses can harness the power of their data to drive their Retail Media Network strategy, enhance customer experiences, and boost their bottom line.


In the evolving digital landscape, Retail Media Networks and Cloud Data Warehouses go hand in hand. They are transforming the way businesses store, analyze, and utilize data, thereby revolutionizing the retail and advertising industry. By leveraging technologies like Snowflake and Census Embedded, businesses can build robust RMNs, deliver personalized experiences to their customers, and drive their business growth.

Related articles

Customer Stories
Built With Census Embedded: Labelbox Becomes Data Warehouse-Native
Built With Census Embedded: Labelbox Becomes Data Warehouse-Native

Every business’s best source of truth is in their cloud data warehouse. If you’re a SaaS provider, your customer’s best data is in their cloud data warehouse, too.

Best Practices
Keeping Data Private with the Composable CDP
Keeping Data Private with the Composable CDP

One of the benefits of composing your Customer Data Platform on your data warehouse is enforcing and maintaining strong controls over how, where, and to whom your data is exposed.

Product News
Sync data 100x faster on Snowflake with Census Live Syncs
Sync data 100x faster on Snowflake with Census Live Syncs

For years, working with high-quality data in real time was an elusive goal for data teams. Two hurdles blocked real-time data activation on Snowflake from becoming a reality: Lack of low-latency data flows and transformation pipelines The compute cost of running queries at high frequency in order to provide real-time insights Today, we’re solving both of those challenges by partnering with Snowflake to support our real-time Live Syncs, which can be 100 times faster and 100 times cheaper to operate than traditional Reverse ETL. You can create a Live Sync using any Snowflake table (including Dynamic Tables) as a source, and sync data to over 200 business tools within seconds. We’re proud to offer the fastest Reverse ETL platform on the planet, and the only one capable of real-time activation with Snowflake. 👉 Luke Ambrosetti discusses Live Sync architecture in-depth on Snowflake’s Medium blog here. Real-Time Composable CDP with Snowflake Developed alongside Snowflake’s product team, we’re excited to enable the fastest-ever data activation on Snowflake. Today marks a massive paradigm shift in how quickly companies can leverage their first-party data to stay ahead of their competition. In the past, businesses had to implement their real-time use cases outside their Data Cloud by building a separate fast path, through hosted custom infrastructure and event buses, or piles of if-this-then-that no-code hacks — all with painful limitations such as lack of scalability, data silos, and low adaptability. Census Live Syncs were born to tear down the latency barrier that previously prevented companies from centralizing these integrations with all of their others. Census Live Syncs and Snowflake now combine to offer real-time CDP capabilities without having to abandon the Data Cloud. This Composable CDP approach transforms the Data Cloud infrastructure that companies already have into an engine that drives business growth and revenue, delivering huge cost savings and data-driven decisions without complex engineering. Together we’re enabling marketing and business teams to interact with customers at the moment of intent, deliver the most personalized recommendations, and update AI models with the freshest insights. Doing the Math: 100x Faster and 100x Cheaper There are two primary ways to use Census Live Syncs — through Snowflake Dynamic Tables, or directly through Snowflake Streams. Near real time: Dynamic Tables have a target lag of minimum 1 minute (as of March 2024). Real time: Live Syncs can operate off a Snowflake Stream directly to achieve true real-time activation in single-digit seconds. Using a real-world example, one of our customers was looking for real-time activation to personalize in-app content immediately. They replaced their previous hourly process with Census Live Syncs, achieving an end-to-end latency of <1 minute. They observed that Live Syncs are 144 times cheaper and 150 times faster than their previous Reverse ETL process. It’s rare to offer customers multiple orders of magnitude of improvement as part of a product release, but we did the math. Continuous Syncs (traditional Reverse ETL) Census Live Syncs Improvement Cost 24 hours = 24 Snowflake credits. 24 * $2 * 30 = $1440/month ⅙ of a credit per day. ⅙ * $2 * 30 = $10/month 144x Speed Transformation hourly job + 15 minutes for ETL = 75 minutes on average 30 seconds on average 150x Cost The previous method of lowest latency Reverse ETL, called Continuous Syncs, required a Snowflake compute platform to be live 24/7 in order to continuously detect changes. This was expensive and also wasteful for datasets that don’t change often. Assuming that one Snowflake credit is on average $2, traditional Reverse ETL costs 24 credits * $2 * 30 days = $1440 per month. Using Snowflake’s Streams to detect changes offers a huge saving in credits to detect changes, just 1/6th of a single credit in equivalent cost, lowering the cost to $10 per month. Speed Real-time activation also requires ETL and transformation workflows to be low latency. In this example, our customer needed real-time activation of an event that occurs 10 times per day. First, we reduced their ETL processing time to 1 second with our HTTP Request source. On the activation side, Live Syncs activate data with subsecond latency. 1 second HTTP Live Sync + 1 minute Dynamic Table refresh + 1 second Census Snowflake Live Sync = 1 minute end-to-end latency. This process can be even faster when using Live Syncs with a Snowflake Stream. For this customer, using Census Live Syncs on Snowflake was 144x cheaper and 150x faster than their previous Reverse ETL process How Live Syncs work It’s easy to set up a real-time workflow with Snowflake as a source in three steps: