{"id":84960,"date":"2025-02-13T01:42:53","date_gmt":"2025-02-13T01:42:53","guid":{"rendered":"https:\/\/peraltafinancing.com\/analytics\/build-a-lookup-table-generator-for-google-tag-manager\/"},"modified":"2025-02-13T01:42:53","modified_gmt":"2025-02-13T01:42:53","slug":"build-a-lookup-table-generator-for-google-tag-manager","status":"publish","type":"post","link":"https:\/\/fivemor.com\/?p=84960","title":{"rendered":"Build A Lookup Table Generator For Google Tag Manager"},"content":{"rendered":"


\n<\/p>\n

\n

In this step-by-step guide, I\u2019ll show you how to build a Lookup Table generator<\/strong> in Google Sheets<\/a>, utilizing Apps Script<\/a> and the Google Tag Manager API<\/a>.<\/p>\n

\n

<\/p>\n

\"Lookup<\/p>\n

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

The purpose of the Lookup Table generator is to automate the often tedious task of adding many, many rows to a Lookup Table within the Google Tag Manager UI. There are other<\/a> solutions<\/a> for this, but none (as far as I know) that uses the Google Tag Manager API.<\/p>\n

Also, using Google Sheets is a no-brainer, because of the similarities between the Lookup Table variable and a spreadsheet. Both are organized into columns and rows. Google Sheets has a wonderful Apps Script integration, so interacting with the GTM API has been made very<\/em> simple.<\/p>\n

\n

This tool was inspired by the work I\u2019ve been doing with Swappie<\/a>, a company from Finland that refurbishes second-hand smartphones and has a marketplace that makes buying and selling these phones easy and safe. One of their use cases for web analytics is to collect product margin<\/strong> information into their Ecommerce reports, and this requires a daily updated data sheet where the product SKUs are mapped to their current product margins.<\/p>\n<\/blockquote>\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

Fetch the sheet template<\/h2>\n

The First thing you\u2019ll want to do is fetch the sheet template. Visit this URL:<\/p>\n

https:\/\/docs.google.com\/spreadsheets\/d\/1LDJ6NOtMMx_5vwRBdPAx9V0gTLnce-7aglQzSm-Ja7M\/<\/a><\/p>\n

Then, click the File<\/strong> menu and select Make a copy<\/strong>.<\/p>\n

\n

<\/p>\n

\"Make<\/p>\n

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

This makes a copy of the sheet in your drive, and this new sheet is what you\u2019ll be working on.<\/p>\n

Configure the sheet<\/h2>\n

Next, configure the sheet. For the Lookup Table generator work optimally, you\u2019ll need the following things:<\/p>\n

    \n
  1. You should create a new Workspace just for the Lookup Table output. That way you don\u2019t have to worry about messing with the Default Workspace (which should rarely, if ever, be used).<\/li>\n
  2. You need to create the Lookup Table variable in the Workspace.<\/li>\n<\/ol>\n

    Once you have these two in place, you need to collect the Account ID<\/strong>, Container ID<\/strong>, Workspace ID<\/strong>, and Lookup Table variable ID<\/strong>. The easiest way to do that is to browse to Variables<\/strong> in the GTM UI, and then right-click<\/em> the Lookup Table variable, and copy its link address.<\/p>\n

    \n

    <\/p>\n

    \"Copy<\/p>\n

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

    If you explore that URL, it will look something like this:<\/p>\n

    ...\/accounts\/23019854\/containers\/8060344\/workspaces\/1000128\/variables\/730<\/code><\/p>\n

    The Account ID<\/strong> is the first<\/em> number in that URL, i.e. 23019854<\/code>.<\/p>\n

    The Container ID<\/strong> is the second<\/em> number in that URL, i.e. 8060344<\/code>.<\/p>\n

    The Workspace ID<\/strong> is the third<\/em> number in that URL, i.e. 1000128<\/code>.<\/p>\n

    The Variable ID<\/strong> is the fourth<\/em> number in that URL, i.e. 730<\/code>.<\/p>\n

    Add these to sheet in their appropriate places. Note! You can also type default<\/code> as the Workspace ID, and it will automatically fetch your Default Workspace, assuming that\u2019s the workspace you want to work in. Again, I recommend against this practice. It\u2019s not how workspaces should be utilized<\/a>.<\/p>\n

    \n

    <\/p>\n

    \"Add<\/p>\n

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

    Add the Apps Script code<\/h2>\n

    Next, in the Google Sheet, launch the Script Editor<\/strong>. Click Tools<\/strong> and then choose Script Editor<\/strong>.<\/p>\n

    \n

    <\/p>\n

    \"Script<\/p>\n

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

    If this is your first time using the Script Editor, you might need to jump through a few steps, but eventually you should see this:<\/p>\n

    \n

    <\/p>\n

    \"Blank<\/p>\n

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

    The next thing to do is to rename<\/em> the project. Click the Untitled project<\/code> text in the top left corner, and rename the project to e.g. Lookup Table Generator<\/code>. Once you click OK<\/strong>, the project will be saved, and you can access its details through script.google.com<\/a>.<\/p>\n

    Now, delete<\/strong> all the code in the editor, and replace it with the code copy-pasted from this gist<\/a>.<\/p>\n

    \n

    <\/p>\n

    \"Gist<\/p>\n

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

    Remember to click the Raw<\/strong> button to get the code in plain text format, ready to be copy-pasted into the script editor.<\/p>\n

    Code walkthrough<\/h3>\n

    I\u2019m not going to step-by-step you through the code, but I\u2019ll briefly introduce what each method<\/em> does.<\/p>\n\n\n\n\n\n\n\n\n\n
    Method<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
    getIds<\/code><\/td>\nParses the Google Sheet for the IDs (Account ID, Container ID, Workspace ID, Variable ID) the user has added to their appropriate places.<\/td>\n<\/tr>\n
    getDefaultWorkspaceId<\/code><\/td>\nIf the user typed default<\/code> as the workspace ID, or if the workspace ID they gave does not exist, the sheet falls back to the \u201cDefault Workspace\u201d. This method fetches its workspace ID.<\/td>\n<\/tr>\n
    getLookupTable<\/code><\/td>\nThis method uses the Google Tag Manager API to fetch the Lookup Table variable the Variable ID points to.<\/td>\n<\/tr>\n
    sendData<\/code><\/td>\nThe data in the Google Sheet is collected, mapped to its correct API resource format, and sent to Google Tag Manager. The contents in the sheet are used to update (i.e. replace) the Lookup Table variable contents in the GTM container.<\/td>\n<\/tr>\n
    populateSheet<\/code><\/td>\nThis method uses the IDs (from getIds<\/code>) to fetch the current contents of the Lookup Table variable into the Google Sheet.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Finalize Apps Script configuration<\/h3>\n

    In addition to the code, you also need to enable API access in the Script Editor. Click Resources<\/strong> and select Advanced Google services..<\/strong>.<\/p>\n

    \n

    <\/p>\n

    \"Advanced<\/p>\n

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

    In the overlay that opens, scroll down to Tagmanager<\/code>, make sure it has v2<\/code> selected as the version, and then enable it by clicking the toggle at the end.<\/p>\n

    \n

    <\/p>\n

    \"Enable<\/p>\n

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

    Click OK<\/strong> when done.<\/p>\n

    Test with the data fetch<\/h3>\n

    To quickly test if the code works, select the populateSheet<\/code> function from the appropriate menu in the Script Editor.<\/p>\n

    \n

    <\/p>\n

    \"Select<\/p>\n

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

    Then, press the Play<\/strong> button just to the left of the \u201cBug\u201d icon in the Script Editor toolbar.<\/p>\n

    The script should now prompt to request authorization. Click Review Permissions<\/strong>.<\/p>\n

    \n

    <\/p>\n

    \"Review<\/p>\n

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

    Follow the sign-in prompts until you see the \u201cThis app isn\u2019t verified\u201d prompt. This screen means that Google hasn\u2019t verified<\/em> this app yet. It\u2019s using APIs that can be dangerous in the wrong hands, which is why Google warns about this app.<\/p>\n

    Since we are building this for internal use only, you don\u2019t have to worry about this prompt. You can click the Advanced<\/strong> link and then the Go to your project<\/em> (unsafe)<\/strong> link.<\/p>\n

    \n

    <\/p>\n

    \"Safety<\/p>\n

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

    Finally, click the Allow<\/strong> button at the bottom of the last screen in the flow.<\/p>\n

    \n

    <\/p>\n

    \"Allow<\/p>\n

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

    At this point, the script will run. Once it\u2019s complete, you can step back into your Google Sheet to see it populated with the Lookup Table variable contents.<\/p>\n

    \n

    <\/p>\n

    \"Sheet<\/p>\n

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

    Test with the data update<\/h3>\n

    Let\u2019s try updating the variable with data from the sheet.<\/p>\n

    Do whatever modifications you want with the sheet content first.<\/p>\n

    \n

    Note!<\/strong> Do not touch the Input<\/strong> and Output<\/strong> headers. Start modifying the sheet from the row after these.<\/p>\n<\/blockquote>\n

    \n

    <\/p>\n

    \"Rows<\/p>\n

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

    Next, go back to Script Editor, and this time choose sendData<\/code> from the list of functions to run. Click the Play button again.<\/p>\n

    \n

    <\/p>\n

    \"Run<\/p>\n

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

    If all works well, you should now be able to see the modified Lookup Table variable in the workspace in the Google Tag Manager UI.<\/p>\n

    \n

    <\/p>\n

    \"Modified<\/p>\n

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

    Map the buttons in the sheet<\/h3>\n

    Finally, to make the sheet a bit easier to use, let\u2019s map the two buttons in the sheet to their corresponding functions.<\/p>\n

    Right-click the Fetch data<\/strong> button, click the little action menu in the top-right corner and choose Assign script<\/strong>.<\/p>\n

    \n

    <\/p>\n

    \"Assign<\/p>\n

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

    Type populateSheet<\/code> in the prompt that opens and click OK.<\/p>\n

    \n

    <\/p>\n

    \"populateSheet\"\/<\/p>\n

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

    Next, do the same for the Update data<\/strong> button, but instead of populateSheet<\/code> type sendData<\/code> into the prompt before clicking OK.<\/p>\n

    Now, whenever someone clicks the Fetch data<\/strong> button, the script will populate the sheet with the variable details (assuming the user who clicks the button has authorized access to Google Tag Manager). Whenever someone clicks the Update data<\/strong> button, the script will update the Lookup Table variable in Google Tag Manager with the contents of the sheet.<\/p>\n

    \n

    If you want to edit the button again, you need to right-click it<\/strong>, as left-clicking it will simply run the script.<\/p>\n<\/blockquote>\n

    Summary<\/h2>\n

    I hope this proof-of-concept was easy to follow. With these steps, you can create a Lookup Table Generator for internal use.<\/p>\n

    There are limitations to how much the script can be run while unverified. You\u2019ll want to take a look at this documentation<\/a> to understand what steps need to be taken if you want to get rid of the security warnings.<\/p>\n

    Basically, if the script is only intended for occasional use by the developer (you), or if the script is meant to be used only by users within your G Suite organization<\/strong>, you don\u2019t have to verify the app.<\/p>\n

    For any other type of extended use, the app needs to be verified<\/strong>, and this is an intricate, often tedious process<\/a>.<\/p>\n

    Google Sheets + Google Apps Script is one of the most powerful, easily accessible automation flows out there. It requires minimal understanding of the Google Cloud Platform, as almost everything is abstracted in the Apps Script sandbox.<\/p>\n<\/p><\/div>\n\n","protected":false},"excerpt":{"rendered":"

    In this step-by-step guide, I\u2019ll show you how to build a Lookup Table generator in Google Sheets, utilizing Apps Script and the Google Tag Manager API. The purpose of the Lookup Table generator is to automate the often tedious task of adding many, many rows to a Lookup Table within the Google Tag Manager UI. […]<\/p>\n","protected":false},"author":1,"featured_media":84961,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12033],"tags":[5293,24377,1531,41975,14495,893,1791],"dealstore":[],"offerexpiration":[],"class_list":["post-84960","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","tag-build","tag-generator","tag-google","tag-lookup","tag-manager","tag-table","tag-tag"],"yoast_head":"\nBuild A Lookup Table Generator For Google Tag Manager - 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=84960\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build A Lookup Table Generator For Google Tag Manager - Som2ny Network\" \/>\n<meta property=\"og:description\" content=\"In this step-by-step guide, I\u2019ll show you how to build a Lookup Table generator in Google Sheets, utilizing Apps Script and the Google Tag Manager API. The purpose of the Lookup Table generator is to automate the often tedious task of adding many, many rows to a Lookup Table within the Google Tag Manager UI. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fivemor.com\/?p=84960\" \/>\n<meta property=\"og:site_name\" content=\"Som2ny Network\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-13T01:42:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1854\" \/>\n\t<meta property=\"og:image:height\" content=\"510\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fivemor.com\/?p=84960#article\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/?p=84960\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\"},\"headline\":\"Build A Lookup Table Generator For Google Tag Manager\",\"datePublished\":\"2025-02-13T01:42:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=84960\"},\"wordCount\":1437,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=84960#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg\",\"keywords\":[\"Build\",\"Generator\",\"Google\",\"Lookup\",\"Manager\",\"Table\",\"TAG\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fivemor.com\/?p=84960#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fivemor.com\/?p=84960\",\"url\":\"https:\/\/fivemor.com\/?p=84960\",\"name\":\"Build A Lookup Table Generator For Google Tag Manager - Som2ny Network\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=84960#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=84960#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg\",\"datePublished\":\"2025-02-13T01:42:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fivemor.com\/?p=84960#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fivemor.com\/?p=84960\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/?p=84960#primaryimage\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg\",\"width\":1854,\"height\":510},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fivemor.com\/?p=84960#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fivemor.com\/?bp_activities=1\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Build A Lookup Table Generator For Google Tag Manager\"}]},{\"@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":"Build A Lookup Table Generator For Google Tag Manager - 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=84960","og_locale":"en_US","og_type":"article","og_title":"Build A Lookup Table Generator For Google Tag Manager - Som2ny Network","og_description":"In this step-by-step guide, I\u2019ll show you how to build a Lookup Table generator in Google Sheets, utilizing Apps Script and the Google Tag Manager API. The purpose of the Lookup Table generator is to automate the often tedious task of adding many, many rows to a Lookup Table within the Google Tag Manager UI. […]","og_url":"https:\/\/fivemor.com\/?p=84960","og_site_name":"Som2ny Network","article_published_time":"2025-02-13T01:42:53+00:00","og_image":[{"width":1854,"height":510,"url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fivemor.com\/?p=84960#article","isPartOf":{"@id":"https:\/\/fivemor.com\/?p=84960"},"author":{"name":"admin","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371"},"headline":"Build A Lookup Table Generator For Google Tag Manager","datePublished":"2025-02-13T01:42:53+00:00","mainEntityOfPage":{"@id":"https:\/\/fivemor.com\/?p=84960"},"wordCount":1437,"commentCount":0,"publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"image":{"@id":"https:\/\/fivemor.com\/?p=84960#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg","keywords":["Build","Generator","Google","Lookup","Manager","Table","TAG"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fivemor.com\/?p=84960#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fivemor.com\/?p=84960","url":"https:\/\/fivemor.com\/?p=84960","name":"Build A Lookup Table Generator For Google Tag Manager - Som2ny Network","isPartOf":{"@id":"https:\/\/fivemor.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fivemor.com\/?p=84960#primaryimage"},"image":{"@id":"https:\/\/fivemor.com\/?p=84960#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg","datePublished":"2025-02-13T01:42:53+00:00","breadcrumb":{"@id":"https:\/\/fivemor.com\/?p=84960#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fivemor.com\/?p=84960"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/?p=84960#primaryimage","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/lookup-table-generator.jpg","width":1854,"height":510},{"@type":"BreadcrumbList","@id":"https:\/\/fivemor.com\/?p=84960#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fivemor.com\/?bp_activities=1"},{"@type":"ListItem","position":2,"name":"Build A Lookup Table Generator For Google Tag Manager"}]},{"@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\/84960","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=84960"}],"version-history":[{"count":0,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/84960\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/media\/84961"}],"wp:attachment":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=84960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=84960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=84960"},{"taxonomy":"dealstore","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fdealstore&post=84960"},{"taxonomy":"offerexpiration","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fofferexpiration&post=84960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}