Commission History

overview wildfire's partner admin tools include information and reporting about transactions this article outlines all of the available data for each transaction the commission 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 commission history report note that some merchants (for example, walmart) have a nightly batch reporting process most merchants report new sales on an hourly basis below are the columns in the commission history page note you can use the edit columns feature to select the columns you want to show or hide column definitions id the unique row identifier for the commission note that a single order may contain several commissions in it some merchants provide order level commissions only (i e one record with all skus/line items combined) though most provide order item level commissions (i e separate records with a common order id) event date the date of the actual commission as reported by the merchant modified date the last time a record was changed this usually represents a change in status (i e , a commission moving from pending to confirmed after we receive payment from the merchant partner) created date the date when our system ingested the commission the delay between the event date and the created date represents the lag in reporting by the merchant merchant name the name of the online store where the commission occurred sale amount the total amount of the sale represented in the application's currency commission depending on who pays the user there could be partner commission and user commission if partner pays the user, there will be only one column partner commission this is the total of the partner's and user's share of earnings from the commission, as reported by the merchant, minus wildfire's share in certain cases where wildfire pays the user, there will be two columns partner commission this will be the partner's share of earnings, as reported by the merchant, minus wildfire's share plus user's share user commission this will be the user's share of earnings, as reported by the merchant, minus both wildfire's share and partner's share device id the device reference that generated the commission read more about device ids here https //documenter getpostman com/view/24961/rwgqvyv2#d96bcd5d cad0 4e72 af91 9b00afceacc3 status indicates where the commission is in the overall payment lifecycle eligible commissions move from “pending” to “ready” to “paid” by default list of all statuses “pending” is the default state of a new commission that is expected to earn a commission amount (i e not disqualified) “confirmed” indicates that the merchant has locked the commission and has committed to making a payment for that individual earning though this signal indicates a commitment from the merchant, it should be viewed the same as the pending status from a risk perspective as no money has changed hands (i e the merchant has not paid the network) note confirmed status was added in v4 of commission records “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 to the partner (and the user, if wildfire pays users on behalf of the partner), and the commission should be included in the relevant payment report order id the order identifier provided by the merchant or the affiliate network (depending on the affiliate networks) orders can have multiple commissions with each record representing an individual item within an order sku 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 commission tracking code read about tracking codes (tc parameters) here tracking code (tc) parameter docid\ pl3 phzaubmp4kwtmqukx basecommissionamount the amount earned by the user prior to boosts, if applicable if the earning was not subject to a boosted offer, this will match amount in this same map boostedcommissionamount the amount that a commission was boosted if a boosted offer was active with the application and merchant at the time of purchase if no boosted offer campaign was active, this will be 0 devicexid identifier registered to the device used by the end user, in most cases this id is also used as the tracking code value on affiliate links this value allows you to match a device to a user instead of just a commission to a user couponcodes merchant reported code or codes applied by a user at time of purchase these values may or may not be valid coupon codes and may include both couponator tested codes as well as codes input by end users at time of purchase shoppingtripcode an identifier representing a single shopping session this value is created and managed by wildfire developed extensions commission search t he following fields can be searched (either substring or exact match) matching is not case sensitive commission id event date to search for a commission record in a given range or particular date, use the date picker on the top merchant id merchant name device id order id sku tracking code shopping trip code device xid coupon codes note though substring match is supported, our search method needs a "complete" substring to match for example, a search for "wal" will not return walmart or walgreens however, a search for "green" will return "green chef" and "green man gaming " export you can export the matching records from commission history this will download a csv format of the matching commission records and depending on the size of the export, you'll experience one of the following the export size is small enough to be downloaded immediately the export size is large enough that it requires separate processing and will be available for download later for the second case, where separate processing is required, you will be prompted to visit the commission history downloads page where you can check the status of your request and, once complete, download the file there are three states described in the commission history downloads pending your job is waiting to be processed and there are other jobs ahead of it processing your job is actively being worked on finalized your job is complete and ready to be downloaded note the jobs listed on the commission history download page are only your jobs and other users cannot see them note the time that it takes for your export job to complete is based on the number and size of all other requests in the system generally, exports should be available no later than a few hours after they are requested note any downloads produced into commission history downloads expire after 48 hours from when they were initially requested