📈 Independent SEO Consultant

Joined April 2011
1,956 Photos and videos
Almost ready. BigQuery integration for Indexing Insight. It can help you do cool things like...create workbooks and automated dashboards.
1
6
396
Indexing Insight BigQuery Claude. Starting to play around with connecting Google Indexing data with Claude using BigQuery connector. Immediately spotted a trend I never thought to plot.
139
Adam Gent retweeted
I'm in my next chapter, and with AI, the constraints are gone. I'm being bolder and dreaming bigger than ever. Here's the latest, plus a sneak peek at the new site I'm building. Even there, I'm reimagining how websites could work and what is useful. patrickstox.com/anthropic-pr…
19
19
174
30,870
It's alive! (BigQuery Data studio that is.)
2
213
System builder who is suspicious of checklists. That is actually pretty good. Shit.
"It's just token prediction, it doesn't actually know anything" 🙄
1
146
The page indexing report hasn't been updated since last Friday... ...I actually almost missed this. Mainly because my indexing data updates daily in Indexing Insight.
1
143
Adam Gent retweeted
Google has launched Search profiles for publishers and creators. So I built a tool to help you find Search Profiles from anywhere. search.audits.com/
8
24
113
16,076
Adam Gent retweeted
lots of SEOs critizicing others because they don't rank for SEO agency style terms. Here's a secret: Once you get past the small clients, big clients don't search for SEO agencies. They have procurement teams and issue RFPs. They find agencies through word of mouth, press mentions, conferences & events, and recommendations from trusted advisors. The truly successful SEOs don't need to rank for SEO terms.
24
7
97
15,177
Building a workbook in Google sheets. Help people see the trees for the woods. All using Ahrefs data. Not meant to be a full diagnostic workbook but give teams a direction/next steps.
1
2
189
BigQuery sure does help you unlock extra powers.
1
4
214
That explains the fluctuations.
Today we released the May 2026 core update. We'll update our ranking release history page when the rollout is complete: status.search.google.com/inc…
5
1,326
Adam Gent retweeted
@JHTScherck said it the other day but now I'm about to start adjusting whom I follow if every one of your posts is leaning into some AI grifter vs SEO convo. I'm open to the conversation but I don't need to follow 20 people all saying the same thing just 2. Also, It's an industry argument that isn't focused on solving problems for clients IMHO. Does LLMs.txt matter? Who cares? It takes like 5-10 minutes to find out put it up and see. If you believe it does great I hope you are also deploying a bunch of other tactics so you can improve the results for your client vs isolating this one thing. If you believe it doesn't, great I hope you are deploying a bunch of other tactics so you can improve results for your client vs isolating this one thing. Everything is new, for all you know an update in the training data could cause an AI to start using it when an old model didn't for all I know. In the early days of any optimization , we're all guessing, don't hang your hat on any one thing, just keep on trying and be open to learning. We're all in the same boat.
6
3
34
1,117
I know its not MCP server... ...but I'm testing out beta BigQuery feature for Indexing Insight. Reporting data, current indexing data and historic indexing data will soon be auto pushed to BigQuery.
1
126
I predict it will get worse. And I don't think it's a reporting bug.
Is everyone noticing Google de-indexing URLs randomly at a higher rate since the beginning of April?
1
261
Pretty cool. A personalized PageRank model for brand recall within Gemini's network. (i.e. AI Brand Authority measurement)
Mar 29
I have now fully mapped Gemini's authority network of 3,000,000 brands with full intention to commercialize this data through tool and SEO workflow integration. Process: dejan.ai/blog/brands/
1
3
429
Adam Gent retweeted
Let's talk about Google Click Signals... ...and how they drive website visibility for both Google rankings and AI answers The Google API leak exposed many of the exact click signals Google measures, with names like badClicks, goodClicks, and lastLongestClicks
12
22
149
11,942
I noticed a drop in brand clicks for Indexing Insight in the last few days. (There are not that many) Turns out AI Overviews has appeared for the brand keyword. Seems to have coincided with me writing a lengthy blog post about 23 things Indexing Insight does.
1
232
This is great resource on XML sitemaps for large websites. Honestly monitoring XML sitemaps has taught me a lot about setting up sitemaps. So many wild things we see happen as we monitor it on a regular basis.
Your sitemaps are probably lying to you. Not about which URLs exist — about what's actually happening with indexing. Most sitemap setups split files arbitrarily: sitemap_0.xml, sitemap_1.xml, sitemap_2.xml. Nice and tidy. Completely useless for diagnostics. When indexing drops, you see a number go down in Search Console. But which pages? Products? Articles? Location pages? With arbitrary splits, you genuinely cannot tell. Segment by content type instead, and sitemaps become a monitoring system. A drop in your products sitemap means something very different from a drop in your articles sitemap, and you can act on it immediately. There's also a detail most people miss: Google Search Console caps issue sample data at 1,000 URLs per sitemap. One monolithic sitemap = 1,000 samples. Ten segmented sitemaps = up to 10,000. That's not a minor difference when you're troubleshooting at scale. Wrote up the full approach: segmentation strategies, hierarchical indexes, naming conventions, and the trade-offs of making your sitemap structure public: visively.com/kb/algorithms/x…
1
1
5
1,018
Yes. Because, I built Indexing Insight a tool that helps track Google indexing at scale.
Are you tracking your indexing progress? Why or why not?
3
12
2,048