# DataDoe Data Scheme

DataDoe syncs Amazon Seller Central, Vendor Central and Amazon Ads data into ready-to-query tables. This index lists every table available in DataDoe exports, the DataDoe MCP and BigQuery. Each entry links to its own Markdown page with all columns.

- Full JSON (large): https://api.datadoe.com/api/v1/spec/data-scheme — narrow it with `?sourceType=SELLER_CENTRAL|VENDOR_CENTRAL|AMAZON_ADS`, `?query=returns` or `?containsPii=true|false`. The same filters work on this Markdown index.
- Have a DataDoe account? Connect the DataDoe MCP and use `exports_sources_get` / `exports_source_get` — they return the tables available for your connected accounts.
- Interactive explorer: https://www.datadoe.com/hub/data-scheme

## Seller Central (72 tables)

### Profit by SKU & Date

- Table name: `amazon_profit_by_sku_and_date`
- Columns: 63
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_profit_by_sku_and_date.md

Daily profit and cost breakdown per SKU and child ASIN from shipped orders, settlement fees, COGS and ad spend. Prefer this table for SKU and child-ASIN profit drill-down instead of calculating manually from other tables. Sponsored Products and Sponsored Display use reported advertised-product spend, sales and orders. Display units include all click-attributed purchases, not just the promoted product. Sponsored Brands contributes estimated spend but no same-SKU conversions. Amazon DSP (estimated spend) contributes promoted-ASIN sales, orders and units. Sponsored Brands spend uses eligible ad-creative ASINs, with same-day ad cost rescaled to campaign cost. Remaining spend uses campaign purchased-product shares. Without purchased-product data, it uses Seller Central sales, orders and sessions, or an even split among known campaign ASINs. Sales and orders allocate campaign totals by purchased-product shares, with the same fallback signals. ASIN spend and sales are split across available SKUs by same-day order-sales shares; orders use order-count shares. A zero total uses an even split for that measure. With no SKU rows, sku is null. Campaigns without any ASIN signal remain account-only. Amazon DSP line item spend is allocated by each ASIN's share of total product sales (including brand halo) on that day. Without positive sales, it uses purchases, then an even split among reported ASINs. Spend and promoted sales use same-day SKU order-sales shares; promoted orders and units use order-count shares. A zero total uses an even split for that measure. With no SKU rows, sku is null. Line items with no ASIN conversion rows remain account-only. Sponsored Television is account-only because its campaign report has no product allocation. Missing or delayed estimates can understate SKU ad spend and overstate SKU profit. Use amazon_profit_by_date for account-level P&L; SUM of SKU profit is not the account profit number.

### Profit by Date

- Table name: `amazon_profit_by_date`
- Columns: 73
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_profit_by_date.md

Daily profit and cost breakdown from shipped orders, settlement fees, COGS and ads spend. Prefer this table for account-level P&L instead of calculating manually from other tables. Target and search-term columns are separate Amazon Ads attribution summaries; their estimated profits are not included in account profit and must not be added together. Ads include Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored Television and Amazon DSP. sponsored_tv_ad_spend isolates Television spend already included once in ad_spend and profit. Television has no SKU attribution. Amazon DSP spend is DSP totalCost and DSP ad sales, orders and units include promoted ASINs plus brand halo, consistent with Sponsored Brands and Sponsored Display sales. Unallocated and account-level fees and ads spend land here, including all DSP spend, so ad_spend can exceed SUM(amazon_profit_by_sku_and_date.ad_spend). Do not expect this profit to equal SUM(amazon_profit_by_sku_and_date.profit).

### Sales & Traffic by ASIN & Date

- Table name: `amazon_sales_and_traffic_with_cogs`
- Columns: 41
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_sales_and_traffic_with_cogs.md

[deprecated, see `issues` for more details] Sales and traffic metrics per child ASIN and date from Amazon sales & traffic business report. Ordered columns are orders placed; shipped columns are units Amazon has shipped. B2B columns are the Amazon Business subset of the matching total. Sessions are 24-hour visits, not page views. Percentages are 0-100. Data may be delayed by up to 14 days. If you do not explicitly need data from this table use the `amazon_order_items_with_cogs` table instead.

### Order Line Items

- Table name: `amazon_order_items_with_cogs`
- Columns: 44
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_order_items_with_cogs.md

Log of all orders per order id and order item. Aggregate this table to get order level data and sales per product or date.

### Listings (Raw JSON)

- Table name: `amazon_listings_raw`
- Columns: 24
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_listings_raw.md

Raw listings payload per SKU and marketplace. Recommended for advanced use cases. For most use cases, use the "amazon_listings_with_cogs" table instead. For AI agents: each row from this table has a lot of data, consider downloading it to file and not directly to the context.

### Promotions

- Table name: `amazon_promotions`
- Columns: 46
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_promotions.md

Promotion configuration per promotion, including schedule, benefit, budget, fees, and selection metadata. Complements amazon_promotion_performance, which contains historical performance metrics.

### Promotion Items

- Table name: `amazon_promotion_items`
- Columns: 22
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_promotion_items.md

Item-level promotion configuration for ITEMS selections, including per-ASIN/SKU benefits and budgets.

### Listings

- Table name: `amazon_listings_with_cogs`
- Columns: 42
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_listings_with_cogs.md

Current listing snapshot per SKU, including price, FBA inventory, and Amazon Warehousing and Distribution (AWD) inventory. FBA available, reserved, inbound, and pending-removal quantities are separate buckets; fba_inventory_supply_at_fba is the FBA total when Amazon sends it, so do not add the buckets to it. AWD quantities are not FBA.

### AWD Inbound Shipments

- Table name: `amazon_awd_inbound_shipments`
- Columns: 44
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_awd_inbound_shipments.md

AWD inbound shipments by shipment id.

### Replenishment Metrics by Date (SnS)

- Table name: `amazon_replenishment_metrics_by_date`
- Columns: 46
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_replenishment_metrics_by_date.md

Amazon Subscribe & Save PERFORMANCE metrics by calendar day. Date is the metric aggregation day, not order date or ship date. total_subscriptions_revenue is SnS program revenue for that day; Amazon does not label it as ordered or shipped sales. shipped_subscription_units is the shipped-units metric. revenue_penetration is SnS program revenue as a percentage of total product revenue.

### Replenishment Metrics by SKU & Date

- Table name: `amazon_replenishment_metrics_by_sku_and_date`
- Columns: 25
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_replenishment_metrics_by_sku_and_date.md

Amazon Subscribe & Save PERFORMANCE metrics by SKU and calendar day. Date is the metric aggregation day, not order date or ship date. total_subscriptions_revenue is SnS program revenue for that SKU and day; Amazon does not label it as ordered or shipped sales. shipped_subscription_units is the shipped-units metric. revenue_penetration is SnS program revenue as a percentage of total product revenue for that offer.

### Replenishment Offers

- Table name: `amazon_replenishment_offers`
- Columns: 21
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_replenishment_offers.md

Current Amazon Subscribe & Save offer snapshot by SKU (eligibility, configuration, inventory, subscriptions). Not a sales time series; use the replenishment metrics tables for SnS revenue and shipped units.

### Item Offers

- Table name: `amazon_item_offers`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_item_offers.md

Competitive offers (Buy Box, seller offers, listing/shipping/landed price) by ASIN and item condition.

### AWD Inbound Shipment Line Items

- Table name: `amazon_awd_inbound_shipment_line_items`
- Columns: 14
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_awd_inbound_shipment_line_items.md

