The Eloqua Upload Wizard enables marketers to enhance data quality by eliminating manual pre-processing steps and ensuring that every upload performs the same data normalization and standardization steps automatically. It also allows marketing teams to distribute upload tasks by training non-Eloqua users to import additional data without risking data quality. Improved error reporting allows Eloqua administrators to update processing rules to accommodate new data outliers seamlessly.
Key Benefits
Eliminates bad data at the source by applying a standard set of data normalization and standardization to all records
Enables non-Eloqua users to upload data without reducing data quality
Improved error notification with detailed reasons helps quickly update rules
Administrators can control who can access the upload wizard
Sends detailed email notifications for completed uploads, including:
Records in the import file
Contacts imported
Contacts created, updated, or excluded
Attaches failed uploads in a CSV file
Upon record rejection, it contains detailed explanation(s) of the problem
Customer Reviews
“The Upload Wizard from 4Thought Marketing is my new best friend. It reduced the time required to process new leads from days to minutes and to get them into the hands of sales much faster.”
Multiple upload templates with pre-defined field mappings that are not user-editable
Validate a field and only accept values found in a user-editable custom object
Normalize a field and update values using matching records in a user-editable custom object (for example, configure “USA” to update to “United States”)
Configure how to handle duplicate records, including always accepting the first but rejecting additional duplicates, or rejecting all duplicates
Enforce data privacy requirements that invoke additional validation to confirm consent or mark the record as an error due to consent issues
Create custom objects with uploaded data if certain conditions are met
Set static values to fields based on field values in the upload data
Add a prefix to specific field values to show the data came from the upload wizard
Validate fields using Eloqua standards (date fields, # of characters, etc.)
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
The Field Contains Cloud App helps improve data quality by comparing two fields to determine if the lookup field contains all or part of the source. It’s especially handy when trying to clean junk in your database.
For example:
If “First Name” [John] is contained in “Last Name” [John], it’s likely somebody filled out a form with junk data.
Do you have two country fields, one that comes from ERP and one from CRM? Compare the two and if they don’t match, route them to corrective action.
Automatically check your records to determine if they need routing to a data enrichment solution.
Key Benefits
Compare two fields and return true if they are the same
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
The Field Equals Field Cloud App helps improve data quality by comparing fields to determine if they are identical. It’s especially handy when trying to clean junk in your database.
For example:
If “First Name” and “Last Name” are both [John], it’s likely somebody filled out a form with junk data.
Do you have two country fields, one that comes from ERP and one from CRM? Compare the two and if they don’t match, route to corrective action
Automatically check your records to determine if they need routing to a data enrichment solution.
Key Benefits
Compare two fields and return true if they are the same
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
The Field Length Indicator Cloud App checks to see if a field length is less than or equal to the configured value and returns to the Yes or No path on your campaign or program canvas.
Key Benefits
Helps identify fields with value lengths shorter than expected
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
The Force Field Length Cloud App can be handy if you have fixed-length fields in your CRM, ERP, or other systems integrated with Oracle Eloqua. The most common usage of this app is to truncate a field to a certain number of characters. A less common usage of the app is to pad a field value with spaces if it does not meet the minimum number of characters required.
Key Benefits
Truncate or pad a value so it has a specified minimum or maximum field length
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
Over time, duplicate contacts creep into Eloqua. The most common example is when individuals move between companies and change email addresses. Another is when your Eloqua instance receives data from social media platforms, so instead of receiving a business email address, you get a contact’s @gmail.com or @outlook.com address.
The Merge Contacts Cloud App allows Oracle Eloqua users to select two records to merge, preview existing data, and select which field values to preserve. As part of the merge process, it retains most of the activity history by creating external activities* before deleting the duplicate contact.
Key Benefits
Easily configure contact fields to display in merge contact UI and specify fields for merging
Preserve historical email address by storing it in a custom object mapped to the merged contact
Backup contact details before merging to an SFTP server
Review contact fields side by side with an intuitive user interface
Preview the proposed final record before confirming changes, merging, and contact deletion
*Subject to the limitations of Eloqua’s external activities.
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
The North America Phone Formatter Cloud App ensures phone numbers follow a standardized format: (aaa) ppp-nnnn x0000. Keeping this field clean and as error-free as possible helps sales reps, auto-dialers, and tools that use a phone number for data analysis. If a number is less than ten characters, the number will not be formatted so that no data is lost.
This cloud app can be paired with our Field Length Indicator Cloud App to catch incomplete phone numbers and process them appropriately, and the CO Regex Cloud App to format phone numbers stored in custom objects.
Key Benefits
Applies the specific US and Canadian phone number format to data
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
The State Normalization Cloud App helps improve data quality by ensuring state names follow a standard format by correcting spelling mistakes and other non-standard variations.
Key Benefits
Improves data quality by standardizing field values for segmentation
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
The String Deleter Cloud App helps improve data quality by surgically removing unwanted character strings. Examples include eliminating honorifics, name prefixes or suffixes, company suffixes, or special characters. The app can also be configured to remove other bad data from integrations or form submissions.
Key Benefits
Remove unwanted honorifics, name prefixes, or suffixes
Eliminate non-standard Company suffixes like Inc, LLC, Co, Ltd.
Remove special characters anywhere in the field ( -, &, :,)
Process up to 50 strings simultaneously
Details
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.
The Unlinked CO Mapper matches orphaned Eloqua custom object records with matching contact records to create a complete customer profile for your marketing campaigns. Key Benefits
Re-map custom objects with contact records previously removed for inactivity
Restore contact history for returning contacts
Enables Eloqua users to manage their contact count efficiently
Each Eloqua instance requires a separate cloud app license.
Each cloud app license includes a reasonable usage limitation of 250k records processed daily and up to 5 app instantiations per Eloqua instance. Higher usage tiers are available at extra cost.