Introduction

Census is a Reverse ETL platform that makes it easy to connect your data warehouse to sales, marketing, and other customer-facing tools that drive your business.

MoEngage <> Census

The MoEngage and Census integration allows you to bring in user and event data from your data warehouse directly into MoEngage. Census can help you keep your customers' data always up-to-date so you can create better-targeted campaigns and customer experiences.

Use Cases

• Sync data about users from Census into MoEngage to build personalized campaigns.
• Sync Customer Events from Census into MoEngage to keep the events up-to-date.
• Deliver better experiences by bringing data from other customer touchpoints into MoEngage.

Integration Prerequisites

• Ensure you have access to your Census account. 
• We have revamped our dashboard settings UI. The Data API ID and Data API Key are available in the following navigations in the new and old UIs.
  • Revamped UI - You can access the Data API ID  in Settings -> Account -> APIs . The Data API ID is the same as the Workspace ID. The Data API Key is available in the same screen in the API Keys -> Data section.
  • Old UI -> You can access the Data API ID and Data API Key in Settings -> App Settings -> APIs -> Data API Settings.  

Connect MoEngage to Census

1. On your Census Dashboard, go to Connections >> "+ New Destination".
2. Search for MoEngage and select.
3. In step 2, you need to configure the following:

4. Click "Connect" after filling in the required details.
5. Census will automatically attempt to test the credentials you've entered.

6. Once your connection is verified, click on "Finish" to add MoEngage as a destination.

Send Users to MoEngage

1. On your Census Dashboard, go to Syncs >> "+ Create a new Sync".
2. Under "Select a Source", choose a connection and its source. Then select the schema and the table you want to sync.
3. Under "Select a Destination", choose "MoEngage" as a connection. Under Object, select "Customer".

4. Select a Sync Behavior. MoEngage supports only "Update or Create".
5. Select a Sync Key. This defines key identifies matching data in MoEngage. Census will use this key to determine which data will sync during each sync run. The column and field should have the same unique value.
6. Under "Set Up MoEngage Field Mappings", select whether you want to sync specific properties or all properties.

7. When you add a mapping, Census will automatically match some of the standard properties in MoEngage. You can also opt to create new properties inside MoEngage.
8. Once you are done with the mapping, optionally you can choose to "Run a Test Sync".
9. Click "Next" once done.
10. Confirm your sync details, and click on "Create Sync" to create a new sync. You can also choose to "run a sync now".
11. Census will then run periodic syncs to keep the data between Census and MoEngage always up-to-date.

Send Events to MoEngage

1. On your Census Dashboard, go to Syncs >> "+ Create a new Sync".
2. Under "Select a Source", choose a connection and its source. Then select the schema and the table you want to sync.
3. Under "Select a Destination", choose "MoEngage" as a connection. Under Object, select "Event".

4. Select a Sync Behavior. MoEngage supports only "Append".
5. Select an Append Key. An append key is a column that identifies unique records in your table. Census will use this to know when to add a new record.
6. Under "Set Up MoEngage Field Mappings", select whether you want to sync specific properties or all properties.

7. When you add a mapping, Census will automatically match some of the standard properties in MoEngage. You can also opt to create new properties inside MoEngage.
   1. It is mandatory to sync "Action" (Event Name) and "Customer ID".
8. Under "Should existing data be synced?", you can either choose to "Backfill All Records" or "Skip Current Records".

9. Once you are done with the mapping, optionally you can choose to "Run a Test Sync".
10. Click "Next" once done.
11. Confirm your sync details, and click on "Create Sync" to create a new sync. You can also choose to "run a sync now".
12. Census will then run periodic syncs to keep the data between Census and MoEngage always up-to-date.