The Twilio: Phone Lookup Application will allow the user to:
- Validate Eloqua Contacts Phone Numbers
- Append Phone Type (Mobile/Landline)
- Append Phone Carrier (AT&T/Verizon/Sprint/...)
This Guide will outline:
- How to configure Eloqua to receive lookup information
- How to add the Twilio: Phone Lookup App to an Eloqua Campaign
- How to create a new configuration using the Sureshot App
Configure Eloqua to Receive Lookup Information
The Twilio: Phone Lookup Application may be configured to write data to Eloqua Contact Fields, an Eloqua Custom Object, or Both. This must be configured before using the app.
Creating Eloqua Contact Fields for Twilio: Phone Lookup
- Open Eloqua
- Click the Settings gear on the top right of the page
- Click 'Fields and Views' under the Database Setup section
- On the next page, click the plus sign on the bottom left.
- Click 'Add Contact Field'
- The edit screen for the new Contact Field will appear. Input 'Phone Lookup - Phone Number Result' in the 'Display name' field. Other fields should appear as follows:
- Once completed, click the 'Save' button on the bottom right.
- Repeat steps 2-6 to create 6 additional Contact Fields for the Phone Lookup application. Here are names of the new Contact Fields the application will use:
- Phone Lookup - National Format
- Phone Lookup - Country Code Result
- Phone Lookup - Lookup Status
- Phone Lookup - Lookup Status Message
- Phone Lookup - Carrier Name
- Phone Lookup - Phone Type
Creating an Eloqua CDO for Twilio: Phone Lookup
- Open Eloqua
- Click the Contacts Menu and select "Custom Object"
- Click Custom Object
- Click New Custom Object
- In the "Display Name Field'' enter 'Twilio Lookup Results'. Other fields should appear as follows
- Click Next
- In the top right click "Custom Object Record Fields"
- Click "Add New Field"
- For "Field Name" enter 'Phone Number Result'. Configure the following fields as follows:
- Click Save
- Repeat steps 7-9 to create the following fields:
- Phone Lookup - National Format
- Phone Lookup - Country Code Result
- Phone Lookup - Lookup Status
- Phone Lookup - Lookup Status Message
- Phone Lookup - Carrier Name
- Phone Lookup - Phone Type
- Click Next at the bottom right
- Click Next again
- Click Save. The new Twilio Custom Object should appear as follows
Adding and Configuring the Twilio Lookup Application in an Eloqua Campaign
- Create a new Eloqua Campaign
- Using the Campaign Steps Menu add a "Segment Members" and a "Wait" Step
- Using the same "Campaign Steps Menu" add "Phone Lookup Validation" step to the campaign
Note: If the application does not appear in the menu click the Arrow next to "Campaign Steps" to view more options - Double Click the application to open the edit window
- Click the Pencil icon to begin creating a new configuration
- The Sureshot Portal will open inside of Eloqua. If this is the first use of the application the user will be prompted to enter Sureshot Platform Credentials
- Begin by naming the configuration. This name will be used to identify each instance of the application
- Under Contact Fields choose the Eloqua Contact field containing the phone number to be processed by the application
- To write data back to an Eloqua Contact map each field to the corresponding Eloqua Contact Field
Note: Carrier Name and Phone Type are Optional lookup fields. If mapped the user will incur extra charges - To map lookup results to CDO click the checkbox next to "CDO Mapping Fields"
- Select the Eloqua Custom Object where the data will be written
- Click the checkbox next to "Use Email Address as Id" to map the Eloqua Contact Email to the Id Field in the CDO. If left unchecked the application will generate a unique identifier
- Map the ID field to the Corresponding CDO Field
- Map the application to the corresponding CDO Fields where look data will be written
- Click Submit
- A green success box will indicate your new configuration has been created and saved
- Close the Sureshot Window
- Connect the Application to the rest of the Campaign
- Save the Campaign
- Activate the campaign to begin processing Eloqua contacts
Phone Lookup Results Definitions
- Phone Number Result - A properly formatted version of the phone number submitted.
- National Format - A properly formatted version of the number based on the specific country format the number is from.
- Country Code Result - The specific country code for the submitted number.
- Lookup Status - Identifies is the number is valid or not (True or False).
- Lookup Status Message - The lookup API response for the validation (contains error messages, etc.)
- Carrier Name (Advanced): Lists the name of the carrier the phone number is tied to such as Verizon, AT&T, etc.
- Phone Type (Advanced): Lists the type of number such as landline, mobile, voip, etc.