Consolidate all your Google Analytics data sheets into one combined sheet making it easier to analyse your data and avoid sampling.
Listing updated:September 20, 2022
Works with:
No reviews

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 MarTools Consolidator add-on.

With the MarTools 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 MarTools 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 >> 'MarTools 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 MarTools Consolidator add-on.  To do this navigate to the 'Add-ons' menu >> 'MarTools 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 MarTools 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 MarTools Consolidator add-on will allow sheets with differing fields to be consolidated.


MarTools 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.
Additional information
PricingNot available
SupportNot available
Privacy policy
Terms of service
MarTools Consolidator will ask for the permissions shown below. Learn more
MarTools Consolidator will need access to your Google account
This will allow MarTools Consolidator to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Clear search
Close search
Google apps
Main menu