Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Add Client ID to Salesforce Marketing Cloud Connector

Answered
Randall Mathews User

The client ID is available in sales force but is not pulled by the fivetran salesforce marketing cloud connector. 

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Randall,

    Luke from the Product team here. Thanks for submitting this feature request.

    I followed up with you by email to learn more about your use case for this field. We've considered adding this field before but noticed it is always the same value in the SEND table for a business unit. It didn't seem to be useful, so we left it out.

    If you prefer to respond here that works too. 

    Thanks!
    Luke

     

  • Abdul Ghaffar Fivetranner

    Hi Randall, Abdul from the Product team here. 

    We looked into this request, and Client ID is already being synced through both the ACCOUNT_HISTORY and BUSINESS_UNIT_HISTORY tables. On BUSINESS_UNIT_HISTORY, the id column represents the Client ID. You can join either table to your other SFMC tables to associate Client ID with individual records.

    One note: the connector syncs the business unit tied to your credentials, so the Client ID reflects that one. For data across multiple business units, you'd need a separate connection for each.

    Let us know if you have any questions.