Run Report Script

[Bertrand Morin]

Hi, 

Is it possible to use google script editor to run a add-on Analytics report ? I juste want to create a CTA which launch "run report" fonction and integrate other fonctions in it after. Do you think it's possible ? If yes, could you please provide me this script ? I'm novice in script editing and i don't have enough knowledge is this competence field.

Thanks for your help.

Bertrand.  

[Uberto Rapizzi]

Hi Bertrand,

Did you find a solution to your problem ?
I would like to do the same as I have a set of reports already create with the GA addons, but I would like to do some things programmatically before and after running the script.

If you are starting from scratch you could use the old Magic script mentioned here, but the syntax is a bit different and it won't be compatible with your GA reports using the addons.

Does someone know if this is possible with the GA addon ?

Cheers

Uberto

[Martin Meany]

Looking for the same thing myself.

[Carl Natale]

The GA add-on is protected from being triggered by Google Apps Scripting. So you have a couple options.

1) Use GAS and formulas to filter and manipulate the data imported by the GA add-on.

2) Use GAS to query GA and insert the data into the spreadsheet. Basically, you could write your own version of the GA add-on. There is a learning curve but it's doable.

There is a lot of help on Google forums, Stack Overflow and YouTube. I also found a great tutorial on Lynda.com. Since you call yourself a novice, I assume you have a grasp of GAS. You just need the time to work at it.