Skip to content
                        * Blog
                        * Services Menu Toggle
                            + B2B Growth
                            + GTM Engineering
                            + Data Strategy
                            + SEO Strategy
                            + AI Integration
                            + AI Search Strategy
                        * Tools Menu Toggle
                            + Keyword Grouper
                            + SEO Sitemap Analyzer
                            + LinkedIn Post Date Finder
                            + TikTok Post Date Finder
                            + Reddit Post Date Finder
                        * Classes Menu Toggle
                            + Learn SQL for SEO
                            + Learn Tech Skills
                    CONTACT
                  CONTACT
                Main Menu

              I Analyzed 8,000 LinkedIn Posts. The “Best Day to Post” Is Different for Everyone.

                Leave a Comment / Analytics , Linkedin / Trevor Fox

                Every LinkedIn advice article says post Tuesday through Thursday. I checked 7,913 posts from 63 profiles. The aggregate best day effect is basically zero — but your personal best day is worth 2x your worst. Here’s the data.

              I Analyzed 8,000 LinkedIn Posts. The “Best Day to Post” Is Different for Everyone. Read More »

              LinkedIn Analytics Tools for Creators Who Mean Business

                Leave a Comment / Analytics , Growth , Linkedin / Trevor Fox

                Last year, I was working with a B2B SaaS client whose founder had been posting on LinkedIn consistently for months. We had a hunch it was working — demo requests seemed to spike after certain posts. but we couldn’t prove it. The CRM showed booked calls, LinkedIn showed likes. But there was no way to

              LinkedIn Analytics Tools for Creators Who Mean Business Read More »

              How Claude Code Search Actually Works: What I Learned from the Source Code Leak

                Leave a Comment / Uncategorized / Trevor Fox

                A leaked copy of Claude Code’s source shows exactly how Claude performs web searches and processes the results. This isn’t about the search engine itself (that part is a server-side black box), but about everything around it: how queries are built, how results are processed, what the model actually sees, and what gets thrown away. If you’re

              How Claude Code Search Actually Works: What I Learned from the Source Code Leak Read More »

              Deconstructing ChatGPT Shopping Research Part 1: Simple Search

                Leave a Comment / ChatGPT / Trevor Fox

                If you’ve used ChatGPT for shopping recently, you’ve likely noticed something different. Just in time for Black Friday, ChatGPT introduced a major commerce feature that is likely to affect the shopping behavior of the nearly one billion people who use the platform. It’s a new, different, and variably opinionated approach to guiding a buyer to

              Deconstructing ChatGPT Shopping Research Part 1: Simple Search Read More »

              Introducing ChatGPT Entities: The Hidden Structured Data Powering AI Search

                Leave a Comment / For Humans , Growth , SEO , SQL , Tutorials / Trevor Fox

                I first noticed an interesting ChatGPT feature while demoing my ChatGPT Search Insights tool for Jeremy Galante, who leads SEO at ClickUp, during the Ahrefs Evolve conference a few weeks ago. We were looking into a strategy that he was just rolling out, and we saw this. He said, “Can you screenshot that for me?”

              Introducing ChatGPT Entities: The Hidden Structured Data Powering AI Search Read More »

              ChatGPT Hints and Modes: Exploring the Growth Opportunities Behind Them

                Leave a Comment / Growth , SEO , Tutorials / Trevor Fox

                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 / Trevor Fox

                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 »

              Attio Analytics Tooling: My Search for a Lightweight, Flexible GTM Analytics Stack

                Leave a Comment / Customer Segmentation , Growth , SQL / Trevor Fox

                A couple of weeks ago, while building out a scoring and segmentation model for a client, I arrived at a situation that Attio’s built-in reporting was not capable of handling. I explored a few options for analyzing prospect data (People and Companies) with varying degrees of success. I wrote this post to help you think

              Attio Analytics Tooling: My Search for a Lightweight, Flexible GTM Analytics Stack Read More »

              SEO SQL Pattern #2: Analyzing performance over time

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

                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 »

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

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

                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 »

          Post pagination
            1 2 … 11 Next →
          Search
            Search

          Let’s Stay Connected

            Follow on LinkedIn
                Subscribe to the blog Sign up!
            Leave this field empty if you're human:

              Categories

                * Analytics
                * BigQuery
                * ChatGPT
                * Customer Segmentation
                * Dataform
                * Digital Marketing Technical Skills
                * DIY
                * For Humans
                * Google Analytics
                * Google Apps Script
                * Google Search Console
                * Google Spreadsheets
                * Google Tag Manager
                * Growth
                * GrowthStudy
                * How to Scale Yourself
                * IoT
                * Javascript
                * Linkedin
                * Minimum Viable Data Stack
                * SEO
                * SEO and Web Development
                * SQL
                * Tutorials
                * Uncategorized
                * WordPress

          Recent Posts

            * I Analyzed 8,000 LinkedIn Posts. The “Best Day to Post” Is Different for Everyone.
            * LinkedIn Analytics Tools for Creators Who Mean Business
            * How Claude Code Search Actually Works: What I Learned from the Source Code Leak
            * Deconstructing ChatGPT Shopping Research Part 1: Simple Search
            * Introducing ChatGPT Entities: The Hidden Structured Data Powering AI Search
                    * Blog
                    * Services Menu Toggle
                        + B2B Growth
                        + GTM Engineering
                        + Data Strategy
                        + SEO Strategy
                        + AI Integration
                        + AI Search Strategy
                    * Tools Menu Toggle
                        + Keyword Grouper
                        + SEO Sitemap Analyzer
                        + LinkedIn Post Date Finder
                        + TikTok Post Date Finder
                        + Reddit Post Date Finder
                    * Classes Menu Toggle
                        + Learn SQL for SEO
                        + Learn Tech Skills
                CONTACT
              CONTACT
            * About Me
            * Contact
            * Blog
            * Privacy

          Growth Services

            * B2B Growth
            * SEO Strategy
            * Digital Marketing
            * GTM Engineering
            * AI Integration

          Data Services

            * Data Strategy & Activation

              Copyright © 2026 Trevor Fox
