Universal analytics for checking co-operating processes

In Instrumenting VBA for Google Analytics and Universal analytics measurement protocol for your GAS libraries I showed how you could us Google Analytics to measure usage of modules and libraries. 
In db access to a variety of databases from Excel, the example accesses 6 or 7 different databases directly from Excel using DataHandler REST API which is built with Google Apps Script and uses many of the drivers covered in Database abstraction with google apps script. By instrumenting all of this with analytics, not only can I track historically who is using what module (see this blogpost), but also I can watch progress using real time analytics  to make sure all the right cloud based libraries are modules are being called in the right order. In other words I can see if any integration fails to do what I expect in real time. I found this to be invaluable when trying to debug this complex environment.

This really boring video, where nothing much seems to happen, shows a VBA process kicking off, followed by each of the Google Apps Script processes to which the backend work has been delegated to - all in the comfort of a single real time Analytics screen. If you stick with it, watch carefully the names of the screens changing as the different libraries kick in.

Real time analytics tracking module execution

Here's some slides frpm #devfestlon on this topic

final Instrumentation with Analytics.pptx

For help and more information join our forumfollow the blogfollow me on twitter

You want to learn Google Apps Script?

Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.