Census
Reverse ETL / data activation platform — sync data from your warehouse to SaaS destinations and manage syncs, sources, destinations, and datasets via the Management API.
Three ways to use Census
Chat with Geni
Ask Geni to pull data, take actions, or answer questions using this integration in a conversation.
Build a workflow
Create automated workflows that trigger on events, run on a schedule, or chain multiple tools together.
Power an app
Use this integration as a data source or action layer behind a dashboard, form, or internal tool.
Supported tools
Actions your AI agents can perform with Census.
Create Dataset
Create a new SQL-defined dataset attached to an existing source connection.
Create Destination
Create a new destination connection (CRM, marketing tool, etc.) in the workspace.
Create Source
Create a new data source connection (warehouse/database) in the workspace.
Create Sync
Create a new sync wiring a source object to a destination object with field mappings.
Fetch Dataset
Get full definition (SQL query, source, columns) of a single dataset.
Fetch Destination
Get full configuration, supported object types, and connection test results for one destination.
Get started automating Census
Ready-to-use workflows
Prompts using Census
See every Census sync's health and fix it in one place
Open one board every morning to see which Census syncs failed, read the real error, and retry, pause, or flag them without leaving the page.
Let marketing push fresh CRM data without asking the data team
A one-screen console where marketing and sales ops refresh lead scores and audiences in your CRM themselves, on approved data pushes only.
See every field your Census syncs write into your CRM
Browse your whole Census workspace as one map of destinations, syncs, and the exact fields they write, and catch write conflicts before they reach your CRM.
Only run Census syncs when your dbt models build cleanly
When a dbt build finishes, we check which models actually succeeded and sync only those tables to your CRM, so sales never sees half-built data.
Weekday Census sync health digest for your data ops channel
Every weekday morning, we walk your Census syncs, spot the ones failing or degrading, and post a triaged digest into Slack.
Triage failed Census syncs to PagerDuty, Linear, and Slack
Every 15 minutes, sweep Census for newly failed sync runs, page on-call for outages, file a Linear ticket for config bugs, and log every failure in Slack.
Weekly Census sync activity report for leadership
Every Monday morning, walk every Census sync and post a leadership-ready recap of what reached your CRMs and marketing tools this week.
Pre-warm Census syncs before the sales day starts
Every weekday at 6:45am, kick off your sales-critical Census syncs, wait for them to finish, and drop a summary in Slack plus a row in a Google Sheet.