Lookups allows you to match values across different tables before you transform them. They enable you to modify and improve the legibility and usefulness of your data from platforms like Facebook Ads and Google Ads. By replacing existing values in your data with new ones defined by you, lookups are essential for recategorizing or renaming values in large datasets.
Lookup transformations are especially useful for large data sets that don't change often. They streamline your data analysis and ensure consistency across your reports.
Some popular use cases include:
- Renaming categories: If you have ad campaigns labeled with numeric IDs in your Google Ads data, you could use a lookup transformation to replace these IDs with more understandable campaign names, making your analysis more straightforward.
- Recategorizing values: Perhaps you've segmented your Facebook Ads by age groups, and the platform provides data in granular 1-year increments. Using a lookup, you can recategorize these into broader age brackets (such as 18-24, 25-34) for more high-level analysis.
Lookups can also be combined with additional transformation steps to perform more complex sequences.
- On the Supermetrics Hub, go to Transformations → Custom fields.
- Click Create new custom field.
- Select either dimension or metric and click Next.
This selection is based on the aspect of the data you aim to manipulate.
- Select the data source you want to apply a transformation to and click Next.
- Select Lookup as your transformation type.
This selection allows you to map existing values in your data to new values defined by you.
- Select the field you want to transform.
- Define the lookup rule. You can select between "equals", "equals (ignore case)", "contains", and "contains (ignore case)".
- Depending on the rule, your lookup transformation will match the original values in your data to your defined new values.
- Build your lookup table. Here, you define pairs of Lookup value (existing value) and Return value (new value). You can create individual rows for each pair or upload in bulk using a CSV format.
- Once your lookup table is set up, click Next.
- Give your custom field a name.
- Click Create custom field.
You can now use your new custom field in your reporting.