Skip to main content

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

Popular posts from this blog

As the testing industry grows and matures, more testers will likely:

But before the testing industry can really prove its worth, more testers will need to know  why  they’re testing -- before they start running tests. To answer “why", you must first formulate a sound hypothesis. Your hypothesis needs to get to the core of what you’re trying to achieve through testing. Testers who start with solid hypotheses have better odds of running valid tests with significant results. Valid tests can lead to big conversion gains. Big conversion gains can equate to big revenue increases. And, of course, big revenue increases mean your company’s doing well. The rest is a no-brainer. If you’re helping your company profit, you might just get that bonus, after all!

Learn Adobe Analytics Marketing Reports & Analytics (SiteCatalyst) : Free Self Implementation Kit for Study

Here is the Adobe® Analytics marketing reports & analytics (SiteCatalyst) self Implementation kit to practice & learn - http://ats.adobe.com/jjsite/implementation_training.php /. There is no sandbox login, but you can see SiteCatalyst beacon firing up using browser debugger. SiteCatalyst Implementation Guide: https://marketing.adobe.com/resources/help/en_US/sc/implement/sc_variables.html Best Buy: http://www.amazon.com/Adobe-SiteCatalyst-Handbook-Insiders-Guide/dp/032185991X?tag=viglink122547-20

Creating exit offers causes friction and does little to improve conversions

Creating exit offers makes it difficult for your customers to leave without a conversion of some type. Exit offers might come in the form of an animated pop-up, a special offer, or something else that keeps visitors on your site longer. Yes, creating exit offers can create annoyance. But, when done correctly, they can also be highly beneficial. In this award-winning real-life test, using  an exit offer increased conversions an astounding 473%! Use exit offers to your advantage. Test new techniques and ways to create it.  Whatever you do, don’t let prospective customers easily leave without trying to get at least a micro-conversion from them.​