Understanding lookup tables

Lookup tables are mutable tables you can use to enrich your event data. They allow you to map existing properties to new ones without needing complex formulas. This makes them a powerful tool for enhancing your data's depth and usability.

These tables are identified by a unique name and are scoped to specific projects. This means each project can have its own set of lookup tables, ensuring data relevance and organization. The ability to update these tables flexibly means you can adapt your data mappings as your needs change.

You can create and manage lookup tables via an API or a web app. This flexibility makes it easy to integrate them into your existing workflows. For instance, if you're working on an e-commerce platform, you might use a lookup table to map product SKUs to detailed product metadata like category and name. This can help in enriching your event data with more context.

Some key features of lookup tables include:

• Creating and managing via API or web app.

• Augmenting user and event properties.

• Supporting CSV file uploads for defining property mappings.

Key features of lookup tables

Lookup tables can be created and managed via API or web app. This flexibility makes them easy to integrate into your workflow. Whether you're a developer or an analyst, you have the tools to manage them efficiently.

They are used to augment user and event properties. By adding new properties, you enrich your data with more context. This makes your analysis more insightful and actionable.

Lookup tables support CSV file uploads to define property mappings. This feature simplifies the process of updating tables. You just upload a CSV file containing the mappings you need.

Here are some benefits:

• Simplify property management by avoiding complex formulas.

• Enhance data analysis with additional properties.

• Improve data consistency by syncing with source-of-truth systems.

Examples of lookup table usage

E-commerce: Map product SKUs to metadata like category and name. Simplify product management. Enhance product-related insights. Learn more about feature management. Check out our A/B Testing Calculator. Explore our integrations.

Geographical analysis: Enrich event data with regional information. Use user IP addresses for accurate location data. Improve regional analysis. Learn more about geotargeting. Explore our analytics capabilities. See how Statsig works.

User segmentation: Categorize users based on behavior or attributes. Create targeted user groups. Enhance personalized marketing efforts. Discover customer journey management. Understand behavioral targeting. Learn about our experimentation platform.