Commission History

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.

Column Definitions

  • “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.