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

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

  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.

  1. In your program, add a new step where the data will be updated.
  2. Select Run Update Rule Set

  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.

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?