AWD inbound shipment line items by shipment id and line item number.

### AWD Replenishment Orders

- Table name: `amazon_awd_replenishment_orders`
- Columns: 15
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_awd_replenishment_orders.md

AWD replenishment orders by order id.

### AWD Replenishment Order Line Items

- Table name: `amazon_awd_replenishment_order_line_items`
- Columns: 20
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_awd_replenishment_order_line_items.md

AWD replenishment order line items by order id and line item number.

### AWD Outbound Orders

- Table name: `amazon_awd_outbound_orders`
- Columns: 17
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_awd_outbound_orders.md

AWD outbound orders: inventory leaving AWD for a destination channel, one row per order id. Not amazon_awd_replenishment_orders (AWD to FBA) and not amazon_awd_inbound_shipments. Shipments are amazon_awd_outbound_shipments. Product arrays are separate stages; do not add them.

### AWD Outbound Shipments

- Table name: `amazon_awd_outbound_shipments`
- Columns: 35
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_awd_outbound_shipments.md

AWD outbound shipments for an amazon_awd_outbound_orders row, with origin and destination addresses. One row per shipment id. Quantities on this row are this shipment only.

### AWD Outbound Shipment Packages

- Table name: `amazon_awd_outbound_shipment_packages`
- Columns: 16
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_awd_outbound_shipment_packages.md

AWD outbound distribution packages exploded from the order and from each shipment. One row per package configuration. Filter package_source before summing; the same configuration can appear in more than one source array.

### FBA Inbound Shipments

- Table name: `amazon_fba_inbound_shipments`
- Columns: 54
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_inbound_shipments.md

FBA inbound shipment line items from inbound plans with shipment status, destination and source addresses, and plan metadata.

### FBA Shipments

- Table name: `amazon_fba_shipments`
- Columns: 55
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_shipments.md

Amazon-fulfilled shipment line items with order, item, pricing, and shipping address details.

### FBA Removal Orders

- Table name: `amazon_fba_removal_orders`
- Columns: 24
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_removal_orders.md

FBA removal order line items with quantities, fees, and status.

### FBA Recommended Removals

- Table name: `amazon_fba_removal_recommended`
- Columns: 23
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_removal_recommended.md

Recommended FBA removal quantities by SKU with sellable and unsellable inventory age buckets.

### FBA Stranded Inventory

- Table name: `amazon_fba_stranded_inventory`
- Columns: 24
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_stranded_inventory.md

FBA stranded inventory that is in Amazon fulfillment centers but not available for sale, with recommended actions, status, and quantities. Updated daily by replacing the full snapshot.

### FBA Removal Shipments

- Table name: `amazon_fba_removal_shipments`
- Columns: 18
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_removal_shipments.md

FBA removal shipment details linked to removal orders.

### FBA Replacement Shipments

- Table name: `amazon_fba_replacement_shipments`
- Columns: 17
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_replacement_shipments.md

FBA replacement shipments with original and replacement order references.

### FBA Restock Recommendations

- Table name: `amazon_fba_restock_recommendations`
- Columns: 36
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_restock_recommendations.md

FBA restock recommendations with inventory levels, sales velocity, and replenishment guidance stored as daily snapshots.

### FBA Inventory by ASIN & Country

- Table name: `amazon_fba_inventory_by_asin_by_country`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_inventory_by_asin_by_country.md

Daily inventory data snapshot for all FBA listings per country.

### FBA Inventory Health

- Table name: `amazon_fba_inventory_health`
- Columns: 115
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_inventory_health.md

Consolidated daily FBA inventory health snapshot across sales windows (7, 30, 60, and 90 days), inbound shipment statuses (working, received, and shipped), estimated storage and long-term storage fees, aged and excess units, and recommended actions. One row per SKU and date; not additive across dates. inv_age_0_to_90_days already includes inv_age_0_to_30_days, inv_age_31_to_60_days, and inv_age_61_to_90_days. The planning-report-sourced columns are not available in the MX marketplace.

### FBA Overage Fee Charges

- Table name: `amazon_fba_overage_fees`
- Columns: 16
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_overage_fees.md

Daily overage fee charges based on FBA storage usage limits.

### FBA Ledger Summary

- Table name: `amazon_fba_ledger_summary`
- Columns: 27
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_ledger_summary.md

Daily FBA ledger summary by fulfillment center. Quantities are signed: receipts and customer returns increase inventory, customer shipments and disposals decrease it. starting_warehouse_balance plus the movement columns equals ending_warehouse_balance for that location. Do not sum locations without grouping by fnsku.

### FBA Ledger Details

- Table name: `amazon_fba_ledger_details`
- Columns: 20
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_ledger_details.md

Daily FBA ledger details with per-event inventory movements, references, and reconciliation quantities.

### FBA Storage Fee Charges

- Table name: `amazon_fba_storage_fees`
- Columns: 33
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_storage_fees.md

Daily FBA storage fee charges with historical data.

### FBA Long-Term Storage Fee Charges

- Table name: `amazon_fba_long_term_storage_fees`
- Columns: 21
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_long_term_storage_fees.md

Daily long-term FBA storage fee charges with historical data.

### FBA Reimbursements

- Table name: `amazon_fba_reimbursements`
- Columns: 25
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_fba_reimbursements.md

Daily FBA reimbursements with historical data.

### Returns (FBA & FBM)

- Table name: `amazon_returns`
- Columns: 35
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_returns.md

Physical return events, not payout refunds. FBA rows are items received at a fulfillment center; date is return/receipt date. FBM rows are return requests by return-request date. quantity is returned units. fnsku and fba_customer_comments are FBA only. product_name is the name on the returns report (FBA product-name, FBM item-name). amazon_return_detailed_disposition is FBA only (SELLABLE, CUSTOMER_DAMAGED, DEFECTIVE, etc.). cogs_* is unit cost as of the return date, times quantity. For payout refunds use amazon_settlements_with_cogs where settlement_type is REFUND.

### Account Status Changed Notifications

- Table name: `amazon_notifications_account_status_changed`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_account_status_changed.md

Near real-time Amazon SP-API ACCOUNT_STATUS_CHANGED notifications for seller account health and performance status changes.

### Any Offer Changed Notifications

- Table name: `amazon_notifications_any_offer_changed`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_any_offer_changed.md

Near real-time Amazon SP-API ANY_OFFER_CHANGED notifications for competitive offer and Buy Box changes.

### B2B Any Offer Changed Notifications

- Table name: `amazon_notifications_b2b_any_offer_changed`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_b2b_any_offer_changed.md

Near real-time Amazon SP-API B2B_ANY_OFFER_CHANGED notifications for B2B competitive offer changes.

### Branded Item Content Change Notifications

- Table name: `amazon_notifications_branded_item_content_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_branded_item_content_change.md

Near real-time Amazon SP-API BRANDED_ITEM_CONTENT_CHANGE notifications for A+ content changes on brand-registered ASINs.

### Detail Page Traffic Event Notifications

- Table name: `amazon_notifications_detail_page_traffic_event`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_detail_page_traffic_event.md

Near real-time Amazon SP-API DETAIL_PAGE_TRAFFIC_EVENT notifications for detail page traffic events.

### FBA Inventory Availability Changes Notifications

- Table name: `amazon_notifications_fba_inventory_availability_changes`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_fba_inventory_availability_changes.md

Near real-time Amazon SP-API FBA_INVENTORY_AVAILABILITY_CHANGES notifications for FBA inventory availability changes.

### FBA Outbound Shipment Status Notifications

- Table name: `amazon_notifications_fba_outbound_shipment_status`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_fba_outbound_shipment_status.md

Near real-time Amazon SP-API FBA_OUTBOUND_SHIPMENT_STATUS notifications for FBA outbound shipment status updates.

### Fee Promotion Notifications

- Table name: `amazon_notifications_fee_promotion`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_fee_promotion.md

Near real-time Amazon SP-API FEE_PROMOTION notifications for Amazon fee promotion events.

### Item Inventory Event Change Notifications

- Table name: `amazon_notifications_item_inventory_event_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_item_inventory_event_change.md

