1.GitLink (Configuration as Code)

Manage all your Reverse ETL and data activation workflows in Git. Bring software engineering best practices like version control, peer review, and testing to business operations.

2.Visual Data Mapper

From Leads to Custom Objects, Census makes it easy for you to configure how data is mapped into your target tools. We take care of all the translation details to keep data flowing smoothly.

3.Notifications

Automatically trigger alerts in Slack or Microsoft Teams for real-time updates on customer activity. Use fields in your data warehouse to customize your message content in our rich visual builder.

4.Scheduled & Continuous 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.

5.SQL Model Builder & Editor

You define what data to sync. Query any data warehouse resource, write powerful filters or transform the data. Just write SQL, preview the results, and save.

6.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.

7.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).

8.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.

9.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.

10.Detailed Observability & Logging

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

11.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.

12.Typecasting from your column to 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.

13.Data Orchestration API

Hourly? Daily? On-demand? Trigger syncs exactly when you want via the Trigger Sync API from tools like Airflow, Dagster, dbt Cloud & more.