Unify your customer data. Sync across your tools.

Census sits on top of your existing data warehouse. You write SQL to build models or transform data to make the most of your customer data. We reliably sync it to Salesforce and other go-to-market tools. It’s that simple.

Process Data

Process

Automate

Sync data

Sync

Simple Tool.  Powerful Solution.

Don't get stuck waiting on the engineering backlog. Syncs can be updated as your business needs change and new data becomes important. Census takes care of scheduling, alerting, and auto-healing.

No Engineering Favors Required

No more relying on engineers to generate data you import and merge in your tools. By automating the entire data pipeline, Census puts the right data directly in your hands and in the right tools.

Automate your Data Processes

Don’t just connect your data sources. Map fields and write queries to transform and unify your data, so it is ready to be used across your stack to help your go-to-market teams make the most of your data.

Work with your existing Warehouse

No need to migrate your data in Census and keep yet another DB in sync. Census works on top of your existing warehouse, so you have all of your data, in one place.  

Packed with features to makes your life easier

SQL Model Builder & Editor

You define what data to sync. You can map one table to multiple tables or objects, write powerful filters or transform the data. Just write SQL, preview the results, and save.

Scheduled & Realtime Sync

You can customize how often data is synced. From realtime all the way to monthly or manual; you can pick different schedules for different syncs.

Object Graph Sync

Sync whole object relationships or only update the values of a related object. For example, you can create a new contact, account, and opportunity with the same owner in one sync.

Daily Data Trends Reports

We make it easy to maintain and keep an eye on your sync with daily & weekly reports that highlight trends in errors, skipped, created or updated records.

Incremental batch updates

We monitor your data changes and only sync the new values and records. This means the syncs are faster and we use less of your APIs' quotas.

Visual Data Mapper

We made it easy to for you to map fields across tables and objects in different tools. We make sure the types are correct. No unecessary mapping mistakes here.

Automatic recovery

If Census loses connections to databases or apps, we notify you via email and automatically resume the sync when we re-connect. You never lose data and your stack stays in sync.

Optimize API calls

You shouldn't have to go past your Salesforce API quota just because your team needs better data. Census uses bulk APIs and only syncs records that have pending changes.

Support for dbt

We love dbt, and we know you love it too. Keep writing dbt models to make the most of your data and use Census to operationalize the data across your tools.

Multiple Sync Behaviors

Each sync is different. Whether you need to create new leads in SFDC or update an account with their PQL score, our modes can help you sync just the right data (Enrich, Mirror, Upsert, or Create).

Detailed Observability & Logging

Detailed Observability & Logging

Every sync comes with a historical log where you can dive into what caused errors or why an application rejected updates.

Auto detection of new fields

Even with a schema change in your warehouse such as a new column on a table or a type change, we will notify you of the changes and keep the sync going.

Smart conversion of data fields

We automatically convert field types for you. If you store "deal size" as an integer in your warehouse and a string in Salesforce, we manage the conversion for you automatically.

Some More Features Coming Soon

Support for teams and oAuth

Change data capture

Salesforce Oauth

Optimize Marketo API usage

Connect the apps you already use and love

Redshift

Redshift

Segment

Segment

Iterable

Iterable

Salesforce

Salesforce

Marketo

Marketo

Postgres

Postgres

Customer.io

Customer.io

Hubspot

Hubspot

Snowflake

Snowflake

Zendesk

Zendesk

Braze

Braze

View all available integrations