Near real-time Amazon SP-API ITEM_INVENTORY_EVENT_CHANGE notifications for item inventory event changes.

### Item Product Type Change Notifications

- Table name: `amazon_notifications_item_product_type_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_item_product_type_change.md

Near real-time Amazon SP-API ITEM_PRODUCT_TYPE_CHANGE notifications for listing product type definition changes.

### Item Sales Event Change Notifications

- Table name: `amazon_notifications_item_sales_event_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_item_sales_event_change.md

Near real-time Amazon SP-API ITEM_SALES_EVENT_CHANGE notifications for item sales event changes.

### Listings Item Issues Change Notifications

- Table name: `amazon_notifications_listings_item_issues_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_listings_item_issues_change.md

Near real-time Amazon SP-API LISTINGS_ITEM_ISSUES_CHANGE notifications for listing quality and issue changes.

### Listings Item MFN Quantity Change Notifications

- Table name: `amazon_notifications_listings_item_mfn_quantity_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_listings_item_mfn_quantity_change.md

Near real-time Amazon SP-API LISTINGS_ITEM_MFN_QUANTITY_CHANGE notifications for MFN listing quantity changes.

### Listings Item Status Change Notifications

- Table name: `amazon_notifications_listings_item_status_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_listings_item_status_change.md

Near real-time Amazon SP-API LISTINGS_ITEM_STATUS_CHANGE notifications for listing status changes.

### Pricing Health Notifications

- Table name: `amazon_notifications_pricing_health`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_pricing_health.md

Near real-time Amazon SP-API PRICING_HEALTH notifications for Featured Offer ineligibility caused by an uncompetitive price.

### Shipment Tracking Milestone Changed Notifications

- Table name: `amazon_notifications_shipment_tracking_milestone_changed`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_shipment_tracking_milestone_changed.md

Near real-time Amazon SP-API SHIPMENT_TRACKING_MILESTONE_CHANGED notifications for Amazon Tracking API shipment milestone updates.

### Transaction Update Notifications

- Table name: `amazon_notifications_transaction_update`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_transaction_update.md

Near real-time Amazon SP-API TRANSACTION_UPDATE notifications for financial transaction updates.

### Order Change Notifications

- Table name: `amazon_notifications_order_change`
- Columns: 16
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_order_change.md

Near real-time Amazon SP-API ORDER_CHANGE notifications for order status and buyer-requested changes.

### Seller Feedback

- Table name: `amazon_seller_feedback`
- Columns: 12
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_seller_feedback.md

Negative and neutral (one to three stars) feedback left for the seller by buyers, including star rating, comments, and optional seller response.

### Seller Account Health Metrics

- Table name: `amazon_seller_performance`
- Columns: 102
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_seller_performance.md

Seller Central Account Health from GET_V2_SELLER_PERFORMANCE_REPORT. The latest date is the current snapshot; Amazon does not return history for older requested dates. Column windows are 7 days, 14 days, 30 days, 60 days, or 6 months. *_value and *_target_* columns are rates. *_count columns are counts. *_status is the health status. seller_account_health_rating_6m_score is the Account Health Rating score (0–1000), not a percentage. Amazon Account Health rate for the window in the column name. Same scale as the matching target column. A rate, not a count. Do not recompute it from the count columns.

### Search Engagement by ASIN (Monthly)

- Table name: `amazon_child_product_search_performance_per_month`
- Columns: 31
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_child_product_search_performance_per_month.md

Monthly Search Catalog Performance per child ASIN (GET_BRAND_ANALYTICS_SEARCH_CATALOG_PERFORMANCE_REPORT). Impressions, clicks, cart adds, and purchases from search results, including sponsored results. search_click_rate is clicks divided by impressions. search_conversion_rate is purchases divided by clicks. Both rates are 0-1 fractions (Amazon examples are 0.1 and 0.05). Not Search Query Performance; that is amazon_child_product_organic_search_ranks_per_week and amazon_child_product_organic_search_ranks_per_month.

### Settlements & P&L Components

- Table name: `amazon_settlements_with_cogs`
- Columns: 214
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_settlements_with_cogs.md

Financial events from Amazon Finances. date is the marketplace-local date of the winning transaction posted time (America/Los_Angeles for US and CA). Once released it matches Transaction Release Date; while still deferred it is the local date of the deferred posting, and it can be one day earlier than the UTC posted timestamp near midnight. transaction_posted_date matches the Amazon Transaction report date/time column and is earlier than date for deferred orders. transaction_release_date matches Transaction Release Date and equals date once released. shipping_promotion_rebate is the order shipping promotion, a rebate to the customer and not an Amazon fee; promotion_fee holds the same values and is kept for backward compatibility. settlement_type REFUND is a money event, not a warehouse return. ORDER rows use order-date COGS; REFUND rows use return-receipt-date COGS (0 when no return). COGS is stored negative. All columns other than "total" express a single type of cost/fee/income. Expenses are negative values (standardize this when comparing with other tables). total_non_principal_amount is total minus item_price in the payout sign. total_fees holds the same value and will be removed on 2026-10-31. marketplace_facilitator_vat / refund_marketplace_facilitator_vat are MarketplaceFacilitatorVAT-* ItemWithheldTax lines (EU/UK); US MarketplaceFacilitatorTax-* stays in item_withheld_tax / refund_item_withheld_tax. fba_inbound_transportation_fee and fba_inbound_transportation_program_fee are ex-VAT base amounts; when Finances lands VAT-inclusive gross on other-transaction inbound rows (UK/EU), the integrated view splits gross/1.20 into the fee column and the remainder into item_tax. Settlement-report FBAFees Base/Tax triples are already ex-VAT on the fee column. There is no dedicated Lightning Deal Fee column because Finances does not distinguish Lightning from Best Deal; those amounts are in deal_participation_fee. Refund Customer Return - Not Received is not available from Finances. Merchant-fulfilled Buy Shipping label fees (LabmanLabelPurchase / LabmanLabelReturn / LabmanLabelChargeBack) attach to the order SKU when that order has a single SKU.

### Search Query Performance (SQP) by ASIN (Weekly)

- Table name: `amazon_child_product_organic_search_ranks_per_week`
- Columns: 34
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_child_product_organic_search_ranks_per_week.md

Weekly Search Query Performance (SQP) per child ASIN and search query (GET_BRAND_ANALYTICS_SEARCH_QUERY_PERFORMANCE_REPORT). child_asin_* columns are this ASIN. search_query_total_* and search_query_volume are the whole query and repeat on every ASIN row. Rates follow Amazon schema examples of 0–1. Only configured SQP ASINs are included.

### Search Query Performance (SQP) by ASIN (Monthly)

- Table name: `amazon_child_product_organic_search_ranks_per_month`
- Columns: 34
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_child_product_organic_search_ranks_per_month.md

Monthly Search Query Performance (SQP) per child ASIN and search query (GET_BRAND_ANALYTICS_SEARCH_QUERY_PERFORMANCE_REPORT). child_asin_* columns are this ASIN. search_query_total_* and search_query_volume are the whole query and repeat on every ASIN row. Rates follow Amazon schema examples of 0–1. Only configured SQP ASINs are included. Not amazon_child_product_search_performance_per_month (catalog-level search engagement).

### Repeat Purchase Performance

- Table name: `amazon_repeat_purchase_report`
- Columns: 14
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_repeat_purchase_report.md

Monthly Brand Analytics repeat purchase report per child ASIN for Brand Registry sellers and vendors. One row per child ASIN and month. repeat_customers_score_total and repeat_purchase_revenue_score_total are 0-1 rates. Repeat revenue is ordered revenue and excludes returns.

### Market Basket Co-Purchase (Monthly)

- Table name: `amazon_market_basket_by_child_asin`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_market_basket_by_child_asin.md

Monthly Brand Analytics market basket report of products frequently bought together. One row per child ASIN and co-purchased ASIN. The co-purchased ASIN can belong to another brand. purchased_with_combination_score is a 0-1 share of multi-item orders.

### Brand Analytics Search Terms (Daily)

- Table name: `amazon_brand_analytics_search_terms_daily`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_brand_analytics_search_terms_daily.md

Daily marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).

### Brand Analytics Search Terms (Weekly)

- Table name: `amazon_brand_analytics_search_terms_weekly`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_brand_analytics_search_terms_weekly.md

Weekly marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).

### Brand Analytics Search Terms (Monthly)

- Table name: `amazon_brand_analytics_search_terms_monthly`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_brand_analytics_search_terms_monthly.md

Monthly marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).

### Product Catalog by ASIN

- Table name: `amazon_products_by_child_asin`
- Columns: 25
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_products_by_child_asin.md

Catalog Items snapshot per child ASIN and marketplace: title, brand, bullets, description, browse node, and best seller rank. amazon_product_type is PARENT, CHILD, or SINGLE. For the catalog product type template and raw JSON attributes, classifications, images, and sales ranks, use amazon_products_raw.

### Product Catalog by ASIN (Raw JSON)

- Table name: `amazon_products_raw`
- Columns: 15
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_products_raw.md

Raw Catalog Items payload per child ASIN and marketplace: attributes, classifications, dimensions, identifiers, images, sales ranks, summaries, and relationships. amazon_product_type is PARENT, CHILD, or SINGLE; product_type is the Amazon product type template. Prefer amazon_products_by_child_asin for titles, bullets, and best seller rank. Rows are large; download them to a file instead of loading them into context.

### Coupon Performance

- Table name: `amazon_coupon_performance`
- Columns: 34
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_coupon_performance.md

Seller and vendor coupon performance, one row per coupon and ASIN. Includes clips, redemptions, budget, and the ASIN discount. Campaign and coupon totals repeat on every ASIN row. Vendor rows carry campaign, vendor code, and Subscribe and Save; sales is seller coupon revenue. Filter on start_date_time. Join amazon_promotions on promotions_api_mapping_id.

### Promotion Performance

- Table name: `amazon_promotion_performance`
- Columns: 32
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_promotion_performance.md

Seller and vendor promotion performance for Best Deal, Lightning Deal, Price Discount, and related deal types. One row per promotion and ASIN. Glance views, units, funding, and revenue at promotion level repeat on every ASIN row; use the product_ columns for the ASIN. amount_spent is vendor funding. Seller revenue matches Seller Central sales. Configuration lives on amazon_promotions.

### Sellers & Vendors Context

- Table name: `amazon_sellers_and_vendors_context`
- Columns: 10
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_sellers_and_vendors_context.md

Lookup of DataDoe Amazon accounts for Seller Central, Vendor Central, Amazon Ads, and Amazon DSP. One row per connection, plus one row per Amazon DSP advertiser mapped to a seller or vendor on a shared agency Ads account. A DSP-only agency seat is not its own seller. seller_or_vendor_id equals connection_context_id and is not unique: one context can have a Seller Central row, an Amazon Ads row, and one row per DSP advertiser. Join Seller Central and Vendor Central facts on sp_connection_id or vendor_connection_id. Attribute DSP facts on organization_id, store_id, ads_dsp_connection_id, and dsp_advertiser_id.

### Cost of Goods Sold (COGS)

- Table name: `amazon_cogs`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_cogs.md

Detailed data about cost of goods sold (COGS) per SKU. COGS are managed by the user via form in the Sellers & Vendors page.

### Order Details PII

- Table name: `amazon_orders_details`
- Columns: 29
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_orders_details.md

Order-level customer and shipping PII details. An extension of `amazon_order_items_with_cogs` table.

## Vendor Central (29 tables)

### Repeat Purchase Performance

- Table name: `amazon_repeat_purchase_report`
- Columns: 14
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_repeat_purchase_report.md

Monthly Brand Analytics repeat purchase report per child ASIN for Brand Registry sellers and vendors. One row per child ASIN and month. repeat_customers_score_total and repeat_purchase_revenue_score_total are 0-1 rates. Repeat revenue is ordered revenue and excludes returns.

### Market Basket Co-Purchase (Monthly)

- Table name: `amazon_market_basket_by_child_asin`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_market_basket_by_child_asin.md

Monthly Brand Analytics market basket report of products frequently bought together. One row per child ASIN and co-purchased ASIN. The co-purchased ASIN can belong to another brand. purchased_with_combination_score is a 0-1 share of multi-item orders.

### Brand Analytics Search Terms (Daily)

- Table name: `amazon_brand_analytics_search_terms_daily`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_brand_analytics_search_terms_daily.md

Daily marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).

### Brand Analytics Search Terms (Weekly)

- Table name: `amazon_brand_analytics_search_terms_weekly`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_brand_analytics_search_terms_weekly.md

Weekly marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).

### Brand Analytics Search Terms (Monthly)

- Table name: `amazon_brand_analytics_search_terms_monthly`
- Columns: 13
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_brand_analytics_search_terms_monthly.md

Monthly marketplace Brand Analytics search terms: top clicked ASINs by customer keyword and department, with search frequency rank, click share, and conversion share. Shares are 0-1 fractions. Marketplace-wide, so clicked ASINs are often competitors. For your own ASIN search query performance use amazon_child_product_organic_search_ranks_per_week or amazon_child_product_organic_search_ranks_per_month. Data can lag; use MAX(date).

### Product Catalog by ASIN

- Table name: `amazon_products_by_child_asin`
- Columns: 25
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_products_by_child_asin.md

Catalog Items snapshot per child ASIN and marketplace: title, brand, bullets, description, browse node, and best seller rank. amazon_product_type is PARENT, CHILD, or SINGLE. For the catalog product type template and raw JSON attributes, classifications, images, and sales ranks, use amazon_products_raw.

### Product Catalog by ASIN (Raw JSON)

- Table name: `amazon_products_raw`
- Columns: 15
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_products_raw.md

Raw Catalog Items payload per child ASIN and marketplace: attributes, classifications, dimensions, identifiers, images, sales ranks, summaries, and relationships. amazon_product_type is PARENT, CHILD, or SINGLE; product_type is the Amazon product type template. Prefer amazon_products_by_child_asin for titles, bullets, and best seller rank. Rows are large; download them to a file instead of loading them into context.

### Coupon Performance

- Table name: `amazon_coupon_performance`
- Columns: 34
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_coupon_performance.md

Seller and vendor coupon performance, one row per coupon and ASIN. Includes clips, redemptions, budget, and the ASIN discount. Campaign and coupon totals repeat on every ASIN row. Vendor rows carry campaign, vendor code, and Subscribe and Save; sales is seller coupon revenue. Filter on start_date_time. Join amazon_promotions on promotions_api_mapping_id.

### Promotion Performance

- Table name: `amazon_promotion_performance`
- Columns: 32
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_promotion_performance.md

Seller and vendor promotion performance for Best Deal, Lightning Deal, Price Discount, and related deal types. One row per promotion and ASIN. Glance views, units, funding, and revenue at promotion level repeat on every ASIN row; use the product_ columns for the ASIN. amount_spent is vendor funding. Seller revenue matches Seller Central sales. Configuration lives on amazon_promotions.

### Invoices

- Table name: `amazon_invoices`
- Columns: 36
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_invoices.md

Accounts payable invoice headers for Vendor Central. One row per invoice. invoice_status is IN_PROGRESS, REJECTED, PARTIALLY_PAID, PARTIALLY_DEDUCTED, PAID, or DEDUCTED. invoice_type is AP_INVENTORY or OTHER. Join amazon_invoice_items on invoice_identifier. date is the UTC day of issue_date.

### Invoice Items

- Table name: `amazon_invoice_items`
- Columns: 40
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_invoice_items.md

Invoice line items for Vendor Central. One row per line. Goods, services, and other charges, with matched quantity, price and quantity variances, and ASIN, SKU, UPC, EAN, or ISBN identifiers. Join amazon_invoices on invoice_identifier. date is the UTC day of the parent invoice issue date.

### Detail Page Traffic Event Notifications

- Table name: `amazon_notifications_detail_page_traffic_event`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_detail_page_traffic_event.md

Near real-time Amazon SP-API DETAIL_PAGE_TRAFFIC_EVENT notifications for detail page traffic events.

### Item Inventory Event Change Notifications

- Table name: `amazon_notifications_item_inventory_event_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_item_inventory_event_change.md

