MCP Query Reference - PPC Prophet

💸 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.

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.

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.

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.

🔔 Alerts & Monitoring

Monitor your Amazon advertising accounts with automated alerts. View budget warnings, performance spikes, non-converting keywords, and more. Create custom alert rules to track the metrics that matter to you.

Alert Types

The system monitors 9 alert types automatically: BUDGET_USE (campaigns hitting budget caps), PROFILE_SPIKES and CAMPAIGN_SPIKES (unusual metric changes), NON_CONVERTING_KEYWORDS and NON_CONVERTING_TARGETS (spend without sales), UNMATCHED_PROFITABLE (converting search terms without keywords), UNMATCHED_MIRRORS (keywords missing on other platforms), ELIGIBILITY_ISSUES (ASIN advertising problems), and PROFILE_TRENDS (multi-day metric trends).

Alert Dashboard

Query	Tool Used
"Do I have any alerts?"	get_alert_summary
"Show me alert summary"	get_alert_summary
"What alerts do I have for Acme Corp?"	list_alerts
"Show me pending alerts"	list_alerts (filtered by status)
"Any budget warnings?"	list_alerts (filtered by type)
"Show me spike alerts"	list_alerts (filtered by type)

Alert Details & Actions

Query	Tool Used
"Show me details for this alert"	get_alert_details
"What keywords are non-converting?"	get_alert_details
"Which campaigns hit their budget?"	get_alert_details
"Acknowledge this alert"	acknowledge_alert

Alert Rule Configuration

Query	Tool Used
"Show me my alert rules"	list_alert_rules
"What am I monitoring?"	list_alert_rules
"Alert me if ACOS increases more than 10% week over week"	create_alert_rule
"Create a spend alert for impressions decreasing 20% monthly"	create_alert_rule
"Change rule 5 threshold to 15%"	update_alert_rule
"Delete rule #5"	delete_alert_rule

⚙️ Rules & Automation Integration PPC Prophet Subscribers

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 integrate with the PPC Prophet rules engine. View your automation rules, inspect configurations, review execution history, and manage alert rules—all through natural language. Alert rules can be created, updated, and deleted directly via MCP.

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"	get_recent_rule_activity