Adding an Amazon Product Expense as a Source will make daily unit expenses available on your managed database. It will also add product expense reporting to your profit and loss analyses.
Datasets: your product expenses (COGS) are surfaced in the following tables:
FINANCE.FINANCE_PROFIT
: Aggregated daily COGS used for overall profit calculations.FINANCE.FINANCE_PROFIT_LEDGER
: COGS represented as transactional events:
FINANCE.FINANCE_PROFIT_METRICS
: Used to compute profit metrics such as:
FINANCE.FINANCE_COGS
: Provides detailed daily COGS data per product/channel.FINANCE.FINANCE_COGS_SKU
: SKU-level breakdown of daily COGS for deeper product-level insights.*FINANCE.FINANCE_PROFIT_LOSS* *(Deprecated)*
: Previously used for profit/loss reporting. Superseded by the tables above.In the Dashboards:
<aside> 💡
The system always uses the most recent upload to calculate final product expenses.
To Edit Previously Uploaded Data:
<aside> ℹ️
Updates take up to 24 hours.
</aside>