Brand Presence & Visibility

For [brand name] in Scrunch, calculate the brand's overall AI visibility rate.

1. Pull the total number of prompt variants tracked for [brand name] — count only
2. Pull the count of variants where brand_present = true — count only
3. Calculate the visibility rate: (brand present / total) × 100
4. Break this down by platform — run the same brand_present=true count filtered to each LLM (ChatGPT, Perplexity, Claude, Gemini, Grok, Meta)
5. Rank platforms from highest to lowest visibility rate

Present the overall rate, the platform breakdown, and flag any platform where [brand name] is significantly above or below its average.

For [brand name], pull prompt variants filtered to brand_present = true. Limit to 50 results.

For this set, tell me:
1. Which platforms have the most brand presence
2. Which tags or topic categories appear most frequently — what topics does [brand name] win on?
3. Are these primarily branded queries (someone asking directly about [brand name]) or unbranded category queries?
4. What does the brand appear to be doing well based on the types of prompts where it appears?

For [brand name], pull prompt variants filtered to:
- branded = true (queries specifically asking about [brand name])
- brand_present = false

Count how many branded queries exist where [brand name] is NOT appearing in AI responses. This should be zero or near-zero for a healthy brand — flag if it's significant. List up to 20 of these prompts so I can see which branded queries the brand is missing.

For [brand name], run the following and report counts for each:
1. Total prompt variants (no filter)
2. brand_present = true, platform = chatgpt
3. brand_present = true, platform = perplexity
4. brand_present = true, platform = claude
5. brand_present = true, platform = gemini
6. brand_present = true, platform = grok
7. brand_present = true, platform = meta

For each platform, calculate the visibility rate vs. total variants on that platform. Rank platforms. Flag any where visibility is under 20% — those are priority gaps.

For [brand name], pull the actual response text behind the numbers instead of just the aggregate rate.

1. Pull prompt variants filtered to brand_present = true. Take the 5 highest-observation results.
2. For each, fetch the full response with get_response — the raw text, not just the presence flag.
3. Read how [brand name] is actually described: is it a recommendation, a passing mention, or one option among many?

Summarize: does the way [brand name] is described match how the brand wants to be positioned, or is the framing off even when presence is technically counted as a win?