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. With them, you can:
- Enrich data using ingested property values. 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. Let’s say 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.
Set up and use Lookup Tables
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.
Create a Lookup Table
To create a new lookup table in Amplitude Data, follow these steps:
- Navigate to Data Sources in the project you want to import the .CSV data to.
- Click I want to import data into Amplitude. Then click CSV.
- 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.
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 Data Sources, then find the lookup table in the Sources table.
- 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 Data Sources, then find the lookup table in the Sources table.
- Open the Edit Lookup Table Configuration tab.
- Click the trash can icon and follow the on-screen instructions.