{"id":174716,"date":"2025-04-07T02:11:45","date_gmt":"2025-04-07T02:11:45","guid":{"rendered":"https:\/\/peraltafinancing.com\/analytics\/google-tag-manager-the-lookup-table-macro\/"},"modified":"2025-04-07T02:11:45","modified_gmt":"2025-04-07T02:11:45","slug":"google-tag-manager-the-lookup-table-macro","status":"publish","type":"post","link":"https:\/\/fivemor.com\/?p=174716","title":{"rendered":"Google Tag Manager: The Lookup Table Macro"},"content":{"rendered":"


\n<\/p>\n

\n

Having just come hot of the press with my latest article on GTM and Content Grouping<\/a> which, to my delight, Bounteous had written an amazing tutorial<\/a> on earlier, Brian Kuhn<\/a> and the amazing Google Tag Manager development team came out with another incredible new feature: The Lookup Table Macro.<\/p>\n

In software engineering, a lookup table<\/em> is an array which takes away a layer of complexity in runtime computation, and replaces it with a simple value assignment based on array indexing. To put it simply, a lookup table looks<\/em> through an array of source values, and assigns<\/em> a value to the target depending on what the source value is. Well, maybe it\u2019s easiest to show it in an image:<\/p>\n

\n

<\/p>\n

\"Lookup<\/p>\n

<\/a><\/p>\n<\/div>\n

This is probably the most simple use case for the lookup table. The range of source values is derived from the custom JavaScript macro {{post_publish_date_month}}<\/em>, which returns the month when the article the visitor is browsing was published. The lookup table goes through the possible values of the source macro, and it uses these values to assign the literal month name to the target macro, {{Post publish month}}<\/em>.<\/p>\n

NOTE!<\/strong> The source value (i.e. \u201cWhen {{macro}} equals\u201d) is case-sensitive<\/strong>!<\/p>\n


\n X<\/span><\/p>\n

\n
\n The Simmer Newsletter<\/strong>\n <\/p>\n

\n Subscribe to the Simmer newsletter<\/a> to get the latest news and content from Simo Ahava into your email inbox!\n <\/p>\n

<\/span><\/p>\n

Why use lookup tables<\/h2>\n

So why resort to a lookup table, when you can just add simple predicate logic to your custom JavaScript, and have it return the month name directly? Well, sure, you could do that, and in most cases it would be just fine.<\/p>\n

However.<\/p>\n

A lookup table, just like macros in general, removes a layer of complexity<\/strong> from your code and replaces it with increased flexibility<\/strong>. Because you take away a transformation from the source (i.e. transliteration of the numerical month to the written month name), you are free to use the numerical month elsewhere in your computations.<\/p>\n

Also, a lookup table is an indexing operation and not strictly a calculation, so the runtime processing power it requires is significantly reduced when compared to having your scripts do all the work. With a large setup, where lookup tables might go through a huge number of source and target operations, you\u2019ll end up with less code, less computation, and a nice and flexible framework for value assignment in your macros.<\/p>\n

To keep the operation as light as possible, you can only check for equation<\/strong>, e.g. \u201cif {{target macro}} equals<\/em> something, then\u2026\u201d. I actually asked Brian about this, and he replied:<\/p>\n

\n

<\/p>\n

\"Brian<\/p>\n

<\/a><\/p>\n<\/div>\n

So if you want to see some other ways of evaluating the source value before assigning a target value, you\u2019ll have to wait and see what the GTM team come up with. I guess it will be some combination of rule + lookup table to keep the setup as simple as possible.<\/p>\n

Naturally, you can refer to your lookup table macros in Custom HTML tags and Custom JavaScript macros as well, so you\u2019ll increase the modularity of your code.<\/p>\n

Use cases<\/h2>\n

Let\u2019s put it this way. Any time you need to do a simple \u201cif X is Y then Z\u201d evaluation based on a range of values, you could do so with a lookup table. Let\u2019s start with a simple one.<\/p>\n

Multi-account or multi-property container<\/h3>\n

If you have a single container deployed across many Google Analytics accounts or properties, you\u2019ll come across the problem of assigning the correct tracking code to your tags. You could do it with a unique tag for each deployment, a unique rule for each tag, and a bunch of macros and custom HTML code to check the correct account, but that will soon turn into a veritable noodle-o-rama of a setup.<\/p>\n

Relax. Use a lookup table:<\/p>\n

\n

<\/p>\n

\"Tracking<\/p>\n

<\/a><\/p>\n<\/div>\n

Filetype defines event category<\/h3>\n

This is an example of using macros in the lookup table itself. I have a custom JavaScript macro, which checks the filetype of the link that was clicked. It uses the gtm.element<\/em> auto-event variables used in auto-event tracking<\/a>. See how I use a macro in the target value field? That\u2019s how flexible this is. You can create a framework or infrastructure of macros, and come up with something really complex with very simple processing.<\/p>\n

Be sure to follow the great Carmen Mardiros<\/a> from Clear Clues<\/a> to find out (hopefully soon) about applications of complex indexing logic using macro-based syntax.<\/em><\/p>\n

\n

<\/p>\n

\"Macro<\/p>\n

<\/a><\/p>\n<\/div>\n

More auto-event madness<\/h3>\n

Another nice use case for auto-event tracking is to set your event parameters depending on what type of auto-event interaction took place. For example, if a link was clicked, I\u2019d want my event action to be the URL of the clicked link. If any click occurred, I want my event action to be the tag type (i.e. DIV or IMG or SPAN etc.) of the clicked element. And if a form was submitted, I\u2019d want my event action to be the ID of the form. Like so:<\/p>\n

\n

<\/p>\n

\"Lookup<\/p>\n

<\/a><\/p>\n<\/div>\n

Then you can just use a single event tag to send your different auto-event hits, with a trigger rule like \u201c{{event}} equals gtm.click OR {{event}} equals gtm.linkClick OR {{event}} equals gtm.formSubmit\u201d.<\/p>\n

Conclusions<\/h2>\n

The lookup table macro is designed to help you actually create a logical infrastructure for your GTM deployment. It also increases flexibility, since you can cross-reference lookup macros in your tags and other macros. I\u2019m a huge advocate of macros in general, because the less you hard-code into your custom tags the better.<\/p>\n

There\u2019s no limit to the number of rows in a lookup table (other than general GTM data set limitations). I know that there\u2019s also an import feature on the roadmap, so you can import your own, pre-defined lookup tables into the system. Mapping classifications from one data set to another will be something that especially large GTM implementations will benefit from.<\/p>\n

Finally, I couldn\u2019t agree more with Eric Erlebacher<\/a>:<\/p>\n

\n

<\/p>\n

\"Eric<\/p>\n

<\/a><\/p>\n<\/div>\n

The GTM dev team is on a roll right now, and I hope it doesn\u2019t stop anytime soon.<\/p>\n<\/p><\/div>\n\n","protected":false},"excerpt":{"rendered":"

Having just come hot of the press with my latest article on GTM and Content Grouping which, to my delight, Bounteous had written an amazing tutorial on earlier, Brian Kuhn and the amazing Google Tag Manager development team came out with another incredible new feature: The Lookup Table Macro. In software engineering, a lookup table […]<\/p>\n","protected":false},"author":1,"featured_media":174717,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12033],"tags":[1531,41975,33546,14495,893,1791],"dealstore":[],"offerexpiration":[],"class_list":["post-174716","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","tag-google","tag-lookup","tag-macro","tag-manager","tag-table","tag-tag"],"yoast_head":"\nGoogle Tag Manager: The Lookup Table Macro - Som2ny Network<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fivemor.com\/?p=174716\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Tag Manager: The Lookup Table Macro - Som2ny Network\" \/>\n<meta property=\"og:description\" content=\"Having just come hot of the press with my latest article on GTM and Content Grouping which, to my delight, Bounteous had written an amazing tutorial on earlier, Brian Kuhn and the amazing Google Tag Manager development team came out with another incredible new feature: The Lookup Table Macro. In software engineering, a lookup table […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fivemor.com\/?p=174716\" \/>\n<meta property=\"og:site_name\" content=\"Som2ny Network\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-07T02:11:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"946\" \/>\n\t<meta property=\"og:image:height\" content=\"619\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fivemor.com\/?p=174716#article\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/?p=174716\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\"},\"headline\":\"Google Tag Manager: The Lookup Table Macro\",\"datePublished\":\"2025-04-07T02:11:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=174716\"},\"wordCount\":1021,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=174716#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg\",\"keywords\":[\"Google\",\"Lookup\",\"Macro\",\"Manager\",\"Table\",\"TAG\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fivemor.com\/?p=174716#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fivemor.com\/?p=174716\",\"url\":\"https:\/\/fivemor.com\/?p=174716\",\"name\":\"Google Tag Manager: The Lookup Table Macro - Som2ny Network\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=174716#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=174716#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg\",\"datePublished\":\"2025-04-07T02:11:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fivemor.com\/?p=174716#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fivemor.com\/?p=174716\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/?p=174716#primaryimage\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg\",\"width\":946,\"height\":619},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fivemor.com\/?p=174716#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fivemor.com\/?bp_activities=1\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Tag Manager: The Lookup Table Macro\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fivemor.com\/#website\",\"url\":\"https:\/\/fivemor.com\/\",\"name\":\"Som2ny Network\",\"description\":\"Daily Deals\",\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fivemor.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/fivemor.com\/#organization\",\"name\":\"Som2ny Network\",\"url\":\"https:\/\/fivemor.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png\",\"width\":300,\"height\":86,\"caption\":\"Som2ny Network\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/fivemor.com\"],\"url\":\"https:\/\/fivemor.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Tag Manager: The Lookup Table Macro - Som2ny Network","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fivemor.com\/?p=174716","og_locale":"en_US","og_type":"article","og_title":"Google Tag Manager: The Lookup Table Macro - Som2ny Network","og_description":"Having just come hot of the press with my latest article on GTM and Content Grouping which, to my delight, Bounteous had written an amazing tutorial on earlier, Brian Kuhn and the amazing Google Tag Manager development team came out with another incredible new feature: The Lookup Table Macro. In software engineering, a lookup table […]","og_url":"https:\/\/fivemor.com\/?p=174716","og_site_name":"Som2ny Network","article_published_time":"2025-04-07T02:11:45+00:00","og_image":[{"width":946,"height":619,"url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fivemor.com\/?p=174716#article","isPartOf":{"@id":"https:\/\/fivemor.com\/?p=174716"},"author":{"name":"admin","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371"},"headline":"Google Tag Manager: The Lookup Table Macro","datePublished":"2025-04-07T02:11:45+00:00","mainEntityOfPage":{"@id":"https:\/\/fivemor.com\/?p=174716"},"wordCount":1021,"commentCount":0,"publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"image":{"@id":"https:\/\/fivemor.com\/?p=174716#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg","keywords":["Google","Lookup","Macro","Manager","Table","TAG"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fivemor.com\/?p=174716#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fivemor.com\/?p=174716","url":"https:\/\/fivemor.com\/?p=174716","name":"Google Tag Manager: The Lookup Table Macro - Som2ny Network","isPartOf":{"@id":"https:\/\/fivemor.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fivemor.com\/?p=174716#primaryimage"},"image":{"@id":"https:\/\/fivemor.com\/?p=174716#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg","datePublished":"2025-04-07T02:11:45+00:00","breadcrumb":{"@id":"https:\/\/fivemor.com\/?p=174716#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fivemor.com\/?p=174716"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/?p=174716#primaryimage","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/04\/lookup-table-macro-example.jpg","width":946,"height":619},{"@type":"BreadcrumbList","@id":"https:\/\/fivemor.com\/?p=174716#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fivemor.com\/?bp_activities=1"},{"@type":"ListItem","position":2,"name":"Google Tag Manager: The Lookup Table Macro"}]},{"@type":"WebSite","@id":"https:\/\/fivemor.com\/#website","url":"https:\/\/fivemor.com\/","name":"Som2ny Network","description":"Daily Deals","publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fivemor.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/fivemor.com\/#organization","name":"Som2ny Network","url":"https:\/\/fivemor.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/#\/schema\/logo\/image\/","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png","width":300,"height":86,"caption":"Som2ny Network"},"image":{"@id":"https:\/\/fivemor.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png","caption":"admin"},"sameAs":["https:\/\/fivemor.com"],"url":"https:\/\/fivemor.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/174716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=174716"}],"version-history":[{"count":0,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/174716\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/media\/174717"}],"wp:attachment":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=174716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=174716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=174716"},{"taxonomy":"dealstore","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fdealstore&post=174716"},{"taxonomy":"offerexpiration","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fofferexpiration&post=174716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}