August 2020 Summaries

dbt is a tool that helps write and run SQL transforms in data warehouses, allowing for version control of SQL code and shared logic across models. Census now supports materializing select dbt models directly into external tools like Salesforce and Marketo. Users can connect to a dbt project stored on GitHub, select models to sync with Census, and automatically have the data published to external applications without manually managing materialization schedules.

We are committed to security and focused on keeping you and your data safe by following industry-leading standards while syncing your data from your warehouse to all of our apps. Our syncing and publishing pipeline is designed around the principle of storing and handling as little of your data as possible, using ephemeral workers that do not store your data, and practicing data defense-in-depth with multiple layers of data scrubbers. We prioritize minimizing data exposure by implementing a server-side approach that ensures sensitive data is not left behind on our servers or in our cloud storage.

The Product Activity Coefficient is a metric that measures customer engagement with a SaaS product by tracking the number of weeks a customer has been active over the last 7 weeks, resulting in a normalized score between 0 and 7. This metric helps Customer Success teams prioritize their work by identifying power users, accounts at risk of churning, and opportunities for expansion. By focusing on leading indicators rather than lagging metrics such as churn or customer satisfaction, CS teams can be proactive and help customers before it's too late. The metric is easy to understand and can be computed using product usage data, making it a valuable tool for B2B SaaS companies looking to improve their Customer Success efforts.

Our mission is to help you unify customer data and make it widely available for teams across the business. Our connectors turn your data warehouse into a platform for your customer data, bringing it to all your favorite applications to make better decisions & provide better service to your users. Today, we're excited to officially launch our Intercom Connector out of beta and have it available on Intercom’s App Store. You can now sync all of your internal customer data into Intercom to display product usage metrics, create granular segments, send personalized in-app or email campaigns, show Product Tours for features that people aren't using, and automatically trigger emails based on data from other apps. With Census, you can easily connect your warehouse to Intercom by adding Intercom as a new service connection via OAuth, creating a new sync, and visualizing the data mapping UI to pick what information you want to make available in Intercom. Once activated, the data will always be up to date and ready to be used to build better customer experiences, while respecting API usage and plan rate limits.