Google GA Report Automation using API Powered Scripts - It's Easy | Google Web Analytics Consultant - Webanalytics Expert

Friday, October 19, 2012

GA Report Automation using API Powered Scripts - It's Easy

I came across a highly useful GA script for automating reporting needs of the clients in a quick span of time. It works using GA API key which is available for every one free of cost, and there is indeed a quota restrictions of 50,000 requests/day. For requests exceeding 50,000 there is a payment associated with every additional request. Nevertheless, the 50,000 requests is on the higher side for our needs, and we may not get exhausted with the permissible limit.
I personally tried this and it works incredibly. The good thing is even the dimensions and metrics which are not available in GA account profiles can be pulled using API without any additional customization (but not A to Z which requires code customization). Once we authorize the GA account any profile can be selected from Google docs where the script would be installed, and the need for logging into GA account can be reduced since we can query and get everything from Google docs itself. The needed data can be populated in any named sheet within docs in a short time, and powerful dashboards can be built.
Hope this information is of some help to all GA project needs.
Here is the blog post which talks about the “magic script” and its implementation for report automation using Google Docs.
GA API console for getting the API key


  1. I would like to say thanks for your sharing this useful information. Nice post keep it up. Hope to see you next post again soon.
    With Regards,
    PPC Services in Sydney | Responsive Design Services in Sydney

  2. This not only saves you time, which in itself is a big thing, but also helps you obtain productivity of the high caliber. Small Business All-in-one CRMs

  3. This comment has been removed by the author.

  4. A content specialist is depended to confirm screenplay contents to guarantee that poor contents are not chosen for shooting. A few contents seem perfect and simple to shoot, yet the specialist will have the capacity to see regions for development that others may neglect. The maker may have the content expert pick a triumphant content among many film contents. screenplay

  5. You have mentioned here great information here. I would like to say this is a well-informed article and also beneficial article for us. This article tells us about OEE Keep sharing this kind of articles, Thank you. OEE