Blog Posts

a collection of all sorts of writings

Featured image for Automated Multi-country Calendar Aggregator with Google Sheets

Automated Multi-country Calendar Aggregator with Google Sheets

16 Mar 2018

When working on a campaign/project that consists of teams from multiple regions or products/services available in multiple regions, it's useful to have the calendar of each country readily in view.  It can be useful for arranging a special promotion, arranging for team member's vacations and understanding impact to your campaign's ...

Featured image for Keyword Network Analysis with Python and Gephi

Keyword Network Analysis with Python and Gephi

11 Mar 2018

One of the key techniques when analysing keyword, headline or any text-related data is to find the connection between terms. Such analysis is called Network Theory or Graph Theory. In its simplest term, we are going to do a co-occurrence analysis between words. This can be extremely useful for discovering the ...

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

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 can possibly be very powerful at the expense of the speed to ...

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 ...