North America Phone Formatter Cloud App Documentation

Purpose

Sometimes you need to have your data cleaned and consistent. This cloud action formats a given number from a selected field into the Standard US/Canada phone format (AAA) PPP NNNN. If the number is less than 10 characters, the number will not be formatted.

This document will show how this Cloud Action can be used inside Campaign Canvas.

Set-up in Oracle Eloqua

Please follow these instructions to set up this cloud app in your Oracle Eloqua instance.

  • Log in to Oracle Eloqua.
  • Click on Get App below to install.

     NOTE: If prompted to log again, please do so.

  • On the next screen, click “Accept and Install” on the top-right section
North America Phone Formatter Cloud App Documentation 14
  • You’re all set. The cloud action is ready to be used
North America Phone Formatter Cloud App Documentation 15

How to use

The following instructions show a basic/simple usage.  You can incorporate this Cloud Action to any existing campaign.

  • Create/Open a campaign
  • Click on “Actions” on the top left side then “Show All Steps” and then locate the “North America Phone Formatter” Cloud Action under the Actions options (colored in purple).
North America Phone Formatter Cloud App Documentation 16
North America Phone Formatter Cloud App Documentation 17
  • Drag and drop the cloud action to the canvas area. Connect the corresponding elements to the dropped cloud action
North America Phone Formatter Cloud App Documentation 18
  • Double click the North America Phone Formatter step, you will see some options for this element.
    • Rename the step if needed  
North America Phone Formatter Cloud App Documentation 19
  • Click the pencil icon to open the settings for this step.

You will need a user to log in and configure this Cloud Action. If you don’t have one, you can create one. If you do, use your user to Log In in the page shown in the following screenshot:

North America Phone Formatter Cloud App Documentation 20

For this cloud action, you just need to indicate which Contact field has the numbers you want to format (Source). The formatted phone number (Destination) field can be the same as the Source or other contact field.
Click “Save Settings” when you have finished indicating the contact fields.

If you have done changes and you want to have the initial values, use the “Revert Changes” button

North America Phone Formatter Cloud App Documentation 21
  • Recommended: Create an element in the campaign in case an error happens, in this example it’s a Wait Step. Check the box to “Automatically route contacts with errors from cloud app”, select the step where you want the contacts to be routed.
North America Phone Formatter Cloud App Documentation 22
  • That’s all. Activate the campaign, put some contacts in it and see the North America Phone Formatter in Action!

License Information

You need a license to configure and execute this Cloud App. Otherwise in the configuration page you will see the following error:

North America Phone Formatter Cloud App Documentation 23

Additionally, if you happen to see records stuck in the Cloud Action step, it may be due to a missing or expired License which you can get with your corresponding Account Manager.