# Synced reports (https://sellersheetai.com/docs/mcp-api/workflows/reports)

> Your Amazon and noon reports, synced on a schedule into your own tables — your agent queries them in seconds, months back, without waiting on Amazon.



<Callout title="In short">
  SellerSheet syncs <Count name="tables.total" /> report tables for every connected store — inventory, listings, orders, returns, settlements, Data Kiosk sales and traffic, every Sponsored Products, Brands and Display report, and noon. `query_report_data` filters, joins and totals them instantly.
</Callout>

## How it works [#how-it-works]

<Steps>
  <Step>
    ### Reports sync on their own [#reports-sync-on-their-own]

    Each table has its own schedule, set when the store connects. Nothing to request, nothing to wait for. `list_report_syncs` shows what syncs for a store and when it last ran.
  </Step>

  <Step>
    ### Your agent reads the schema first [#your-agent-reads-the-schema-first]

    `get_table_schema` returns the columns, types and unique key of one table, so the query uses real column names. Every table also has its own page on the [Data](/docs/data) tab.
  </Step>

  <Step>
    ### One query, any date range [#one-query-any-date-range]

    `query_report_data` takes the tables, columns, filters, grouping and sort — results come back in seconds and do not use Amazon's rate limits. Your agent writes them to your sheet when you work there.
  </Step>
</Steps>

## Try asking [#try-asking]

> "What were my top 10 products by revenue last month?"

> "From the synced inventory reports, find stock that hasn't sold in over 90 days."

> "Total sales and sessions by week for the last 3 months, as a trend table."

## A query, both ways [#a-query-both-ways]

**MCP** — you ask: "How many orders did I get yesterday?" Your agent calls `query_report_data` on the orders table.

<ToolCall tool="query_report_data" args="{ tables: [&#x22;rpt_orders&#x22;], columns: [&#x22;amazon_order_id&#x22;, &#x22;purchase_date&#x22;, &#x22;item_price&#x22;], limit: 100 }" />

## Tools on this page [#tools-on-this-page]

<ToolList tools="[&#x22;query_report_data&#x22;, &#x22;get_table_schema&#x22;, &#x22;list_report_syncs&#x22;]" />

## FAQ [#faq]

### I need data fresher than the last sync. [#i-need-data-fresher-than-the-last-sync]

Request a report from Amazon directly — see [On-demand reports](/docs/mcp-api/workflows/reports-ondemand) — or call the live tool for that area, such as [Orders](/docs/mcp-api/workflows/orders) or [FBA inventory](/docs/mcp-api/workflows/fba-inventory).

### Where is the list of tables? [#where-is-the-list-of-tables]

On the [Data](/docs/data) tab — each table with its report type, cadence and columns.

### Is there a skill for this? [#is-there-a-skill-for-this]

Yes — the `report-data` skill teaches your agent the tables and the query patterns. See [Install the skills](/docs/start/skills).