Platform-Specific Analysis

For [brand name], run the following analysis for each major platform (chatgpt, perplexity, claude, gemini, grok, meta):
- Total variants on that platform
- brand_present = true count on that platform
- brand_present = false count on that platform
- Visibility rate per platform

Rank platforms by visibility rate. For the two lowest-performing platforms, pull 10 example prompts where brand_present = false to show what types of queries [brand name] is missing there.

For [brand name], pull prompt variants filtered to:
- platform = [platform name]
- brand_present = false

Limit to 30 results sorted by observation_count descending. What is [brand name] consistently missing on [platform name]? Are the gaps concentrated in specific topics or tags? Is there a pattern to what [platform name] tends to surface vs. what [brand name] provides?

For [brand name], I want to find prompts where [brand name] appears on some platforms but not others.

Pull variants where brand_present = true for platform = chatgpt. Then pull brand_present = false for the same tag set on platform = perplexity. Compare the overlap — identify seed prompts where ChatGPT cites [brand name] but Perplexity doesn't (or vice versa). These inconsistencies reveal platform-specific optimization opportunities.