Census

Free tier available

Reverse ETL pioneer — now part of Fivetran's end-to-end data movement platform

Reverse ETL reverse-etl activation sync

📖 Overview

Census pioneered the Reverse ETL category — the concept of syncing data from your warehouse back to the operational tools where business teams actually work. Instead of building brittle point-to-point integrations or exporting CSVs, Census turns your data warehouse into a live operational hub, pushing trusted data to Salesforce, HubSpot, Braze, and 200+ other destinations. **Major update (May 2025):** Census was acquired by **Fivetran**, creating an end-to-end data movement platform that covers both forward ETL (ingestion) and Reverse ETL (activation). The Census team and product are being integrated into Fivetran's platform, though the Census product continues to operate independently during the transition. This is a significant signal — it validates Reverse ETL as a core part of the modern data stack, not a niche category. Census is backed by Sequoia, Andreessen Horowitz, Insight Partners, and Tiger Global, and is used by companies like Canva, Sonos, Figma, and Notion.

✨ Key Features

✓ 200+ Destinations: Sync to CRM, marketing automation, ad platforms, support tools, and more
✓ Audience Hub: Visual, no-code segment builder for marketing teams — acts as a composable CDP
✓ dbt Integration: First-class support for using dbt models as sync sources
✓ Incremental Syncs: Efficient change detection that only moves what's changed
✓ Entity Resolution: Match and merge records across systems using flexible identity rules
✓ Embedded Reverse ETL: White-label Census capabilities inside your own platform (launched 2023)
✓ Observability: Sync monitoring, alerting, and debugging with detailed sync logs
✓ Live Syncs: Near real-time data activation for time-sensitive use cases
✓ Computed Columns: Transform data on the fly without modifying warehouse models
✓ API Access: Programmatic sync management for automation and CI/CD workflows

💰 Pricing

Model

freemium

Starting Price

$0 (limited)

✓ Free tier available 🏢 Enterprise plans available

👍 Pros

+ Category creator and leader in Reverse ETL — deep product maturity
+ Excellent dbt and warehouse-native integration
+ Audience Hub provides composable CDP functionality without a separate CDP purchase
+ Strong enterprise features including RBAC, SSO, and audit logs
+ Free tier is generous enough for small teams to get real value
+ Fivetran acquisition provides long-term stability and forward+reverse ETL unification
+ Great documentation and responsive support

👎 Cons

− Pricing scales with record volume — can get expensive at high data volumes
− Some destination connectors have field mapping limitations
− Requires clean, well-modeled warehouse data to be effective
− Fivetran acquisition creates uncertainty about independent product roadmap
− Learning curve for advanced features like entity resolution and computed columns
− Audience Hub competes with dedicated CDPs — may not fully replace Segment or mParticle for complex use cases

🎯 Best For

Data teams who've invested in dbt and a cloud warehouse and want to activate that modeled data across business tools without building custom pipelines. Ideal for marketing ops (audience syncing, ad targeting), sales ops (lead enrichment, CRM sync), and customer success teams. Especially compelling if you're already a Fivetran customer, since the combined platform covers ingestion through activation.