This guide covers the following:
Custom Data Object definitions
APIs used for data syncing
Volume and frequency of data syncing
Common errors and associated handling
Custom Data Object (CDO) Definitions
The 6sense platform is designed to push all required predictive data into Eloqua’s CDOs for the data to be available as a reference to all your workflows, and without requiring any changes to your Standard Objects. In order to achieve this, the following are some requirements that contain actions for your team:
Your Eloqua administration team must create the required CDOs within Eloqua. Information on how to create a CDO in Eloqua can be found here.
Each product category being modeled by 6sense will need to have separate 6sense fields as described in the CDO structure below.
CDO #1: Contact6sense (Required)
Field Label (Display Name) | Field Name | API Name | Data Type | Notes |
|---|---|---|---|---|
Eloqua Contact ID | originalExternalID | originalExternalID1 | Text (32) | |
Custom Key | customKey6sense | customKey6sense1 | Text (64) | |
Score Date | scoreDate6sense | scoreDate6sense1 | Date | |
Contacts Email | contactEmail6sense | contactEmail6sense1 | Text | |
6sense Contact Intent Score – <ProductCat> | contactIntentScore6sense_<ProductCat> | contactIntentScore6sense_<ProductCat>1 | Integer | * |
6sense Contact Profile Fit – <ProductCat> | contactProfileFit6sense_<ProductCat> | contactProfileFit6sense_<ProductCat>1 | Text (18) | * |
6sense Account Intent Score – <ProductCat> | accountIntentScore6sense_<ProductCat> | accountIntentScore6sense_<ProductCat>1 | Integer | * |
6sense Account Profile Fit – <ProductCat> | accountProfileFit6sense_<ProductCat> | accountProfileFit6sense_<ProductCat>1 | Text (18) | * |
6sense Account Buying Stage – <ProductCat> | accountBuyingStage6sense_<ProductCat> | accountBuyingStage6sense_<ProductCat>1 | Text (30) | * |
6sense Account Numerical Reach Score | accountNumericalReach6sense_<ProductCat> | accountNumericalReach6sense_<ProductCat>1 | Integer | |
6sense Account Reach Score | accountReach6sense_<ProductCat> | accountReach6sense_<ProductCat>1 | Text (18) | |
6sense Contact Reach Score | contactReach6sense_<ProductCat> | contactReach6sense_<ProductCat>1 | Text (18) | |
6sense Account Profile Score – <ProductCat> | accountProfileScore6sense_<ProductCat> | accountProfileScore6sense_<ProductCat>1 | Integer | * |
6sense Contact Grade – <ProductCat> | contactGrade6sense_<ProductCat> | contactGrade6sense_<ProductCat>1 | Text (18) | * |
6sense Contact Profile Score – <ProductCat> | contactProfileScore6sense_<ProductCat> | contactProfileScore6sense_<ProductCat>1 | Integer | * |
Replicate these fields as required for each product category being modeled by 6sense. Replace <ProductCat> with your desired product category name.
If you do not want to follow the recommended naming convention above, please ensure the API names do not start with a number.
CDO #2: Account6sense (Optional)
This CDO is optional. Its use depends upon your use cases within Eloqua and if you are using the Eloqua Account Object.
Field Label (Display Name) | Field Name | Eloqua API Name | Data Type | Notes |
|---|---|---|---|---|
Eloqua Account ID | originalExternalID | originalExternalID1 | Text (32) | |
Custom Key | customKey6sense | customKey6sense1 | Text (64) | |
6sense Account Intent Score – <ProductCat> | accountIntentScore6sense_<ProductCat> | accountIntentScore6sense_<ProductCat>1 | Integer | * |
6sense Account Profile Fit – <ProductCat> | accountProfileFit6sense_<ProductName> | accountProfileFit6sense_<ProductCat>1 | * | |
6sense Account Buying Stage – <ProductCat> | accountBuyingStage6sense_<ProductCat> | accountBuyingStage6sense_<ProductCat>1 | Text (30) | * |
Replicate these fields as required for each product category being modeled by 6sense. Replace <ProductCat> with your desired product category name.
If you do not want to follow the recommended naming convention above, please ensure the API names do not start with a number.
APIs Used for Data Syncing
We currently use Eloqua’s Bulk APIs to transport data from the 6sense Platform to Eloqua CDOs. Details of these APIs are available here.
Volume & Frequency of Data Syncing
While every customer’s data volume is different, here are some noteworthy points to help get an understanding of factors that drive volume and frequency of data syncs:
6sense syncs predictive intelligence data to Eloqua CDOs nightly using an Eloqua account provisioned by your Eloqua administration team for 6sense.
Only records with updated scores since the last sync are included.
The number of API calls used for exports depends on the amount of data to be exported which varies daily. 6sense maintains an internal cap of using up to only 700 API calls per day maximum that shared by both import and export syncs between Eloqua and 6sense.
From a performance perspective:
Each batch of records is limited to a maximum of 32MB. The number of records in a batch depends on the number of fields in each record, which in turn depends on the number of product categories that 6sense is predicting for your organization. The current average batch size is 150K records. Up to 10 API calls will be required for each batch.
On average, the time to import 10K record updates from 6sense to Eloqua is two (2) minutes.
When there are CDO data size constraints, and it is not feasible to store predictions for all records, 6sense can manually configure certain filters to reduce the volume. If this applies in your implementation, reach out to your 6sense Customer Success Manager to discuss options.
Common Errors and Associated Handling
This entire process generally faces very few error scenarios in our experience, but the common errors seen and resolutions are described below:
Login Failure: The export will be disabled, and the 6sense CSM will reach out to the customer to conduct a password reset.
Export Setup Failure: Usually caused by either incorrect field mappings (which 6sense will handle) or incorrect CDO structure (6sense will reach out to the customer to resolve).
If any other errors are seen, please reach out to your 6sense CSM or open a case.