CJ Affiliate Connector Reference

13 metrics57 dimensions

Fields

https://connectors.windsor.ai/cj?api_key=<APIKEY>&date_preset=last_7d&fields=date,advertiser_name,advertiser_id,website_name,website_id,adv_commission_amount_usd,adv_commission_amount_adv_currency,reviewed_status

The CJ Affiliate connector exposes 70 fields (13 metrics, 57 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

CJ Affiliate Fields

CJ Affiliate Advertiser fields

The Advertiser report of the CJ Affiliate connector includes 53 fields.

CJ Affiliate Advertiser fields (account_id to posting_date)

ID	Type	Name	Description
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	TIMESTAMP	Click Date	Click date and time 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	TIMESTAMP	Event Date	Event date and time 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	TIMESTAMP	Locking Date	Date and time 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	TIMESTAMP	Posting Date	Date and time on which the commission is posted

CJ Affiliate Advertiser fields (pub_commission_amount_pub_currency to website_name)

ID	Type	Name	Description
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
website_id	TEXT	Website Id	Publisher website identification number
website_name	TEXT	Website Name	Publisher website name

CJ Affiliate other fields

The CJ Affiliate connector has 17 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20