Best Practices

The most complete CDP on Snowflake | Census

Katy Yuan
Katy Yuan May 08, 2023

Katy is a Product Marketing Manager at Census who loves diving into startups, SaaS technology, and modern data platforms. When she's not working, you can find her playing pickleball or Ultimate Frisbee.

Marketers today have more customer data than ever before, making it possible to precisely target customers based on CRM data, purchase history, support interactions, and activity on a website, app, or social media.

However, marketers still struggle to activate cross-channel personalized experiences because they lack access to a single unified view of their customers.

The volumes of customer data coming from an explosion of marketing tools – now 11,038 and counting – and increasing privacy regulation mean that marketing teams can no longer rely on the martech platforms of the past to manage customer data.

Enter the Composable Customer Data Platform – the new foundation for data and marketing teams to activate data together, centered around the Snowflake Data Cloud.

On the Snowflake blog 👉 Visual Segmentation for the Data Cloud with Census Audience Hub

The evolution of CDPs

A CDP is an all-in-one data solution for marketing teams, providing data ingestion, modeling, and activation features. However, customers who adopt off-the-shelf CDPs struggle with their rigid data models, long onboarding times, and redundancies across analytics and marketing tools. In fact:

  • Only 1% of CDP owners believe their CDP meets current and future needs.
  • Only 29% are satisfied with their CDP’s customer segmentation capabilities.
  • Only 22% are satisfied with their CDP’s personalization capabilities.

As business use cases have become more complex and the Snowflake Data Cloud has emerged as the central repository for customer data and analytics, companies discovered that they had two sources of truth for customer data: A fragmented version in the CDP and a complete version in Snowflake.

CDPs duplicate data and create silos – where's your source of truth?

To avoid creating separate data silos in a traditional CDP, organizations began leveraging Census to activate customer data directly from Snowflake. With the addition of other best-in-class components like Fivetran for ELT, dbt for data transformation, and Snowplow for event collection, a more robust marketing platform — the Composable CDP — was born.‎

The Composable CDP is a best-of-breed marketing platform

Download ebook 👉 The Composable CDP: Powering Customer 360 with Snowflake

The rise of the Composable CDP

A Composable CDP shares similar goals with traditional CDPs but differs in architecture. Instead of ingesting a copy of data, a Composable CDP leverages existing data infrastructure to power marketing personalization and customer engagement.

Census Audience Hub is the activation layer that helps marketers unleash the power of their customer data. It provides a suite of no-code features for marketers to create, explore, and activate dynamic audience segments with their Customer 360 data in Snowflake.

Census Audience Hub helps marketers activate all their customer data in Snowflake

After creating audiences, automated Reverse ETL syncs enable marketers to keep their audiences up-to-date in 200+ marketing and advertising tools like Braze, Iterable, HubSpot, Salesforce, and Google Ads.

Benefits

Using a Composable CDP instead of a traditional CDP has these advantages:

  • Completeness: Data from across the entire organization, including events, customer information, offline data, and third-party datasets, is consolidated into a complete Customer 360 view.
  • Flexibility: Composable tools are designed to integrate with Snowflake and speak SQL as their common language, offering greater flexibility in data modeling, transformation, and vendor selection.
  • Cost savings: Organizations can avoid the costs associated with building and maintaining duplicate data silos, while leveraging Snowflake’s unlimited storage and data history.
  • Faster time-to-value: Activating the existing data in Snowflake is faster than implementing a traditional CDP, which can often take 6 months or more.
  • Consistent metrics: Since Composable CDPs activate data from the organization’s source of truth, it’s easier to ensure that metrics are consistent across BI dashboards and customer-facing tools.
  • Privacy and security: Off-the-shelf CDPs replicate sensitive customer data into their data store, creating additional privacy and security risks.

‎See it in action

Leading companies have adopted the Composable CDP approach to drive more business impact with their data. At Census, we’ve helped B2B and B2C companies target, personalize, and unify customer experiences.

See how Canva, Zip, and HOVER leveraged Census on top of Snowflake.👇

💡 Why did Canva build a Composable CDP with Census, Fivetran, and Snowflake? Find out here.

What’s next? The future of MarTech is composable

In today's data-driven world, organizations need to activate the full potential of their customer data as their competitive advantage. 

The Composable CDP is a massive step forward in bridging the gap between data and marketing teams, bringing them together on the same platform towards the same business goals.

Monolithic, one-size-fits-all solutions are no longer the best choice for organizations to activate the potential of their customer data. Instead, by leveraging the newest innovations in the Snowflake Data Cloud, companies can build the most effective marketing platform that unifies customer experiences across all channels.

🚀 Ready to build a best-in-class Composable CDP with Snowflake? Get a personalized onboarding of Census or start a free trial today.

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: