If there’s one thing guaranteed to drive an analyst to drink or violence, it’s a request to update a 500-slide Powerpoint deck with thousands of once-tidy datapoints into a wipe-right-on-click abomination. I suspect that, in a desperate power grab, marketers are doing everything in their power to drag us analysts into the mud, to suffer as they suffer. Luckily, with help from Google’s Apps Script and their APIs, analysts can output all their data into a nice, tidy Google Sheet and auto-populate it into a Google Slides document with a single button press.

Continue reading

Ever wished you could grab a guilt-free coffee whilst your humungous R script completes processing and be notified when it’s done? With the glorious pushoverr package by Brian D Connely, you can! Here’s the final effect we’re looking for: This post will look at a simple example of how to set up Pushover on an Android phone, install the pushoverr R package and send yourself a push notification after running a script.

Continue reading

I had the pleasure of attending Measurecamp London in early March, and had an absolute blast. My Measure Slack pal Pawel Kapuscinski pointed out that I should stop being a wuss and host a session, so I scrambled some slides together on the Friday night. Here’s a copy of the slides, which look at how to use the Google Pagespeed Insights API, coupled with a couple of functions I put together, to pull speed insights at scale using R.

Continue reading

Below is a copy of the post I wrote for the wonderful Dartistics website, which is maintained by Tim Wilson and Mark Edmondson. This example creates a Sankey chart to show how traffic flows from the homepage, split by device category. Steps to achieve this are: Call google_analytics_4 to get unique pageviews, split by the secondPagePath dimension. We apply a dimension filter to limit the results only to users landing on our website homepage.

Continue reading

Author's picture

Donal Phipps


Analytical & data plumber

United Kingdom