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 fully customize the schedule. From realtime to monthly or manual, you pick when it is the right time to run the sync: Different Syncs, different schedules.
Easily sync whole object relationships or only update the values of a related object. For example, create a new contact, account, and opportunity with the same owners in one sync.
We make it easy to maintains and keep an eye on your sync with daily & weekly reports that highlight trends in errors, skipped, created or updated records.
We made it easy to for you to map fields across tables and objects in different tools. We make sure the type are correct and notify you if not. No mistakes here.
If Census loses connections to the databases or tools, we notify you via email and automatically resume the sync when we reconnect. That way, you never lose data and your stack stays in sync.
Don't buy more salesforce API calls to get better data. We only sync records that need to be created or updated to ensure we use the minimum amount of API calls required.
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).
Sync comes with a historical sync log where you can deep dive into errors or records skipped helping you debug and review the sync.
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. So if you store deal amount as an integer in your warehouse and string in salesforce, we will do that conversion for you automatically.
