Visibility Gaps & Content Opportunities

For [brand name], get all tags from the Scrunch configuration. For each tag, pull:
- Total variants with that tag
- Variants with that tag where brand_present = false

Calculate a "gap rate" per tag (brand absent / total). Rank tags by gap rate from highest to lowest. The top tags are the highest-priority content investment areas. Show me the top 10 gap tags and list 5 example prompts from each of the top 3.

For [brand name], pull prompt variants filtered to:
- branded = false (unbranded category or comparison queries)
- brand_present = false

Limit to 50 results sorted by observation_count descending.

For this set:
1. What topics or categories are these prompts in?
2. What does a prospect appear to be searching for when [brand name] doesn't appear?
3. Group these into 3–5 thematic clusters — these represent distinct content gap areas
4. For each cluster, identify what type of content [brand name] would need to appear for these queries

For [brand name], pull prompt variants where brand_present = false. Sort by observation_count descending. Return the top 25.

For each:
- Show the prompt text
- Show the platform
- Show the observation count
- Note whether it's a branded or unbranded query

Flag any branded queries in this list — a brand missing its own branded queries at high observation volume is an urgent issue.

For [brand name], I want to identify prompts where [brand name] is close to appearing but isn't yet.

Pull prompt variants where:
- brand_present = false
- branded = false
- The prompt text contains keywords related to [brand name]'s core category (use search filter: "[category keyword]")

List up to 30 results. For each, explain why [brand name] likely doesn't appear and what content change would most likely flip this to a brand_present = true result.