Analytics

ChatGPT Hints and Modes: Exploring the Growth Opportunities Behind Them

Leave a Comment / Growth, SEO, Tutorials /

One of my favorite ways to identify or scale up growth tactics is to reverse engineer the platforms that direct people’s attention and shape their perception. ChatGPT, like Google, Facebook, and LinkedIn before it presents the biggest opportunity today—both in terms of overall growth expectations and leverage. (It’s early!) ChatGPT has several interesting components that, […]

ChatGPT Hints and Modes: Exploring the Growth Opportunities Behind Them Read More »

SEO SQL Pattern #3: Grouping and filtering URLs for content analysis

Leave a Comment / BigQuery, Google Search Console, SEO, SQL /

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 »

Charting a CTR Curve with BigQuery

SEO SQL Pattern #1: Aggregating Position Metrics and CTR Curves

2 Comments / BigQuery, Google Search Console, SEO, SQL /

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 »

Longtail Query Analysis in BigQuery using Levenshtein Distance

Leave a Comment / BigQuery, SEO, SQL, Tutorials /

A few days ago, Cyrus Shepard posted an example about using Levenshtein distance to compute the similarity or dissimilarity (aka the edit distance) between two strings. His example showed how to apply Levenshtein distance in Google Sheets in the context of written content, but it inspired me to demonstrate another common application: query similarity.  Since

Longtail Query Analysis in BigQuery using Levenshtein Distance Read More »

Fostering Collaborative Analytics: A Founder’s Guide

Leave a Comment / Growth /

In today’s all-or-nothing startup environment, young businesses need to be near-perfect in every aspect to succeed. As startups grow, analytics is the key to success. And yes, data-driven insights can be a game-changer. However, a widespread challenge persists: most startups struggle to integrate analytics seamlessly into their day-to-day business operations. As a founder, you have

Fostering Collaborative Analytics: A Founder’s Guide Read More »

The two steps in Dataform execution: Javascript, then SQL statements

Understanding SQLX and Javascript in Dataform

Leave a Comment / BigQuery, Dataform, Google Analytics, Javascript, SQL /

When you think of “programming languages for data,” Javascript probably doesn’t even make the list. Yet, if you’re using Dataform, it’s almost impossible to avoid. As you’ll learn in this article, Dataform is Javascript all the way down. Even SQLX files that you write are pretty much just Javascript files under the covers. So shed

Understanding SQLX and Javascript in Dataform Read More »

Google Search Console to BigQuery: The Complete Guide to GSC Bulk Export

7 Comments / BigQuery, Google Search Console, SEO, SQL, Tutorials /

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 »

CONTACT
CONTACT