account_id | TEXT | Account ID | Same as advertiserId |
account_name | TEXT | Account Name | Same as advertiserName |
action_status | TEXT | Action Status | Status of the commission. Possible values: closed, extended, locked, new. |
action_tracker_id | TEXT | Action Tracker Id | Unique identifier of an advertiser’s defined action associated with the commission |
action_tracker_name | TEXT | Action Tracker Name | Name of the action (as specified by the advertiser) for that commission |
action_type | TEXT | Action Type | Action type for the commission. Possible values: bonus, click, imp, item_lead, item_sale, perf_inc, sim_lead, sim_sale. |
ad_owner | TEXT | Ad Owner | Displays the CID of the advertiser the link was clicked through (only applies to cross correlated accounts) |
adv_commission_amount_adv_currency | NUMERIC | Adv Commission Amount Adv Currency | Advertiser commission amount in advertiser's currency (Advertiser-only attribute) |
adv_commission_amount_usd | NUMERIC | Adv Commission Amount Usd | Advertiser commission amount in USD (Advertiser-only attribute) |
advertiser_id | TEXT | Advertiser Id | CID of the advertiser for this commission |
advertiser_name | TEXT | Advertiser Name (cj) | Name of the advertiser for this commission |
aid | TEXT | Ad Id | Ad idenification number |
cj_fee_adv_currency | NUMERIC | CJ Fee Adv Currency | CJ fee in the advertiser's currency (Advertiser-only attribute) |
cj_fee_usd | NUMERIC | CJ Fee Usd | CJ fee in USD (Advertiser-only attribute) |
click_date | DATE | Click Date | Click date for the commission |
click_referring_url | TEXT | Click Referring Url | Click referring URL for the commission |
commission_id | TEXT | Commission Id | Commission identification number |
concluding_browser | TEXT | Concluding Browser | The associated browser that the transaction concluded in. |
concluding_device_name | TEXT | Concluding Device Name | The associated device name that the transaction concluded in. |
concluding_device_type | TEXT | Concluding Device Type | The associated device type that the transaction concluded in. |
correction_reason | TEXT | Correction Reason | If this is not an original transaction, the reason the transaction was corrected will be returned. Possible values: INVALID_CREDIT_CARD, RETURNED_MERCHANDISE, DUPLICATED_ORDER, CANT_SHIP_OR_SOLD_OUT, UNQUALIFIED_LEAD, QUALIFIED_LEAD, OTHER_REASON |
country | COUNTRY | Country | Country where the transaction occurred |
coupon | TEXT | Coupon | The coupon/voucher code used in the transaction |
date | DATE | Date | Event date for the commission in UTC time zone (YYYY-MM-DD format) |
event_date | DATE | Event Date | Event date for the commission in UTC time zone |
initiating_browser | TEXT | Initiating Browser | The associated browser that the transaction initiated in. |
initiating_device_name | TEXT | Initiating Device Name | The associated device name that the transaction initiated in. |
initiating_device_type | TEXT | Initiating Device Type | The associated device type that the transaction initiated in. |
is_cross_device | BOOLEAN | Is Cross Device | Indicates if a transaction was attributed using cross-device tracking with ‘true’ or ‘false’ |
locking_date | DATE | Locking Date | Date on which the commission is locked for extending or correcting |
locking_method | TEXT | Locking Method | The locking method for the commission based on program terms. Possible values: IMMEDIATE, FIXED_DATE, OPEN_ENDED, FIXED_DURATION |
new_to_file | BOOLEAN | New To File | Advertiser defined, indicates if the customer is new or existing to the advertiser (Advertiser only attribute) |
order_discount_adv_currency | NUMERIC | Order Discount Adv Currency | Discount associated with the order in the advertiser's currency |
order_discount_orig_currency | NUMERIC | Order Discount Orig Currency | Discount associated with the order in original currency |
order_discount_pub_currency | NUMERIC | Order Discount Pub Currency | Discount associated with the order in the publisher's currency |
order_discount_usd | NUMERIC | Order Discount Usd | Discount associated with the order in USD |
order_id | TEXT | Order Id | Advertiser-assigned identification number for the order |
original | BOOLEAN | Original | Displays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction |
original_action_id | TEXT | Original Action Id | Identification number used for correlation between the original transaction and corrected transaction |
posting_date | DATE | Posting Date | Date on which the commission is posted |
pub_commission_amount_pub_currency | NUMERIC | Pub Commission Amount Pub Currency | Publisher commission amount in publisher's currency |
pub_commission_amount_usd | NUMERIC | Pub Commission Amount Usd | Publisher commission amount in USD |
publisher_id | TEXT | Publisher Id | CID of the publisher for this commission |
publisher_name | TEXT | Publisher Name (cj) | Name of the publisher for this commission |
reviewed_status | TEXT | Reviewed Status | Indicates if an advertiser has reviewed a transaction. |
sale_amount_adv_currency | NUMERIC | Sale Amount Adv Currency | Sale amount in advertiser's currency |
sale_amount_pub_currency | NUMERIC | Sale Amount Pub Currency | Sale amount in publisher's currency |
sale_amount_usd | NUMERIC | Sale Amount Usd | Sale amount in USD |
site_to_store_offer | TEXT | Site To Store Offer | Displays coupon code used, indicates it was a site to store offer transaction |
source | TEXT | Source | Source for the transaction |
validation_status | TEXT | Validation Status | The commission's validation status. Possible values: PENDING, ACCEPTED, DECLINED, AUTOMATED |
vertical_attributes | TEXT | Vertical Attributes | Advertiser-supplied vertical attributes |
website_id | TEXT | Website Id | Publisher website identification number |
website_name | TEXT | Website Name | Publisher website name |