> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/cj-affiliate/cj-affiliate-supported-columns.md).

# 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](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/cj-affiliate.md) 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 |