Lookup Tables in Segmentation
You can use Lookup Table fields directly in Dynamic Segments to filter users based on shared metadata. Insider One resolves the value at evaluation time by matching the bound attribute or event value to the table's join key.
Example: with a "Products" table bound to the purchase event's item_id, you can target "users who purchased a product where in_stock = false" or "…where category = electronics".
Because segments resolve against the latest table data, updating a row automatically changes who qualifies.
To use a lookup table in segmentation:
Navigate to Segments > Dynamic Segments.
Select the appropriate segment condition:
For attribute-based binding: Under the Standard tab, select the lookup table condition.
For event-based binding: Under the event conditions, select lookup table fields
Choose the lookup table and the field to filter on.
Apply operators and values.
You can use a maximum of five lookup-based filters per segment.
Lookup Tables on User Profiles
When a lookup table is bound to a User Profile attribute, the matched lookup data is visible on the User Profile page.
This gives you a quick view of the reference data for each user without navigating to the lookup table.
