Skip to main content
Glama

DSP performance

get_dsp_performance
Read-only

Use for Amazon DSP Reporting v3 performance at order, line item, and creative grain: spend, sales, ROAS, viewability, and video completion. Do not use for Sponsored Products/Brands/Display, search terms, or seller account sales; use the matching ads or sales tool.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
limitNoMax rows (1-1000, default 20).
offsetNoPagination offset (0-100000, default 0). Use the returned pagination.next_offset to continue.
sort_byNoColumn to sort byspend
end_dateNoOptional. YYYY-MM-DD. Defaults to yesterday.
min_spendNoOnly include rows with at least this spend
order_nameNoFilter by DSP order name (LIKE match, use % for wildcards)
sort_orderNoSort orderdesc
start_dateNoOptional. YYYY-MM-DD. Defaults to 30 days ago.
creative_nameNoFilter by creative name (LIKE match, use % for wildcards)
line_item_nameNoFilter by DSP line item name (LIKE match, use % for wildcards)
include_raw_rowsNoFalse returns compact rows. Default true.
dsp_advertiser_idNoFilter by DSP advertiser ID
include_diagnosticsNoTrue may add expanded freshness diagnostics. Basic empty-result data-window diagnostics are included by default when available.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
evidenceNo

Schema Changelog

Changes observed during successful MCP inspections.

  1. Added

TDQS

A4.2/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare readOnlyHint=true, destructiveHint=false, and openWorldHint=false, so the safety profile is fully covered. The description adds the reporting grain and metric scope but says nothing about freshness/latency of the data, row limits, or pagination behavior beyond what the schema documents. With annotations carrying the safety burden, this meets the lower bar but adds only modest extra context.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two tight sentences: the positive scope comes first, the exclusions and routing second. Every clause earns its place, with no restating of the name or title.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a 13-parameter read-only reporting tool with a full output schema, the description supplies the scope, grain, and routing needed to select and call it correctly. Minor gap: no note on default date window behavior at the description level, though the schema and output schema cover the rest.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100% – every one of the 13 parameters, including the date defaults, LIKE-match filters, and diagnostics flag, is documented in the schema. The description adds no parameter-level detail (e.g., how order_name interacts with the grain), so the baseline 3 applies.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb (reporting on) and resource (Amazon DSP Reporting v3 performance) plus the grain (order, line item, creative) and the metrics returned (spend, sales, ROAS, viewability, video completion). This distinguishes it cleanly from sibling ad-reporting tools like get_sb_campaign_performance or get_sponsored_ads_report.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicitly covers both when to use (DSP performance by order/line item/creative) and when not to use it, calling out Sponsored Products/Brands/Display, search terms, and seller account sales as out of scope, then routing to 'the matching ads or sales tool'. Nothing is left to inference about tool selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.