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
- Implementation Type: Server-side.
- Implementation Technique: REST API.
- Frequency: Batch with option for continuous, hourly updates.
- Resulting data: User profiles and User fields.
This integration utilizes the GIGYA APIs to import user data. Once the import is started the job will:
- Validate credentials by getting the user schema.
- Search for users that have been updated since the last import.
- Initial search request:
SELECT * FROM accounts WHERE lastUpdatedTimestamp >= <last import date> ORDER BY lastUpdatedTimestamp LIMIT 10000, andopenCursor = true. - Page through results.
- Initial search request:
- Search for lite users that have been updated since the last import.
- Initial search request:
SELECT * FROM emailAccounts WHERE lastUpdatedTimestamp >= <last import date> AND hasLiteAccount=true AND hasFullAccount=false ORDER BY lastUpdatedTimestamp LIMIT 10000, andopenCursor = true. - Page through results.
- Initial search request:
- Search for subscriptions that have been updated since the last import.
- Initial search request:
SELECT * FROM emailAccounts WHERE subscriptions.<subscription name>.email.lastUpdatedSubscriptionState > <last import date>, andopenCursor = true. - Page through results.
- Initial search request:
- Ingest the data from the searches into the
gigya_usersstream.
Fields
The following fields are included in the default mapping of the gigya_users stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| address | address | Address | string |
| birth_day | birth_day | Birth Day | string |
| birth_month | birth_month | Birth Month | string |
| birth_year | birth_year | Birth Year | string |
| city | city | City | string |
| country | country | Country | string |
| created | gy_user_created | GIGYA Profile Created | date |
| email(email) | email unique id | Email Address | string |
| emaildomain(email) | emaildomain | Email Domain | string |
| facebook_id | fbuid unique id | Facebook User ID | string |
| first_name | first_name | First Name | string |
| gender | gender | Gender | string |
| google_id | google_id unique id | Google ID | string |
| id | gy_profile_id unique id | GIGYA Distinct ID | string |
| instagram_id | instagram_id unique id | Instagram ID | string |
| is_registered | gy_is_registered | GIGYA Is Registered | string |
| last_login | gy_user_last_login | GIGYA Profile Last Login | date |
| last_name | last_name | Last Name | string |
| last_updated | gy_user_updated | GIGYA Profile Updated | date |
| login_provider | gy_login_provider | GIGYA Login Provider | string |
| map(subscription_name, double_optin-status) | gy_subscription_optin_status | GIGYA Subscription Optin Status | map[string]string |
| map(subscription_name, subscribed) | gy_subscriptions | GIGYA Subscriptions | map[string]bool |
| map(subscription_name, todate(modified)) | gy_subscription_modified_date | GIGYA Subscription Modified Date | map[string]time |
| site_id | gy_site_id | GIGYA Site ID | string |
| state | state | State | string |
| tobool("true") | gy_lite_account | GIGYA Lite Account | bool |
| twitter_id | twuser_id unique id | Twitter ID | string |
| twitter_name | twuser_screenname unique id | Twitter username | string |
| zip | zip | Zip | string |
Configuration
Follow these steps to set up and configure an import job for Gigya in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select Gigya from the list of providers.
- Select the Import Audiences job type from the list.
- Select the Authorization you would like to use or create a new one.
- Enter a Label to identify this job you are creating in Lytics.
- (Optional) Enter a Description for further context on your job.
- Complete the configuration steps for your job.
- (optional) In the Import Since text box, enter the date from which you want to import data using the
YYYY-MM-DDformat. If left blank, Lytics will import all available data. - (optional) From the Extended Data Fields input, select additional data fields to import to Lytics. Basic profile data will automatically be imported.
- (Optional) Toggle Show Advanced Options. Select the Keep Updated checkbox to run this import hourly.
- Click Start Import.
