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
- Name your Lookup Table
- Place it in a folder
- Enter your Lookup value Column Name
- Enter your Replacement Column Name
Pretty easy right?
There are two ways to update your table data: one by one or as an import.
- In your program, add a new step where the data will be updated.
- Select Run Update Rule Set
- Create a new Update Rule
- 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!