Automating exports from Google Analytics for scheduled reporting

James Standen Analytics Canvas Tool, Automation 9 Comments

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.

Comments 9

    1. Post

      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.

  1. How can one automate the export of data instead of having to ‘Run with all data and write to exports.’ This currently works but don’t see any documentation regarding how to do this automatically.

    1. Post

      Hi Anshuman,

      If you look in the help files or the online documentation under automation, it defines how to run Analytics Canvas from the command line, or using the Automation wizard to generate a .bat file that will run one or more canvases. It is also possible to have emails sent on success and failure of automated runs. All of this functionality is available with the Automation subscription- this is an add-on to the other desktop subscriptions and provides a machine license for canvas to run in this automated mode. This allows for scheduling and integration into enterprise systems etc.

  2. We are sending the encrypted data (Page URLs, Document URLs..) from our site to Google Analytics.

    Do you provide any feasibility in Analytics Canvas to apply the custom transformation logic on the fly (Javascript or c#) to the data that will be exported (page urls etc..) before the import to custom database.

    1. Post

      With Analytics Canvas automation, Canvases can be integrated with any executable logic so what you are describing is certainly possible. A single script could run a canvas to do the extract, run a c# process that does the transformations, then run another canvas that imports the transformed data into the database.

      1. Hello James,

        Thanks for your quick reply. Can you please help us in providing the related tutorial for automation. I have taken a trial of Analytics Canvas and would like to try this option of decryption and validate the information from Google Analytics.


  3. We are trying to export the user id for all users who clicked on a particular activity on on site. Is it possible using GA to automatically export this list say daily or weekly?

Leave a Reply

Your email address will not be published. Required fields are marked *