# Profit by Date

- BigQuery table name: `amazon_profit_by_date`
- Available in: Seller Central
- Data scheme index: https://api.datadoe.com/api/v1/spec/data-scheme.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). Columns from average_sales_per_order_item through order_item_session_percentage_b2b are Amazon daily account totals from Sales and Traffic, filled for seller accounts only, and are not sums of per-ASIN rows. total_sessions, total_page_views, avg_buybox_percentage and their B2B and B2C variants also use the daily account totals, and fall back to child ASIN rows when the day has no account total. Columns starting with asin_ are per child ASIN Sales and Traffic values summed for the day.

- Source type: `SELLER_CENTRAL`
- Source ID: `b24cd69c061d107e5d5897d6fd06f95cd0432b3ed51b04b4ad8207e601da964c`
- Requires a date period: yes
- Contains PII: no
- Premium table: yes
- User-managed: no
- Default dataset: yes
- Rows count towards billing: yes
- Hub: https://www.datadoe.com/hub/data-scheme?source=SELLER_CENTRAL&table=b24cd69c061d107e5d5897d6fd06f95cd0432b3ed51b04b4ad8207e601da964c

## Fetch periods

- `CONTINUOUS`

## Data availability

- `INTRADAY` — Intraday updates are available when source data changes during the day. Refresh: 10am, 1pm, 4pm.

## Search aliases

- pnl
- p&l
- net profit
- account profit
- fees
- margin
- sessions
- buy box
- buybox

## Columns (142)

