Appreciation Engine: Import Users and Activity Feed
Import users and their activity feed from Appreciation Engine so you can use this data to build and refine your Lytics audiences.
Integration Details
- Implementation Type: Server-side.
- Implementation Technique: REST API.
- Frequency: Users and their activity data is batch imported hourly on a continuous basis.
- Resulting Data: Full user profiles for all Appreciation Engine users for the given Brand. The activity data related to the users will also be imported as additional user fields.
This integration utilizes the Appreciation Engine APIs to receive users and their activity data. On running the workflow, it will:
- Query for all users in your Appreciation Engine Brand to bring in the latest members.
- Bring in backfill members if configured to do so.
- Bring in the activity feed from your Appreciation Engine Brand. You can configure how far back in the activity feed you want to bring in.
Fields
The following fields are included in the default mapping of the appreciationengine_users stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
email unique id | string | ||
| facebook_user_id | fbuid unique id | Facebook User ID | string |
| twitter_user_id | twuser_id unique id | Twitter User ID | string |
| twitter_username | twuser_screenname unique id | Twitter Username | string |
| first_name | first_name | First Name | string |
| last_name | last_name | Last Name | string |
| city | city | City | string |
| set(id) | ae_profile_ids | Appreciation Engine IDs | array(string) |
| activity_count | ae_activity_count | Appreciation Engine Activity Count | number |
| score | ae_score | Appreciation Engine Score | number |
The following fields are included in the default mapping of the appreciationengine_activity stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
email unique id | Email Address | string | |
| hourofday() | ae_hourly | Appreciation Engine Active Hours of Day | number |
| hourofweek() | ae_hourofweek | Appreciation Engine Active Hours of Week | number |
| yymm() | ae_yymm | Appreciation Engine Active Months | number |
| type | ae_action_cnts | Counts for each type of action | number |
| service | ae_service_cnts | Counts for each service | number |
| max(epochms()) | last_active_ts | Last Active | date |
| emaildomain(email) | emaildomain | Email Domain | string |
| set(user_id) | ae_profile_ids | Appreciation Engine IDs | array(string) |
| user_id | ae_last_profile_id | Appreciation Engine Last ID | string |
Please contact customer support for any other fields you would like to map from Appreciation Engine to Lytics user fields.
Configuration
Follow these steps to set up and configure an import of Appreciation Engine users and activity in the Lytics platform.
- From Data > Integrations select the Appreciation Engine tile.
- Select the Import Users and Activity Feed workflow.
- Select the authorization you created in the previous step.
- If you want to import backfill users, check the Import Backfill Users option.
- (Optional) If you want to backfill activity data, enter the Activity Backfill Start Date in
yyyy-mm-dd format. If left blank it will default to the current date. This will only be used if the backfill end date is set. - (Optional) If you want to backfill activity data, enter the Activity Backfill End Date in
yyyy-mm-dd format. If left blank no backfill of activity data before this date will be imported. - (Optional) If you want this integration to keep user and activity data updated, select the Keep Updated checkbox.
- Click Start Import.
Users and activity feed data should begin appearing in the appreciationengine_users and appreciationengine_activity streams within a few minutes after starting the import.