How to create and use lookup tables in Google Tag Manager

Author:

In Google Tag Manager (GTM), Lookup Tables are a powerful feature that allow you to map one set of values to another. They are commonly used to convert, transform, or customize data for use in tags, triggers, and variables. This can help you manage complex data and streamline your tag firing process without having to modify your website’s code directly.

A Lookup Table Variable is essentially a table where you provide a set of input values (lookup keys) and specify corresponding output values. Based on the incoming input value, the lookup table returns the corresponding output value, which can then be used for things like sending dynamic values to Google Analytics, Google Ads, or any other platform.

Here’s how to create and use lookup tables in Google Tag Manager:

Step 1: Create a Lookup Table Variable

  1. Log in to Google Tag Manager: Navigate to the GTM dashboard.
  2. Go to Variables: On the left-hand panel, click on Variables.
  3. Create a New Variable: Under the Variables section, click on the New button to create a new variable.
  4. Choose Variable Type: Select the variable type as Lookup Table. This will allow you to map incoming values (keys) to their corresponding output values.
  5. Define Lookup Table Inputs (Keys):
    • Input Variable: This is the variable that will be used as the lookup key. It can be any variable that you have created in GTM (such as a Page URL, Referrer, Custom JavaScript, or other built-in variables like Page Path or Device Type).
    • Add Lookup Values: In the lookup table, you will define the key-value pairs. For example:
      • If the Input Variable is Page Path, the key could be /home, and the output could be Homepage.
      • If the Input Variable is Country, the key could be US, and the output could be United States.
    • You can add multiple rows of key-value pairs. Each key is compared to the value of the input variable, and if there is a match, the corresponding output value is returned.
  6. Set Default Value: It’s recommended to define a Default Value in case none of the keys in your lookup table match the input variable’s value. For example, if none of the pages match, you can set the output to Unknown Page. The default value helps avoid errors if there’s an unmatched lookup.
  7. Save the Variable: After defining the lookup table, click on Save to store your new Lookup Table Variable.

Step 2: Use the Lookup Table Variable in Tags, Triggers, or Other Variables

After creating the Lookup Table Variable, you can use it in Tags, Triggers, and other Variables to customize data that is sent to third-party tools (like Google Analytics or Facebook Pixel).

Example 1: Using Lookup Table in a Tag (Google Analytics)

  1. Create or Edit a Tag: Go to Tags in GTM and either create a new tag or edit an existing one. For example, a Google Analytics tag.
  2. Use the Lookup Table Variable in the Tag Configuration:
    • In the tag configuration (e.g., Google Analytics), you might have fields like Event Category or Custom Dimension.
    • Instead of hardcoding values into these fields, use your Lookup Table Variable. For example:
      • If you want to dynamically change the Event Category based on the Page Path, you could use your Lookup Table Variable (created earlier) in place of a static category.
      • Under Event Category, use the variable you just created from the Lookup Table, which will map paths like /home to Homepage.
  3. Trigger the Tag: Make sure the appropriate trigger is selected for when this tag should fire. For example, you may want to trigger this tag on all pageviews or on specific events.
  4. Save and Publish: After configuring the tag and ensuring it’s using the Lookup Table Variable correctly, click Save and Submit to publish your changes.

Example 2: Using Lookup Table for Dynamic Tracking IDs

You may need to dynamically send different tracking IDs to Google Ads or another platform based on certain page conditions (like page URL, user location, etc.). Here’s how you could do it with a Lookup Table:

  1. Create a Lookup Table Variable with the Input Variable being the Page URL or Country.
  2. Add Key-Value Pairs like:
    • Key: /product1, Output: Tracking ID 1
    • Key: /product2, Output: Tracking ID 2
  3. Configure a Google Ads Conversion Tag and replace the static tracking ID with the Lookup Table Variable.
  4. Test Your Tag to ensure the correct tracking ID is dynamically sent based on the page the user is on.

Step 3: Testing and Debugging

Before publishing any changes, it’s critical to test your Lookup Table Variable and its functionality:

  1. Preview Mode: GTM offers a Preview Mode where you can test the configuration in real-time without pushing changes to your live site. In Preview Mode, you can check if your Lookup Table Variable is returning the expected values based on the input.
  2. Use the GTM Debug Console:
    • In Preview Mode, open the GTM debug console to check the values of the variables and whether the correct lookup values are returned.
    • In the Variables tab of the GTM Debugger, find your Lookup Table Variable and see if it’s mapping the input values to the expected output correctly.
  3. Check the Tag Firing: Ensure that the tags configured with your Lookup Table Variable are firing correctly and the correct data is being passed to the third-party tools (e.g., Google Analytics, Google Ads).

Best Practices for Using Lookup Tables in Google Tag Manager

  1. Keep It Simple: Lookup tables are a powerful tool, but they should be used judiciously. Avoid overly complex tables with too many values, as they may make managing your tags more difficult.
  2. Use Default Values: Always define a default value to ensure your lookup table has a fallback if no matching key is found.
  3. Use Consistent Input Variables: The key to a successful lookup table is consistency. Ensure that the input variable (such as Page Path or Referrer) is accurate and uniform across the site to avoid mismatches.
  4. Minimize Hardcoded Values: Use Lookup Tables to replace hardcoded values wherever possible to make your tags more flexible and easier to manage.
  5. Optimize for Performance: While Lookup Tables are quite efficient, large tables with many keys can introduce performance challenges. Consider breaking up large tables or using other GTM features (like Custom JavaScript Variables) for more complex lookups.

Conclusion

Lookup Tables in Google Tag Manager allow you to map one set of values to another, making it easier to customize and manage your tags and tracking data. Whether you’re mapping page paths to event categories, customizing tracking IDs based on location, or transforming data before sending it to a third-party tool, Lookup Tables are an essential part of GTM’s powerful tagging capabilities. With careful setup and testing, Lookup Tables can help improve the flexibility, efficiency, and accuracy of your data collection.

Categories: Digital Marketing