Documentation / Product / Integrations / GIGYA

GIGYA: Import Users

Import GIGYA contacts and email subscriptions into Lytics to build a more complete view of your customers. You can import from full accounts and lite GIGYA (SAP Customer Data Cloud) accounts.

Integration Details

This integration utilizes the GIGYA APIs to import user data. Once the import is started the workflow will:

  1. Validate credentials by getting the user schema.
  2. Search for users that have been updated since the last import.
    1. Initial search request: SELECT * FROM accounts WHERE lastUpdatedTimestamp >= <last import date> ORDER BY lastUpdatedTimestamp LIMIT 10000, and openCursor = true.
    2. Page through results.
  3. Search for lite users that have been updated since the last import.
    1. Initial search request: SELECT * FROM emailAccounts WHERE lastUpdatedTimestamp >= <last import date> AND hasLiteAccount=true AND hasFullAccount=false ORDER BY lastUpdatedTimestamp LIMIT 10000, and openCursor = true.
    2. Page through results.
  4. Search for subscriptions that have been updated since the last import.
    1. Initial search request: SELECT * FROM emailAccounts WHERE subscriptions.<subscription name>.email.lastUpdatedSubscriptionState > <last import date>, and openCursor = true.
    2. Page through results.
  5. Ingest the data from the searches into the gigya_users stream.

Fields

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

Source FieldLytics User FieldDescriptionType
instagram_idinstagram_id unique idInstagram IDstring
is_registeredis_registeredUser registered in GIGYAboolean
twitter_idtwuser_id unique idTwitter IDstring
twitter_nametwuser_screenname unique idTwitter usernamestring
idgy_profile_id unique idGIGYA Distinct IDstring
google_idgoogle_id unique idGoogle IDstring
facebook_idfbuid unique idFacebook User IDstring
emailemail unique idEmail Addressstring
addressaddressAddressstring
birth_daybirth_dayBirth Daystring
birth_monthbirth_monthBirth Monthstring
birth_yearbirth_yearBirth Yearstring
citycityCitystring
countrycountryCountrystring
domain(email)emaildomainEmail Domainstring
first_namefirst_nameFirst Namestring
gendergenderGenderstring
lite_accountgy_lite_accountGIGYA Lite Accountbool
login_providergy_login_providerGIGYA Login Providerstring
site_idgy_site_idGIGYA Site IDstring
map(subscription_name, modified)gy_subscription_modified_dateGIGYA Subscription Modified Datemap[string]time
map(subscription_name, double_optin-status)gy_subscription_optin_statusGIGYA Subscription Optin Statusmap[string]string
map(subscription_name, todate(subscribed))gy_subscriptionsGIGYA Subscriptionsmap[string]bool
createdgy_user_createdGIGYA Profile Createddate
last_logingy_user_last_loginGIGYA Profile Last Logindate
last_updatedgy_user_updatedGIGYA Profile Updateddate
last_namelast_nameLast Namestring
statestateStatestring
zipzipZipstring

Configuration

Follow these steps to set up and configure an import of GIGYA users into the Lytics platform.

  1. Navigate to GIGYA in the Integrations section of Lytics. gigya integration tile
  2. Select Workflows from the menu on the left.
  3. Select Import Users from the list.
  4. Select the authorization you would like to use.
  5. In the Import Since box, enter the date from which you want to import data using the YYYY-MM-DD format. If left blank, Lytics will import all available data.
  6. From the Extended Data Fields input, select additional data fields to import to Lytics. Basic profile data will automatically be imported.
  7. Click on the Show Advanced Options tab to expand the advanced configuration.
  8. Select the Keep Updated checkbox to continuously run this import hourly.
  9. Click the Start Import button to start the workflow. gigya integration import config