The following is an adaptation of the speech I gave at Hong Kong Toastmasters International speech competition. Thought is was interesting so I decided to post it. Do you remember your first day of school? How about your first time away from you parents or your first time out of the country. Do you remember […]
When you reach the limits of Google Analytics custom reports and you still need more, Google Spreadsheets and the Google Analytics Add-On can take you past sampling, data consistency and dimension challenges. This post is all about the Google Analytics + Google Spreadsheets workflow. It is an end-to-end example of how you can extract more
Google Analytics to Google Spreadsheets is Data to Insights Read More »
I recently ran into this problem when I was looking at someones Adwords account and wanted to get an idea about all the unique keywords that they were using. I used the following formula to get an array of all unique keywords: =UNIQUE(SPLIT(CONCATENATE(‘Keyword Report’!B2:B),” “)) But then I encountered a problem: “Error Result was not automatically
How To Add Multiple Columns to Google Spreadsheets Read More »
In Defence of QR Codes If QR codes aren’t being used effectively, it is more the fault of the publisher than the technology. The technology, despite its looks, is quite elegant and offers a lot of opportunity. However, there are some pretty significant barriers to adoption and use. So the burden is upon the publisher
QR Code Scan-to-Vote App Using IFTTT and Google Sheets Read More »
From AOL Instant Messenger to WeChat stickers, digital communication has always fascinated me. From the beginning, there has always been so much we don’t understand about digital communication. It’s kind of like GMO; we just started using it without considering the implications. We are continually learning how to use the the digital medium to achieve
Is Slack Messenger Right for My Team? Analytics and Answers Read More »
This is part one of four in the $10k Technical Skills for Digital Marketing series. You’ve gone a long way, Keep it up! Getting Started and the Learning Mindset Being a technical marketer is as much about using technologies as it is about learning and adapting to new ones. The learning mindset may not get its
Top 3 Resources to Learn Digital Marketing Technical Skills | $10k Tech Skills 4/4 Read More »
Why? Because, connect all the things! Why else? Because the less information people have to fill into your form, the more likely they are to complete it – especially if you are asking them to fill in information that they will have to look up! Dynamically, pre-filling forms are a great conversion optimization hack to
Dynamically Pre-fill Google Forms with URL Parameters Read More »
Google Analytics got a whole lot more interesting when the Measurement Protocol was introduced. We already knew GA was the industry standard for web analytics but with the Measurement Protocol it has become the analytics platform of anything and everything that can be made digital. With some clever instrumentation, we can now use it to
Track REST APIs with the Google Analytics Measurement Protocol Read More »
This is part 3 of 4 of the $10k Technical Skills for Digital Marketing. You could be so much faster! Right now, you are using your browser to view HTML pages. You go to a page, get some information and move on. Imagine how much more information you could gather if you could tell your browser to look at
Learn the Power of API’s for Digital Marketing | $10k Tech Skills 3/4 Read More »
You know what’s cooler than calling API’s and services with Google Apps Script? Making your own API with Google Apps Script. After playing around with my first REST API with Python and Bottle, I wondered how this could be done even cheaper and quicker; without worrying about the complexities of databases and hosting. When it’s simple
How to Make a Google Apps Script RESTful API or Service Read More »
