Competitive Intelligence

For [brand name], first list all configured competitors to get their IDs. Then for each competitor, pull the count of variants where competitor_present = [competitor ID].

Build a competitor presence ranking: which competitors appear most frequently in AI responses across [brand name]'s tracked prompts? Calculate each competitor's presence rate vs. total variants. Rank them. Flag any competitor appearing in more than 30% of prompts — that's a dominant player worth analyzing further.

For [brand name], get the competitor ID for [competitor name] from the competitors list. Then pull variants filtered to:
- competitor_present = [competitor ID]
- brand_present = false

Limit to 50 results. This shows prompts where [competitor name] appears in AI responses but [brand name] does not.

For this set:
1. What topics or categories are these? Tag/topic breakdown
2. Are these branded or unbranded queries?
3. What is [competitor name] likely doing well that [brand name] isn't for these queries?
4. Which of these represent the most valuable queries to reclaim — highest observation count, most commercially relevant topics?

For [brand name], list all competitors and get their IDs. For each competitor, run two counts:
1. competitor_present = true, brand_present = false → competitor wins, brand loses
2. competitor_present = true, brand_present = true → both appear (co-mentions)

Build a displacement table showing for each competitor: how many prompts they win outright vs. share. Rank competitors by displacement rate. The top competitors are actively taking visibility that [brand name] should own.

For [brand name], pull variants where brand_present = true. Within this set, identify which prompts are non-branded (branded = false) — these are category queries where [brand name] is earning unprompted AI visibility.

Separately, for the top 3 competitors by presence rate, check their presence on the same prompts using competitor_present filter. Identify prompts where [brand name] appears and those competitors do not — these are [brand name]'s defensible positions.