Complete reference of natural language queries supported by PPC Prophet MCP.
These queries work with Claude Desktop, ChatGPT, Cursor, and any MCP-compatible client.
Date Range
All performance queries default to the last 90 days. Maximum supported range is 90 days. Queries requesting older data will automatically adjust to the most recent 90-day window.
💸 Wasted Spend Analysis get_wasted_spend
Find campaigns, keywords, or search terms spending money without converting.
Campaign-Level
Query
What It Does
"Show me wasted spend"
Top 20 campaigns with $5+ spend and 0 conversions
"Which campaigns are losing money?"
Same as above
"Find campaigns bleeding budget"
Same as above
"What's wasting my ad spend?"
Same as above
"Campaigns spending without sales"
Same as above
Keyword-Level
Query
What It Does
"Which keywords are losing money?"
Top 20 keywords with $5+ spend, 0 conversions
"Show me wasted spend on keywords"
Same as above
"Find keywords bleeding budget"
Same as above
"Keywords with no sales"
Same as above
"What keywords should I pause?"
Same as above
Search Term-Level
Query
What It Does
"Which search terms are wasting money?"
Top 20 search terms with $5+ spend, 0 conversions
"Show me bad search terms"
Same as above
"Search terms to add as negatives"
Same as above
With Custom Thresholds
Query
What It Does
"Show keywords with $10+ spend and no sales"
Raises min_spend threshold
"Find campaigns wasting at least $50"
Higher threshold for bigger accounts
"Show me the top 50 wasted keywords"
Increases result limit
🔍 Search Term Performance get_search_term_performance
Get search term metrics sorted by any KPI. Shows what customers are actually searching for.
Query
What It Does
"Show me top search terms by sales"
Best converting search terms
"Which search terms have the best ROAS?"
Most efficient search terms
"Search terms with highest ACOS"
Inefficient search terms to review
"Top converting search terms"
Highest conversion rates
"What are customers searching for?"
Top search terms by impressions
"Search terms with most clicks"
Traffic drivers
"Search terms with at least $10 spend"
Filter by minimum spend
"Top 50 search terms by sales"
Increase result limit
📊 Campaign Performance get_campaign_performance
Get campaign metrics sorted by any KPI.
Query
What It Does
"Show me top 10 campaigns by sales"
Best performing by revenue
"Which campaigns have the best ROAS?"
Sorted by return on ad spend
"Campaigns with highest ACOS"
Find inefficient campaigns
"Top campaigns by spend"
See where budget is going
"Show me campaigns sorted by clicks"
Traffic leaders
"Bottom 10 campaigns by sales"
Underperformers
📈 Overall Performance get_performance
Get aggregate performance summary.
Query
What It Does
"How did I do last month?"
Overall metrics summary
"What's my total spend this week?"
Aggregate spend
"Show me my ACOS for December"
Period summary with ACOS
"Performance summary for last 30 days"
Standard overview
⚖️ Period Comparison compare_periods
Compare performance between two date ranges with percent changes and trends.
Overall Comparison
Query
What It Does
"Compare last week to the week before"
Week-over-week metrics comparison
"How does this month compare to last month?"
Month-over-month comparison
"What changed compared to last month?"
Shows all metric changes
"Show me week-over-week changes"
WoW comparison
Campaign-Level Comparison
Query
What It Does
"Show me campaigns that improved this week"
Campaign comparison sorted by gains
"Which campaigns got worse?"
Campaign comparison (declining)
"Compare campaign performance month over month"
Campaign-level MoM
Keyword-Level Comparison
Query
What It Does
"Which keywords dropped in performance?"
Keyword comparison (declining)
"Keywords that improved this month"
Keyword comparison sorted by gains
"Show campaigns with at least 20% change"
Filter by min_change_percent
📦 ASIN Performance get_asin_performance
Get performance metrics grouped by advertised ASIN/product.
Query
What It Does
"Which ASINs are driving the most sales?"
Top ASINs by revenue
"Show me ASIN performance"
Default ASIN metrics
"Top performing products"
Same as above
"Which products have the best ROAS?"
ASINs sorted by ROAS
"ASINs with highest ACOS"
Inefficient products
"ASINs with at least $50 spend"
Filter by min_spend
🎯 Match Type Breakdown get_match_type_performance
Compare performance across keyword match types (exact, phrase, broad, auto).
Query
What It Does
"How does exact match compare to broad?"
Side-by-side comparison
"Show me match type breakdown"
All match types with metrics
"Which match type has the best ACOS?"
Efficiency comparison
"Exact vs phrase vs broad performance"
Comparison table
📅 Day of Week Analysis get_dayofweek_performance
Get performance breakdown by day of week (Monday-Sunday).
Query
What It Does
"Which day of the week performs best?"
Day breakdown with best day highlighted
"Show me day of week breakdown"
Full Monday-Sunday metrics
"Performance by day of week"
Same as above
"Should I adjust day-parting?"
Day analysis for scheduling decisions
"What days have the best ROAS?"
Days sorted by efficiency
🖥️ Platform Comparison get_platform_performance
Compare performance across advertising platforms (SP, SB, SD).
Query
What It Does
"How does Sponsored Products compare to Sponsored Brands?"
SP vs SB comparison
"Show me platform breakdown"
All platforms with metrics
"SP vs SB vs SD performance"
Full comparison
"Which platform has the best ROAS?"
Efficiency comparison
🔎 Root Cause Analysis diagnose_change
Answer "Why did my metric change?" by drilling down from account to campaign to keyword level, identifying primary drivers, and correlating with bid/budget changes.
Metric Change Diagnosis
Query
What It Does
"Why did my ACOS increase?"
Identifies campaigns driving ACOS change with CPC/CVR decomposition
"What caused the sales drop this week?"
Drills down to campaigns/keywords impacting sales
"Diagnose the spend increase"
Shows contribution breakdown for spend change
"Why is ROAS down compared to last week?"
Analyzes ROAS decline with driver attribution
"What's driving the CPC change?"
Correlates CPC change with bid activity
Custom Date Ranges
Query
What It Does
"Why did ACOS change between Jan 1-7 vs Jan 8-14?"
Custom period comparison
"Diagnose sales change this month vs last month"
Month-over-month analysis
How It Works
The diagnose tool calculates each campaign's contribution to the total change, decomposes metrics into factors (CPC, CVR, AOV), and correlates with bid/budget changes from your change history. Results show a 90% coverage cutoff—the top drivers that explain most of the change.
⚙️ Profile Management
Manage your Amazon Ads profiles and MCP activation.
Query
Tool Used
"List my profiles"
list_profiles
"Which profiles are ready?"
list_mcp_profiles
"Activate profile 2"
activate_mcp_profile
"Check status of profile 1"
check_mcp_status
📊 MCP Apps Interactive Widgets
MCP Apps render interactive visualizations directly in your chat. When you run certain queries,
you'll see rich data widgets instead of plain text. Currently supported in Claude Web and Claude Desktop.
Compatibility
MCP Apps require Claude Web or Claude Desktop with MCP Apps support enabled. Other clients will receive text fallbacks with the same data.
Wasted Spend AnalyzerInteractive
Example Prompt
"Show me wasted spend on keywords"
Wasted Spend
Total Wasted
$2,847.32
18
Keywords
1,247
Wasted Clicks
89,421
Impressions
$2.28
Avg CPC
organic dog treats
$612.40
premium pet food
$441.20
natural dog chews
$356.80
grain free kibble
$278.15
Keyword
Spend
Clicks
Action
organic dog treats
$612.40
287
premium pet food
$441.20
198
Visualize wasted spend across campaigns, keywords, or search terms. Sortable table with one-click pause actions.
Campaign Performance DashboardInteractive
Example Prompt
"Show me campaign performance for last month"
Performance Overview
Jan 1 - Jan 28, 2026
$12,847
Spend
$48,291
Sales
26.6%
ACOS
3.76x
ROAS
8,421
Clicks
847
Orders
Top Campaigns (Sales vs Spend)
Brand - Exact
Product - Auto
Competitor
Campaign
Status
Sales
ACOS
Brand - Exact Match
enabled
$18,420
18.2%
Product - Auto Targeting
enabled
$12,847
24.8%
Full campaign performance dashboard with metrics, charts, and sortable data. Color-coded ACOS/ROAS indicators.
Diagnose Change DashboardInteractive
Example Prompt
"Why did my ACOS increase this week?"
ACOS ⚠️ increased
17.2%
→
19.2%
+11.8%
Top Drivers
Brand - Exact Match SP
+29.3%
FACTOR BREAKDOWN
AOV-7.0% (worse)
CPC-7.3% (better)
CVR+0.8% (better)
TOP KEYWORDS
"brand name" (exact)+42.1%
"brand product" (phrase)-18.4%
Product - Auto SP
+24.8%
Root cause analysis that drills down from account to campaign to keyword level. Shows contribution breakdown with metric decomposition and bid correlation.
Query your PPC Prophet automation rules directly from Claude. View rule configurations,
check execution history, and monitor automation activity across profiles.
PPC Prophet Integration
These tools provide read-only access to your automation rules configured in the main PPC Prophet platform. To create or modify rules, use the PPC Prophet dashboard at app.getppcprophet.com.
Rule Management
Query
Tool Used
"Show me all my automation rules"
list_rules
"What bid adjustment rules do I have?"
list_rules (filtered by action)
"Show my negative keyword rules"
list_rules (filtered by action)
"Get details for rule ID 123"
get_rule_details
"What are the metric filters on rule 456?"
get_rule_details
"Which profiles is rule 789 applied to?"
get_rule_details
Execution History
Query
Tool Used
"What did rule 123 do last week?"
get_rule_outcomes
"Show me execution history for my bid rules"
get_rule_outcomes
"How many actions did rule 456 take this month?"
get_rule_outcomes
"Show me recent automation activity"
get_recent_rule_activity
"What automations ran today?"
get_recent_rule_activity
"Give me a summary of rule activity across all profiles"