If this, then that: A guide to creating Lookup Tables in Eloqua

August 4, 2016  |  
By The Pedowitz Group (TPG)
  |  Technology
August 4, 2016
By The Pedowitz Group (TPG)

A Lookup Table contains useful data for automatically updating records with other data. The table itself is quite easy to build, and can help you with your system processes on a regular basis.

There are many things that a Lookup Table can do within Eloqua. Below are a few examples of other useful items that a Lookup Table can be used for.

  • Assign a state to a field based on a zip code
  • Translate a short code to a full-length word in another field
  • Update a sales region by state/zip
  • Update industry from a SIC code

Lookup Tables can be found in Eloqua under Data Tools: Visit Audience > Tools > Data Tools > Lookup Tables

1 1

Creating one is very easy. Visit the Data Tools Small Menu > New Lookup Table

if this 2 2 1
  1. Name your Lookup Table
  2. Place it in a folder
  3. Enter your Lookup value Column Name
  4. Enter your Replacement Column Name

Pretty easy right?

There are two ways to update your table data: one by one or as an import.

if this 5 2 1
  1. In your program, add a new step where the data will be updated.
  2. Select Run Update Rule Set
if this 4 2 1
  1. Create a new Update Rule
  2. The language of your rule is to update your field, with the look up table value when the field data matches the lookup table key.
if this 3 2 1

Using a lookup for something custom to your company can be a helpful tool. Think outside the box: if “you have this, you can write that” automatically!

Want More Eloqua?

You May Also Like…

The Power of Experiential Marketing: A Conversation with Brook Jay

Uncover insights into innovative marketing approaches with Brook. Learn about the Hybrid Collective model and forging genuine brand connections.

Get in touch.

Send Us an Email

Schedule a Call