Trevor Fox

From Spreadsheets to SQL: Step One towards the 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

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

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”

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

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 »

Does CloudFront impact SEO? Let’s set it up for an S3 static site and test it!

This is the fifth post in my series about static site SEO with AWS. In the last post, we uploaded the static site to Amazon S3 so that it’s publicly accessible on the web. In this post, we’ll move beyond static site basics and start to discuss how Cloudfront CDN impacts load speeds and SEO. …

Does CloudFront impact SEO? Let’s set it up for an S3 static site and test it! Read More »