Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Schema Information for Commission Junction

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      Need help with something?

      Talk to data expert

      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

       

       

      metadata data structure

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Schema Information for Pinterest

      Table of Contents

      Tables/APIs Publishers Commission Details Promotional Properties Product_Feeds Product_Subscription

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand