Lookup Tables let you store shared reference data in Insider One, such as product details, store information, or subscription plan specifications, and activate it across your audiences without duplicating that data on every user profile or event. Each table contains rows of reference data linked to your users and events via a primary key. You define the table schema, bind the primary key to a user attribute or an event parameter, and reference the table columns directly when you build segments. Because the data lives in one place, updating a row automatically updates every segment that references it.
You can load data into a Lookup Table in two ways: upload a CSV file through the InOne panel or send rows programmatically through the Lookup Tables API.
Explore Lookup Tables
How Lookup Tables Work
Understand the data model, primary keys, bindings, activation rules, limits, and industry use cases before you create your first table. See How Lookup Tables Work.
Manage Lookup Tables from InOne
Follow the step-by-step panel workflow to create a table, upload CSV data, set up bindings, publish, and monitor table statuses. See Manage Lookup Tables from InOne.
Manage Lookup Tables via API
Create tables, upsert and delete rows, add columns, and export data programmatically, with request and response examples for every endpoint. See Manage Lookup Tables via API.
Use Lookup Tables across InOne
Filter users in Dynamic Segments with lookup table columns and view matched reference data on User Profiles. See Use Lookup Tables across InOne.
FAQ about Lookup Tables
Find answers on update timing, CSV upsert behavior, duplicate primary keys, exports, and user role permissions. See FAQ about Lookup Tables.