Amplitude's Lookup Table integration lets you import your own data and map it to ingested properties to have an enhanced set of properties.
This feature is in closed beta. Customers with an Enterprise plan or the Govern add-on can contact their Amplitude Customer Service Manager or Account Executive to get access.
You can also create and manage lookup tables via an API. See Lookup Table API for more information.
To set up this integration, you need the following:
An event property or user property to create a mapping from.
A CSV that has the data you want to map to:
"
). The first double quote signifies the beginning of the column data, and the last double quote marks the end. If a string contains double quotes, replace them with single quotes.If you want to create a new lookup property or that mapped property is wrong, you can update the lookup table.
When you no longer need a lookup table, you can delete it.
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:
Purchased
with an event property named SKU
. The SKU
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 called Product Name
and have it automatically populate based on that list.Language Code
and passed in language codes (en_US
, fr_FR
, de_DE
, etc.). This is difficult to read, so you want a Language
property that maps to friendlier values like English
, French
, and German
. Use this feature to create a new property called Language
that maps the language codes to the language names.The following CSV creates a new property called Language
that maps to the SKU
property. This CSV is an example implementation of the Bulk update property values use case from the previous section.
SKU | Language |
---|---|
en_US | English |
fr_FR | French |
de_DE | German |
Thanks for your feedback!
July 3rd, 2024
Need help? Contact Support
Visit Amplitude.com
Have a look at the Amplitude Blog
Learn more at Amplitude Academy
© 2024 Amplitude, Inc. All rights reserved. Amplitude is a registered trademark of Amplitude, Inc.