When having a field containing for instance campaign codes it is often better to replace these with more readable variants. This can be done with Funnel rules either using the conventional "WHEN condition THEN value" or Inline Lookup Tables.

Maintaining these rules can be cumbersome especially when there are frequent changes to the lookup values.

Example of google sheet with campaign codes to campaign names

To make this easier, you can connect a Google Sheet, with the lookup values, as a source in Funnel and create a "Custom Dimension".

Choose the field to use for lookup, in this case, "Campaign", and click "+ more steps"...

Select "lookup"...

By default "Inline CSV" is selected. Available Google Sheet sources will be listed in the "from" selector. Change to the source containing the lookup values...

Select which field to look for in "IN FIELD" and which field to return in "RETURN", for instance "Campaign code" and "Campaign name".
Matching can be fine-tuned by changing comparison operator in "MATCH USING".


The sheet may only contain up to 5000 rows.

For a 'Funnel Dimension', both columns in the google sheet must contain string values and for a 'Metric' both columns must contain numeric values.

Did this answer your question?