Eloqua

Skip to end of metadata
Go to start of metadata

Overview

The Eloqua plugin allows you to seamlessly integrate your Gigya user data with Oracle's Eloqua marketing service. It automates the transfer of user social data between Gigya and Eloqua, transferring data in both directions using APIs to control transmission and receipt of data. Bulk data transfers of the entire user list can be scheduled ad-hoc and automated daily updates (at preset times) used to transfer new and updated users.

Synchronization is performed in two separate jobs - one transfers information from Gigya to Eloqua, creating and updating users as needed, and the other transfers information from Eloqua to Gigya, updating existing users (the integration cannot create new users in Gigya).

See the Eloqua_configuration for configuring Eloqua to work with this integration. See also the list of details you will need to supply to Gigya so that the integration can be set up for you.

See examples:

Integration with Eloqua is a premium service and can only be activated if your site package includes Gigya's Identity Access and Storage or Registration-as-a-Service. For activation and more information, please contact your Gigya Account Manager or enter a support request on our site.

For inbound user synchronization, the integration with Gigya can only update data for users already existing in Gigya's database. New users are not created.


Eloqua Configuration

The following items need to be defined in Eloqua:

  1. The Gigya ID field needs to be added to the contact fields.
  2. Custom objects need to be defined for storing Facebook Likes and Favorites.

Please create a test site in the Gigya admin console for integration testing (don't use your production site) and use a test list on the target integration platform. We are able to put integrations in "sample mode" for testing, which will restrict audiences to 10 sample accounts.

 Work with your Eloqua account team to ensure that the Eloqua integration is defined correctlyYour customer support team can test that data transfers successfully from Gigya to Eloqua and vice versa. 

Adding the Gigya ID field to the contact fields  

Transfers of data from Eloqua to Gigya are faster and more effective if contact data stored by Eloqua includes the Gigya user ID.

  1. Click the "Settings" button at the top of the window and then select "Setup", this opens the "Application Setup" page.
  2. In the "Database" row, select "Fields and Views".

  3. Click the plus button at the bottom of the window and select "Add Contact Field".

  4. Add the "Gigya UID" field (see below) and click the "Save" button.  The "Save" action automatically generates a field in the Eloqua contacts database  and after the Save action the field's "Database name" will appear. Thus the database name for the Gigya UID will be (in the example shown below), "C_Gigya_UID1", although the Display Name shows Gigya UID.  You will need to know the field's database name for mapping with Gigya.

Defining Custom objects for storing Facebook Likes and Favorites

If you want to transfer Facebook Likes or Favorites data to Eloqua:

Likes and Favorites are stored in objects whose content Eloqua is only able to read after the object is setup on their site.  These objects need to be configured before transferring the data.

To set up a Likes or a Favorites object on Eloqua (note that separate objects must be defined for Likes and Favorites): 

  1. Click the "Contacts" button at the top of the window. 
  2. Select "Custom Objects"

  3. Click "New Custom Object" 

  4. In the "Custom Object Details", enter a Display Name, Type and Description.  In the Place in Folder field select "Custom Objects".

  5. In the "Default Entity Mapping Used in Upload", enter Contacts in the "Entity Type" and Email Address in the "Entity Field".

  6. Click the "Next" button at the bottom right hand corner of the window.

  7. In the top right of the window, click the down arrow next to "Custom Object Record Fields" and select "Add new Field".

  8. Enter each of the fields you want mapped from the Gigya Profile object's Likes and Favorite objects:

    • For Favorites you need the following fields:

      Field NameRequiredData TypeGigya field used for mappingPurpose
      OIDRequiredText  Unique Eloqua identifier
      emailRequiredTextprofile.emailConnects object to user
      GIDRequiredTextGigya Account UIDConnects object to user
      Type Textprofile.favorites.interestsFacebook favorite type
      Name Textprofile.favorites.interests.nameFacebook favorite name
      Category Textprofile.favorites.interests.category    Facebook favorite category
    • After you create a field, press "Save and Close" and then add another field as required.

    • At the end you should have the following fields:

    • For Likes you need:

      Field NameRequiredData TypeGigya field used for mappingPurpose
      OIDRequiredText  Unique Eloqua identifier
      emailRequiredTextprofile.emailConnects object to user
      GIDRequiredTextGigya Account UIDConnects object to user
      Type Textprofile.likesFacebook favorite type
      Name Textprofile.likes.nameFacebook favorite name
      Category Textprofile.likes.category    Facebook favorite category
    • Note that the Likes fields are required for a "Likes" object. If you are defining a "Favorites" object this is not relevant.

  9. When you have finished defining the fields, in the top right hand corner select "Custom Object" and then "Field Mapping".

  10. In the "Custom Object Record Field Mapping to Entity" window, select the Contact DB fields that you want the Custom Object fields to be copied to.
    Note: You may need to create fields in the Contact DB if they do not yet exist. If you do, use the instructions in Adding the Gigya ID field to the Contact fields

Gigya Configuration: Required Information

The Gigya configuration is managed by your Account Manager, who will need the following information:

  • Run times: Run frequency settings and a time of day for the run in UTC hh:mm  (GMT) time.
  • Field mappings: A list of Eloqua fields you want connected to Gigya. Pass the names of the Eloqua fields as they are stored in the database, on the left, and matching Gigya fields on the right. As a minimum you must provide the email and Gigya UID . For example {C_EmailAddress=profile.email, C_Gigya_UID1=UID, C_FirstName=profile.firstName, C_LastName=profile.lastName}.  To see how to obtain the Eloqua database field names see Adding the Gigya ID field to the contact fields, in particular section 4.
  • Likes & Favorites mapping and object IDs: Names of the Eloqua objects which will store Facebook Like and Favorites information and their field mappings. Instructions for finding the object IDs are provided below.  
  • Inbound mappings: If you are transferring unsubscribe data from Eloqua to Gigya you will need to provide details of the field mappings for this information.
  • Eloqua system credentials: Your Eloqua sign-in details. Your Eloqua user should have its permissions set to "Advanced Users – Marketing and API Users".

Locating the identifiers of the custom objects storing Facebook Likes and Favorites

Instructions for locating the Eloqua object identifier:

  1. Click the "Contacts" button at the top of the window and select "Custom Objects".
  2. Locate the object you defined on the left hand side and hover over it with the mouse.

  3. A javascript fragment will appear at the bottom of the window on the left, copy the name of the object you hovered over and the "ViewDataCardSet" number, which is the unique identifier of that object.
    In the following example, object "Favorite2" is being hovered over, and its unique identifier is 17.

Eloqua Error Reports

Please forward any Eloqua error reports you receive to esp@gigya.com.

Example of Eloqua data after integration

Defining an Eloqua segment using Facebook data

  1. Click the Contacts button at the top of the window, then select "Segments".
  2. In the dialog box, select "Create a Segment" and then choose to create a blank segment.

  3. Click the plus button and select "Filter Criteria".

  4. Double click the "Has Linked Contact in Custom Object" option on the right, or drag-and-drop it into the middle.

  5. Double click the "Has Linked Contact in Custom Object" item in the middle and then select the custom object containing your like or favorites data.

  6. Click the Add button and then double click to edit the field connection and set the Likes/Favorites category you want selected in the segment.  Click "Finish" to save your settings. 

  7. On the left side of the window, click the refresh button to load the relevant contacts.

  8. In the above example, 19 contacts were found. Click the "View Contacts" button at the top right to view the contacts.