The Commissions History report provides a ledger of all transactions reported to Wildfire by merchants. The report is as real-time as possible; as soon as a transaction is reported to Wildfire, it appears in the Commissions History report. Note that some merchants (for example, Walmart) have a nightly batch reporting process. Most merchants report new sales on an hourly basis.
- “ID” is the unique row identifier for the transaction. Note that a single order may contain several transactions in it. The Commission History report provides transaction records, not order records, to give the greatest amount of granularity.
- “Event Date” is the date of the actual transaction as reported by the merchant. We normalize for timezone to report these in Pacific Time.
- “Modified Date” is the last time a record was changed. This usually represents a change in status (i.e., a transaction moving from Pending to Confirmed after we receive payment from the merchant partner).
- “Created Date” is the date when our system ingested the transaction. The delay between the Event Date and the Created Date represents the lag in reporting by the merchant.
- “Status” indicates where the transaction is in the overall payment lifecycle. Eligible transactions move from “Pending” to “Ready” to “Paid”. “Disqualified” is the other possible status.
- “Pending” is the default state of a new transaction that is expected to earn a commission amount (not disqualified).
- “Ready” indicates that the merchant has paid us for the commission and the payment is just awaiting the next payment cycle (at the beginning of each month).
- “Paid” indicates that the record has been paid, and the transaction should be included in the relevant payment report.
- “Disqualified” indicates that the transaction was not eligible for earning. Some merchants don't report these records. Others (like Ticketmaster) report these records. An example of a “Disqualified” sale is a pre-sale ticket.
- “Order ID” is either the order identifier provided by the merchant or the affiliate network (depending on the affiliate networks).
- “SKU” is the item identified in the order and is not always available (depends on the merchant and network). Note that if a single order contains multiple items of the same SKU these are almost always reported as a single transaction.