Use a Google Sheets lookup table to replace dimension values in Funnel. For example, replace campaign codes with readable campaign names.
Use this method when lookup values change often. For a lookup table that you maintain directly in a Funnel rule, see Create lookup tables for custom fields.
Before you begin
Prepare a Google Sheet with one column for the values to find and one column for the values to return.
Make sure that the sheet has no more than 5,000 rows.
For a dimension lookup, use text values in both columns. For a metric lookup, use numeric values in both columns.
Configure the lookup
In Funnel, go to Data > Organize > Dimensions.
Create or edit a custom dimension.
Add a rule for all data.
Select the field that contains the values to find. For example, select
Campaign.
Click + more steps.
Select lookup.
Change the lookup source from Comma-separated values to the Google Sheets data source.
Under IN FIELD, select the sheet field that contains the values to find. For example, select
Campaign code.Under RETURN, select the sheet field that contains the replacement values. For example, select
Campaign name.Under MATCH USING, select the comparison operator for the lookup.
What to expect
Funnel uses the matching row in the Google Sheet to replace each source value with the corresponding return value.