Sync your data warehouse to Amplitude

Reverse ETL for Amplitude

Sync user attributes from your data warehouse to intelligently adapt each user experience in real-time based on these insights. Drive business outcomes – from customer loyalty to lifetime value, and more.
Azure Synapse icon
Looker icon
Data Build Tool (dbt)
Heroku Postgres Connect icon
BigQuery icon
SQL Server icon
Google Sheets icon
Databricks icon
Snowflake icon
Postgres icon
Redshift icon
Elastic search
Rockset icon
panoply icon
Athena icon
MySQL icon
Census logo
Census logo
Hubspot icon
tiktok icon
GCS icon
ActiveCampaign icon
Segment icon
Google Ads Icon
Asana icon
SFTP icon
Jira icon
Amplitude icon
Customer.io icon
Oracle Netsuite icon
pinterest icon
Microsoft Ads icon
Criteo icon
Totango icon
Twitter Ads icon
Custom destination API icon
User Interviews icon
Klaviyo icon
Zendesk icon
Orbit icon
Gainsight icon
Airtable icon
Pipedrive icon
S3 icon
Marketo icon
Google Analytics integration
Facebook Ads Logo
Snapchat icon
Courier icon
SendGrid icon
Datastore logo
Salesforce Marketing Cloud icon
Planhat icon
Appcues Integration Logo
Shopify icon
Outreach icon
Intercom icon
Userflow icon
Microsoft Ads Icon
Front icon
Mixpanel icon
Sailthru icon
Mailchimp icon
Autopilot icon
Calixa icon
Slack
Freshsales icon
Salesforce logo
Zoho icon
Iterable icon
Webhooks icon
mParticle icon
Zuora icon
Google Ads icon
Anaplan icon
Chargebee icon
correlated logo
Apollo icon
Help Scout icon
Vitally icon
Braze icon
Stripe icon
Algolia icon
Close.io icon
Facebook Ads icon
Zapier integration logo
Zendesk icon
Stripe icon
Campaign Monitor icon
Pendo icon
Notion icon
LinkedIn Ads icon
Dynamics 365 icon
ChartMogul Integration Logo
Pardot icon
Heap Analytics Icon
Oracle Fusion Cloud
Ortto icon
Drift icon
Kustomer CRM icon
data models for sync illustration
video play button
Census logo
data part for integration uses illustrationimage part for integration uses illustration
Census logo

What can you do with Amplitude and Census?

360º Customer Profiles
Your stack is composed of 10+ tools. Each one has data about your customers; none have the full picture. With Census, unify that siloed data into a bespoke 360° customer profile that stays in sync across all tools, so your team doesn’t have to go to 5 different places to understand their customers.

Track Synthetic Events
Are there holes in your tracking implementation? Need to capture an event after the fact? With Census can send events based on interactions that are out of reach of your application and backfill event streams with historical data.

Custom Properties
Add custom properties to your user identities with data from your data warehouse for access to fine-grain segmentation, high-impact metrics, and consistent reporting across your whole customer data stack.

360º Customer Profiles

Your stack is composed of 10+ tools. Each one has data about your customers; none have the full picture. With Census, unify that siloed data into a bespoke 360° customer profile that stays in sync across all tools, so your team doesn’t have to go to 5 different places to understand their customers.

Custom Properties

Create granular segments or audiences based on any data so you can send personalized emails and messages, show ads to inactive users to reengage them, promote new features to users who will benefit the most, and many more use cases.

Synthetic Events

Are there holes in your tracking implementation? Need to capture an event after the fact? With Census can send events based on interactions that are out of reach of your application and backfill event streams with historical data.

Learn how to connect Amplitude and Census
Learn how to connect Amplitude and Census
Where can Census sync to in Amplitude?

Device ID

Use the Identify API to set the User ID for a particular Device ID or update user properties of a particular user without sending an event.

User Profile API

The User Profile API serves Amplitude user profiles, which include user properties, computed user properties, a list of cohort IDs of cohorts that the user is in, and recommendations.

Group Identify API

Use the Group Identify API to set or update properties of particular groups. The Amplitude Accounts add-on makes analytical functionality available at the group level. A group is an object that a set of users might belong to, like a company of customers, team of users, or a playlist with listeners. Groups can help you understand how accounts interact with your product, instead of how individual users interact.

Batch Event Upload API

The Batch Event Upload API lets you upload large amounts of event data. The event JSON format follows our HTTP API format, and has the same requirements (each event must have an event type, and so on).

A data analyst looks at data, looks at dashboards, finds insights, and is then able to activate it using Census all in one step.

Cuong Duong
Data Analyst @ Canva
Amplitude
features:

A single source of truth in all your tools

Census is the easiest way to share a consistent view of your data across your entire business.  Define your models, metrics, and business logic in your data warehouse and sync them to all your operational tools.

  • Create trust in consistent metrics
  • Automate confidently with clean data
  • Simplify your data integration strategy
  • Improve data security and visibility
Take action with confidence
Get your free shirt with your free Census account. When you wear it, you’ll know that you're in with the likes of data visionaries at Notion, Mode, Canva, and Loom.