The final two SQL patterns posts focus on the core components of search: content and keywords. Today we’ll analyze how content (URLs) attracts traffic from search, and we’ll wrap up the series by analyzing how users search for that content. The URL dimension is perhaps the most important dimension in SEO because it represents the […]
SEO SQL Pattern #3: Grouping and filtering URLs for content analysis Read More »
The time dimension is often overlooked in digital analytics. We take it for granted because the whole point of digital marketing is to grow—traffic, customers, and revenue—over time. Performance is inherently a factor of time! This post follows from the post on Pattern #1, which is all about ranking data and does not take time
SEO SQL Pattern #2: Analyzing performance over time Read More »
Google Search Console only provides a few metrics: impressions, clicks, CTR, and average position. The first three are easy to understand, but the average position can trip up even the savviest analyst if they’re not careful. That’s why I started this series on SQL Patterns for SEO with a (perhaps overly) thorough explanation of how
SEO SQL Pattern #1: Aggregating Position Metrics and CTR Curves Read More »
Discover the differences between the searchdata_url_impression and searchdata_site_impression tables, and learn how they can help you analyze your site’s performance at different levels of granularity.
A Primer on Google Search Console Tables in BigQuery Read More »
You may have heard the hype about integrating Google Search Console and Google BigQuery using the new Bulk Export feature. If you’re like me, you recognize the power of analyzing SEO data with SQL or the BI tool of your choice (you’ve probably heard of Looker and Looker Studio). Or you might be thinking to
Google Search Console to BigQuery: The Complete Guide to GSC Bulk Export Read More »
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 »
You are probably here because you have more SEO data than you know what to do with and precious little time to make sense of it. A framework is exactly what you need. An SEO measurement framework draws the relationships between all the metrics that you collect and the levers that you can pull to
Metrics and Levers of an SEO Measurement Framework Read More »
Freshness matters. It matters to searchers, therefore it matters to search engines, therefore it should matter to you. The best tool to ensure that search engines have your site’s freshest content is your sitemap. This post explains why pinging search engines with your sitemaps is important for SEO and how to optimize the process and
Pinging Search Engines with Your Sitemap Works – Here’s How Read More »
Pssst… have you heard about Google Search Console’s BigQuery integration?? The thing I enjoy most about SEO is thinking at scale. Working at Postmates was fun because sometimes it’s more appropriate to size opportunities on a logarithmic scale than a linear one. But there is a challenge that comes along with that: opportunities scale logarithmically,
SEO with the Google Search Console API and Python Read More »
The Google Search Console Fetch and Render Tool is like putting on a pair of Googlebot goggles and looking at your own site through those lenses. If you have a simple website, (WordPress for example) that hasn’t been modified too much, you may not appreciate why this is important. But the more complex your site
