DataHawk provides a reporting of financial activity on Amazon Seller accounts. This article details the data sources used to provide holistic reports and the data models that deliver them.
The profit (& loss) data is built from several data sources. It first comes up as an events ledger.
The majority of records in the Seller Profit Ledger are financial events sourced from the Amazon Finance API. This includes all transactions made on an Amazon Seller Account. Some events like account-level advertising costs and storage fees, are replaced by more detailed events sourced from enrichment reports.
Financial events are complete with a 2 year history up to T-2d from today.
There are particular financial events that lack richness in accompanying information. These enrichment reports are used to replace these events, providing additional relevant information at no loss.
Advertising cost events are replaced with events sourced from Advertising Reports to provide sponsored type and ASIN annotation on otherwise account-level events.
Advertising events are complete with a 2 year history up to T-2d from today.
Removal and disposal fee events are replaced with events sourced from this report to provide ASIN and SKU annotation on otherwise account-level events.
FBA reports are produced by Amazon once a month. Events can take up to one month to be present in the dataset.
Storage Fee events are replaced with events sourced from this report to provide ASIN annotation on an otherwise account-level event.
FBA reports are produced by Amazon once a month. Events can take up to one month to be present in the dataset.