Blog Posts

a collection of all sorts of writings

Featured image for Auto Increase AdWords Daily Budget

Auto Increase AdWords Daily Budget

07 May 2018

AdWords daily budget is a safety measure implemented to ensure that you don't overspend your budget and ensure that your budget pacing is done well for the month, quarter or year. However, sometimes you'll have campaigns that you would like to fully fund, such as your brand keywords. Your competitors ...

Featured image for Importing Your Own Python Module or Python File in Colaboratory

Importing Your Own Python Module or Python File in Colaboratory

30 Apr 2018

It's a good practice to keep your code modular to enhance its value and applicability to a wider range of use cases. It also helps to make your Python script shorter, reduces clutter and easier to understand. Readers of your code only need to know the purpose of you calling the ...

Featured image for Make Your Colaboratory Code Easier to Use with Form Input

Make Your Colaboratory Code Easier to Use with Form Input

23 Apr 2018

I find the forms function on Colaboratory extremely useful when you're sharing your Colaboratory notebook for a wider audience. Some users might not really understand Python to edit the variables for their use cases safely. Hence, the forms function provides a dialogue-box interface to enable editing of variables via an ...

Featured image for Intro to Colaboratory and Linking it to Google Sheets

Intro to Colaboratory and Linking it to Google Sheets

16 Apr 2018

Colaboratory is an amazing new tool built by Google that is a Jupyter notebook running on Python 2 or Python 3 ran entirely on the Cloud. The main advantages I find to using Colaboratory are: Very easy to share your code: Just share it like any Google Drive files It's fast: I've ...

Featured image for Scheduling a Python Script to Run Upon Boot at a Predefined Time (Windows)

Scheduling a Python Script to Run Upon Boot at a Predefined Time (Windows)

09 Apr 2018

Running a Python script on a schedule can be useful, either for scheduled data mining or updating of a dashboard on Google Sheets. There are cloud solutions out there, but there's a simple GUI version of a scheduler for scripts on Windows that can be used. The programme is included ...

Featured image for Streaming Adwords Data for Processing on Google Sheets

Streaming Adwords Data for Processing on Google Sheets

02 Apr 2018

Digital marketers operating on Adwords often have to spend a lot of time downloading reports from Adwords. The most painful part is when we need to download the same report repeatedly. When it comes to repetitive tasks, Adwords has helped to simplify it by allowing us to use Adwords Scripts. ...

Featured image for Simple Sentiment Analysis with Python

Simple Sentiment Analysis with Python

21 Mar 2018

Sentiment Analysis is a very useful (and fun) technique when analysing text data. In this piece, we'll explore three simple ways to perform sentiment analysis on Python. Dataset to be used I slowly extracted by hand several reviews of my favourite Korean and Thai restaurants in Singapore. I chose what ...

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