Build Your Own Free Backlink Checker Tool With Google Sheets

A step-by-step guide to building a free automated backlink checker and monitor, using nothing but Google Sheets formulas & the official Google Analytics add-on.… Continue reading...


How to Find Low Competition Keywords You Already Rank For (And Blow Them Up!)

Mixing the keyword difficulty tool with the new 100-deep keyword positions In case you didn’t see it, SEMrush announced that they’ve expanded their US database in a big way. Not only did they double the amount of keywords in their US database, but they now track 100 positions deep for all of them.… Continue reading...


5 Reasons I’m Rebelling Against List Posts

1. I hate them I see them freaking everywhere. They’re all over everyone’s social media, plastered on every website, and beaten into the ground by every Buzzfeed clone out there. Oversaturation. I immediately tune them out and I can’t be the only one.… Continue reading...


Keyword Eye’s 25 Years of SEO Infographic

I saw this infographic while reading Keyword Eye’s blog, and it’s totally awesome. It’s like an illustrated path through the history of the SEO industry, search engines, and the impact of Google changes on everything. Click through to the article for even more good stuff.… Continue reading...


The Blatantly Obvious Guide to White Hat SEO Tactics

Something Something White Hat Tactics I was originally going to call this article How to do White Hat SEO in 3 Easy Steps or 3 Powerful White Hat SEO Tactics some similar lame click-baity thing, and while this is going to be a list of “white hat” things you can do right now, I hope to make it blatantly obvious that I believe the term “white hat SEO” is actually slick marketing speak for something much, much simpler.… Continue reading...


Using a Google Sheet as an Update Server!

Here’s a quick video to show you something I thought was really neat. I used a Google Sheet as kind of a DIY update server for an application I built, so that users wouldn’t overload my own server by checking for updates to software I made.… Continue reading...


Video: The SEO’s Guide to Kicking Ass with API

This is the recording of a webinar I did with SEMrush showing how to import APIs and web data into Google Sheets and manipulate that data to build tools and do pretty cool shit. Free SEMrush API Key: SEMrush gave me a free SEMrush API trial to give away for the webinar. … Continue reading...


How to Make a Simple Website Ripper with Google Sheets

Ripping a website’s source code is the starting point for many, many SEO tasks. Whether you’re verifying updates, checking for open graph, checking for schema markup, or trying to figure out which pages are missing that oh-so-important CSS file, if you’re in the SEO field – at some point, you’re going to be digging through source code.… Continue reading...