Ctrlk
For the complete documentation index, see llms.txt. This page is also available as Markdown.

CJ Affiliate - Supported Columns

Every column the CJ Affiliate connector can download.

These are the columns available to a CJ Affiliate connector. The recommended template uses a small subset, listed on the CJ Affiliate page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates.

Dimensions

Column
Type

payloadComplete

Boolean

actionStatus

String

actionTrackerId

String

actionTrackerName

String

actionType

String

adOwner

String

advertiserId

String

advertiserName

String

aid

String

clickDate

DateTime

clickReferringURL

String

commissionId

String

concludingBrowser

String

concludingDeviceName

String

concludingDeviceType

String

correctionReason

String

country

String

coupon

String

eventDate

DateTime

initiatingBrowser

String

initiatingDeviceName

String

initiatingDeviceType

String

isCrossDevice

Boolean

lockingDate

DateTime

lockingMethod

String

newToFile

Boolean

orderId

String

original

Boolean

originalActionId

String

postingDate

DateTime

publisherId

String

publisherName

String

reviewedStatus

String

shopperId

String

siteToStoreOffer

String

source

String

validationStatus

String

websiteId

String

websiteName

String

Record_SituationDetail_id

String

Record_SituationDetail_name

String

commissionItemId

String

itemListId

String

sku

String

Record_Item_SituationDetail_id

String

Record_Item_SituationDetail_name

String

ancillarySpend

String

annualFee

String

applicationStatus

String

apr

String

aprTransfe

String

aprTransferTime

String

bookingDate

DateTime

bookingStatus

String

bookingValuePostTax

String

bookingValuePreTax

String

brand

String

brandId

String

businessUnit

String

campaignId

String

campaignName

String

carOptions

String

cardCategory

String

cashAdvanceFee

String

category

String

city

String

class

String

confirmationNumber

String

contractLength

String

contractType

String

countryCode

String

couponDiscount

String

couponType

String

creditLine

String

creditQuality

String

creditReport

String

cruiseType

String

custCountry

String

custSegment

String

custStatus

String

custType

String

customerLocation

String

delivery

String

description

String

destCity

String

destCountry

String

destState

String

destinationId

String

domestic

String

dropoffIata

String

dropoffId

String

duration

String

endDateTime

String

flightFareType

String

flightOptions

String

flightType

String

flyerMiles

String

fundedAmount

String

fundedCurrency

String

genre

String

guests

String

iata

String

introductoryApr

String

introductoryAprTime

String

itemId

String

itemName

String

itemType

String

itineraryId

String

lifestage

String

location

String

loyaltyEarned

String

loyaltyFirstTimeSignup

String

loyaltyLevel

String

loyaltyRedeemed

String

loyaltyStatus

String

margin

String

marketingChannel

String

minBalance

String

minDeposit

String

minStayDuration

String

noCancellation

String

orCity

String

orCountry

String

orState

String

paidAtBookingPostTax

String

paidAtBookingPreTax

String

paymentMethod

String

paymentModel

String

pickupIata

String

pickupId

String

platformId

String

pointOfSale

String

port

String

preorder

String

prepaid

String

prequalify

String

promotion

String

promotionAmount

String

promotionConditionThreshold

String

promotionConditionType

String

promotionEnds

DateTime

promotionStarts

DateTime

promotionType

String

verticalAttributes_quantity

String

rating

String

roomType

String

rooms

String

serviceType

String

shipName

String

startDateTime

String

state

String

subscriptionFee

String

subscriptionLength

String

taxAmount

String

taxType

String

transferFee

String

travelType

String

tripType

String

upsell

String

Metrics

Column
Type

count

Int

advCommissionAmountAdvCurrency

Decimal

advCommissionAmountUsd

Decimal

cjFeeAdvCurrency

Decimal

cjFeeUsd

Decimal

orderDiscountAdvCurrency

Decimal

orderDiscountOrigCurrency

Decimal

orderDiscountPubCurrency

Decimal

orderDiscountUsd

Decimal

pubCommissionAmountPubCurrency

Decimal

pubCommissionAmountUsd

Decimal

saleAmountAdvCurrency

Decimal

saleAmountPubCurrency

Decimal

saleAmountUsd

Decimal

discountAdvCurrency

Decimal

discountPubCurrency

Decimal

discountUsd

Decimal

perItemSaleAmountAdvCurrency

Decimal

perItemSaleAmountPubCurrency

Decimal

perItemSaleAmountUsd

Decimal

quantity

Int

totalCommissionAdvCurrency

Decimal

totalCommissionPubCurrency

Decimal

totalCommissionUsd

Decimal

PreviousCJ Affiliate - Parameters
NextCompari

Was this helpful?