Trevor Fox

Web Addresses Explained: What Every Human Should Know About URLs

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 »

Google Analytics to Google Spreadsheets is Data to Insights

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 »

How To Add Multiple Columns to Google Spreadsheets

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 »

Slack

Is Slack Messenger Right for My Team? Analytics and Answers

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 »

Top 3 Resources to Learn Digital Marketing Technical Skills | $10k Tech Skills 4/4

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 »