SEO Depths
SEO Blog by Simone De Palma
-
Reddit Content Gaps: Compare Your Ranking Queries with Reddit Topics
Google Search Console tells you what you already rank for. Reddit tells you what people are still asking, arguing about and getting wrong. Compare the two to turn content gaps into opportunities. I built a Streamlit app on top of a Python pipeline that does exactly that: it compares GSC queries with Reddit discussions to…
-
Reddit Content Opportunity Finder with Gemini, Knowledge Graph API and Jev
Reddit threads are full of people asking the questions your content should already answer. The problem is volume. A single scrape can return thousands of comments, most of them noise, some of them about your competitors, and only a few of them genuine gaps you could fill with a guide, a landing page or an…
-
Grounded Prompts in your Search Console as a Brand Recall Indicator for LLMs and How to Map Them with BigQuery and Python
Prompts are essentially search queries and conversational questions that deserve grounding during RAG. So when someone sells you on “creating” a list of prompts to track AI visibility, remember: there’s nothing particularly creative about it. More importantly, you’re being asked to outsource your understanding of your own search demand to a tool. If you have…
-
How to Map out ChatGPT Grounding queries in BigQuery (from GSC and BWT)
ChatGPT’s relationship with the open Web is ever-changing, but the official data sources apparently don’t: Google Search Console and Bing Webmaster Tools retain the most interesting signals in plain sight The Reddit citation slump from ChatGPT proved that OpenAI is increasingly relying on its own web index and cached content while narrowing some of its…
-
Map out AI Mode Follow-up Queries using BigQuery
Conversational queries have always been buried in the Search Performance report, and yet many still underestimate their first-party search data The search for AI Mode queries is an odyssey, except you never truly come home. Google Search Console applies anonymisation and aggregation mechanisms to its query-level data, so not every query appears in the interface.…
-
Automating SEO Competitor Analysis with Python
How much of your competitor analysis is still manual? Many SEO professionals spend hours exporting reports, crawling websites, checking robots.txt files, analysing schema markup, comparing search results and grouping keywords into topics. While each task is valuable on its own, repeating the same process across multiple competitors quickly becomes time-consuming and difficult to scale. Fortunately,…
-
Testing a Markdown vs HTML Delivery Layer for AI Crawlers
Are AI bots more keen on retrieving a markdown or an HTML version of a page? For one of my pages, I used Cloudflare Workers to create a clean Markdown variant of a page delivered exclusively to OpenAI’s bots while leaving the normal HTML version for browsers and search engines. The point was to see…
-
Advanced AI Search Tracking: Mapping out ChatGPT Answers with Server Logs
Relying solely on search queries grounded in Search Console and Bing can highlight intent, but it may not fully capture broader patterns of engagement. To understand how AI systems access and display content, we need to look beyond queries and move closer to the infrastructure itself. Traditionally, log files have been difficult for SEO teams…
-
Advanced SEO Tracking Framework for Zero-Click and AI Visibility
As AI platforms emerge as new traffic channels, search behaviour is more fluid and nuanced. Unlike traditional search engines, AI visibility is harder to measure as AI responses are generated in real time. Prompt tracking is often mentioned, but common guidance on attribution is scarce. Besides, prompts are synthetic data projections based on actual search…
-
Backlink Semantic Analysis with Python: How to Evaluate Your Link Profile
Backlinks are foundational to SEO. They signal authority, relevance, and trust to search engines. Traditional backlink metrics like Domain Rating (DR) tell you how authoritative a linking site is, but they often miss how relevant those links are to your specific content. The Backlink Semantic Analysis project tackles this by combining authority metrics with semantic…
