Sync your data warehouse to Heap

Reverse ETL for Heap

Enrich your behavioral analytics in Heap with user and account attributes and synthetic events from your data warehouse. For once, your event dashboards and your CRM will tell the same story!
AWS S3 Integration
Postgres icon
MySQL icon
Redshift icon
Google Sheets icon
Elastic search
Heroku Postgres Connect icon
Data Build Tool (dbt)
Rockset icon
BigQuery icon
Looker icon
Azure Synapse icon
Databricks icon
Snowflake icon
SQL Server icon
panoply icon
Athena icon
Census logo
Census logo
Jira icon
Kustomer CRM icon
Twitter Ads icon
Notion icon
Courier icon
SendGrid icon
Planhat icon
Algolia icon
Google Ads icon
Sailthru icon
Zuora icon
Orbit icon
Autopilot icon
S3 icon
Intercom icon
Freshsales icon
Marketo icon
Pendo icon
mParticle icon
Criteo icon
Apollo icon
Userpilot icon
User Interviews icon
Segment icon
Calixa icon
Airtable icon
Outreach icon
pinterest icon
GCS icon
Totango icon
Google Analytics integration
Oracle Netsuite icon
Google Ads Icon
Snapchat icon
Userflow icon
Customer.io icon
Postgres icon
Chargebee icon
Datastore logo
Zendesk icon
Zendesk icon
Drift icon
Stripe icon
Salesforce logo
Front icon
Asana icon
FullStory icon
Help Scout icon
Google Search Ads 360 icon
Microsoft Ads icon
Appcues Integration Logo
Salesforce Marketing Cloud icon
LinkedIn Ads icon
Instagram Ads icon
Oracle Fusion Cloud
Pardot icon
ActiveCampaign icon
Mixpanel icon
Slack
Vitally icon
Dynamics 365 icon
Shopify icon
Facebook Ads icon
Hubspot icon
ChartMogul Integration Logo
The Trade Desk icon
Facebook Ads Logo
Mailchimp icon
Close.io icon
Campaign Monitor icon
Iterable icon
Microsoft Ads Icon
Anaplan icon
tiktok icon
Zapier integration logo
Pipedrive icon
Microsoft Teams icon
Google Analytics 4 icon
Ortto icon
PostHog icon
Custom destination API icon
Heap Analytics Icon
Stripe icon
SQL Server icon
Klaviyo icon
Zoho icon
Webhooks icon
Braze icon
Gainsight icon
Poplar icon
Great Question icon
SFTP icon
correlated logo
Amplitude icon
ChurnZero 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 Heap 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? 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? 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 Heap and Census
Learn how to connect Heap and Census
Where can Census sync to in Heap?

Add Account

This API allows you to attach custom account properties to users. An account ID or use of our Salesforce integration is required for this to work.

User Activity API

The User Activity API allows a Google Analytics property owner to retrieve all analytics measurement data associated with a single user. Specifically, the API retrieves all of the measurement data associated with a particular User ID or Client ID.

Add Event Properties

Use this API to send stateful information into Heap as a set of global key-value pairs that get attached to all of a user's subsequent events.

Need help getting started with Heap?
Connect with us and we'll help you get Heap connected to Census in 30 minutes or less! In addition, we can answer any questions you have about the platform or what you can do with it. We've seen a lot of powerful use cases!

Census means access to data is never a blocker for our revenue teams – if they want to run a growth experiment, the data is always available.

Julie Beynon
Head of Analytics @ Clearbit
Heap
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.