Marketing Console Users Guide

Lookups

Lookups provide powerful capability to write data driven rules. Instead of coding every condition explicitly, lookups allow looking up values from a look table based on one or more keys.

A lookup table has one or more key columns, and one or more value columns. An example lookup table, where ‘member_tier’ and ‘booking_code’ are keys and ‘bonus’ and ‘point_bonus’ are value:

member_tier booking_code bonus point_bonus
Silver E 0.10 0.05
Silver M 0.25 0.15
Gold E 0.20 0.20
Gold M 0.45 0.35
default   0.05 0.05

The example assumes ‘bonus’ is a discount rate and ‘point_bonus’ is additional points awarded to different members.

Instead of coding how to compute the bonus based on member_tier and booking_code in rules using expressions, it can be looked up from the above lookup table.

Note: Lookup tables are csv files, NOT XLS files.

Also See