Schema Information for Commission Junction
Schema Information for Commission Junction
In this article, we will look at the essential attributes and tables supported by Commission Junction.
Find the links to other articles related to Commission Junction below:
- Essential Attributes and Supported Table for Commission Junction
- Setup Instructions for Commission Junction
Tables/APIs
The tables and APIs associated with the Commission Junction connector are as follows.
Publishers
Purpose: Retrieve list of all publishers
Source API Documentation: https://developers.cj.com/docs/rest-apis/publisher-lookup
Replication: Key-Based Replication
Replication Key: NA
Fullname |
Type |
|---|---|
cid |
STRING |
country |
STRING |
currency |
STRING |
networkrating |
STRING |
publishername |
STRING |
programterms |
RECORD |
promotionalmethods |
RECORD |
sevendayepc |
STRING |
threemonthepc |
STRING |
websites |
RECORD |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
websites_st |
STRING |
websites_st_1 |
STRING |
networkrating_1 |
STRING |
programterms_1 |
RECORD |
promotionalmethods_1 |
RECORD |
publishername_1 |
STRING |
sevendayepc_1 |
STRING |
threemonthepc_1 |
STRING |
programterms.name |
STRING |
programterms.dateaccepted |
STRING |
programterms.dateexpired |
STRING |
programterms.joinstatus |
STRING |
promotionalmethods.promotionalmethod |
STRING |
websites.website |
RECORD |
websites.website.name |
STRING |
websites.website.pid |
STRING |
websites.website.url |
STRING |
websites.website.category |
STRING |
programterms_1.name |
STRING |
programterms_1.dateaccepted |
STRING |
programterms_1.dateexpired |
STRING |
programterms_1.joinstatus |
STRING |
promotionalmethods_1.promotionalmethod |
STRING |
Commission Details
Purpose: Retrieve real-time commission data
Source API Documentation: https://developers.cj.com/docs/rest-apis/commission-detail-(legacy)
Replication: Key-Based Replication
Replication Key: NA
Fullname |
Type |
|---|---|
actionstatus |
STRING |
actiontype |
STRING |
aid |
INTEGER |
commissionid |
NUMERIC |
country |
STRING |
eventdate |
STRING |
lockingdate |
DATE |
orderid |
INTEGER |
original |
BOOLEAN |
originalactionid |
NUMERIC |
postingdate |
STRING |
websiteid |
INTEGER |
actiontrackerid |
INTEGER |
actiontrackername |
STRING |
cid |
INTEGER |
publishername |
STRING |
commissionamount |
NUMERIC |
orderdiscount |
INTEGER |
saleamount |
INTEGER |
iscrossdevice |
BOOLEAN |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
aid_st |
STRING |
commissionid_st |
STRING |
orderid_st |
STRING |
original_st |
STRING |
originalactionid_st |
STRING |
websiteid_st |
STRING |
actiontrackerid_st |
STRING |
cid_st |
STRING |
commissionamount_st |
STRING |
orderdiscount_st |
STRING |
saleamount_st |
STRING |
iscrossdevice_st |
STRING |
aid_st_1 |
STRING |
commissionid_st_1 |
STRING |
orderid_st_1 |
STRING |
original_st_1 |
STRING |
originalactionid_st_1 |
STRING |
websiteid_st_1 |
STRING |
actiontrackerid_st_1 |
STRING |
cid_st_1 |
STRING |
commissionamount_st_1 |
STRING |
orderdiscount_st_1 |
STRING |
saleamount_st_1 |
STRING |
iscrossdevice_st_1 |
STRING |
commissionid_1 |
STRING |
lockingdate_1 |
DATE |
orderid_1 |
STRING |
originalactionid_1 |
STRING |
websiteid_1 |
STRING |
actiontrackerid_1 |
STRING |
commissionamount_1 |
STRING |
orderdiscount_1 |
STRING |
saleamount_1 |
STRING |
iscrossdevice_1 |
STRING |
aid_st_1_1 |
STRING |
commissionid_st_1_1 |
STRING |
orderid_st_1_1 |
STRING |
original_st_1_1 |
STRING |
originalactionid_st_1_1 |
STRING |
websiteid_st_1_1 |
STRING |
actiontrackerid_st_1_1 |
STRING |
cid_st_1_1 |
STRING |
commissionamount_st_1_1 |
STRING |
orderdiscount_st_1_1 |
STRING |
saleamount_st_1_1 |
STRING |
iscrossdevice_st_1_1 |
STRING |
commissionid_1_1 |
STRING |
lockingdate_1_1 |
DATE |
orderid_1_1 |
STRING |
originalactionid_1_1 |
STRING |
websiteid_1_1 |
STRING |
actiontrackerid_1_1 |
STRING |
commissionamount_1_1 |
STRING |
orderdiscount_1_1 |
STRING |
saleamount_1_1 |
STRING |
iscrossdevice_1_1 |
STRING |
actionstatus_1 |
STRING |
actiontype_1 |
STRING |
eventdate_1 |
STRING |
postingdate_1 |
STRING |
actiontrackername_1 |
STRING |
publishername_1 |
STRING |
Promotional Properties
Purpose: Retrieve all publishers promotional properties
Source API Documentation:https://developers.cj.com/graphql/reference/Promotional%20Properties
Replication: Key-Based Replication
Replication Key: NA
Fullname |
Type |
|---|---|
id |
STRING |
publisherId |
STRING |
name |
STRING |
description |
STRING |
status |
STRING |
isPrimary |
BOOLEAN |
createdAt |
TIMESTAMP |
updatedAt |
TIMESTAMP |
propertyTypeDetails |
RECORD |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
tags |
RECORD |
promotionalModels |
RECORD |
propertyTypeDetails.type |
STRING |
propertyTypeDetails.websiteUrl |
STRING |
propertyTypeDetails.browserExtensionDownloadInformation |
RECORD |
propertyTypeDetails.browserExtensionDownloadInformation.browserExtensionBrowser |
STRING |
propertyTypeDetails.browserExtensionDownloadInformation.browserExtensionDownloadLink |
STRING |
propertyTypeDetails.browserExtensionName |
STRING |
propertyTypeDetails.browserExtensionDescription |
STRING |
propertyTypeDetails.mobileAppDownloadInformation |
RECORD |
propertyTypeDetails.mobileAppDownloadInformation.mobileAppPlatform |
STRING |
propertyTypeDetails.mobileAppDownloadInformation.mobileAppDownloadLink |
STRING |
propertyTypeDetails.mobileAppName |
STRING |
propertyTypeDetails.paidSearchEngineDescription |
STRING |
propertyTypeDetails.socialMediaHandle |
STRING |
propertyTypeDetails.socialMediaPlatform |
STRING |
propertyTypeDetails.paidDisplayAdsDescription |
STRING |
propertyTypeDetails.otherDescription |
STRING |
propertyTypeDetails.servicesAndToolsMarketingSiteUrl |
STRING |
propertyTypeDetails.emailAddress |
STRING |
propertyTypeDetails.emailOpenRate |
STRING |
propertyTypeDetails.emailMailingListSize |
STRING |
tags.name |
STRING |
promotionalModels.type |
STRING |
promotionalModels.isPrimary |
BOOLEAN |
promotionalModels.description |
STRING |
Product_Feeds
Purpose: Retrieve product feed summary
Source API Documentation:https://developers.cj.com/graphql/reference/Promotional%20Properties
Replication: Key-Based Replication
Replication Key: NA
Fullname |
Type |
|---|---|
sourceFeedType |
STRING |
productCount |
NUMERIC |
advertiserCountry |
STRING |
lastUpdated |
TIMESTAMP |
advertiserName |
STRING |
language |
STRING |
currency |
STRING |
feedName |
STRING |
adId |
STRING |
advertiserId |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Product_Subscription
Purpose: Retrieve product feed summary
Source API Documentation:https://developers.cj.com/graphql/reference/Promotional%20Properties
Replication: Key-Based Replication
Replication Key: NA
Fullname |
Type |
|---|---|
id |
STRING |
adId |
STRING |
description |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |