A Google Sheets add-on to enable bulk management of analytics configurations for enterprise users of Google Analytics.
By:pdro
Works with:
825
Overview
GA Management Magic
---------
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.

##Working with Custom Dimensions in Google Sheets
####Listing Custom Dimensions
To list custom dimensions from a property (or list of properties), run the __List custom dimensions__ command from the add-on menu. At the prompt, enter one or more property ID(s) from which to list custom dimension 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 in your property by running the __Update custom dimensions__ function from the add-on menu.

####Updating Custom Dimensions
To update custom dimension settings within a property or list of properties, run the __Update custom dimensions__ 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 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.
Additional information
PricingNot available
Developer
pdroTrader status unspecified
SupportNot available
Privacy policy
Terms of service
GA Management Magic will ask for the permissions shown below. Learn more
GA Management Magic will need access to your Google account
This will allow GA Management Magic 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
Connect to an external service
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
Edit Google Analytics management entities
See and download your Google Analytics data
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of GA Management Magic
November 2, 2017
So far so good in my effort to manage ONE property's custom dimensions. Pedro--I could not figure out how to publish a set of custom dimensions to multiple properties. I tried comma delimiting the property IDs with and without spaces, but got an error when I ran the update. Is it possible to publish dimensions to multiple properties from one sheet? Thanks, Nate UPDATE: It appears the only way to publish custom dimensions for multiple properties at a time is to copy and paste into separate rows and change property IDs. That's not a huge deal, except that we've started getting this message now that we have several rows we try to publish: "failed to update all dimensions Quota Error: You have exceeded the maximum number of writes/day for this project." So for larger efforts this tool has it's limits. UPDATE2: Tried publishing a batch of 184 Custom Dimensions on one of our accounts today (11/2/2017) and got a new message: "Failed to insert all dimensions Quota Error: Rate limit for writes exceeded." This tool is breaking my heart.
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
June 3, 2019
It worked great while I was using it last summer, but as of June 2019 does not seem to be functioning -- says a script needs permission to run, but then requests a log in... except then Google says it can't sign in because needs to be verified.
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
July 12, 2017
Awesome add-on! The only issue is the Quota Error, is there a way to install the add-on "locally" that way I can use my own Google Cloud quota instead of a shared one that I believe this add-on is using? Thanks in advanced!
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
December 2, 2016
Useful add-on and previous issues mentioned seem to be resolved. We have tweaked the scripts slightly for our situation but a great tool overall!
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
January 4, 2018
Doesn't appear to work anymore. At least, the update filter feature doesn't do anything.
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
March 1, 2016
Awesome at first. I gave it one star because I cannot update custom dimensions.I don't think it's the developers fault I think Google may have changed API>
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
October 19, 2017
I can't make it work. When listing filters I enter only the middle part (i.e. 123456) of UA-123456-12. Otherwise I get an error. Also, how to push the filters to another account? I tried just changing the ID and using update feature but I get "ReferenceError: "account" is not defined" every single time.
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
May 15, 2019
2019 Seems to of died completely for me.
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
July 4, 2018
The filter update functionality isn't working for me?
Is this review helpful?
Yes
No
Profile Picture
A User of GA Management Magic
September 23, 2016
I know I wrote it, but, MAN, do I like this add-on!
Is this review helpful?
Yes
No
1-10 of 10
Search
Clear search
Close search
Google apps
Main menu