Author: M Smith
Automatically load CSVs received on email into Google Sheet
When working hands on with data, the data can be in many different forms and in many different locations. The most common format is arguably csv format, and the most …
Omnibug – Part 2 :: Analysing Adobe Analytics hits
In part 1 of this Omnibug series we looked at filtering web analytics hits that are detected by Omnibug and exporting this data into a csv (or tsv) format for …
Getting started with Google Apps Scripts
Google Apps Script is a great way to extend the functionality and potentially automate processes while working in Google Workspace. Google Apps Script can be thought of as the Google …
Omnibug – Part 1
In the life of a digital data analyst there comes a time(or many a time) when varification of exactly what is being tracked by Google Analytics or Adobe Analytics. This …
(Approximate) Median in BigQuery
Saving the code snippet here in the hopes you don’t also spend multiple hours trying to figure this one out. Luckily my use case didn’t require an exact median so …