Rankings & Priority Lists

For [brand name], pull prompt variants filtered to brand_present = true. Sort by observation_count descending. Return the top 10.

For each:
- Show the seed prompt text
- Show the platform
- Show the observation count
- Note whether it's branded or unbranded
- Note the tag/topic

Summarize: what do [brand name]'s best-performing prompts have in common? Topic, framing, funnel stage?

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

For each:
- Show the seed prompt text
- Show the platform
- Show the observation count
- Note whether it's branded or unbranded
- Note which competitors appear instead (if any)

Prioritize: which of these 10 gaps represents the most urgent fix, and why?

For [brand name], get the competitor ID for [competitor name]. Pull variants filtered to:
- competitor_present = [competitor ID]
- brand_present = false

Sort by observation_count descending. Return top 10.

These are the highest-stakes losses — prompts where [competitor name] is getting the AI mention and [brand name] isn't. For each, identify what content [brand name] would need to create or optimize to compete.

For [brand name], pull variants filtered to citation_domain = [brand domain]. Sort by observation_count descending. Return top 10.

These are the prompts where [brand name]'s own content is getting cited most by AI. Note which pages are cited and what topics they cover. These are the pages to protect, expand, and use as a model for other content.

For [brand name], get all tags. For each tag, pull:
- Total variant count for that tag
- brand_present = true count for that tag

Calculate visibility rate per tag. Return the 10 tags with the lowest visibility rate. Rank by urgency: low visibility rate combined with high observation count = highest priority.