{"id":120033,"date":"2025-03-08T12:53:24","date_gmt":"2025-03-08T12:53:24","guid":{"rendered":"https:\/\/peraltafinancing.com\/analytics\/google-analytics-validator-simo-ahavas-blog\/"},"modified":"2025-03-08T12:53:24","modified_gmt":"2025-03-08T12:53:24","slug":"google-analytics-validator-simo-ahavas-blog","status":"publish","type":"post","link":"https:\/\/fivemor.com\/?p=120033","title":{"rendered":"Google Analytics Validator | Simo Ahava’s blog"},"content":{"rendered":"


\n<\/p>\n

\n

The Google Analytics Validator<\/strong> is a Google Sheets<\/a> add-on. It lets you build a spreadsheet of all the accounts, properties, and views you have access to in Google Analytics<\/a>. Then, you can select any number of these properties to populate a second sheet, where each Custom Dimension configured in the property is displayed with its name, scope, and active status.<\/p>\n

\n

<\/p>\n

\"Google<\/p>\n

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

Finally, you can poll for the last 7 days data for any selected property\/view to see if the Custom Dimension has collected any hits.<\/p>\n

\n

<\/p>\n

\"Last<\/p>\n

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

The add-on is completely free to use. It\u2019s a hobby project, but I would still welcome any feedback. You can send the feedback to simo (at) simoahava.com<\/strong>.<\/p>\n

How to get it<\/h2>\n

In Google Sheets, open the Add-ons<\/strong> menu, and click Get add-ons<\/strong>.<\/p>\n

\n

<\/p>\n

\"Get<\/p>\n

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

You should see the Chrome web store window open. Enter \u201cgoogle analytics validator\u201d into the search field and press Enter. You should see the add-on appear in the search results.<\/p>\n

\n

<\/p>\n

\"Store<\/p>\n

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

Click the + FREE<\/strong> button. You will be asked to sign in with your Google ID, and then approve the add-on access to your data. The add-on requires read-only<\/strong> access to your Google Analytics data, and read and write<\/strong> access to your Google Sheets account.<\/p>\n

You are then ready to use the tool!<\/p>\n

GitHub repo<\/h3>\n

You can download the open-source code from the GitHub repo: ga-validator-apps-script<\/a>.<\/p>\n

How it works<\/h2>\n

You should see the Google Analytics Validator<\/strong> menu item in the Add-ons menu. You might need to reload the page if it isn\u2019t there, or if it seems to be missing all its menu items.<\/p>\n

First, click on 1. Build Google Analytics hierarchy<\/strong>. This collects all the Google Analytics accounts, properties, and views you have access to, and builds them into a new sheet with the name \u201cGA Hierarchy\u201d.<\/p>\n

\n

<\/p>\n

\"Google<\/p>\n

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

NOTE!<\/strong> If this sheet already exists, it is overwritten.<\/p>\n

Next, type the letter x<\/strong> or X<\/strong> in the Select for analysis (x\/X)<\/strong> column for each property\/view that you want to include in the Custom Dimension analysis.<\/p>\n

Once you\u2019re done, click on 2. Run validator<\/strong> in the menu. This creates a new sheet named \u201cGA Dimensions\u201d (overwriting any existing sheet with the name<\/strong>), where all the dimensions from 1-200 are populated with values drawn from the properties you selected for analysis.<\/p>\n

Finally, you can select any cell in a data column, and then click 3. Fetch last 7 days data\u2026<\/strong> in the menu. This populates the LAST 7 DAYS<\/strong> column for the given view, fetching data from the last 7 days for each dimension that is active. The data that is fetched is the ga:hits<\/code> metric.<\/p>\n

\n

<\/p>\n

\"Last<\/p>\n

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

This tool has three purposes:<\/p>\n

    \n
  1. \n

    It gives you a master list of accounts, properties, and views you have access to.<\/p>\n<\/li>\n

  2. \n

    It lets you see how Custom Dimensions are configured across properties.<\/p>\n<\/li>\n

  3. \n

    It lets you analyze which Custom Dimensions have not collected any data recently.<\/p>\n<\/li>\n<\/ol>\n

    Privacy Policy<\/h2>\n

    What information do you collect?<\/h4>\n

    The Google Analytics Validator collects no information from its users. It is an API tool for building sheets of data based on your Google Analytics account and data hierarchy, and no usage information is collected or used in any way.<\/p>\n

    The only thing the add-on logs is the generic Google Cloud Console API usage statistics, which tells the owner how much the enabled APIs are being used, but this data cannot be use to identify users or individual use patterns.<\/p>\n

    How do you use the information?<\/h4>\n

    No user or usage information is used. The only thing the owner monitors is API usage, so that it can be determined if quotas need to be increased to ensure the tool works smoothly.<\/p>\n

    What information do you share?<\/h4>\n

    No information is shared with third parties, with other users, with analytics tools, with marketing partners, or any other party.<\/p>\n

    Terms of Service<\/h2>\n

    Terms of Service (\u201cTerms\u201d)<\/h3>\n

    Last updated: October 30, 2018<\/strong><\/p>\n

    Please read these Terms of Service (\u201cTerms\u201d, \u201cTerms of Service\u201d) carefully before using the Google Analytics Validator extension (the \u201cService\u201d) operated by Simo Ahava (\u201cus\u201d, \u201cwe\u201d, or \u201cour\u201d).<\/p>\n

    Your access to and use of the Service is conditioned on your acceptance of and compliance with these Terms. These Terms apply to all visitors, users and others who access or use the Service.<\/p>\n

    By accessing or using the Service you agree to be bound by these Terms. If you disagree with any part of the terms then you may not access the Service.<\/p>\n