Many years ago I posted a way you could open a Google Sheet at a specific row for editing. This let you do some url wrangling where you could direct […]
At the Association for Learning Technology (ALT) we use the open source CiviCRM for membership and events management. I’ve previously described how we are able to do Custom regular reporting […]
In a recent post I demonstrated how you can use Google Apps Script to add new tweets to a downloaded Twitter archive hosted on Github Pages. This project used the […]
tl;dr How do you keep your downloaded Twitter archive fresh on Github Pages using Google Apps Script? By running this Google Apps Script powered web app. If you were to […]
The day job at the Association for Learning Technology (ALT) and my Google Apps Script hobby made an unexpected collision recently when I was asked by Bruce Mcpherson to contribute […]
I recently got to try out a new talk at IWMW16 in Liverpool on ‘The Google Analytics of Things’: The majority of websites are using Google Analytics for tracking and […]
Tomorrow I’m looking forward to trying out a new talk at IWMW16 in Liverpool on ‘The Google Analytics of Things’. Tune in to the live stream at 2pm BST tomorrow (22nd June 2016) to watch.
The basic concept is that if you are using Google Analytics to track your website usage you can see the volume of traffic from particular sources including Twitter as a referral source. As referral links from Twitter are unique we can identify who originally tweeted the link to your site and measure its impact (number of visits, purchase, etc.).
Integrating third party APIs asynchronously with Google Analytics and batch sending tracking data whilst preserving the original activity timestamp
Having seen Google Apps Script develop over the last 7 years one of the key challenges was distributing custom scripts for others to use in your domain. In 2014 Google released add-ons, a way for developers to package and distribute custom functionality that can be added to your Google Sheets, Documents or Forms through the Google Apps Marketplace or the Add-ons store. This post outlines the basics of publishing add-ons to your own domain.