This article will help you:
- Understand how adding a Lookup Table data source can enhance your event and user properties
- Learn how to quickly add, edit, or delete a Lookup Table
With Amplitude's Lookup Table feature, you can import your own data and map it to ingested properties to create an enhanced set of event and user properties.
NOTE: This feature is in closed beta. Customers with an Enterprise plan can contact their Amplitude Customer Service Manager or Account Executive to get access.
With them, you can:
- Enrich data using ingested property values. Let's say you've captured an event called
Purchased
with an event property namedSKU
. TheSKU
value itself doesn’t inherently hold a lot of meaning. But with your list of all the SKUs and their corresponding product names, you can use this feature to create a new property calledProduct Name
and have it automatically populate based on that list. - Bulk change or fix property values. Imagine you've captured a user property called
Language Code
and passed in language codes (en_US
,fr_FR
,de_DE
, etc.). This is difficult to read, so you want aLanguage
property that maps to friendlier values likeEnglish
,French
, andGerman
. Use this feature to create a new property calledLanguage
that maps the language codes to the language names. - Bulk filter long lists. You want to see user behavior for a specific region and you have a list of all the customers and their regions. Use this to map each customer to a region, creating a new
Region
property. Now you can filter specifically to each region in a chart.
NOTE: Lookup Tables may not exceed 100MB or 1 million rows. Contact your Amplitude CSM if you have data that exceeds this limit.
Create a Lookup Table
Before you can get started using Lookup Tables, you’ll need:
- An event property or user property to create a mapping from, and
- A .CSV that has the data you want to map to. The first column data must correspond to the mapping property value and must contain unique values.
NOTE: Keep in mind that Lookup Tables are looking for exact matches, and are case-sensitive.
To create a new Lookup Table in Amplitude Data, follow these steps:
- Navigate to Sources in the project you want to import the .CSV data to.
- Click + Add Source. Search for CSV, then click it.
- Navigate to your .CSV file and upload it. Then click Next.
- Map your event property by selecting it from the dropdown. When you're done, click Finish.
NOTE: You must be an Admin or Manager of the project to add or manage a source.
Update a Lookup Table
If you want to create a new lookup property or fix an incorrectly-mapped property, you can update the lookup table by following these steps:
- In Amplitude, navigate to Sources, find the Lookup Table in the Sources List. Click on it to open its General tab.
- Open the Edit Lookup Table Configuration tab.
- Make your changes. You can change the mapping, or replace the .CSV by uploading a new file.
- When you’re finished, click Update your lookup table configuration.
Delete a Lookup Table and its properties
To delete a Lookup Table you no longer need, follow these steps:
- In Amplitude, navigate to Sources, then find the Lookup Table in the Sources List.
- Open the Edit Lookup Table Configuration tab.
- Click
(trash can) and follow the on-screen instructions.