Amazon Advertising
Amazon Ads SP Insights Report Download MCP
Download a completed Amazon Ads insights report from your connected advertising account and review the returned report data for further analysis.
Amazon Ads SP Insights Report Download AI Prompts & Use Cases
After connecting this MCP tool to your AI assistant, you can ask the questions below. Replace bracketed placeholders with your own inputs and use the supported values in Arguments.
New to Nexscope MCP? Follow the connection guide, then use the prompts below. The Integration and Parameters & Response tabs contain the connection steps, call example, and technical reference.
1. Download A Completed Insights Report
Prompt: Download my completed Sponsored Products insights report for [CONNECTION_ID] using the download reference returned by its completed report part. Summarize the content actually retrieved and do not display the backend download token.
2. Prepare A Report Table For Analysis
Prompt: Download my completed Sponsored Products insights report for [CONNECTION_ID] using the download reference returned by its completed report part. Summarize the content actually retrieved and do not display the backend download token. Parse the downloaded CSV with its actual headers. Return a column inventory and a small row preview, preserving blank cells; do not invent metrics absent from the file.
3. Combine Two Completed CSV Parts
Prompt: Download exactly two completed CSV parts [part A reference] and [part B reference] for my owned connection [connection ID], using their existing download references privately. Compare actual headers and report context first. Combine rows only when their structures and scope are compatible; otherwise keep the tables separate and explain the mismatch. Do not invent a deduplication key or assume these are every report part.
What You Need to Provide
Use an Amazon Ads connection you own. Keep credentials out of prompts. A report still processing is not a completed result; reuse its reference rather than creating it again.
Advertising changes require a preview and your explicit confirmation. These examples do not authorize changes by themselves.
Step 1 · Connect
Connect Your AI Assistant
Connect a compatible MCP client to Nexscope, then select this tool from your assistant. Use the connection settings in your client to complete authentication.
POST https://api.nexscope.ai/mcp
MCP-Protocol-Version: 2025-11-25
Content-Type: application/jsonAuthentication
Use OAuth 2.1 Authorization Code with PKCE and the mcp:tools scope. API keys remain supported as a compatibility option.
Authorization: Bearer nk-xxxxxxxxxxxxxxxxxUsing an API key? Get your key from API Access and include it in the Authorization header shown above.
Call this MCP tool
nexscope_amazon_ads_sp_insights_report_downloadhttps://api.nexscope.ai/mcptools/callInitialize an MCP 2025-11-25 Streamable HTTP session at https://api.nexscope.ai/mcp, then use tools/call.
{
"jsonrpc": "2.0",
"id": "amazon-ads-sp-insights-report-download-1",
"method": "tools/call",
"params": {
"name": "nexscope_amazon_ads_sp_insights_report_download",
"arguments": {
"connectionId": 123,
"documentToken": "opaque-document-token"
}
}
}MCP 2025-11-25 · Streamable HTTPProgress is delivered on the original POST SSE response. GET SSE carries notifications; reconnecting must query existing asynchronous work rather than submit again.
Arguments
| Name | Type | Required | Description |
|---|---|---|---|
connectionId | integer | required | Owned Amazon Ads connection ID; profile and region are resolved by the backend. Example: 123 |
documentToken | string | required | Backend-issued token from a completed report part, consumed by the existing download workflow. Example: opaque-document-token |
Response fields
Treat structuredContent as the programmatic API response payload.
| Name | Type | Required | Description |
|---|---|---|---|
code | integer | required | 0 means accepted or successful; nonzero is a platform error. |
cost | string | required | Elapsed milliseconds, never credits; -1 outside web requests. |
data | any | required | Data value used by this API operation. |
msg | string | null | required | Msg value used by this API operation. |
time | string | required | Server local time: yyyy-MM-dd HH:mm:ss. |
traceId | string | null | required | Trace id value used by this API operation. |
ts | string | required | Epoch milliseconds. |
Any of option 1
| Name | Type | Required | Description |
|---|---|---|---|
data | object | required | Data value used by this API operation. |
data.content | string | optional | UTF-8 CSV report content Example: date.value,metric.impressions
2026-08-01,10
|
data.contentType | string | optional | Downloaded media type Example: text/csv |
data.costTime | integer | optional | Execution time reported by the upstream provider. Example: null |
data.costToken | integer | optional | Token cost reported by the upstream provider. Example: null |
data.dataSnapshotMonth | string | optional | Data snapshot month returned by the upstream provider. Example: null |
data.page | integer | optional | Current page returned by the upstream provider. Example: null |
data.pageItemCount | integer | optional | Item count on the current page returned by the upstream provider. Example: null |
data.pageSize | integer | optional | Page size returned by the upstream provider. Example: null |
data.sourceTool | string | optional | Provider-specific source tool name. Example: null |
data.sourceType | string | optional | Provider-specific source platform type. Example: null |
data.title | string | optional | Provider-specific response title. Example: null |
data.totalPage | integer | optional | Total page count returned by the upstream provider. Example: null |
data.type | string | optional | Provider-specific render or payload type. Example: null |
Any of option 2
| Name | Type | Required | Description |
|---|---|---|---|
data | null | required | Data value used by this API operation. |
Format Illustration
Illustrative example with fictional data, not a live tool call.
Illustrative Question
Download my completed Sponsored Products insights report and summarize the returned CSV.
Illustrative Response Explanation
The illustrative CSV contains one row dated August 1, 2026, with 10 impressions. This download contains no clicks or spend, so CTR and cost per click cannot be calculated.
About this sample: Illustrative format example only; the 10 impressions are fictional. Replace the placeholder with the opaque document token returned for your completed report. A token cannot be invented from the report ID.
Published sample data is not available for this page. A format illustration or workflow guide is not a substitute for a published result.
View the MCP Request & Response Format
Examples
Illustrative example with fictional data, not a live tool call.
The JSON-RPC envelope below illustrates how the shown arguments and payload fit into MCP. It is not captured network traffic or proof of a successful call. Workflow-only examples do not include a result.
MCP Request
{
"jsonrpc": "2.0",
"id": "amazon-ads-sp-insights-report-download-example",
"method": "tools/call",
"params": {
"name": "nexscope_amazon_ads_sp_insights_report_download",
"arguments": {
"connectionId": 123,
"documentToken": "opaque-document-token"
}
}
}MCP Response Format
{
"jsonrpc": "2.0",
"id": "amazon-ads-sp-insights-report-download-example",
"result": {
"content": [
{
"type": "text",
"text": "{\"code\":0,\"msg\":null,\"data\":{\"content\":\"date.value,metric.impressions\\n2026-08-01,10\\n\",\"contentType\":\"text/csv\"},\"cost\":\"0\",\"time\":\"2026-01-01 00:00:00\",\"traceId\":null,\"ts\":\"1767225600000\"}"
}
],
"structuredContent": {
"code": 0,
"msg": null,
"data": {
"content": "date.value,metric.impressions\n2026-08-01,10\n",
"contentType": "text/csv"
},
"cost": "0",
"time": "2026-01-01 00:00:00",
"traceId": null,
"ts": "1767225600000"
},
"isError": false
}
}