Connect CJ Affiliate to Looker Studio

Directly connect CJ Affiliate to Looker Studio, in minutes, and in an easy-to-use format

cj affiliate google data studio integration

About the CJ Affiliate Google Data Studio Connector

The CJ Affiliate Google Data Studio Connector pulls Metrics and Dimensions for CJ Affiliate. The Insights are retrieved at the campaign level.

Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

Prerequisites

To set up the connector, the user should have:

How to connect Dragon Metrics to Looker Studio?

Do you plan to connect and visualize your CJ Affiliate in Google Data Studio? Follow the Tutorial Below:

Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend.select fields on the right

Go to “Select Destination” and choose Google Data Studio.

Once done, select “connect” and authorize access to your data source.

cj affiliate looker studio integration

Start Free Trial

CJ Affiliate metrics & dimensions available for streaming into Looker Studio

nametypedescription
Account IDTEXTSame as advertiserId
Account NameTEXTSame as advertiserName
Action StatusTEXTStatus of the commission. Possible values: closed, extended, locked, new.
Action Tracker IdTEXTUnique identifier of an advertiser’s defined action associated with the commission
Action Tracker NameTEXTName of the action (as specified by the advertiser) for that commission
Action TypeTEXTAction type for the commission. Possible values: bonus, click, imp, item_lead, item_sale, perf_inc, sim_lead, sim_sale.
Ad OwnerTEXTDisplays the CID of the advertiser the link was clicked through (only applies to cross correlated accounts)
Adv Commission Amount Adv CurrencyNUMERICAdvertiser commission amount in advertiser's currency (Advertiser-only attribute)
Adv Commission Amount UsdNUMERICAdvertiser commission amount in USD (Advertiser-only attribute)
Advertiser IdTEXTCID of the advertiser for this commission
Advertiser Name (cj)TEXTName of the advertiser for this commission
Ad IdTEXTAd idenification number
CJ Fee Adv CurrencyNUMERICCJ fee in the advertiser's currency (Advertiser-only attribute)
CJ Fee UsdNUMERICCJ fee in USD (Advertiser-only attribute)
Click DateDATEClick date for the commission
Click Referring UrlTEXTClick referring URL for the commission
Commission IdTEXTCommission identification number
Concluding BrowserTEXTThe associated browser that the transaction concluded in.
Concluding Device NameTEXTThe associated device name that the transaction concluded in.
Concluding Device TypeTEXTThe associated device type that the transaction concluded in.
Correction ReasonTEXTIf 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
CountryCOUNTRYCountry where the transaction occurred
CouponTEXTThe coupon/voucher code used in the transaction
DateDATEEvent date for the commission in UTC time zone (YYYY-MM-DD format)
Event DateDATEEvent date for the commission in UTC time zone
Initiating BrowserTEXTThe associated browser that the transaction initiated in.
Initiating Device NameTEXTThe associated device name that the transaction initiated in.
Initiating Device TypeTEXTThe associated device type that the transaction initiated in.
Is Cross DeviceBOOLEANIndicates if a transaction was attributed using cross-device tracking with ‘true’ or ‘false’
Locking DateDATEDate on which the commission is locked for extending or correcting
Locking MethodTEXTThe locking method for the commission based on program terms. Possible values: IMMEDIATE, FIXED_DATE, OPEN_ENDED, FIXED_DURATION
New To FileBOOLEANAdvertiser defined, indicates if the customer is new or existing to the advertiser (Advertiser only attribute)
Order Discount Adv CurrencyNUMERICDiscount associated with the order in the advertiser's currency
Order Discount Orig CurrencyNUMERICDiscount associated with the order in original currency
Order Discount Pub CurrencyNUMERICDiscount associated with the order in the publisher's currency
Order Discount UsdNUMERICDiscount associated with the order in USD
Order IdTEXTAdvertiser-assigned identification number for the order
OriginalBOOLEANDisplays either a '1' indicating an original transaction or a '0' indicating a non-original or corrected transaction
Original Action IdTEXTIdentification number used for correlation between the original transaction and corrected transaction
Posting DateDATEDate on which the commission is posted
Pub Commission Amount Pub CurrencyNUMERICPublisher commission amount in publisher's currency
Pub Commission Amount UsdNUMERICPublisher commission amount in USD
Publisher IdTEXTCID of the publisher for this commission
Publisher Name (cj)TEXTName of the publisher for this commission
Reviewed StatusTEXTIndicates if an advertiser has reviewed a transaction.
Sale Amount Adv CurrencyNUMERICSale amount in advertiser's currency
Sale Amount Pub CurrencyNUMERICSale amount in publisher's currency
Sale Amount UsdNUMERICSale amount in USD
Site To Store OfferTEXTDisplays coupon code used, indicates it was a site to store offer transaction
SourceTEXTSource for the transaction
Validation StatusTEXTThe commission's validation status. Possible values: PENDING, ACCEPTED, DECLINED, AUTOMATED
Vertical AttributesTEXTAdvertiser-supplied vertical attributes
Website IdTEXTPublisher website identification number
Website NameTEXTPublisher website name

Easily connect Dragon Metrics to Looker Studio

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your CJ Affiliate and Google Data Studio Integrations