Trevor Fox

Bulk Hide, Show, Delete & Copy Multiple Sheets in Google Spreadsheets

Update: This script now allows you to copy multiple sheets within one spreadsheet to either the same spreadsheet or a different one. If you want to copy the sheet to the same spreadsheet just input you current spreadsheet’s id when prompted. The spreadsheet id can be found in the Spreadsheet’s URL eg: docs.google.com/spreadsheets/d/SPREADSHEETID/edit#gid=0 If you are looking …

Bulk Hide, Show, Delete & Copy Multiple Sheets in Google Spreadsheets Read More »

Data-Driven Marketing Starts With the Data Layer

The term “digital marketing “ should describe the marketing methods as much as it describes the marketing medium.   Too often, marketers are satisfied with their “digital marketing” efforts when they send a tweet, “blast” an email or run a search ad because their message is transmitted over a digital medium.  Unfortunately, this misunderstanding so vastly …

Data-Driven Marketing Starts With the Data Layer Read More »

Inspecting and Debugging the Google Tag Manager dataLayer

The Data Layer Inspector and Debugger This project began as a solution to a problem that I often faced setting up Google Tag Manager and specifically the data layer. The solution that I ended making was dataLayer logger, inspector, and debugger that offered the same features as the Google Analytics Debugger but for the data …

Inspecting and Debugging the Google Tag Manager dataLayer Read More »

Automate MailChimp Reporting with Google Spreadsheets

I made it! I am finally a nerd. At the top of the MailChimp API there is a clear disclaimer: “Woah, Nerds Only!” Undeterred, I scrolled on to test my nerdy medal. The following is my account of navigating the well-charted waters of the MailChimp API and a tutorial on how to automate a “BARF” …

Automate MailChimp Reporting with Google Spreadsheets Read More »

Google Result Date Bookmarklet Using “&as_qdr=y15”

I have been goofing around a lot with JavaScript lately. It’s fun to explore because every time I find and open a new door of understanding, there are two more doors to open and explore. I am currently in the room of browser functionality and thats where I found my bookmarklet. Making a bookmarklet was …

Google Result Date Bookmarklet Using “&as_qdr=y15” Read More »

Event Tracking on Squarespace Using Google Tag Manager

I like Google Tag Manager and Squarespace for the same reason: they simplify and streamline the processes website design and Google Analytics implementation while maintaining power and functionality of the product.  For the old sliced bread analogy, they are the greatest things to come along since the knife. Squarespace is a great plug-and-play, drag-and-drop Content Management System (CMS). It …

Event Tracking on Squarespace Using Google Tag Manager Read More »

What is Facebook “basic info?”

Facebook “Basic Info” Means “basically everything.” The odds are good that, at one time or another, you have probably downloaded and/or signed into a game, app, or website using your Facebook ID.  From Spotify to Instagram to some stupid cartoon vegetable game, you have seen the message that looks like this: THIS APP WILL RECEIVE: Basic Info (a list of …

What is Facebook “basic info?” Read More »