Google Search Console Prompt Research

Using my connected Google Search Console (attached file) and OtterlyAI account (brand report ID: XXXXXXXXX), do the following:

1. Pull the top 20–30 question-style queries I already rank for in GSC (last 90 days). Filter for natural-language patterns: how, what, why, best, vs, alternative, top, should I, is X worth, X for Y. Prioritize by impressions × position (rank ≤ 20).

2. Classify intent for each query: Informational / Commercial / Navigational / Transactional.

3. Convert each query into a natural-language AI prompt — the way a real user would phrase it to ChatGPT, Perplexity, Gemini, or Google AI Mode. Keep the intent intact but make it conversational (e.g. "best CRM for startups" → "What's the best CRM for an early-stage startup in 2026?").

4. Cross-reference with OtterlyAI: for each generated prompt, check whether Otterly is already tracking an equivalent prompt for my brand.
Mark ✅ Tracked if Otterly has it (link to the prompt).
Mark 🆕 New — recommend adding if it's not tracked.
For tracked prompts, pull current brand-mention rate and NSS so I can see AI visibility at a glance.

5. Output a single table with columns: GSC Query | Impressions | Avg Position | Intent | AI Prompt | Otterly Status | Brand Mention % | NSS | Priority.
End with the "Overlap Gap" section — the prompts where I rank well on Google (position ≤ 10) but have zero or low brand presence in AI engines. These are the highest-leverage GEO opportunities. Rank them by GSC impressions and recommend the top 5 to add to Otterly tracking this week.

Tip: replace anything in [BRACKETS] with your own values, then paste this into Claude with the OtterlyAI connector enabled.