Creating a Lookup Table

Lookup tables enable you to find and certain values and add a label to it. It's a way to simplify and bucket your data values without replacing the original in your source. 

To start, press the 'Add Source' button within the sources page.

Then name your lookup table, click the "Lookup Table" button, and click "Continue."

After creating your lookup table, you'll be greeted with the configuration. You can set a default label that will apply to all values that don't match one of the expressions.

Here, you have two different options for setting up the lookup source.

Manually create a list of expressions and labels within Conversionomics

For this method, all you need to do is input the expressions to look for, and the desired label's for them. You are able to add as many expressions as you want.

Import an existing table from a Gsheet

For this method you will need a Gsheet with expressions and labels already filled out. First, you will need to share the sheet with the Google Cloud Platform service account that connects Conversionomics to GCP. Then you just need to paste the link within the correct section. This will remove the above method as to avoid conflicts. Finally you will need to input the column where the expressions and labels are located. (Note: You must use the letter(s) used to identify the column, and it must be capitalized)

After you are finished setting up the lookup configuration, press save at the bottom of the page and the source will be ready to go.