Documentation / Product / Integrations / Appreciation Engine

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:

  1. Query for all users in your Appreciation Engine Brand to bring in the latest members.
  2. Bring in backfill members if configured to do so.
  3. 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 FieldLytics User FieldDescriptionType
emailemail unique idEmailstring
facebook_user_idfbuid unique idFacebook User IDstring
twitter_user_idtwuser_id unique idTwitter User IDstring
twitter_usernametwuser_screenname unique idTwitter Usernamestring
first_namefirst_nameFirst Namestring
last_namelast_nameLast Namestring
citycityCitystring
set(id)ae_profile_idsAppreciation Engine IDsarray(string)
activity_countae_activity_countAppreciation Engine Activity Countnumber
scoreae_scoreAppreciation Engine Scorenumber

The following fields are included in the default mapping of the appreciationengine_activity stream:

Source FieldLytics User FieldDescriptionType
emailemail unique idEmail Addressstring
hourofday()ae_hourlyAppreciation Engine Active Hours of Daynumber
hourofweek()ae_hourofweekAppreciation Engine Active Hours of Weeknumber
yymm()ae_yymmAppreciation Engine Active Monthsnumber
typeae_action_cntsCounts for each type of actionnumber
serviceae_service_cntsCounts for each servicenumber
max(epochms())last_active_tsLast Activedate
emaildomain(email)emaildomainEmail Domainstring
set(user_id)ae_profile_idsAppreciation Engine IDsarray(string)
user_idae_last_profile_idAppreciation Engine Last IDstring

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.

  1. From Data > Integrations select the Appreciation Engine tile. appreciation engine
  2. Select the Import Users and Activity Feed workflow.
  3. Select the authorization you created in the previous step.
  4. If you want to import backfill users, check the Import Backfill Users option.
  5. (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.
  6. (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.
  7. (Optional) If you want this integration to keep user and activity data updated, select the Keep Updated checkbox.
  8. Click Start Import.

appreciation engine 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.