Product News

What's new in Census: January product release updates

Katy Yuan
Katy Yuan January 26, 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.

Happy new year everyone (it’s not too late to say that, right?)! Hope you had a restful break and have returned excited to try new things with data. In case you missed it, check out our product review of 2021 for the top five product features of last year.

Here’s some data use case motivation in case you’re in need of it: A couple of weeks ago, Brendan Short at Groundswell gave a shout-out to a fantastic personalized email from Cesca Fleischer at Rippling.

We love how this showcases the level of personalization that’s possible with a tool like Census (and this is just the tip of the iceberg).

Personalization for all: New Connectors by category

Finance, you get a connector! Product, you get a connector! Ecommerce, you get a connector! Marketing and advertising… you got a lot already, but have some more…

In case it wasn’t clear, we’re introducing a ton of new connectors. Here they are by category:

🧮 Finance: New connectors for all your signup and billing needs

  • Anaplan Import Actions (Models Coming Soon!)
  • Chargify
  • Chargebee
  • Zuora

💡 Operational analytics use case: What’s one thing I could do with Census?

With our new finance connectors, you can sync your product signup and engagement data into subscription and billing tools so that the product context lives by the billing context. This enables you to also reference product usage data for configuring subscription change logic (e.g. new signup date means they should be on the “Free” subscription).

✨ Marketing: New connectors for all your advertising and automation needs

Connectors for advertising

  • TikTok
  • Snapchat
  • Microsoft Ads (fka Bing Ads) and Offline conversions (Custom Audience Coming Soon!)
  • LinkedIn Ads Coming Soon!
  • Criteo Coming Soon!

💡 Operational analytics use case: What’s one thing I could do with Census?

With our new connectors for marketing, you can create lookalike audiences based on your best existing customers. Lookalike audiences are a safe and cost-effective way to expand and improve the quality of your advertising audiences at the same time. Read about how Bleach London saw a 20% decrease in CPA by improving their audiences.

Connectors for marketing automation

  • Autopilot
  • ActiveCampaign now supports Lists Improvement!
  • Swrve Coming Soon!

💡 Operational analytics use case: What’s one thing I could do with Census?

Like Cesca’s email above, you can sync product usage data into your marketing automation platform. You can use these to trigger and personalize emails to nudge customers onto the next step of the product journey.

🏗️ Product: Connectors to help you understand your users

  • Pendo (Product Analytics)
  • Appcues (User Onboarding)
  • Delighted (NPS & Surveys)
  • Heap Analytics (Product Analytics)

💡 Operational analytics use case: What’s one thing I could do with Census?

By combining product usage data with user profiles, you can identify your most engaged customers and target them for feedback or to try new features.

đź’° Sales: Connectors to help you reach the right customers at the right time

Connectors for Product-led Growth CRMs

💡 Operational analytics use case: What’s one thing I could do with Census?

With our new sales connector, you can now easily trigger campaigns in Outreach for all accounts over a certain number of employees with more than 10 logins within the last week who have self-service billing revenue of more than $300 MRR. And that’s just one example: Read more examples from Correlated here.

Ecommerce: A new connector to help you build a more personalized product

  • Shopify

💡 Operational analytics use case: What’s one thing I could do with Census?

With our new Shopify connector, you can create more personalized product recommendations by syncing additional properties to your customer object.

🤝 Customer Success: Connectors to help you better support your customers

  • Kustomer Coming Soon!
  • Gainsight Custom Objects (🔥 Many Requests!) Coming Soon!

💡 Operational analytics use case: What’s one thing I could do with Census?

With our new connectors for customer success, you can help prioritize your customer support queue by creating a customer VIP score based on attributes such as product usage data, customer spend, and loyalty, and syncing that data to CS tools like Front, Zendesk, Intercom, etc.

🆕 For all you dbt fans: We now support dbt 1.0

Our dbt project integration now runs on dbt 1.0. For more information on our dbt integration as well as tips on upgrading to 1.0, take a look at our dbt integration docs.

🔒🪣 Increased security for Snowflake on GCP

Snowflake users on Google Cloud Platform can now request that Census keep their data within GCP infrastructure for additional security. Contact us via email or chat to find out more.

Note: we’ll also soon let you bring your own Google Cloud Storage Bucket! 👉 If you’re interested, check out how we do this for S3

▶️ Check out this week’s webinar: Reverse ETL vs CDP – Is there one clear winner?

Torn between upgrading your data stack with reverse ETL or adding a CDP? This webinar is for you. In it, Census Head of Product Ankush Rustagi breaks down the pros and cons of reverse ETL and CDPs, as well as the reasons why data and marketing leaders are moving from CDPs to reverse ETL on their data warehouse to activate their customer data.

👉 Watch the recording here

🙏We need your help: Vote on your most important integrations

Our product team would like to have you help prioritize our next set of integrations! If you’d like to help us build the best product possible, let us know which integrations matter most to you here. We're currently considering:

  • Campaign Monitor
  • Google Analytics
  • Google Campaign Manager
  • Google Ad Manager
  • mParticle
  • JIRA
  • Salesloft

🔜 Want to join the beta for an upcoming integration? Send us a message. You can check out our full list of integrations here.

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: