Blog Posts

a collection of all sorts of writings

Featured image for Pulling Data from DoubleClick Search Directly into Python

Pulling Data from DoubleClick Search Directly into Python

04 Mar 2018

Pulling data direct from the data source itself unlocks plenty of possibilities. For those using DoubleClick Search (DS3), it's best to pull data directly from DS3 when working with search engine marketing (SEM) data if we're hoping to do some data manipulation. Google's documentation isn't the best - I've seen ...

Featured image for Overpower Your Google Sheets with Python

Overpower Your Google Sheets with Python

26 Feb 2018

This post is updated on Jan 2019 following the version 2.0 release. Google Sheets by itself is just another spreadsheet application much like Excel. With Google Apps Script, it becomes a spreadsheet application with VBA-like features but (in my opinion) is easier to use. With the multitude of add-ons, it ...

Featured image for Google Sheets Functions to Speed Up Your Work

Google Sheets Functions to Speed Up Your Work

23 Feb 2018

This is the first post on this website and I would like to begin the blog with my 3 top functions on Google Sheets that will speed your work up by a lot. Query This is probably my favourite, but one which I use with caution as too many of them ...