Profitability review
get_profitability_reviewReturns ranked ASIN profitability issue signals from Shipment/Refund financial-event net, FBA reimbursements, returns, Business Reports sales and units, and SP/SD product ad spend. Financial-event revenue, fees, tax, and marketplace net are selected by posted_date, not order date; Business Reports use their order-date basis, while ads, returns, and reimbursements use their own source dates. The same requested window can therefore contain different transaction cohorts near its cutoffs and must not be treated as one order-date cohort without accounting for posting lag. Account-level Adjustment/ServiceFee financial events are excluded because they cannot be deterministically attributed to an ASIN. Fees on off-Amazon fulfillment (MCF) orders, which carry no Principal, are excluded from fees, net, and contribution and returned in off_amazon_fulfillment_fees; prior_period_order_share reports how much posted principal came from orders placed before the period. Set include_sponsored_brands=true to return exact SB campaign spend once in summary.account_level_costs as an unallocated account-level cost. It is not allocated to, deducted from, or repeated across ASIN rows. Responses expose date_basis, scope, excluded_costs, and reconciliation_note. DSP ad spend, FBA storage fees, inbound freight, COGS, and account-level Adjustment/ServiceFee events remain excluded. Money is scoped to the marketplace currency by default; set include_all_currencies=true to include mixed currencies. A data gap reports when Refund financial events are absent in the period.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sku | No | Filter by SKU. | |
| asin | No | Filter by ASIN. | |
| limit | No | Max review rows to return. | |
| end_date | No | Optional. YYYY-MM-DD end date applied independently to each source date. Defaults to today in the marketplace reporting time zone. | |
| start_date | No | Optional. YYYY-MM-DD start date applied independently to each source date. Defaults to 30 days ago. | |
| high_fee_pct | No | Amazon fees above this percent of gross revenue are flagged as fee_pressure. | |
| review_focus | No | Profitability issue to focus on. Defaults to all non-healthy issues. | all |
| high_tacos_pct | No | SP/SD ad spend above this percent of sales is flagged as ad_drag. | |
| include_healthy | No | Set true to include healthy ASINs after profitability issues. Defaults to false. | |
| include_raw_rows | No | False returns compact rows. Default true. | |
| target_margin_pct | No | Contribution margin below this percent is flagged as low_margin. | |
| include_diagnostics | No | True may add expanded freshness diagnostics. Basic empty-result data-window diagnostics are included by default when available. | |
| high_return_rate_pct | No | Returned units above this percent of units ordered are flagged as high_return_rate. | |
| include_all_currencies | No | By default, money (financial events, reimbursements, ad spend) is scoped to the marketplace currency so amounts are not summed across USD/CAD/MXN etc. Set true to include all currencies (amounts are then mixed and should not be summed). | |
| include_sponsored_brands | No | Return exact Sponsored Brands campaign spend once as an unallocated account-level cost. It is not allocated to ASIN rows or included in their contribution, TACOS, ACOS, or ranking metrics. Defaults to false. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| evidence | No |