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.
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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
Every sync comes with a historical log where you can dive into what caused errors or why an application rejected updates.
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.
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.