This page describes how to use Census with Amplitude.

πŸƒβ€β™€οΈ Getting Started

β€ŒIn this guide, we will show you how to connect Amplitude to Census and create your first sync.


1. Get API key from Amplitude

Census needs only one piece of information to connect to your Amplitude project:
  • The API Key for an HTTP API data source for your Amplitude project

2. Create a HTTP API Data Source in Amplitude, and copy the API key

Amplitude lets you pull data from a number of different sources, including via HTTP API. If you don't have this data source set up in Amplitude already, you'll need to create one. The same steps below will also allow you to find the API key for a pre-existing HTTP API data source, as Amplitude will only permit one per project.
  1. 1.
    Within Amplitude’s left navigation bar, scroll down to the very bottom. Click on Sources & Destinations.
  2. 2.
    β€ŒOnce here, navigate to the top-right of the screen and click to Add Data Source.
  3. 3.
    Select β€œHTTP API” as the type of data source, and click Next.
  4. 4.
    Copy the API Key (it will be a long string of numbers and characters), click Next.
  5. 5.
    If you are setting up the HTTP API data source for the first time, Amplitude will require you to POST an event to their API to complete set-up. Amplitude provides instructions to send a sample event and complete set-up at this stage.
  6. 6.
    When the event is received by Amplitude, click Finish to finish setting up this source within Amplitude.

3. Create the Census Connection

Now that we have the API Key from Amplitude, we can now set up Amplitude as a Destination in Census.
  1. 1.
    In the Settings tab of Census, create a new Amplitude Service Connection.
  2. 2.
    You can provide whatever name you like.
  3. 3.
    Provide the copied API Key from Amplitude.
  4. 4.

4. Create your first Model

Now navigate to the Model section of our Dashboard​
Here you will have to write SQL queries to select the data you want to see in Amplitude. Here are some ideas of data you should select
  • The Lifetime Value of a customer
  • The end date of a user's trial
  • The date a user became active in your product
  • The number of key activities a user did in your app in the last 7/30 days
Once you have created your model, click save.

5. Create your first Sync

Now head to the Sync page and click the Add Sync button
In the "What data do you want to sync?" section.
  • For the Connection, select the data warehouse you've already connected (See Prerequisites).
  • For the Source, select the model you created in step 4.
Next up is the "Where do you want to sync data to?" section.
  • Pick the Amplitude connection you created in step 3.
  • For Object, Select Device or User. If Devices can be associated with Users, then select Device. If no Device information is collected, select User.
For the "How should changes to the source be synced?" section.
  • Select Update Or Create
  • Pick the right mapping key; Amplitude only supports Distinct ID.
Finally, select the fields you want to update in the Mapper in the "Which Fields should be updated?" section. Here simply map the field from your Amplitude instance to the column from your model.
Click the Next button to see the final preview, which will have a recap of what will happen when you start the sync.

πŸ—„οΈ Supported Objects

Object Name
Device ID
User ID
Group Value
Insert ID
Both User and Device objects will resolve to a single User Profile in Amplitude. If Devices can be associated with Users, then select Device and map the User field to an appropriate value in your model. If no Device information is collected, select User.
πŸŽ’ Contact us if you want Census to support more Objects for this destination

πŸ”„ Supported Sync Behaviors

Learn more about what all of our sync behaviors on our Core Concept page.
Update or Create
Device, User, Group
Create Only
β€Œ πŸ”‹ Contact us if you want Census to support more Sync Behaviors for this destination

πŸš‘ Need help connecting to Amplitude?

​Contact us via [email protected] or start a conversation with us via the in-app chat.
Last modified 2mo ago