Commission Junction

Commission Junction ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Commission Junction Access Token Commission Junction CID Commission Junction ISO Country Code
Replication Type	Key based Replication
Replication Key	NA LastRun
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Publishers	Details
Accounts	Product_Feeds
Product_Subscriptions

Integrate Commission Junction with Daton

1. Signin to Daton

2. Select Impact from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your Commission Junction Access Token, CID and ISO Country code. Click here to learn more about Commission Junction Access Token

5. After providing the details to authorize Daton to periodically extract data from Inventory Planner.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Commission Junction Data

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

Fields

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

Fields

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

Fields

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

Fields

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

Fields

fullname	type
id	STRING
adId	STRING
description	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC