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

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?

• Grab our Eloqua starter’s guide
• Read articles on tools such as the contact washing machine
• Learn how we can help you with our Eloqua consulting practice – we’re a Platinum Partner!