Automating exports from Google Analytics for scheduled reporting

Post 31 of 60

While usually the most important and valuable analysis is ad-hoc, and done by an analyst, very often there is the need for scheduled exports and reporting of Google Analytics data.

Google Analytics provides some automation capabilities for custom reports, for a limited number of dimensions and metrics, but of course the results are subject to sampling (fast access mode).

The Analytics Canvas command line functionality goes much further, making it possible to query up to 7 dimensions and 10 metrics easily, and even more by taking advantage of the power of Analytics Canvas to join multiple data sets. By automatically pumping Google analytics data into a database, even more sophisticated analysis can be done, and sampling can be avoided by using query partitioning.

  • Run jobs at any frequency- Monthly, Weekly, Daily, hourly
  • Integrate Google Analytics into existing Business intelligence and reporting systems
  • Automatically extract data from Google Analytics using the API, and then insert into databases or files
  • Generate excel dashboards directly based on templates populated by Google Analytics data automatically
  • Avoid fast access mode sampling by running multiple queries seemlessly, deliver accurate data

With the command line functionality, not only can Google analytics data be automatically exported, but then based on the successful extraction of your analytics data, upstream tasks can be seemlessly run.

Get started now- Automate!

The free trial of Analytics canvas now includes the command line capability.

Try it free

This capability is licensed in the form of the Automation subscription, which is used in conjunction with the client subscriptions to provide a complete solution. Developers can create and run Canvases using Analytics Canvas desktop, and then run them on the command line enabled server version as needed.

For a brief overview of how to run Analytics Canvas from the command line, check out the command line documentation, which has examples and everything you need to start extracting from Google analytics using and automatic schedule, and avoiding mindless data manipulation for reporting, so you can spend more time doing Analysis, and driving your websites performance forward.

This article was written by James Standen

James is the founder of nModal Solutions, the creator of the Analytics Canvas tools. nModal's vision is to bring an entire new class of visual, flexible tools to web analytics and social media analysis. You can find him on Google+.

2 comments:

Cezanne HuqJuly 25, 2012 at 4:27 pmReply

Is it possible to derive raw data/clickstream files from Google Premium using your tool?

James StandenJuly 26, 2012 at 7:26 amReply

Hi Cezanne,

Google does not provide access to the raw data export that is available in Google Premium to the API (yet- Google if you are reading we’d love it!)

But we have a number of clients that are Google Premium customers, and they use our query partitioning feature to avoid sampling and can get exact data in the majority of cases.

Menu