# An ENTITY topic for Amazon's FBA fee estimates (one row per SKU per Amazon store per snapshot # day). Charged fees are in ut_amzn_settlements. Amazon rows live in the connector store, not the # DuckDB mirror, so this topic has no `store:` block and no validated measure yet. key: amazon_fees semantic: approved: [_snapshot_date, sku, asin, amazon_store, your_price, estimated_fee_total, estimated_referral_fee_per_unit, expected_fulfillment_fee_per_unit, currency] date_field: _snapshot_date scope: "Amazon's estimated fees per unit for each SKU, one snapshot per sync day. Use the latest _snapshot_date for current fees. Fees Amazon charged are in Amazon settlements." measure_not_yet: - key: estimated_fee_total cause: "Amazon fee estimates live in the connector store, not the semantic mirror, and no metric reconciles them yet." fix: "Add a fee metric in model/metrics with a validate method that ties the stored rows to the report row count, and register its validator in harness/semantic.py." purposes: _snapshot_date: "The sync day of the estimate. Use the latest one for current fees." estimated_fee_total: "Amazon's estimated total fee per unit." estimated_referral_fee_per_unit: "Amazon's estimated referral fee per unit." expected_fulfillment_fee_per_unit: "Amazon's expected FBA fulfillment fee per unit." synonyms: estimated_fee_total: [total fee, Amazon fee, fees] estimated_referral_fee_per_unit: [referral fee, commission] expected_fulfillment_fee_per_unit: [FBA fee, fulfillment fee, pick and pack fee] sku: [seller sku] choices: {} label: "Amazon FBA fee estimates" entity: amazon.fba_fee_estimate grid: ut_amzn_fba_fee_estimates subject: "amazon:fba_fee_estimate" grain: "one row per SKU per Amazon store per snapshot day" fields: - key: _snapshot_date label: "Snapshot date" type: date kind: data - key: sku label: "Sku" type: text kind: data - key: asin label: "Asin" type: text kind: data - key: amazon_store label: "Amazon store" type: text kind: data - key: your_price label: "Your price" type: currency kind: data - key: estimated_fee_total label: "Estimated fee total" type: currency kind: data - key: estimated_referral_fee_per_unit label: "Estimated referral fee per unit" type: currency kind: data - key: expected_fulfillment_fee_per_unit label: "Expected fulfillment fee per unit" type: currency kind: data - key: currency label: "Currency" type: text kind: data ai_context: > Amazon's estimated fees per unit by SKU. Use the latest _snapshot_date. These are estimates, not charges: for fees Amazon charged, use Amazon settlements and sum the negative amount lines.