In the same way that user interfaces allow us to interact with an application, Application Programming Interfaces (API) allow applications to interact with applications. How do API’s work? This is best illustrated by example. If you have ever witnessed a Twitter bot randomly like or retweet your tweet, you have seen an API in action. […]
What is an API? And Why Should I Care? Read More »
This week I did a Google Tag Manager implementation where I had no control over the site’s source code and no access to the site’s developers. It’s an imperfect situation but luckily, GTM Auto Event Tracking affords a solution that is very effective considering these constraints. This post is meant share a few tips on
9 Pro Tips for GTM Auto Event Tracking and the Click Element Variable Read More »
If you can remember your elementary school English lessons, you might recall learning how to format postal addresses so you could send a letter or navigate yourself to a particular destination. Today, most of us navigate to Web addresses far more often than street addresses and yet we no sense about how web addresses work, what
Web Addresses Explained: What Every Human Should Know About URLs Read More »
I spent some time at Rise Conference here in Hong Kong this week. The conference hosts a few hundred startups from all across Asia and offers each of them a booth, an opportunity to pitch, and the hope of meeting their next, investor, engineer, or growth hacker. It was complete startup sensory overload. The talks
8 Tips for Writing a Great Startup Company Description Read More »
I geeked out recently over the Android task automation app, Automate. The reason I got so excited was that it provided a very elegant solution for creating a custom NFC sensor for a project I’ve been working on. What I also came to find out was that Automate opened up a lot of possibilities beyond
IFTTT + NFC Tags: a Maker Channel Tutorial Read More »
I’ll admit, my posts have been lame lately, but don’t worry, I just found something that I’m pretty excited about! (This is not a paid endorsement, but it will get a bit geeky. ) Automate by LamaLab is a clean, simple, fun and free (!) way to turn your IoT imagination into reality. The app puts all
“Hello World!” with Automate for Android Read More »
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
First, Learn The Language Read More »
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 »
