digilytiks GA4 Consolidator Google Sheets Add-on

Overview

**FOR USE WITH THE GOOGLE ANALYTICS ADD-ON**

Are you a prolific user of the Google Analytics add-on and finding it difficult to manage multiple data sheets?

Is the data you are pulling from GA being sampled?

If you answered yes to any of the questions above then you need the digilytiks GA4 Consolidator add-on.

With the digilytiks GA4 Consolidator add-on you can consolidate all your GA reports into one data sheet which allows for easy analysis and manipulation. You can also avoid pulling sampled data by splitting your reports into smaller segments or shorter timeframes and then re-compiling the data using this add-on.

Instructions for use

You can either use the digilytiks GA4 Consolidator add-on on a manual or scheduled basis depending on your needs.

To use the tool manually, ensure your data sheets are up to date and then navigate to the ‘Add-ons’ menu >> ‘digilytiks GA4 Consolidator’ >> ‘Run Consolidator’.

If you schedule the Google Analytics add-on to run reports periodically you will probably want to do the same with the digilytiks GA4 Consolidator add-on. To do this navigate to the ‘Add-ons’ menu >> ‘digilytiks GA4 Consolidator’ >> ‘Schedule Consolidator’. A sidebar will open with a number of scheduling options. You should mirror the scheduling of your Google Analytics add-on. If your GA reports are scheduled to run at a certain hour you should set the digilytiks GA4 Consolidator scheduling to run the following hour.

Please note each of your sheets should contain the same fields in the same order. A future release of the digilytiks GA4 Consolidator add-on will allow sheets with differing fields to be consolidated.

digilytiks GA4 Consolidator Add-on Process

  1. Checks the ‘Report Configuration’ sheet to see what reports exist. If your report is not named here it will not be consolidated.
  2. Loops through each report sheet and copies the data to a new ‘Consolidation’ sheet. If the ‘Consolidation’ sheet already exists the data is added to the first available free row.
  3. The GA data sheet is deleted.

You can view our privacy policy here.