Digital Marketing + SEO Blog

If you're looking for a rambling SEO blog with digital marketing musings, you've come to the right place.

Marketing Data Lakes & Warehouses

My most recent post covered strategy & planning for digital marketing agencies, specifically from an SEO perspective. In my mind, one of the most compelling questions was this: why aren’t there more success stories with SEO agencies? From my young perspective, I call out 5 things successful entrants can do for the best shot at […]

Digital Marketing Agency Strategy and Planning

Or, What Marketing Could be, Part 2 Recently I broke my unintentional blogging hiatus to write about what marketing could be, and things to think about if your organic search traffic from Google goes down. I fully intend to return to technical education and blogging, but perhaps the dawn of a new decade is bringing […]

Google Traffic Down!

The Hitchhiker’s Guide to Fielding and Surviving Frantic Client Requests *Fair warning, this is a live draft / work in progress post, as of 12/7/2019! Polishing pending.* “Our Google traffic is down!” If you’ve done any time in the SEO consulting or digital marketing business, you’ve seen this client (or manager) email at the most […]

Cover image of a blog post about automating Screaming Frog SEO crawls with command line and batch files

Automated Screaming Frog Reports With Command Line & Batch Files

Did you know that you can automate Screaming Frog crawl reports using Command Line and Windows batch files? First, the credit goes to Tom Gregan and Open Source SEO for cutting the trail. ­čÖé Starting with version 10, Screaming Frog SEO Spider has offered command line functionality– how cool is that? What’s more, the command […]

Photo taken by Texas SEO consultant at Clearwater Falls in Oregon

What Marketing Could Be, Part 1

The rambling preamble For those imaginary regular readers out there, I find myself again starting a post with, “…I know it’s been awhile since I last posted…” Yet it’s truly been, say, 2 years since my last post? Anyway, this year marked my 7th year in industry after college. I’m looking to reflect and document […]

JOINS in PostgreSQL

Welcome back, SQL-ites! Today, we’re going to take a significant leap forward in our journey of learning PostgreSQL. A quick recap on where we’ve been recently: The AS PostgreSQL statement An Intermediate PostgreSQL Skills Challenge, and, The HAVING clause in PostgreSQL In more broad terms, most of our PostgreSQL training so far has focused on […]

DSC_0050 Zach Doty AS PostgreSQL Statement Cover Photo

JOINS Foundations: The AS PostgreSQL Statement

Intro to JOINS: the AS PostgreSQL Statement What’s up SQL people? We’re back, and better than ever, in our foray to learn PostgreSQL. Since we’ve completed some intermediate skills challenges & learned GROUP BY, it’s time to examine JOINS. Before we examine JOINS, there’s a key foundation piece we must cover first: the AS statement […]

DSC_0012 Zach Doty PostgreSQL cover photo

PostgreSQL Intermediate Skills Test

Hey there, SQL-ites. Time for another (yes, another!) PostgreSQL skills challenge. It’s our last stop before moving into more intermediate and advanced PostgreSQL skills, such as JOINS. If you’re just joining this series on SQL, we previously covered the HAVING statement & GROUP BY. Here’s the home page of our journey in learning PostgreSQL.┬áToday, we […]

DSC_0300 Zach Doty Cover Photo for HAVING PostgreSQL Clause

The HAVING Clause in PostgreSQL

Howdy SQL-ites! Welcome back to our next step in learning SQL. After a long hiatus, we recently stumbled our way through some intermediate SQL statement challenges, namely on GROUP BY. Today, we’re back in the flow, and learning about the HAVING clause in PostgreSQL.   About the HAVING Clause in PostgreSQL The┬áHAVING clause is most […]

DSC_0006 Zach Doty Intermediate GROUP BY SQL Skills Challenge Cover Photo

Intermediate SQL Skills Challenge: GROUP BY

Hey there SQL-ites! Wow, it’s been awhile since I’ve last posted. Work has been crazy busy again, and just life in general. Sure feels good to be back, learning again! I’m daringly dropping straight back into my learnings from where we left off…in April!? Crazy. Anyway, let’s get back to brass tacks. Before life and […]