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

      • Saras IQ

        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