Free GA Scripts and API for Automating Reports in Google Docs Presentation, PPT

Elegant, Efficient and Dynamic - this is how I would describe GA APIs capability to pull the desired reports in a flash. Knowing how to make use of the scripts and API to retrieve data is crucial to reduce the time and enjoy the additional data it could facilitate.

Google Analytics Real Time Data Obeys Profile Filters

Real time data reported in GA profiles can be accessed by non-admin users now, and the real time data obeys the filters set in profiles.

Google announced these changes through their blog. Read the blog post here.

Defining the GA API Query Parameters - Google Analytics API

Knowing how to define the API query parameters to pull out the data from Google Analytics profiles is imperative.

The reference guide from Google unfolds the defining methodology required to retrieve data from GA using API powered scripts.

There are two "super-duper" high level roofs containing thicker and thinner branches which you might want to know while dealing with GA API enabled reports. They are

1) Core Reporting API

2) Multi-Channel Funnels Reporting API

Here is the link to the API reporting developer guide

https://developers.google.com/analytics/devguides/reporting/

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.

http://analytics.blogspot.ca/2012/08/automate-google-analytics-reporting.html

GA API console for getting the API key

code.google.com/apis/console