Product News

Census Segments: Build audiences without SQL

Katy Yuan
Katy Yuan February 15, 2022

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.

ℹ️ Census Segments is now part of Audience Hub, our suite of features purpose-built to help marketers activate the 360° data in their warehouse. Check out the Audience Hub page for our newest releases!

To all my fellow marketers out there - tell me if this looks familiar to you:

The old way - what a nightmare. No more of these ad audience CSVs!

At my previous job, I had multiple folders jammed full of CSVs with different versions of our ad audiences, and a daily calendar reminder to “Do Audience Uploads.”

What if I told you…you could move them all to the recycle bin for good?

Now you can. Introducing Census Segments!

👉 What is Census Segments?

A single place to build audience segments on top of your data warehouse, and sync them with all your advertising and marketing tools. No more CSV uploads or SQL required.

This means you can experiment with audiences faster, all while using trusted data from your company’s source of truth (the data warehouse). This warehouse-centric approach reflects our vision to revolutionize how companies work with data with Operational Analytics. Our mission is to deliver the best, most reliable data to every user at scale, bridging the gap between data and ops teams.

To validate our vision, this quarter we’re offering Census Segments on all plans (including free) at no cost to you. 🙌

This release of Census Segments includes:

  • UI Visual Segment Builder
  • A single place to manage segments and sync them to all downstream marketing tools
  • A library of advertising and marketing connectors
  • Approval process for data teams to verify that segments are only built on trusted data models
  • Integrations with dbt and Looker models

🛠️ A new Visual Segment Builder to create audiences without SQL

Instead of manual CSV uploads and complicated SQL queries, we’re offering an intuitive visual segment builder to help you build personalized audiences with all the rich data available in your warehouse. You can easily spin up segments to:

  • find lookalike audiences based on top spending customers
  • segment audiences by persona, and
  • target highly engaged users with specific campaigns.

Early users like CultureAmp and Webflow are already loving Segments 👉

"Census makes it really easy to sync audiences into our Ad platforms. I build my audiences on top of models from my data team, click go, and it just works. It does exactly what it’s supposed to.” - Ryan Luis, Sr. Manager Revenue Operations at Webflow

TL;DR: We’re going from this:

To this:

🔗 The Census advantage: A library of marketing and advertising connectors

Census has a whole suite of marketing and advertising connectors, which means you can update all your audiences and segmentation lists from a single place. The benefit of managing audiences at this higher level is if you want to edit an audience down the line, you only have to make that change once and Census will update it everywhere.

We recently added a ton of new ads connectors including TikTok, Snapchat and Bing!

❤️ Who’s loving it?

Bleach London, a direct-to-consumer eCommerce brand, reduced cost per acquisition by 20% with better segmentation.

"That’s what I like about Census – it’s not like I have to do ‘X for Facebook and Y on email.’ With one click I can share that audience with all the platforms and we can activate all our different use cases.” — Michael Lorenzos, Head of eCommerce Growth

Read his story

🤝 Data teams: Make trusted data self-service for marketing

Unlike other tools designed only for marketing teams, Census has features for both data teams and ops teams.

Census Segments enables data teams to make the trusted models they’ve worked tirelessly on available for self-serve by marketing teams. To ensure this collaboration happens seamlessly we also have features to make data teams happy:

  • Approval process to only make trusted models available for segment building
  • Integrations with dbt and Looker so data teams can make their models immediately available to marketing teams.

The best part: When data changes upstream, the marketing team’s audiences will be automatically updated with ✨fresh✨ data.

Clearbit, a B2B SaaS company, syncs more than 100 fields to multiple apps to build a 360° customer view and craft hyper personalized email campaigns.

"With Census, our sales & marketing always have current data in their tools and the data team can enable growth experiments." — Julie Beynon, Head of Analytics

Read more about using dbt & Census to empower business teams

🙋 But wait…how is Census Segments different from what Customer Data Platforms (CDPs) offer?

Good question! CDPs are great marketing tools but ​​they weren’t built to be warehouse-native, which means they don’t have all the data you need and they quickly get expensive as you scale. We believe the best business outcomes are achieved when the data warehouse is the single source of truth for all business and data teams.

Want to learn more about when to use a CDP vs reverse ETL? Check out these resources:

How do I get started?

Census Segments is live today! 🎉 Log in to your account or start your free trial now.

🔮 The Future: What’s coming next?

Many of our customers have requested Census Segments as a feature and this initial release is just the beginning. We have plenty of exciting improvements on the roadmap.

Keep an eye out for these upcoming features:

  • Access controls for data teams to limit settings by user
  • A richer and more powerful filter experience with our Segment Builder 2.0

✋ Ready to try out all these awesome new features? Get a demo of Census!

Related articles

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:

Best Practices
How Retail Brands Should Implement Real-Time Data Platforms To Drive Revenue
How Retail Brands Should Implement Real-Time Data Platforms To Drive Revenue

Remember when the days of "Dear [First Name]" emails felt like cutting-edge personalization?

Product News
Why Census Embedded?
Why Census Embedded?

Last November, we shipped a new product: Census Embedded. It's a massive expansion of our footprint in the world of data. As I'll lay out here, it's a natural evolution of our platform in service of our mission and it's poised to help a lot of people get access to more great quality data.