Trevor Fox

Writing Custom Dimension to Google Analytics from Snowflake DB

1 Comment / Google Analytics, Tutorials /

Like many data geeks, Google Analytics first sparked my curiosity. Last week, Census released our Google Analytics integration. I could write a long list of game-changing applications for creating custom dimensions in Google Analytics from data in a Snowflake data warehouse, but I’ve been swirling around one that I find particularly interesting. Here’s what I’m thinking. Census, as […]

Writing Custom Dimension to Google Analytics from Snowflake DB Read More »

From Spreadsheets to SQL: Step One towards the Minimum Viable Data Stack

1 Comment / Minimum Viable Data Stack /

“A spreadsheet is just data in single-player mode” Last week I made a mistake. I boldly claimed that “A spreadsheet is just data in single-player mode.” And while I stand by that claim. I didn’t expect to be called to account for it. As it turns out, the post was pretty popular and I think

From Spreadsheets to SQL: Step One towards the Minimum Viable Data Stack Read More »

There’s something to learn from black hat SEO tactics for PDF files

Leave a Comment / SEO /

Go search Google for “free tiktok followers” and you will see some brilliant, although dirty #blackhat #SEO. Most of the top ten results belong to a spammer who has hacked into dozens of sites and created fake profiles and uploaded .pdf files to public directories with spun content. That scam is surprising, but what’s particularly

There’s something to learn from black hat SEO tactics for PDF files Read More »

Read This Before You Run Your First SEO A/B Test

Leave a Comment / Google Search Console, SEO, SEO and Web Development /

This is a quick post to provide context for the SEO A/B test-curious people out there. I was prompted by a thread in Measure Slack and figured long-form would make more sense. I didn’t want to make this another hideously long SEO-ified post but rather get to the point quickly.  Here’s the post and then

Read This Before You Run Your First SEO A/B Test Read More »

Scroll to Text Fragments

How to Highlight Text On a Page with “Scroll to Text Fragments”

1 Comment / For Humans, Javascript /

If you read my blog, you probably know that I am a bit of a geek about URLs. The “Universal Resource Locator” is a fundamental principle of the internet and are responsible for a lot of interesting features of the information superhighway. URLs make it possible to navigate from page to page, to change the

How to Highlight Text On a Page with “Scroll to Text Fragments” Read More »

Pulling Reddit Metrics into Google Sheets

Leave a Comment / Google Apps Script, Google Spreadsheets /

Reddit is a legend of the Web 2.0 transitionary time period. In that era, it was common to find rough edges around popular sites and features and Easter Eggs that could be described as “features that don’t exactly have any purpose, but some people might find it cool.” (Consider Google’s “I’m feeling lucky” feature… This post

Pulling Reddit Metrics into Google Sheets Read More »

CONTACT
CONTACT