Like our new look? Read on.

Lookup from Data Source - New feature

1 minute read Last updated Sep 7 2020
Lookup from data source
Contributors Dropdown icon

The custom fields lookup operator just got new capabilities! You can now create a lookup rule that performs the lookup in a data source in your Funnel account. This means that you can now create your lookup rule so that the list of lookup values and results are dynamic.

Let's say you encode the names of your advertising campaigns in order to keep query parameters in the ads' destination URLs unreadable:

Let's also assume that in order to be able to figure out which campaign resulted in what visits, you keep a list of campaign codes and their respective readable names:

Campaign code translation table example

With this new lookup feature you can  create a custom dimension in Funnel to translate the recorded campaign value from the query parameter to a human readable value:

Lookup from data source operator

This example assumes your translation table lives in a Google Sheet, but you can use any data source as long as it is a single partition. Currently, this includes Google Sheets sources configured as single partitions as well as custom data sources created by us for you.

You can learn more about this feature in the article Lookup Values from a Google Sheet in our Knowledge Base.

Want to work smarter with your marketing data?
Discover Funnel