Data

The report tables SellerSheet keeps in sync for every connected store.

SellerSheet syncs 72 report tables — 21 seller, 45 Ads and 6 noon — that your AI queries with query_report_data.

How syncing works

  • On a schedule, per table. As soon as a store is connected, SellerSheet requests each report from Amazon (or noon) on that table's own cadence — shown on every table's page — and keeps the rows. Your agent never waits for Amazon to build a report: query_report_data answers from the stored rows in seconds and spends none of Amazon's rate limits.
  • Active marketplaces only. Only the marketplaces active on your plan sync. A store with no active marketplace is paused and refused rather than answered from stale rows — see Store refs.
  • Live when it must be live. For "right now" questions — one SKU's stock before a shipment, one order's status — your agent calls the live tool instead. See Synced reports.
  • No buyer personal data. No table holds a buyer's name, e-mail or street address — see Data we never see.

Find a table

Search by table name, report type or column name. How fresh is it? says how often a table syncs, with its exact schedule under it. Need it right now? names the live tool your AI calls instead when the last sync is not recent enough — "—" where no live tool answers that table.

Seller reports (SP-API) (21)

TableHow fresh is it?Need it right now?
rpt_dk_sales_traffic_by_asinDK_SALES_TRAFFIC_BY_ASINDailyDaily at 01:19 marketplace local timesales_getOrderMetricssales, not traffic
rpt_dk_sales_traffic_by_dateDK_SALES_TRAFFIC_BY_DATEDailyDaily at 01:18 marketplace local timesales_getOrderMetricssales, not traffic
rpt_get_afn_inventory_dataGET_AFN_INVENTORY_DATASeveral times a dayEvery 6 hours, on the hour (marketplace local time)fbaInventory_getInventorySummariesone or a few SKUs
rpt_get_afn_inventory_data_by_countryGET_AFN_INVENTORY_DATA_BY_COUNTRYSeveral times a dayEvery 6 hours, on the hour (marketplace local time)fbaInventory_getInventorySummariesone or a few SKUs
rpt_get_fba_estimated_fba_fees_txt_dataGET_FBA_ESTIMATED_FBA_FEES_TXT_DATADailyDaily at 01:08 marketplace local timeproductFees_getMyFeesEstimateForSKUone SKU at a price
rpt_get_fba_fulfillment_customer_returns_dataGET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATADailyDaily at 01:02 marketplace local timeSynced only
rpt_get_fba_fulfillment_longterm_storage_fee_charges_dataGET_FBA_FULFILLMENT_LONGTERM_STORAGE_FEE_CHARGES_DATADailyDaily at 01:07 marketplace local timeSynced only
rpt_get_fba_fulfillment_removal_order_detail_dataGET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATADailyDaily at 01:03 marketplace local timeSynced only
rpt_get_fba_fulfillment_removal_shipment_detail_dataGET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATADailyDaily at 01:11 marketplace local timeSynced only
rpt_get_fba_inventory_planning_dataGET_FBA_INVENTORY_PLANNING_DATASeveral times a dayEvery 6 hours, at minute 5 (marketplace local time)Synced only
rpt_get_fba_myi_all_inventory_dataGET_FBA_MYI_ALL_INVENTORY_DATASeveral times a dayEvery 6 hours, at minute 15 (marketplace local time)fbaInventory_getInventorySummariesone or a few SKUs
rpt_get_fba_reimbursements_dataGET_FBA_REIMBURSEMENTS_DATADailyDaily at 01:04 marketplace local timeSynced only
rpt_get_fba_storage_fee_charges_dataGET_FBA_STORAGE_FEE_CHARGES_DATADailyDaily at 01:06 marketplace local timeSynced only
rpt_get_flat_file_returns_data_by_return_dateGET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATEDailyDaily at 01:01 marketplace local timeSynced only
rpt_get_ledger_detail_view_dataGET_LEDGER_DETAIL_VIEW_DATADailyDaily at 01:00 marketplace local timeSynced only
rpt_get_merchant_listings_all_dataGET_MERCHANT_LISTINGS_ALL_DATADailyDaily at 01:05 marketplace local timelistings_searchListingsItems
rpt_get_merchants_listings_fyp_reportGET_MERCHANTS_LISTINGS_FYP_REPORTDailyDaily at 01:09 marketplace local timelistings_searchListingsItems
rpt_get_stranded_inventory_ui_dataGET_STRANDED_INVENTORY_UI_DATASeveral times a dayEvery 6 hours, at minute 30 (marketplace local time)Synced only
rpt_get_v2_seller_performance_reportGET_V2_SELLER_PERFORMANCE_REPORTDailyDaily at 01:10 marketplace local timeSynced only
rpt_get_v2_settlement_report_data_flat_file_v2GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2Several times a dayEvery 12 hours, at minute 17 (marketplace local time)finances_listFinancialEventGroups
rpt_ordersGET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL|GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERALHourlyEvery hour, on the hourorders_searchOrders

