The Google Analytics Management API can be accessed through a Google Sheet to list and update settings data in a tabular format. This application lists management entities from Google Analytics into your sheet, and allows you to update settings based on edits or additions in your sheet.
###Installing the tool This tool can be installed through the Google Add-ons Web Store. It can also be installed by placing all the Apps Script files in this repository into a script bound to a Google Sheet.
##Working with Custom Dimensions/Metrics in Google Sheets ####Listing Custom Dimensions/Metrics To list custom dimensions/metrics from a property (or list of properties), run the List custom dimensions or List custom metrics command from the add-on menu. At the prompt, enter one or more property ID(s) from which to list custom dimension/metric settings in your sheet.
A new sheet will be added, formatted, and populated with the values from the properties listed.
If you update any of these values, you can update the custom dimensions/metrics in your property by running the Update custom dimensions or Update custom metrics function from the add-on menu.
####Updating Custom Dimensions/Metrics To update custom dimension/metric settings within a property or list of properties, run the Update custom dimensions Update custom metrics command from the add-on menu.
If you do not have a pre-formatted sheet, the script will format a new sheet for you into which you can enter your custom dimension/metric settings.
##Working with Filters in Google Sheets ####Listing Filters To list filters from an account, run the List filters command from the add-on menu. Enter one or more account ID(s) from which to list settings.
A new sheet will be added, formatted, and populated with the filter values from the account.
If you modify any of these values, you can update the filters in your account by running the Update filters function from the add-on menu.
####Updating Filters To update filter settings from the sheet to an account or list of accounts, run the Update filters command from the add-on menu. At the prompt, enter the account IDs (separated by commas) of the accounts that should be updated with the filter settings in your sheet.