- `marketplace_id` (`TEXT`, required) — Amazon provided ID that represents a specific country where the Seller or Vendor operates.
- `marketplace_country_code` (`TEXT`, required) — ISO country code for the Amazon marketplace.
- `marketplace_country_name` (`TEXT`, required) — Human-readable country name for the marketplace (derived from marketplace_id).
- `seller_or_vendor_id` (`TEXT`, required) — DataDoe account identifier used by MCP/API calls (sellers_and_vendors_list, exports). Not unique in amazon_sellers_and_vendors_context when one account has multiple connection contexts — join that table on connection_context_id instead.
- `seller_or_vendor_name` (`TEXT`, required) — DataDoe connection context display name for the seller or vendor.
- `marketplace_seller_id` (`TEXT`, nullable) — Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID.
- `currency` (`TEXT`, required)
- `date` (`DATE`, required) — Date of the profit calculation in the marketplace timezone. Each organization, store, marketplace, seller, currency and date has one row.
- `total_sales` (`NUMBER`, required) — Sales from shipped order items. Includes tax where Amazon reports prices with tax; see sales_tax. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' ? (amazon_order_items_with_cogs.item_price_value ?? 0) + (amazon_order_items_with_cogs.item_shipping_price_value ?? 0) - (amazon_order_items_with_cogs.item_ship_promotion_discount_value ?? 0) : 0)`
- `sales_tax` (`NUMBER`, required) — Positive tax amount on shipped item and buyer-paid shipping prices for marketplaces whose selling prices include tax (all supported marketplaces except the US and Canada). Subtracted once from profit. Excludes gift-wrap tax; the P&L API uses item and gift-wrap tax while its shipping cost offsets buyer-paid shipping tax, so its sales_tax can differ. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' && ["A1AM78C64UM0Y8","A2Q3Y263D00KWC","A28R8C7NBKEWEA","A1RKKUPIHCS9HS","A1F83G8C2ARO7P","A13V1IB3VIYZZH","AMEN7PMS3EDWL","A1805IZSGTT6HS","A1PA6795UKMFR9","APJ6JRA9NG5V4","A2NODRKZP88ZB9","AE08WJ6YKNBMC","A1C3SOZRARQ6R3","ARBP9OOSHTCHU","A33AVAJ2PDY3EV","A17E79C6D8DWNP","A2VIGQ35RCS4UG","A21TJRUUN4KGV","A19VAU5U5O7RUS","A39IBJ37TRP1C6","A1VC38T7YXB528"].includes(amazon_order_items_with_cogs.marketplace_id) ? (amazon_order_items_with_cogs.item_tax_value ?? 0) + (amazon_order_items_with_cogs.item_shipping_tax_value ?? 0) : 0)`
- `sales_tax_missing_items` (`NUMBER`, required) — Number of shipped order items with a non-zero item price and no item tax, or a net shipping charge and no shipping tax, for marketplaces whose selling prices include tax (all supported marketplaces except the US and Canada). A positive count means sales_tax may be incomplete. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' && ["A1AM78C64UM0Y8","A2Q3Y263D00KWC","A28R8C7NBKEWEA","A1RKKUPIHCS9HS","A1F83G8C2ARO7P","A13V1IB3VIYZZH","AMEN7PMS3EDWL","A1805IZSGTT6HS","A1PA6795UKMFR9","APJ6JRA9NG5V4","A2NODRKZP88ZB9","AE08WJ6YKNBMC","A1C3SOZRARQ6R3","ARBP9OOSHTCHU","A33AVAJ2PDY3EV","A17E79C6D8DWNP","A2VIGQ35RCS4UG","A21TJRUUN4KGV","A19VAU5U5O7RUS","A39IBJ37TRP1C6","A1VC38T7YXB528"].includes(amazon_order_items_with_cogs.marketplace_id) && ((amazon_order_items_with_cogs.item_price_value !== 0 && amazon_order_items_with_cogs.item_tax_value == null) || (amazon_order_items_with_cogs.item_shipping_price_value > (amazon_order_items_with_cogs.item_ship_promotion_discount_value ?? 0) && amazon_order_items_with_cogs.item_shipping_tax_value == null)) ? 1 : 0)`
- `total_sales_b2b` (`NUMBER`, required) — Total sales from shipped B2B order items (order_is_business=true). Included in total_sales, not additive. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' && amazon_order_items_with_cogs.order_is_business ? (amazon_order_items_with_cogs.item_price_value ?? 0) + (amazon_order_items_with_cogs.item_shipping_price_value ?? 0) - (amazon_order_items_with_cogs.item_ship_promotion_discount_value ?? 0) : 0)`
- `total_sales_b2c` (`NUMBER`, required) — Total sales from shipped B2C order items (order_is_business=false). Included in total_sales, not additive. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' && !(amazon_order_items_with_cogs.order_is_business ?? false) ? (amazon_order_items_with_cogs.item_price_value ?? 0) + (amazon_order_items_with_cogs.item_shipping_price_value ?? 0) - (amazon_order_items_with_cogs.item_ship_promotion_discount_value ?? 0) : 0)`
- `unshipped_sales` (`NUMBER`, required) — Sales from order items with one of unshipped statuses. Not included in total_sales. — definition: `sum(String(amazon_order_items_with_cogs.item_status).toLowerCase().includes('unshipped') ? (amazon_order_items_with_cogs.item_price_value ?? 0) + (amazon_order_items_with_cogs.item_shipping_price_value ?? 0) - (amazon_order_items_with_cogs.item_ship_promotion_discount_value ?? 0) : 0)`
- `total_units_b2b` (`NUMBER`, required) — Ordered units from order line items where order_is_business is true, excluding canceled items. Includes unshipped. Not the same as total_units_sold_b2b, which counts shipped units only. — definition: `sum((amazon_order_items_with_cogs.item_status == null || !String(amazon_order_items_with_cogs.item_status).toLowerCase().includes('cancel')) && amazon_order_items_with_cogs.order_is_business ? amazon_order_items_with_cogs.quantity : 0)`
- `total_units_b2c` (`NUMBER`, required) — Ordered units from order line items where order_is_business is false, excluding canceled items. Includes unshipped. — definition: `sum((amazon_order_items_with_cogs.item_status == null || !String(amazon_order_items_with_cogs.item_status).toLowerCase().includes('cancel')) && !(amazon_order_items_with_cogs.order_is_business ?? false) ? amazon_order_items_with_cogs.quantity : 0)`
- `total_units_sold` (`NUMBER`, required) — Total quantity sold from shipped order items. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' ? amazon_order_items_with_cogs.quantity : 0)`
- `total_units_sold_b2b` (`NUMBER`, required) — Shipped units from order line items where order_is_business is true. Included in total_units_sold, not additive. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' && amazon_order_items_with_cogs.order_is_business ? amazon_order_items_with_cogs.quantity : 0)`
- `total_units_sold_b2c` (`NUMBER`, required) — Shipped units from order line items where order_is_business is false. Included in total_units_sold, not additive. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' && !(amazon_order_items_with_cogs.order_is_business ?? false) ? amazon_order_items_with_cogs.quantity : 0)`
- `total_orders` (`NUMBER`, required) — Distinct shipped orders this item appeared in. — definition: `countDistinct(amazon_order_items_with_cogs.item_status === 'Shipped' ? amazon_order_items_with_cogs.amazon_order_id : null)`
- `refund_count` (`NUMBER`, required) — Count of settlement_type REFUND financial events on posted date. Not SUM(quantity). A day can exist here with no sales if refunds posted that day. — definition: `count(amazon_settlements_with_cogs.settlement_type === 'REFUND')`
- `refund_cost` (`NUMBER`, required) — Refund principal and fee reversals on the settlement posting date. Excludes refunded item, shipping and promotion tax. Return COGS is added on the return date. Not part of total_fees. — definition: `(sum(amazon_settlements_with_cogs.settlement_type === 'REFUND' ? (amazon_settlements_with_cogs.refunded_amount ?? 0) + (amazon_settlements_with_cogs.refunded_referral_fee ?? 0) + (amazon_settlements_with_cogs.refund_commission ?? 0) + (amazon_settlements_with_cogs.refund_shipping ?? 0) + (amazon_settlements_with_cogs.refund_shipping_promotion ?? 0) + (amazon_settlements_with_cogs.refund_digital_services_fee ?? 0) : 0)) + (sum(amazon_returns.amazon_return_detailed_disposition != null && String(amazon_returns.amazon_return_detailed_disposition).toUpperCase() === 'SELLABLE' ? (amazon_returns.cogs_total_value ?? 0) : 0)) + (sum(amazon_returns.amazon_return_detailed_disposition != null && String(amazon_returns.amazon_return_detailed_disposition).toUpperCase() !== 'SELLABLE' ? 0 - (amazon_returns.cogs_total_value ?? 0) : 0))`
- `return_units` (`NUMBER`, required) — Returned units from amazon_returns on return receipt/request date, not payout date. — definition: `sum((amazon_returns.quantity ?? 0))`
- `return_cogs` (`NUMBER`, required) — Item cost of returned units from amazon_returns on return receipt/request date. Not part of profit. — definition: `sum((amazon_returns.cogs_total_value ?? 0))`
- `cogs_item` (`NUMBER`, required) — Total item COGS from shipped order items. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' ? amazon_order_items_with_cogs.cogs_item_value : 0)`
- `cogs_shipping` (`NUMBER`, required) — Total shipping COGS from shipped order items. — definition: `sum(amazon_order_items_with_cogs.item_status === 'Shipped' ? amazon_order_items_with_cogs.cogs_shipping_value : 0)`
- `lost_damaged_by_amazon` (`NUMBER`, required) — Lost or damaged inventory reimbursements and charges on settlement posted date. Stored as a positive cost (settlement cash-flow sign flipped). Included in cogs_total, not in total_fees. — definition: `sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.warehouse_lost ?? 0) + (amazon_settlements_with_cogs.warehouse_lost_manual ?? 0)) : 0)`
- `missing_returns` (`NUMBER`, required) — Missing-from-inbound inventory on settlement posted date. Stored as a positive cost (settlement cash-flow sign flipped). Included in cogs_total, not in total_fees. — definition: `sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.missing_from_inbound ?? 0) + (amazon_settlements_with_cogs.missing_from_inbound_clawback ?? 0)) : 0)`
- `cogs_total` (`NUMBER`, required) — Shipped-order COGS plus lost_damaged_by_amazon and missing_returns on posted date. — definition: `(sum(amazon_order_items_with_cogs.item_status === 'Shipped' ? amazon_order_items_with_cogs.cogs_total_value : 0)) + (sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.warehouse_lost ?? 0) + (amazon_settlements_with_cogs.warehouse_lost_manual ?? 0)) : 0)) + (sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.missing_from_inbound ?? 0) + (amazon_settlements_with_cogs.missing_from_inbound_clawback ?? 0)) : 0))`
- `cogs_present` (`LOGIC`, nullable) — True when every shipped order item and return in this profit row has an applicable uploaded COGS record. False if any is missing; null when neither contributes.
- `total_fees` (`NUMBER`, required) — Positive cost (settlement cash-flow sign flipped). Order fees use the order date when available; inbound, storage and similar fees use the posting date. Advertising is in ad_spend, inventory adjustments in cogs_total and refunds in refund_cost. Seller-retained sales tax on items, shipping and gift-wrap is excluded before the sign flip, accounting for withheld tax and marketplace-facilitator VAT. promotion_tax_discount remains included in fees. Do not add this to amazon_settlements_with_cogs.total_non_principal_amount, which also includes non-fee payments. — definition: `(sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.total_fees ?? 0) - (amazon_settlements_with_cogs.cost_of_advertising ?? 0) - ((amazon_settlements_with_cogs.fba_inbound_convenience_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_transportation_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_transportation_program_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_placement_service_fee ?? 0) + (amazon_settlements_with_cogs.fba_storage_fee ?? 0) + (amazon_settlements_with_cogs.long_term_storage_fee ?? 0) + (amazon_settlements_with_cogs.fba_disposal_fee ?? 0) + (amazon_settlements_with_cogs.removal_complete ?? 0) + (amazon_settlements_with_cogs.subscription_fee ?? 0) + (amazon_settlements_with_cogs.compensated_clawback ?? 0) + (amazon_settlements_with_cogs.warehouse_damage ?? 0) + (amazon_settlements_with_cogs.reversal_reimbursement ?? 0) + (amazon_settlements_with_cogs.free_replacement_refund_items ?? 0) + (amazon_settlements_with_cogs.liquidations_revenue ?? 0) + (amazon_settlements_with_cogs.liquidations_other ?? 0) + (amazon_settlements_with_cogs.liquidations_brokerage_fee ?? 0) + (amazon_settlements_with_cogs.fba_inventory_reimbursement_re_evaluation ?? 0) + (amazon_settlements_with_cogs.warehouse_lost ?? 0) + (amazon_settlements_with_cogs.warehouse_lost_manual ?? 0) + (amazon_settlements_with_cogs.missing_from_inbound ?? 0) + (amazon_settlements_with_cogs.missing_from_inbound_clawback ?? 0)) - ((amazon_settlements_with_cogs.item_tax ?? 0) + (amazon_settlements_with_cogs.item_shipping_tax ?? 0) + (amazon_settlements_with_cogs.item_gift_wrap_tax ?? 0) + (amazon_settlements_with_cogs.item_withheld_tax ?? 0) + (amazon_settlements_with_cogs.marketplace_facilitator_vat ?? 0) + (amazon_settlements_with_cogs.refund_tax ?? 0) + (amazon_settlements_with_cogs.refund_shipping_tax ?? 0) + (amazon_settlements_with_cogs.refund_item_withheld_tax ?? 0) + (amazon_settlements_with_cogs.refund_marketplace_facilitator_vat ?? 0))) : 0)) + (sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.fba_inbound_convenience_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_transportation_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_transportation_program_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_placement_service_fee ?? 0) + (amazon_settlements_with_cogs.fba_storage_fee ?? 0) + (amazon_settlements_with_cogs.long_term_storage_fee ?? 0) + (amazon_settlements_with_cogs.fba_disposal_fee ?? 0) + (amazon_settlements_with_cogs.removal_complete ?? 0) + (amazon_settlements_with_cogs.subscription_fee ?? 0) + (amazon_settlements_with_cogs.compensated_clawback ?? 0) + (amazon_settlements_with_cogs.warehouse_damage ?? 0) + (amazon_settlements_with_cogs.reversal_reimbursement ?? 0) + (amazon_settlements_with_cogs.free_replacement_refund_items ?? 0) + (amazon_settlements_with_cogs.liquidations_revenue ?? 0) + (amazon_settlements_with_cogs.liquidations_other ?? 0) + (amazon_settlements_with_cogs.liquidations_brokerage_fee ?? 0) + (amazon_settlements_with_cogs.fba_inventory_reimbursement_re_evaluation ?? 0)) : 0))`
- `total_selling_fees` (`NUMBER`, required) — Referral fee on non-REFUND settlements. Refunded referral fee and refund commission are in refund_cost, not here. Stored as a positive cost. Subtract from sales. — definition: `sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - (amazon_settlements_with_cogs.total_selling_fees ?? 0) : 0)`
- `fba_fees` (`NUMBER`, required) — Per-unit and other order-tied FBA fees use COALESCE(order_date, posted date); inbound, storage, LTSF and disposal use posted date. Stored as a positive cost. Subtract from sales. — definition: `sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.fba_per_unit_fulfillment_fee ?? 0) + (amazon_settlements_with_cogs.fba_transportation_fee ?? 0) + (amazon_settlements_with_cogs.fba_customer_return_per_unit_fee ?? 0) + (amazon_settlements_with_cogs.fba_other ?? 0)) : 0) + sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.fba_storage_fee ?? 0) + (amazon_settlements_with_cogs.fba_disposal_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_convenience_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_placement_service_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_transportation_fee ?? 0) + (amazon_settlements_with_cogs.fba_inbound_transportation_program_fee ?? 0) + (amazon_settlements_with_cogs.fba_inventory_reimbursement_re_evaluation ?? 0) + (amazon_settlements_with_cogs.long_term_storage_fee ?? 0)) : 0)`
- `awd_fees` (`NUMBER`, required) — AWD fees from Amazon settlements. Stored as a positive cost. Subtract from sales. — definition: `sum(amazon_settlements_with_cogs.settlement_type !== 'REFUND' ? 0 - ((amazon_settlements_with_cogs.awd_processing_fee ?? 0) + (amazon_settlements_with_cogs.awd_transportation_fee ?? 0) + (amazon_settlements_with_cogs.awd_storage_fee ?? 0) + (amazon_settlements_with_cogs.awd_processing_fee_discount ?? 0) + (amazon_settlements_with_cogs.awd_storage_fee_discount ?? 0) + (amazon_settlements_with_cogs.awd_transportation_fee_discount ?? 0)) : 0)`
- `ad_spend` (`NUMBER`, required) — Ad spend of all campaign types: Sponsored Products, Sponsored Brands, Sponsored Display, Sponsored Television and Amazon DSP. Amazon DSP spend is DSP totalCost: supply cost plus Amazon fees, excluding third-party fees paid by the agency. Includes all Sponsored Television spend and all DSP spend, including spend with no ASIN allocation. Use this for account advertising cost; it can exceed SUM(amazon_profit_by_sku_and_date.ad_spend). — definition: `sum(amazon_ads_performance_by_campaign_by_date.ad_spend) + sum(amazon_ads_dsp_performance_by_creative_by_date.ad_spend)`
- `sponsored_tv_ad_spend` (`NUMBER`, required) — Sponsored Television campaign spend, included once in ad_spend and deducted once in profit. Account-only: the campaign report does not support SKU attribution. Do not add this amount to ad_spend or deduct it from profit again. — definition: `sum(amazon_ads_performance_by_campaign_by_date.ad_campaign_type === 'SPONSORED_TELEVISION' ? (amazon_ads_performance_by_campaign_by_date.ad_spend ?? 0) : 0)`
- `ad_sales` (`NUMBER`, required) — Attributed ad sales (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS). Includes Amazon DSP (14d attribution) with promoted ASINs plus brand halo, like Sponsored Brands and Sponsored Display sales. — definition: `sum(amazon_ads_performance_by_campaign_by_date.ad_sales) + sum(amazon_ads_dsp_performance_by_creative_by_date.ad_sales)`
- `ad_orders` (`NUMBER`, required) — Attributed ad orders (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS). Includes Amazon DSP (14d attribution) with promoted ASINs plus brand halo, like Sponsored Brands and Sponsored Display sales. — definition: `sum(amazon_ads_performance_by_campaign_by_date.ad_orders) + sum(amazon_ads_dsp_performance_by_creative_by_date.ad_orders)`
- `ad_units_sold` (`NUMBER`, required) — Attributed ad units sold (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS). Includes Amazon DSP (14d attribution) with promoted ASINs plus brand halo, like Sponsored Brands and Sponsored Display sales. — definition: `sum(amazon_ads_performance_by_campaign_by_date.ad_units_sold) + sum(amazon_ads_dsp_performance_by_creative_by_date.ad_units_sold)`
- `ad_clicks` (`NUMBER`, required) — Attributed ad clicks, including Amazon DSP click-throughs. — definition: `sum(amazon_ads_performance_by_campaign_by_date.ad_clicks) + sum(amazon_ads_dsp_performance_by_creative_by_date.ad_clicks)`
- `ad_impressions` (`NUMBER`, required) — Attributed ad impressions, including Amazon DSP impressions. — definition: `sum(amazon_ads_performance_by_campaign_by_date.ad_impressions) + sum(amazon_ads_dsp_performance_by_creative_by_date.ad_impressions)`
- `ad_target_reported_spend` (`NUMBER`, required) — Target-report spend on this click date. Can differ from account ad_spend because report scopes differ. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_target_and_date.ad_spend) by marketplace, seller, currency and date`
- `ad_target_reported_sales` (`NUMBER`, required) — Sales attributed to targets on this click date. Sponsored Products uses seven days and Sponsored Brands uses 14 days. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_target_and_date.ad_sales) by marketplace, seller, currency and date`
- `ad_target_count` (`NUMBER`, required) — Number of target report rows on this date, including rows with spend and no sales. Null when no matching summary exists. — definition: `count(amazon_ads_profit_by_target_and_date rows) by marketplace, seller, currency and date`
- `ad_target_costed_sales` (`NUMBER`, required) — Target sales from exactly the rows with a non-null profit estimate. Includes provisional rows and excludes partly costed rows. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_target_and_date.ad_sales where estimated_profit_after_ads is not null)`
- `ad_target_costed_spend` (`NUMBER`, required) — Target spend from exactly the rows with a non-null profit estimate, including provisional and spend-only rows. Compare costed profit with this spend. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_target_and_date.ad_spend where estimated_profit_after_ads is not null)`
- `ad_target_unsupported_sales` (`NUMBER`, required) — Target sales from ad types without product attribution for profit estimation. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_target_and_date.unsupported_sales)`
- `ad_target_missing_cost_sales` (`NUMBER`, required) — Target Sponsored Products sales on rows without a profit estimate because the Seller Central connection, costs or reconciliation are incomplete. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_target_and_date.missing_cost_sales)`
- `ad_target_costed_estimated_profit_after_ads` (`NUMBER`, required) — Sum of available target profit estimates, including provisional and spend-only rows, excluding refunds. Use ad_target_costed_sales and ad_target_costed_spend for the matching scope. Null when no estimate is available. Overlaps the other ad summary and must not be added to account P&L. — definition: `sum(amazon_ads_profit_by_target_and_date.estimated_profit_after_ads)`
- `ad_target_mature_spend_without_sales` (`NUMBER`, required) — Target spend with no attributed sales after the report attribution window has passed. Null when no matching summary exists. — definition: `sum(coalesce(amazon_ads_profit_by_target_and_date.mature_spend_without_sales, 0))`
- `ad_search_term_reported_spend` (`NUMBER`, required) — Search-term report spend on this click date. This overlaps target spend. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_search_term_and_date.ad_spend) by marketplace, seller, currency and date`
- `ad_search_term_reported_sales` (`NUMBER`, required) — Sales attributed to search terms on this click date. This overlaps target sales. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_search_term_and_date.ad_sales) by marketplace, seller, currency and date`
- `ad_search_term_count` (`NUMBER`, required) — Number of search-term report rows on this date. Null when no matching summary exists. — definition: `count(amazon_ads_profit_by_search_term_and_date rows) by marketplace, seller, currency and date`
- `ad_search_term_costed_sales` (`NUMBER`, required) — Search-term sales from exactly the rows with a non-null profit estimate. Includes provisional rows and excludes partly costed rows. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_search_term_and_date.ad_sales where estimated_profit_after_ads is not null)`
- `ad_search_term_costed_spend` (`NUMBER`, required) — Search-term spend from exactly the rows with a non-null profit estimate, including provisional and spend-only rows. Compare costed profit with this spend. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_search_term_and_date.ad_spend where estimated_profit_after_ads is not null)`
- `ad_search_term_unsupported_sales` (`NUMBER`, required) — Search-term sales from ad types without product attribution for profit estimation. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_search_term_and_date.unsupported_sales)`
- `ad_search_term_missing_cost_sales` (`NUMBER`, required) — Search-term Sponsored Products sales on rows without a profit estimate because the Seller Central connection, parent target, costs or reconciliation are incomplete. Null when no matching summary exists. — definition: `sum(amazon_ads_profit_by_search_term_and_date.missing_cost_sales)`
- `ad_search_term_costed_estimated_profit_after_ads` (`NUMBER`, required) — Sum of available search-term profit estimates, including provisional and spend-only rows, excluding refunds. Use ad_search_term_costed_sales and ad_search_term_costed_spend for the matching scope. Null when no estimate is available. Overlaps the other ad summary and must not be added to account P&L. — definition: `sum(amazon_ads_profit_by_search_term_and_date.estimated_profit_after_ads)`
- `ad_search_term_mature_spend_without_sales` (`NUMBER`, required) — Search-term spend with no attributed sales after the report attribution window has passed. Null when no matching summary exists. — definition: `sum(coalesce(amazon_ads_profit_by_search_term_and_date.mature_spend_without_sales, 0))`
- `avg_buybox_percentage` (`NUMBER`, required) — Account-level buy box percentage for the day, from Amazon Sales and Traffic daily buyBoxPercentage. Buy box percentage is the share of page views where the buy box (add to cart) appeared for your offers. Falls back to the unweighted average of child ASINs when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? raw_sp_api_report_sales_and_traffic_by_date.buyBoxPercentage : avg(amazon_sales_and_traffic_with_cogs.buybox_percentage)`
- `avg_buybox_percentage_b2b` (`NUMBER`, required) — Account-level B2B buy box percentage for the day, from Amazon Sales and Traffic daily buyBoxPercentageB2B. Falls back to the unweighted average of child ASINs when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? raw_sp_api_report_sales_and_traffic_by_date.buyBoxPercentageB2B : avg(amazon_sales_and_traffic_with_cogs.buybox_percentage_b2b)`
- `avg_buybox_percentage_b2c` (`NUMBER`, required) — Account-level B2C buy box percentage for the day. Amazon does not publish B2C buy box; reconstructed from the daily overall and B2B buy box weighted by page views. Falls back to the unweighted average of child ASINs when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? ((raw_sp_api_report_sales_and_traffic_by_date.buyBoxPercentage ?? 0) * (raw_sp_api_report_sales_and_traffic_by_date.pageViews ?? 0) - (raw_sp_api_report_sales_and_traffic_by_date.buyBoxPercentageB2B ?? 0) * (raw_sp_api_report_sales_and_traffic_by_date.pageViewsB2B ?? 0)) / ((raw_sp_api_report_sales_and_traffic_by_date.pageViews ?? 0) - (raw_sp_api_report_sales_and_traffic_by_date.pageViewsB2B ?? 0)) : avg(((amazon_sales_and_traffic_with_cogs.buybox_percentage ?? 0) * (amazon_sales_and_traffic_with_cogs.page_views ?? 0) - (amazon_sales_and_traffic_with_cogs.buybox_percentage_b2b ?? 0) * (amazon_sales_and_traffic_with_cogs.page_views_b2b ?? 0)) / ((amazon_sales_and_traffic_with_cogs.page_views ?? 0) - (amazon_sales_and_traffic_with_cogs.page_views_b2b ?? 0)))`
- `total_sessions` (`NUMBER`, required) — Account-level sessions for the day, from Amazon Sales and Traffic daily sessions. A session is a visit to your Amazon product detail pages via browser or mobile app, counted once even when it covers several child ASINs, so it can be lower than asin_ sums. Falls back to the sum of child ASIN rows when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? raw_sp_api_report_sales_and_traffic_by_date.sessions : sum(amazon_sales_and_traffic_with_cogs.session)`
- `sessions_b2b` (`NUMBER`, required) — Account-level B2B sessions for the day, from Amazon Sales and Traffic daily sessionsB2B. Included in total_sessions, not additive. Falls back to the sum of child ASIN rows when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? raw_sp_api_report_sales_and_traffic_by_date.sessionsB2B : sum(amazon_sales_and_traffic_with_cogs.sessions_b2b)`
- `sessions_b2c` (`NUMBER`, required) — Account-level B2C sessions for the day, calculated as total_sessions minus sessions_b2b. Amazon does not publish a B2C sessions field. Falls back to the sum of child ASIN rows when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? Math.max((raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) - (raw_sp_api_report_sales_and_traffic_by_date.sessionsB2B ?? 0), 0) : sum(Math.max((amazon_sales_and_traffic_with_cogs.session ?? 0) - (amazon_sales_and_traffic_with_cogs.sessions_b2b ?? 0), 0))`
- `total_page_views` (`NUMBER`, required) — Account-level page views for the day, from Amazon Sales and Traffic daily pageViews. Page views count visits to your Amazon product detail pages via browser or mobile app. Falls back to the sum of child ASIN rows when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? raw_sp_api_report_sales_and_traffic_by_date.pageViews : sum(amazon_sales_and_traffic_with_cogs.page_views)`
- `page_views_b2b` (`NUMBER`, required) — Account-level B2B page views for the day, from Amazon Sales and Traffic daily pageViewsB2B. Included in total_page_views, not additive. Falls back to the sum of child ASIN rows when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? raw_sp_api_report_sales_and_traffic_by_date.pageViewsB2B : sum(amazon_sales_and_traffic_with_cogs.page_views_b2b)`
- `page_views_b2c` (`NUMBER`, required) — Account-level B2C page views for the day, calculated as total_page_views minus page_views_b2b. Amazon does not publish a B2C page views field. Falls back to the sum of child ASIN rows when the day has no account total. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `(raw_sp_api_report_sales_and_traffic_by_date.sessions ?? 0) > 0 ? Math.max((raw_sp_api_report_sales_and_traffic_by_date.pageViews ?? 0) - (raw_sp_api_report_sales_and_traffic_by_date.pageViewsB2B ?? 0), 0) : sum(Math.max((amazon_sales_and_traffic_with_cogs.page_views ?? 0) - (amazon_sales_and_traffic_with_cogs.page_views_b2b ?? 0), 0))`
- `average_sales_per_order_item` (`NUMBER`, required) — Account-level average ordered product sales per order item for the day, from Amazon Sales and Traffic averageSalesPerOrderItem. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `average_sales_per_order_item_b2b` (`NUMBER`, required) — Account-level average ordered product sales per B2B order item for the day, from Amazon Sales and Traffic averageSalesPerOrderItemB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `average_sales_per_order_item_b2c` (`NUMBER`, required) — Account-level average ordered product sales per B2C order item for the day, reconstructed from overall and B2B averages weighted by order items. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `((raw_sp_api_report_sales_and_traffic_by_date.averageSalesPerOrderItem ?? 0) * (raw_sp_api_report_sales_and_traffic_by_date.totalOrderItems ?? 0) - (raw_sp_api_report_sales_and_traffic_by_date.averageSalesPerOrderItemB2B ?? 0) * (raw_sp_api_report_sales_and_traffic_by_date.totalOrderItemsB2B ?? 0)) / ((raw_sp_api_report_sales_and_traffic_by_date.totalOrderItems ?? 0) - (raw_sp_api_report_sales_and_traffic_by_date.totalOrderItemsB2B ?? 0))`
- `average_units_per_order_item` (`NUMBER`, required) — Account-level average units per order item for the day, from Amazon Sales and Traffic averageUnitsPerOrderItem. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `average_units_per_order_item_b2b` (`NUMBER`, required) — Account-level average units per B2B order item for the day, from Amazon Sales and Traffic averageUnitsPerOrderItemB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `average_units_per_order_item_b2c` (`NUMBER`, required) — Account-level average units per B2C order item for the day, reconstructed from overall and B2B averages weighted by order items. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `((raw_sp_api_report_sales_and_traffic_by_date.averageUnitsPerOrderItem ?? 0) * (raw_sp_api_report_sales_and_traffic_by_date.totalOrderItems ?? 0) - (raw_sp_api_report_sales_and_traffic_by_date.averageUnitsPerOrderItemB2B ?? 0) * (raw_sp_api_report_sales_and_traffic_by_date.totalOrderItemsB2B ?? 0)) / ((raw_sp_api_report_sales_and_traffic_by_date.totalOrderItems ?? 0) - (raw_sp_api_report_sales_and_traffic_by_date.totalOrderItemsB2B ?? 0))`
- `claims_granted` (`NUMBER`, required) — Number of A-to-z Guarantee claims granted for the day, from Amazon Sales and Traffic claimsGranted. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `claims_granted_b2b` (`NUMBER`, required) — Number of A-to-z Guarantee claims granted for B2B orders for the day, from Amazon Sales and Traffic claimsGrantedB2B. Included in claims_granted, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `claims_granted_b2c` (`NUMBER`, required) — Number of A-to-z Guarantee claims granted for B2C orders for the day, calculated as claims_granted minus claims_granted_b2b. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `Math.max((amazon_profit_by_date.claims_granted ?? 0) - (amazon_profit_by_date.claims_granted_b2b ?? 0), 0)`
- `claims_amount` (`NUMBER`, required) — Amount of A-to-z Guarantee claims granted for the day in the row currency, from Amazon Sales and Traffic claimsAmount. Not included in profit or refund_cost. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `claims_amount_b2b` (`NUMBER`, required) — Amount of A-to-z Guarantee claims granted for B2B orders for the day, from Amazon Sales and Traffic claimsAmountB2B. Included in claims_amount, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `claims_amount_b2c` (`NUMBER`, required) — Amount of A-to-z Guarantee claims granted for B2C orders for the day, calculated as claims_amount minus claims_amount_b2b. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `Math.max((amazon_profit_by_date.claims_amount ?? 0) - (amazon_profit_by_date.claims_amount_b2b ?? 0), 0)`
- `units_refunded` (`NUMBER`, required) — Units refunded for the day as reported by Amazon Sales and Traffic unitsRefunded. Can differ from return_units, which counts customer returns. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `units_refunded_b2b` (`NUMBER`, required) — B2B units refunded for the day, from Amazon Sales and Traffic unitsRefundedB2B. Included in units_refunded, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `refund_rate` (`NUMBER`, required) — Units refunded as a percentage of units ordered for the day, from Amazon Sales and Traffic refundRate. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `refund_rate_b2b` (`NUMBER`, required) — B2B units refunded as a percentage of B2B units ordered for the day, from Amazon Sales and Traffic refundRateB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `shipped_product_sales` (`NUMBER`, required) — Account-level shipped product sales for the day in the row currency, from Amazon Sales and Traffic shippedProductSales. Amazon's own figure; can differ from total_sales, which is built from order items. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `shipped_product_sales_b2b` (`NUMBER`, required) — Account-level B2B shipped product sales for the day, from Amazon Sales and Traffic shippedProductSalesB2B. Included in shipped_product_sales, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `units_shipped` (`NUMBER`, required) — Account-level units shipped for the day, from Amazon Sales and Traffic unitsShipped. Amazon's own figure; can differ from total_units_sold, which is built from order items. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `units_shipped_b2b` (`NUMBER`, required) — Account-level B2B units shipped for the day, from Amazon Sales and Traffic unitsShippedB2B. Included in units_shipped, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `orders_shipped` (`NUMBER`, required) — Account-level orders shipped for the day, from Amazon Sales and Traffic ordersShipped. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `orders_shipped_b2b` (`NUMBER`, required) — Account-level B2B orders shipped for the day, from Amazon Sales and Traffic ordersShippedB2B. Included in orders_shipped, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `average_offer_count` (`NUMBER`, required) — Account-level average number of offers listed for sale for the day, from Amazon Sales and Traffic averageOfferCount. Do not sum across days. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `average_parent_items` (`NUMBER`, required) — Account-level average number of parent items listed for sale for the day, from Amazon Sales and Traffic averageParentItems. Do not sum across days. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `feedback_received` (`NUMBER`, required) — Number of seller feedback ratings received for the day, from Amazon Sales and Traffic feedbackReceived. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `feedback_received_b2b` (`NUMBER`, required) — Number of seller feedback ratings received from B2B buyers for the day, from Amazon Sales and Traffic feedbackReceivedB2B. Included in feedback_received, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `feedback_received_b2c` (`NUMBER`, required) — Number of seller feedback ratings received from B2C buyers for the day, calculated as feedback_received minus feedback_received_b2b. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `Math.max((amazon_profit_by_date.feedback_received ?? 0) - (amazon_profit_by_date.feedback_received_b2b ?? 0), 0)`
- `negative_feedback_received` (`NUMBER`, required) — Number of negative seller feedback ratings received for the day, from Amazon Sales and Traffic negativeFeedbackReceived. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `negative_feedback_received_b2b` (`NUMBER`, required) — Number of negative seller feedback ratings received from B2B buyers for the day, from Amazon Sales and Traffic negativeFeedbackReceivedB2B. Included in negative_feedback_received, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `received_negative_feedback_rate` (`NUMBER`, required) — Negative seller feedback received as a percentage of feedback received for the day, from Amazon Sales and Traffic receivedNegativeFeedbackRate. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `received_negative_feedback_rate_b2b` (`NUMBER`, required) — B2B negative seller feedback received as a percentage of B2B feedback received for the day, from Amazon Sales and Traffic receivedNegativeFeedbackRateB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `browser_sessions` (`NUMBER`, required) — Account-level sessions from web browsers for the day, from Amazon Sales and Traffic browserSessions. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `browser_sessions_b2b` (`NUMBER`, required) — Account-level B2B sessions from web browsers for the day, from Amazon Sales and Traffic browserSessionsB2B. Included in browser_sessions, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `mobile_sessions` (`NUMBER`, required) — Account-level sessions from the Amazon mobile app for the day, from Amazon Sales and Traffic mobileAppSessions. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `mobile_sessions_b2b` (`NUMBER`, required) — Account-level B2B sessions from the Amazon mobile app for the day, from Amazon Sales and Traffic mobileAppSessionsB2B. Included in mobile_sessions, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `browser_page_views` (`NUMBER`, required) — Account-level page views from web browsers for the day, from Amazon Sales and Traffic browserPageViews. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `browser_page_views_b2b` (`NUMBER`, required) — Account-level B2B page views from web browsers for the day, from Amazon Sales and Traffic browserPageViewsB2B. Included in browser_page_views, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `mobile_page_views` (`NUMBER`, required) — Account-level page views from the Amazon mobile app for the day, from Amazon Sales and Traffic mobileAppPageViews. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `mobile_page_views_b2b` (`NUMBER`, required) — Account-level B2B page views from the Amazon mobile app for the day, from Amazon Sales and Traffic mobileAppPageViewsB2B. Included in mobile_page_views, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `unit_session_percentage` (`NUMBER`, required) — Account-level units ordered as a percentage of sessions for the day, from Amazon Sales and Traffic unitSessionPercentage. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `unit_session_percentage_b2b` (`NUMBER`, required) — Account-level B2B units ordered as a percentage of B2B sessions for the day, from Amazon Sales and Traffic unitSessionPercentageB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `order_item_session_percentage` (`NUMBER`, required) — Account-level order items as a percentage of sessions for the day, from Amazon Sales and Traffic orderItemSessionPercentage. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `order_item_session_percentage_b2b` (`NUMBER`, required) — Account-level B2B order items as a percentage of B2B sessions for the day, from Amazon Sales and Traffic orderItemSessionPercentageB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_sessions` (`NUMBER`, required) — Sessions from web browsers summed across child ASIN rows for the day, from Amazon Sales and Traffic browserSessions. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_sessions_b2b` (`NUMBER`, required) — B2B sessions from web browsers summed across child ASIN rows for the day, from Amazon Sales and Traffic browserSessionsB2B. Included in asin_browser_sessions, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_sessions_b2c` (`NUMBER`, required) — B2C sessions from web browsers summed across child ASIN rows for the day, calculated as asin_browser_sessions minus asin_browser_sessions_b2b, floored at 0 per child ASIN. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `sum(Math.max((raw_sp_api_report_sales_and_traffic.browserSessions ?? 0) - (raw_sp_api_report_sales_and_traffic.browserSessionsB2B ?? 0), 0))`
- `asin_mobile_sessions` (`NUMBER`, required) — Sessions from the Amazon mobile app summed across child ASIN rows for the day, from Amazon Sales and Traffic mobileAppSessions. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_mobile_sessions_b2b` (`NUMBER`, required) — B2B sessions from the amazon mobile app summed across child ASIN rows for the day, from Amazon Sales and Traffic mobileAppSessionsB2B. Included in asin_mobile_sessions, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_mobile_sessions_b2c` (`NUMBER`, required) — B2C sessions from the amazon mobile app summed across child ASIN rows for the day, calculated as asin_mobile_sessions minus asin_mobile_sessions_b2b, floored at 0 per child ASIN. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `sum(Math.max((raw_sp_api_report_sales_and_traffic.mobileAppSessions ?? 0) - (raw_sp_api_report_sales_and_traffic.mobileAppSessionsB2B ?? 0), 0))`
- `asin_browser_page_views` (`NUMBER`, required) — Page views from web browsers summed across child ASIN rows for the day, from Amazon Sales and Traffic browserPageViews. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_page_views_b2b` (`NUMBER`, required) — B2B page views from web browsers summed across child ASIN rows for the day, from Amazon Sales and Traffic browserPageViewsB2B. Included in asin_browser_page_views, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_page_views_b2c` (`NUMBER`, required) — B2C page views from web browsers summed across child ASIN rows for the day, calculated as asin_browser_page_views minus asin_browser_page_views_b2b, floored at 0 per child ASIN. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `sum(Math.max((raw_sp_api_report_sales_and_traffic.browserPageViews ?? 0) - (raw_sp_api_report_sales_and_traffic.browserPageViewsB2B ?? 0), 0))`
- `asin_mobile_page_views` (`NUMBER`, required) — Page views from the Amazon mobile app summed across child ASIN rows for the day, from Amazon Sales and Traffic mobileAppPageViews. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_mobile_page_views_b2b` (`NUMBER`, required) — B2B page views from the amazon mobile app summed across child ASIN rows for the day, from Amazon Sales and Traffic mobileAppPageViewsB2B. Included in asin_mobile_page_views, not additive. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_mobile_page_views_b2c` (`NUMBER`, required) — B2C page views from the amazon mobile app summed across child ASIN rows for the day, calculated as asin_mobile_page_views minus asin_mobile_page_views_b2b, floored at 0 per child ASIN. Amazon does not publish a B2C field. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations. — definition: `sum(Math.max((raw_sp_api_report_sales_and_traffic.mobileAppPageViews ?? 0) - (raw_sp_api_report_sales_and_traffic.mobileAppPageViewsB2B ?? 0), 0))`
- `asin_session_percentage` (`NUMBER`, required) — Child ASIN share of the account's daily sessions as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic sessionPercentage. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_session_percentage_b2b` (`NUMBER`, required) — Child ASIN share of the account's daily B2B sessions as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic sessionPercentageB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_page_views_percentage` (`NUMBER`, required) — Child ASIN share of the account's daily page views as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic pageViewsPercentage. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_page_views_percentage_b2b` (`NUMBER`, required) — Child ASIN share of the account's daily B2B page views as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic pageViewsPercentageB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_session_percentage` (`NUMBER`, required) — Child ASIN share of the account's daily browser sessions as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic browserSessionPercentage. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_session_percentage_b2b` (`NUMBER`, required) — Child ASIN share of the account's daily B2B browser sessions as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic browserSessionPercentageB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_mobile_session_percentage` (`NUMBER`, required) — Child ASIN share of the account's daily mobile app sessions as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic mobileAppSessionPercentage. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_mobile_session_percentage_b2b` (`NUMBER`, required) — Child ASIN share of the account's daily B2B mobile app sessions as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic mobileAppSessionPercentageB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_page_views_percentage` (`NUMBER`, required) — Child ASIN share of the account's daily browser page views as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic browserPageViewsPercentage. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_browser_page_views_percentage_b2b` (`NUMBER`, required) — Child ASIN share of the account's daily B2B browser page views as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic browserPageViewsPercentageB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_mobile_page_views_percentage` (`NUMBER`, required) — Child ASIN share of the account's daily mobile app page views as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic mobileAppPageViewsPercentage. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_mobile_page_views_percentage_b2b` (`NUMBER`, required) — Child ASIN share of the account's daily B2B mobile app page views as a percentage (0-100) summed across child ASIN rows for the day, from Amazon Sales and Traffic mobileAppPageViewsPercentageB2B. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_unit_session_percentage` (`NUMBER`, required) — Units ordered as a percentage of sessions across child ASIN rows for the day, the per-ASIN unitSessionPercentage weighted by sessions. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `asin_unit_session_percentage_b2b` (`NUMBER`, required) — B2B units ordered as a percentage of B2B sessions across child ASIN rows for the day, the per-ASIN unitSessionPercentageB2B weighted by B2B sessions. From Amazon Sales and Traffic (Data Kiosk). Data may be delayed by up to 3 days and may remain incomplete or be revised for up to 30 days after the row date due to Amazon reporting limitations.
- `profit` (`NUMBER`, required) — Net profit after subtracting sales_tax once. refund_cost is signed: cash outflows are negative and fee reversals are positive. Refunded tax is excluded. — definition: `amazon_profit_by_date.total_sales - amazon_profit_by_date.sales_tax - amazon_profit_by_date.total_fees - amazon_profit_by_date.cogs_total - amazon_profit_by_date.ad_spend + amazon_profit_by_date.refund_cost`
- `total_cost` (`NUMBER`, required) — Sales tax included in prices, fees, COGS and ad spend, minus signed refund_cost. — definition: `amazon_profit_by_date.sales_tax + amazon_profit_by_date.total_fees + amazon_profit_by_date.cogs_total + amazon_profit_by_date.ad_spend - amazon_profit_by_date.refund_cost`
- `acos` (`NUMBER`, required) — Advertising Cost of Sales as a percentage. — definition: `amazon_profit_by_date.ad_sales === 0 ? null : amazon_profit_by_date.ad_spend / amazon_profit_by_date.ad_sales * 100`
- `tacos` (`NUMBER`, required) — Total Advertising Cost of Sales as a percentage. — definition: `amazon_profit_by_date.total_sales === 0 ? null : amazon_profit_by_date.ad_spend / amazon_profit_by_date.total_sales * 100`
- `roi` (`NUMBER`, required) — Return on Investment as a percentage. — definition: `amazon_profit_by_date.total_cost === 0 ? null : amazon_profit_by_date.profit / amazon_profit_by_date.total_cost * 100`

---

Query live via DataDoe MCP `exports_source_get` (connected accounts only), or request rows with `exports_create`.