Near real-time Amazon SP-API ITEM_INVENTORY_EVENT_CHANGE notifications for item inventory event changes.

### Item Sales Event Change Notifications

- Table name: `amazon_notifications_item_sales_event_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_item_sales_event_change.md

Near real-time Amazon SP-API ITEM_SALES_EVENT_CHANGE notifications for item sales event changes.

### Listings Item Issues Change Notifications

- Table name: `amazon_notifications_listings_item_issues_change`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_listings_item_issues_change.md

Near real-time Amazon SP-API LISTINGS_ITEM_ISSUES_CHANGE notifications for listing quality and issue changes.

### Shipment Tracking Milestone Changed Notifications

- Table name: `amazon_notifications_shipment_tracking_milestone_changed`
- Columns: 11
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_notifications_shipment_tracking_milestone_changed.md

Near real-time Amazon SP-API SHIPMENT_TRACKING_MILESTONE_CHANGED notifications for Amazon Tracking API shipment milestone updates.

### Vendor Codes

- Table name: `amazon_vendor_codes`
- Columns: 9
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_codes.md

Vendor codes assigned by Amazon, uploaded per ASIN or SKU. Each row has exactly one of child_asin or sku set.

### Vendor Listings

- Table name: `amazon_vendor_listings`
- Columns: 39
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_listings.md

Vendor Central listings from the Listings Items API, one row per connection, marketplace, vendor code, and SKU. Cost price is what Amazon pays the vendor. Offers and fulfillment availability are not published for vendors.

### Weekly Customer Demand

- Table name: `amazon_vendor_forecasting`
- Columns: 16
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_forecasting.md

Weekly forward customer-demand forecast per child ASIN from Amazon Vendor Forecasting. Amazon exposes only the latest forecast per request; DataDoe stores each fetch as a snapshot keyed by date (forecast generation date). Each snapshot has about twelve forward weeks (start_forecasting_date/end_forecasting_date); the same week can appear on multiple dates — filter to MAX(date) per child_asin and week for the current forecast. Rows are not additive across date snapshots.

### Sales, Traffic & Inventory by ASIN & Date

- Table name: `amazon_vendor_sales_traffic_and_inventory_by_child_and_date`
- Columns: 108
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_sales_traffic_and_inventory_by_child_and_date.md

Daily sales, traffic and inventory metrics per child ASIN. Columns prefixed manufacturing_retail_ are Amazon manufacturing-view metrics for all ASINs the vendor manufactures. Columns prefixed sourcing_retail_ are Amazon sourcing-view metrics for ASINs this vendor sourced directly to Amazon (distributor view). DataDoe fetches both views and joins them onto one ASIN-day; the prefixes are overlapping views, not two independent facts and not additive — never sum them or revenue and units double-count. Shipped units/revenue often match because Amazon returns the same shippedOrders in both views; matching is expected, not a copied row. Ordered units/revenue exist only under manufacturing. Contra-COGS is typically populated only under sourcing. Use manufacturing_retail_ for glance views, customer-ordered units/revenue (retail demand, not purchase orders), and net PPM. Use sourcing_retail_ for purchase-order fill metrics (vendor_confirmation_rate, received_fill_rate) and contra-COGS. Amazon-to-vendor purchase-order quantity is amazon_vendor_purchase_orders.ordered_quantity. Either prefix alone is valid for shipped revenue/COGS — pick one view per analysis, not both. Shipped COGS, shipped revenue, contra-COGS, and Net PPM measure Amazon retail economics, not the vendor's own product margin. net_pure_product_margin is a convenience alias of manufacturing_retail_net_ppm (both read manufacturing net_ppm); do not cross-check them as independent series. On-hand, aged, unhealthy, in-transit, and open purchase-order units are end-of-period snapshots and are not additive across days.

### Real-Time Sales by ASIN & Hour

- Table name: `amazon_vendor_real_time_sales`
- Columns: 14
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_real_time_sales.md

Hourly units and revenue ordered by Amazon customers per ASIN (GET_VENDOR_REAL_TIME_SALES_REPORT). Not Amazon-to-vendor purchase-order quantity. Not the daily manufacturing_retail_ordered_units series.

### Real-Time Traffic by ASIN & Hour

- Table name: `amazon_vendor_real_time_traffic`
- Columns: 12
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_real_time_traffic.md

Hourly detail-page views per ASIN (GET_VENDOR_REAL_TIME_TRAFFIC_REPORT). All customer views of the detail page, not the daily glance_views column (Featured Offer wins only).

### Real-Time Inventory by ASIN & Hour

- Table name: `amazon_vendor_real_time_inventory`
- Columns: 12
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_real_time_inventory.md

Hourly highly available inventory per ASIN (GET_VENDOR_REAL_TIME_INVENTORY_REPORT). Units Amazon can still sell, not on-hand sellable inventory from the daily table.

### Vendor Direct Fulfillment Orders

- Table name: `amazon_vendor_df_orders`
- Columns: 38
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_df_orders.md

Vendor Direct Fulfillment order line items (vendor ships to the customer). One row per line item with order header fields repeated. purchase_order_number is the DF purchase order; customer_order_number is the shopper order.

### Vendor Direct Fulfillment Orders PII

- Table name: `amazon_vendor_df_orders_pii`
- Columns: 24
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_df_orders_pii.md

Vendor Direct Fulfillment customer and shipping PII. One row per purchase order. Join amazon_vendor_df_orders on purchase_order_number. Restricted and off by default.

### Vendor Purchase Orders

- Table name: `amazon_vendor_purchase_orders`
- Columns: 33
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_purchase_orders.md

Vendor Retail Procurement purchase order line items. One row per line item with purchase order header fields repeated. ordered_quantity is Amazon-to-vendor PO quantity, not customer retail demand (manufacturing_retail_ordered_units). Acknowledgement and Amazon fulfillment-center received quantity are on amazon_vendor_purchase_orders_status.

### Vendor Purchase Order Status

- Table name: `amazon_vendor_purchase_orders_status`
- Columns: 39
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_purchase_orders_status.md

Vendor Retail Procurement purchase order item status (getPurchaseOrdersStatus). One row per line item, same grain as amazon_vendor_purchase_orders (purchase_order_number and item_sequence_number). Holds vendor acknowledgement and Amazon fulfillment-center receiving. ordered_quantity is Amazon-to-vendor PO quantity, not customer retail demand (manufacturing_retail_ordered_units). Rows appear after the matching purchase order is synced.

### Vendor Shipments

- Table name: `amazon_vendor_shipments`
- Columns: 33
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_vendor_shipments.md

WePay/collect Vendor Retail Procurement shipments (submitted or requested for routing; does not include shipments created in Vendor Central). One row per shipment with nested purchase orders, containers, and status details. Amazon does not return shipments created only in Vendor Central (Orders > Shipments / appointments).

### Sellers & Vendors Context

- Table name: `amazon_sellers_and_vendors_context`
- Columns: 10
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_sellers_and_vendors_context.md

Lookup of DataDoe Amazon accounts for Seller Central, Vendor Central, Amazon Ads, and Amazon DSP. One row per connection, plus one row per Amazon DSP advertiser mapped to a seller or vendor on a shared agency Ads account. A DSP-only agency seat is not its own seller. seller_or_vendor_id equals connection_context_id and is not unique: one context can have a Seller Central row, an Amazon Ads row, and one row per DSP advertiser. Join Seller Central and Vendor Central facts on sp_connection_id or vendor_connection_id. Attribute DSP facts on organization_id, store_id, ads_dsp_connection_id, and dsp_advertiser_id.

## Amazon Ads (46 tables)

### Ad Performance by ASIN & Date

- Table name: `amazon_ads_performance_by_child_asin_and_date`
- Columns: 31
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_performance_by_child_asin_and_date.md

Ads performance by product, ad or campaign, and date for Sponsored Products, Sponsored Display, and Sponsored Brands. Multiple rows can exist for the same ASIN, SKU and date. Products and Display report advertised/promoted-product sales and orders; Display units include all click-attributed purchases. Brands ad_sales and ad_orders are estimated shares of campaign totals, including brand halo; Brands same-SKU columns, clicks and impressions are null. Sponsored Brands spend uses eligible ad-creative ASINs, with same-day ad cost rescaled to campaign cost. Remaining spend uses campaign purchased-product shares. Without purchased-product data, it uses Seller Central sales, orders and sessions, or an even split among known campaign ASINs. Sales and orders allocate campaign totals by purchased-product shares, with the same fallback signals. ASIN spend and sales are split across available SKUs by same-day order-sales shares; orders use order-count shares. A zero total uses an even split for that measure. With no SKU rows, sku is null. Campaigns without any ASIN signal remain account-only. Estimates can lag the campaign report and are revised as inputs arrive. Prefer amazon_ads_performance_by_campaign_by_date for total campaign data. Sponsored Television and Amazon DSP are not included here.

### Ad Performance by Campaign & Date

- Table name: `amazon_ads_performance_by_campaign_by_date`
- Columns: 30
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_performance_by_campaign_by_date.md

Ads performance per campaign and date for Sponsored Products, Sponsored Brands, Sponsored Display, and Sponsored Television. Use this table for total sponsored ads campaign spend and sales. ad_impressions and ad_clicks exclude invalid traffic; gross and invalid columns are the traffic-quality reconciliation. Amazon DSP is not included; use amazon_ads_dsp_performance_by_creative_by_date for Amazon DSP.

### DSP Performance by Creative & Date

- Table name: `amazon_ads_dsp_performance_by_creative_by_date`
- Columns: 52
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_performance_by_creative_by_date.md

Amazon DSP performance per advertiser, date, order, line item, and creative. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Use this table for total Amazon DSP spend and sales; it is the DSP source of amazon_profit_by_date. ad_sales, ad_orders, and ad_units_sold include brand halo; the _promoted columns cover promoted ASINs only. Order and line item budgets repeat on every creative row, so do not sum them.

### DSP Product Conversions by ASIN & Date

- Table name: `amazon_ads_dsp_performance_by_asin_by_date`
- Columns: 33
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_performance_by_asin_by_date.md

Amazon DSP product conversions per advertiser, date, order, line item, child ASIN, and conversion type. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. dsp_conversion_type PROMOTED rows are conversions of ASINs promoted by the line item; BRAND_HALO rows are conversions of other ASINs of the same brands. Sum PROMOTED and BRAND_HALO for total product sales as in the Amazon DSP console. Amazon reports no cost, impressions, or clicks at ASIN level; spend is in amazon_ads_dsp_performance_by_creative_by_date. Amazon limits the report to the top 500 ASINs of the past 65 days, so totals can be slightly below the creative table.

### DSP Performance by City & Date

- Table name: `amazon_ads_dsp_performance_by_city_by_date`
- Columns: 39
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_performance_by_city_by_date.md

Amazon DSP performance per advertiser, date, order, line item, and city. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. city is a bare city name (for example Columbus) and is not unique across regions; the country is the marketplace country. Large table: always filter by date.

### DSP Performance by Audience & Date

- Table name: `amazon_ads_dsp_performance_by_audience_by_date`
- Columns: 35
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_performance_by_audience_by_date.md

Amazon DSP performance per advertiser, date, order, line item, and audience segment. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Amazon does not report sales, units, or brand halo metrics in this report; conversion columns cover promoted ASINs only. A line item can target several segments, so do not sum segment rows to get line item totals; use amazon_ads_dsp_performance_by_creative_by_date for totals.

### DSP Performance by Device & Date

- Table name: `amazon_ads_dsp_performance_by_device_by_date`
- Columns: 33
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_performance_by_device_by_date.md

Amazon DSP performance per advertiser, date, order, line item, and device type. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. ad_sales includes brand halo; all other conversion columns cover promoted ASINs only, because Amazon does not report their brand halo totals in this report.

### DSP Performance by Supply Source & Date

- Table name: `amazon_ads_dsp_performance_by_supply_source_by_date`
- Columns: 37
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_performance_by_supply_source_by_date.md

Amazon DSP performance per advertiser, date, and supply source (inventory exchange or publisher). Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. Advertiser level: there is no order or line item breakdown. ad_currency is null because Amazon does not return a currency in this report; monetary values are in the currency of the marketplace.

### DSP Reach & Frequency

- Table name: `amazon_ads_dsp_reach_and_frequency`
- Columns: 17
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_reach_and_frequency.md

Amazon DSP reach and average frequency per advertiser and report period. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. Each row summarizes one period (period_start_date to period_end_date): a 30-day window on the first fetch, then 1-day windows. Periods can overlap. Reach and frequency are not additive: never sum or average them across rows or periods; pick one period.

### DSP Brand Suitability

- Table name: `amazon_ads_dsp_brand_suitability`
- Columns: 25
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_brand_suitability.md

Amazon DSP brand suitability: impressions per advertiser, order, line item, and report period, broken down by inventory tier, content category, or supply source. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Rows are rolling 7-day summaries starting every day: never sum across different periods (summing all dates overcounts about 7 times); pick one period and one dsp_brand_suitability_dimension.

### DSP Performance by Content

- Table name: `amazon_ads_dsp_performance_by_content`
- Columns: 33
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_performance_by_content.md

Amazon DSP audio and video delivery (streaming TV, online video, audio) per advertiser, report period, order, line item, creative, supply source, and content (show title, rating, type, genre). Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Impressions and cost per thousand impressions only: Amazon does not report cost totals or conversions in this report. Rows are rolling 7-day summaries starting every day: never sum across different periods (summing all dates overcounts about 7 times); pick one period.

### DSP Bid Adjustments by Date

- Table name: `amazon_ads_dsp_bid_adjustments_by_date`
- Columns: 25
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_dsp_bid_adjustments_by_date.md

Amazon DSP bid adjustment rule activity per advertiser, date, line item, bid adjustment rule, and matched terms. Amazon DSP only (DataDoe DSP slot of a seller or vendor), refreshed once a day, not intraday. Rows map to a seller or vendor through seller_or_vendor_id, which is null when the DSP advertiser is not mapped. DSP order = campaign and line item = ad group in the new Amazon DSP naming. Only line items that use bid adjustment rules have rows; the table is empty for advertisers without bid adjustments. ad_win_rate and ad_match_rate are rates: never sum them across rows.

### Ads Brand Metrics

- Table name: `amazon_ads_brand_metrics`
- Columns: 67
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_brand_metrics.md

Amazon Ads Brand Metrics: brand-level awareness, consideration, and sales indices plus the shopping funnel (branded searches, detail-page views, add-to-carts, brand customers, high-value customers, return on engagement), by brand, category node, computation date, and lookback. Indices are percentiles versus peers, not 0–1 rates. This is all on-Amazon shopping, not ad-attributed performance. Sparse — most metric columns are NULL for a given row. Columns ending in _category_median are the peer median. Columns ending in _category_top_performers or _category_performers are the average of the 95th–99th percentile of peers. Columns ending in _return_on_engagement, or containing _roe_, are return on engagement (currency), not rates.

### Ads Attribution Performance by Creative

- Table name: `amazon_ads_attribution_performance_by_creative_by_date`
- Columns: 26
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_attribution_performance_by_creative_by_date.md

Amazon Attribution Performance by Creative: off-Amazon traffic measured by Amazon Attribution tags (14-day last-click), not Sponsored Ads conversion windows. One row per date, campaign, ad group, creative, and publisher. Use amazon_ads_attribution_performance_by_ad_group_by_date for totals and Brand Referral Bonus. Never sum creative rows up to ad-group or campaign level — Amazon masks rows with fewer than 10 lifetime clicks (metrics are 0) and creative totals will not match ad-group totals.

### Ads Attribution Performance by Ad Group

- Table name: `amazon_ads_attribution_performance_by_ad_group_by_date`
- Columns: 26
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_attribution_performance_by_ad_group_by_date.md

Amazon Attribution Performance by Ad Group: off-Amazon traffic measured by Amazon Attribution tags (14-day last-click), not Sponsored Ads conversion windows. Use this table for ad-group or campaign totals and for Brand Referral Bonus (brb_bonus_amount). Do not sum amazon_ads_attribution_performance_by_creative_by_date to this grain. BRB is present only for enrolled sellers and only at ad-group level. Rows with fewer than 10 lifetime clicks are masked (metrics 0).

### Ads Attribution Products

- Table name: `amazon_ads_attribution_products_by_date`
- Columns: 38
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_attribution_products_by_date.md

Amazon Attribution Products: off-Amazon traffic measured by Amazon Attribution tags (14-day last-click), not Sponsored Ads conversion windows. Top 100 products per campaign, always at ad-group grain. Use amazon_ads_attribution_performance_by_ad_group_by_date for totals and BRB. Rows with fewer than 10 lifetime clicks are masked (metrics 0). History is last 90 days.

### Keyword Targeting Performance

- Table name: `amazon_ads_targeting_by_campaign_by_date`
- Columns: 35
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_targeting_by_campaign_by_date.md

Keyword and product-target performance per target and date for Sponsored Products, Sponsored Brands, Sponsored Display, and Sponsored Television. ad_keyword is the target; the customer query that matched it is amazon_ads_search_terms_by_campaign_by_date.ad_search_term. Do not sum this table into campaign totals.

### Search Term Performance (Ads)

- Table name: `amazon_ads_search_terms_by_campaign_by_date`
- Columns: 35
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_search_terms_by_campaign_by_date.md

Customer search queries that matched an advertised keyword or product target, for Sponsored Products and Sponsored Brands. ad_search_term is the shopper query; ad_keyword is the target it matched. Not Brand Analytics search terms and not Search Query Performance.

### Ad Profit by Target and Date

- Table name: `amazon_ads_profit_by_target_and_date`
- Columns: 64
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_profit_by_target_and_date.md

One row per target present in the collected reports and click date. Includes Sponsored Products keywords and product or automatic targets, Sponsored Brands product targets (excludes Brands keywords), and reported Display and Television targets. This is partial report coverage, not all account advertising. Spend and attributed sales are reported metrics. Sponsored Products COGS and fees are estimates from uploaded COGS, purchased ASINs, advertised-product mix and preceding 90 days of Seller Central ORDER settlements. For purchased ASINs with several SKUs, use shared unit costs or recent order quantities as weights within the seller connection. Accept purchased sales and units within max(2% of the target value, 0.01), and scale costs by target other-SKU sales / purchased sales. Other campaign types keep reported metrics but have null profit estimates. Refund costs are excluded and recent profit is provisional. This is an ad decision view; its profit does not add to amazon_profit_by_date.profit.

### Ad Profit by Search Term and Date

- Table name: `amazon_ads_profit_by_search_term_and_date`
- Columns: 68
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_profit_by_search_term_and_date.md

One row per reported shopper search term, parent target and click date for Sponsored Products and Brands. The report identifies the query and parent keyword or target but not the ASIN purchased for that query. Sponsored Products profit estimates inherit the parent target product mix and cost per same- or other-SKU sale. Sponsored Brands keeps spend, sales and keyword identity with null profit. Recent estimates are provisional and all estimates exclude refunds. Search-term totals overlap target totals and are not account P&L.

### Ad Placement Performance (Sponsored Brands and Sponsored Products)

- Table name: `amazon_ads_placement_by_campaign_by_date`
- Columns: 49
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_placement_by_campaign_by_date.md

Placement performance for SPONSORED_BRANDS and SPONSORED_PRODUCTS campaigns, including Amazon Business placement breakdown for Sponsored Products.

### Sponsored Brands Ad Performance

- Table name: `amazon_ads_sponsored_brands_by_ad_by_date`
- Columns: 44
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_sponsored_brands_by_ad_by_date.md

Sponsored Brands performance per ad and date. Attribution is 14 days. Same-SKU columns exclude brand halo. New-to-brand columns use a 12-month first-purchase lookback. Do not sum this table into campaign totals.

### Video Ad Extension Performance

- Table name: `amazon_ads_video_ad_extensions_by_date`
- Columns: 37
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_video_ad_extensions_by_date.md

Performance for Sponsored Products video ad extensions per extension, ad, and date. Grain is creativeExtensionId + adId. Do not sum these metrics with campaign, ASIN, or ad-level ads views (double-count). Canonical conversion metrics use 14-day attribution.

### Prompt Ad Extension Performance

- Table name: `amazon_ads_prompt_ad_extensions_by_date`
- Columns: 37
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_prompt_ad_extensions_by_date.md

Performance for Sponsored Products and Sponsored Brands prompt ad extensions per extension, ad, and date. Grain is creativeExtensionId + adId. Do not sum these metrics with campaign, ASIN, or ad-level ads views (double-count). Canonical conversion metrics use 14-day attribution.

### Bid-Boost Audience Performance

- Table name: `amazon_ads_audiences_by_date`
- Columns: 23
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_audiences_by_date.md

Bid-boost audience segment performance for Sponsored Products and Sponsored Brands. Grain is campaign + audience segment + date. Do not sum these metrics with campaign or ASIN ads views (double-count). DSP Audience (order / lineItem / segment) is a different report and is not included here. Canonical conversion metrics use 14-day attribution for SPONSORED_PRODUCTS and the unwindowed purchases/sales/unitsSoldClicks fields for SPONSORED_BRANDS.

### Ad Group Performance

- Table name: `amazon_ads_by_ad_group_by_date`
- Columns: 37
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_by_ad_group_by_date.md

Performance for ad groups in SPONSORED_BRANDS and SPONSORED_DISPLAY campaigns.

### Ad Campaigns (raw)

- Table name: `amazon_ads_campaigns_raw`
- Columns: 28
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_campaigns_raw.md

Snapshots of Amazon Ads campaign configuration and settings. Rows are identified by campaign and ad product within each Organization, Store, and Ads Connection. State changes update the existing row. Includes archived, enabled, and paused campaigns. Snapshots are refreshed every 72 hours. Live entity state can be obtained using Actions.

### Ad Groups (raw)

- Table name: `amazon_ads_ad_groups_raw`
- Columns: 21
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ad_groups_raw.md

Snapshots of Amazon Ads ad group configuration and settings. Rows are identified by ad group and ad product. Includes archived, enabled, and paused ad groups. Snapshots are refreshed every 72 hours. Live entity state can be obtained using Actions.

### Ads (raw)

- Table name: `amazon_ads_ads_raw`
- Columns: 33
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ads_raw.md

Snapshots of Amazon Ads ad configuration and creative settings. Rows are identified by ad, ad product, and ad type. Includes archived, enabled, and paused ads. Snapshots are refreshed every 72 hours. Live entity state can be obtained using Actions.

### Ad Targets (raw)

- Table name: `amazon_ads_targets_raw`
- Columns: 40
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_targets_raw.md

Snapshots of Amazon Ads targeting configuration (keywords, product targets, audiences). Rows are identified by target and ad product. Includes archived, enabled, and paused targets. Snapshots are refreshed every 72 hours. Live entity state can be obtained using Actions.

### Ad Creative Assets

- Table name: `amazon_ads_creative_assets`
- Columns: 39
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_creative_assets.md

Amazon Ads Creative Asset Library assets and versions. Rows are identified by creative asset ID and version.

### Ad Entity History

- Table name: `amazon_ads_entity_history`
- Columns: 16
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_entity_history.md

Change history events for Amazon Ads entities (campaigns, ad groups, ads, targets), such as state, bid, and budget changes.

### Ad Purchased Products

- Table name: `amazon_ads_purchased_products`
- Columns: 32
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_purchased_products.md

ASINs purchased after an ad click or view, including brand-halo ASINs that differ from the promoted ASIN. Sponsored Products, Sponsored Display, and Sponsored Brands. Not the advertised-product performance table (amazon_ads_performance_by_child_asin_and_date).

### AMS Campaigns

- Table name: `amazon_ads_ams_campaigns`
- Columns: 21
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_campaigns.md

Amazon Marketing Stream campaign configuration events from dataset ads-campaign-management-campaigns.

### AMS Campaign Ad Groups

- Table name: `amazon_ads_ams_campaign_ad_groups`
- Columns: 16
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_campaign_ad_groups.md

Amazon Marketing Stream ad group configuration events from dataset ads-campaign-management-adgroups.

### AMS Campaign Ads

- Table name: `amazon_ads_ams_campaign_ads`
- Columns: 19
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_campaign_ads.md

Amazon Marketing Stream ad configuration events from dataset ads-campaign-management-ads.

### AMS Budget Usage

- Table name: `amazon_ads_ams_budget_usage`
- Columns: 16
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_budget_usage.md

Amazon Marketing Stream budget consumption events from dataset budget-usage.

### AMS Campaign Diagnostics

- Table name: `amazon_ads_ams_campaign_diagnostics`
- Columns: 20
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_campaign_diagnostics.md

Amazon Marketing Stream campaign diagnostics recommendations from dataset sponsored-ads-campaign-diagnostics-recommendations.

### AMS Campaign Targets

- Table name: `amazon_ads_ams_campaign_targets`
- Columns: 30
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_campaign_targets.md

Amazon Marketing Stream targeting configuration events from dataset ads-campaign-management-targets.

### AMS Traffic

- Table name: `amazon_ads_ams_traffic`
- Columns: 29
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_traffic.md

Amazon Marketing Stream near real-time traffic metrics unified across Sponsored Products, Sponsored Brands, and Sponsored Display.

### AMS Conversion

- Table name: `amazon_ads_ams_conversion`
- Columns: 55
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_conversion.md

Amazon Marketing Stream near real-time conversion metrics for Sponsored Products, Sponsored Brands, and Sponsored Display. Click-attributed columns are named ad_attributed_*; view-through columns start with ad_view_attributed_. Same-SKU columns exclude brand halo. Windows are 1, 7, 14, and 30 days. The daily campaign table uses 7 days for Sponsored Products and 14 days for Sponsored Brands and Sponsored Display — do not add these hourly rows to that table.

### AMS SB Clickstream

- Table name: `amazon_ads_ams_sb_clickstream`
- Columns: 22
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_sb_clickstream.md

Amazon Marketing Stream Sponsored Brands clickstream engagement metrics from dataset sb-clickstream.

### AMS SB Rich Media

- Table name: `amazon_ads_ams_sb_rich_media`
- Columns: 24
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_sb_rich_media.md

Amazon Marketing Stream Sponsored Brands rich media / video engagement metrics.

### AMS SP Budget Recommendations

- Table name: `amazon_ads_ams_sp_budget_recommendations`
- Columns: 24
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_ams_sp_budget_recommendations.md

Amazon Marketing Stream Sponsored Products budget recommendations. Missed sales, clicks, and impressions are Amazon estimates of what the campaign might have gained if it had not run out of budget, as a lower and upper bound, not a guarantee.

### Negative Keywords

- Table name: `amazon_ads_negative_keywords`
- Columns: 15
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_ads_negative_keywords.md

Negative keywords that block traffic. Weekly snapshots. These rows have no spend or sales.

### Sellers & Vendors Context

- Table name: `amazon_sellers_and_vendors_context`
- Columns: 10
- Markdown: https://api.datadoe.com/api/v1/spec/data-scheme/amazon_sellers_and_vendors_context.md

Lookup of DataDoe Amazon accounts for Seller Central, Vendor Central, Amazon Ads, and Amazon DSP. One row per connection, plus one row per Amazon DSP advertiser mapped to a seller or vendor on a shared agency Ads account. A DSP-only agency seat is not its own seller. seller_or_vendor_id equals connection_context_id and is not unique: one context can have a Seller Central row, an Amazon Ads row, and one row per DSP advertiser. Join Seller Central and Vendor Central facts on sp_connection_id or vendor_connection_id. Attribute DSP facts on organization_id, store_id, ads_dsp_connection_id, and dsp_advertiser_id.