Amazon Ads reports (45)

TableHow fresh is it?Need it right now?
rpt_ads_ad_groupsads-roster/ad-groupsDailyDaily at 01:41 marketplace local timeSynced only
rpt_ads_adsads-roster/adsDailyDaily at 01:43 marketplace local timeSynced only
rpt_ads_campaign_dailyads-performance-v1/campaign-dailyHourlyDelivered by Amazon Marketing Stream, hourlySynced only
rpt_ads_campaign_hourlyads-performance-v1/campaign-hourlyHourlyDelivered by Amazon Marketing Stream, hourlySynced only
rpt_ads_campaignsads-roster/campaignsDailyDaily at 01:40 marketplace local timeSynced only
rpt_ads_converted_product_dailyads-converted-product-v1HourlyDelivered by Amazon Marketing Stream, hourlySynced only
rpt_ads_performance_dailyads-performance-v1/dailyHourlyDelivered by Amazon Marketing Stream, hourlySynced only
rpt_ads_performance_hourlyads-performance-v1HourlyDelivered by Amazon Marketing Stream, hourlySynced only
rpt_ads_targetsads-roster/targetsDailyDaily at 01:42 marketplace local timeSynced only
rpt_amc_atc_by_search_termAMC_ATC_BY_SEARCH_TERMSeveral times a dayWeekly (Amazon schedule, Monday 00:00 in the marketplace zone)Synced only
rpt_amc_campaign_overlapAMC_CAMPAIGN_OVERLAPWeeklyEvery 4 weeks (on demand, 15 days after the 28-day period ends)Synced only
rpt_amc_cross_sell_next_purchaseAMC_CROSS_SELL_NEXT_PURCHASEWeeklyEvery 4 weeks (on demand, 15 days after the 28-day period ends)Synced only
rpt_amc_first_vs_attributed_termAMC_FIRST_VS_ATTRIBUTED_TERMWeeklyEvery 4 weeks (on demand, 15 days after the 28-day period ends)Synced only
rpt_amc_hour_of_dayAMC_HOUR_OF_DAYSeveral times a dayWeekly (Amazon schedule, Monday 00:00 in the marketplace zone)Synced only
rpt_amc_impressions_per_shopperAMC_IMPRESSIONS_PER_SHOPPERWeeklyEvery 4 weeks (on demand, 15 days after the 28-day period ends)Synced only
rpt_amc_keyword_haloAMC_KEYWORD_HALOWeeklyEvery 4 weeks (on demand, 15 days after the 28-day period ends)Synced only
rpt_amc_ntb_by_campaignAMC_NTB_BY_CAMPAIGNSeveral times a dayWeekly (Amazon schedule, Monday 00:00 in the marketplace zone)Synced only
rpt_amc_ntb_gateway_asinsAMC_NTB_GATEWAY_ASINSWeeklyEvery 4 weeks (on demand, 15 days after the 28-day period ends)Synced only
rpt_amc_path_to_conversionAMC_PATH_TO_CONVERSIONWeeklyEvery 4 weeks (on demand, 15 days after the 28-day period ends)Synced only
rpt_amc_time_to_conversionAMC_TIME_TO_CONVERSIONWeeklyEvery 4 weeks (on demand, 15 days after the 28-day period ends)Synced only
rpt_sb_ad_groupssbAdGroupsDailyDaily at 01:00 marketplace local timeSynced only
rpt_sb_advertised_productssbAdvertisedProductDailyDaily at 01:00 marketplace local timeSynced only
rpt_sb_campaignssbCampaignsDailyDaily at 01:00 marketplace local timeads_campaigns_budget_usagetoday's budget use
rpt_sb_keywordssbKeywordsDailyDaily at 01:00 marketplace local timeads_query_targetcurrent bids and state
rpt_sb_negative_keywordssbNegativeKeywordsDailyDaily at 01:17 marketplace local timeads_query_target
rpt_sb_purchased_productssbPurchasedProductDailyDaily at 01:00 marketplace local timeSynced only
rpt_sb_search_termssbSearchTermDailyDaily at 01:00 marketplace local timeSynced only
rpt_sb_targetssbTargetsDailyDaily at 01:00 marketplace local timeads_query_targetcurrent bids and state
rpt_sd_ad_groupssdAdGroupsDailyDaily at 01:00 marketplace local timeSynced only
rpt_sd_advertised_productssdAdvertisedProductDailyDaily at 01:00 marketplace local timeSynced only
rpt_sd_campaignssdCampaignsDailyDaily at 01:00 marketplace local timeads_campaigns_budget_usagetoday's budget use
rpt_sd_negative_targetssdNegativeTargetsDailyDaily at 01:18 marketplace local timeads_query_target
rpt_sd_targetssdTargetsDailyDaily at 01:00 marketplace local timeads_query_targetcurrent bids and state
rpt_sp_ad_groupsspAdGroupsDailyDaily at 01:00 marketplace local timeSynced only
rpt_sp_advertised_productsspAdvertisedProductDailyDaily at 01:00 marketplace local timeSynced only
rpt_sp_campaign_negative_keywordsspCampaignNegativeKeywordsDailyDaily at 01:14 marketplace local timeads_query_target
rpt_sp_campaign_negative_targetsspCampaignNegativeTargetsDailyDaily at 01:16 marketplace local timeads_query_target
rpt_sp_campaign_placementspCampaignsByPlacementDailyDaily at 01:00 marketplace local timeSynced only
rpt_sp_campaignsspCampaignsDailyDaily at 01:00 marketplace local timeads_campaigns_budget_usagetoday's budget use
rpt_sp_keywordsspKeywordsDailyDaily at 01:00 marketplace local timeads_query_targetcurrent bids and state
rpt_sp_negative_keywordsspNegativeKeywordsDailyDaily at 01:13 marketplace local timeads_query_target
rpt_sp_negative_targetsspNegativeTargetsDailyDaily at 01:15 marketplace local timeads_query_target
rpt_sp_purchased_productsspPurchasedProduct|spPurchasedProductBackfillDailyDaily at 01:00 marketplace local timeSynced only
rpt_sp_search_termsspSearchTermDailyDaily at 01:00 marketplace local timeSynced only
rpt_sp_targetsspTargetsDailyDaily at 01:00 marketplace local timeads_query_targetcurrent bids and state

noon reports (6)

TableHow fresh is it?Need it right now?
rpt_noon_catalogNOON_CATALOGDailyDaily at 05:00 UTCSynced only
rpt_noon_catalog_exportNOON_CATALOG_EXPORTDailyDaily at 03:00 UTCSynced only
rpt_noon_fbn_agingNOON_FBN_AGINGSeveral times a dayTwice a day, at 04:00 and 16:00 UTCSynced only
rpt_noon_financeNOON_FINANCESeveral times a dayTwice a day, at 04:00 and 16:00 UTCSynced only
rpt_noon_ordersNOON_ORDERS_EXPORTSeveral times a dayTwice a day, at 04:00 and 16:00 UTCSynced only
rpt_noon_product_viewsNOON_PRODUCT_VIEWSSeveral times a dayTwice a day, at 04:00 and 16:00 UTCSynced only

On this page

Actions

View as Markdown

Ask an assistant

Ask ChatGPTAsk Claude