Know which tables and fields are available to query Marketing Cloud tracking data with SQL, and which objects the Marketing Cloud connector creates in Salesforce Service Cloud.

Lists the standard Marketing Cloud tables (subscribers, bounces, clicks, opens, complaints, journeys) and the et4ae5__ data model installed by the connector, with links to the official documentation.

Walkthrough

Standard tables

_Subscribers: SubscriberID, SubscriberKey, EmailAddress, Status, SubscriberType, DateJoined, DateUndeliverable, DateUnsubscribed (https://help.salesforce.com/s/articleView?id=sf.mc_as_data_view_subscribers.htm&type=5)
_bounce
_Click: SubscriberID, JobID, EventDate, URL, LinkName (https://help.salesforce.com/s/articleView?id=sf.mc_as_data_view_click.htm&type=5)
_Open
_Complaint
_Journey

Salesforce Service data model with connector

In Salesforce Service Cloud, the connector creates the following data model:

et4ae5__abTest__c
et4ae5__AggregateLink__c
et4ae5__Automated_Send__c
et4ae5__Business_Unit__c
et4ae5__Campaign_Member_Configuration__c
et4ae5__Configuration__c
et4ae5__Email_Linkage__c
et4ae5__IndividualEmailResult__c: et4ae5__Contact__c, et4ae5__SendDefinition__c, et4ae5__TriggeredSendDefinition__c, et4ae5__DateSent__c, et4ae5__DateOpened__c, et4ae5__Opened__c, et4ae5__NumberOfUniqueClicks__c, et4ae5__Clicked__c, et4ae5__DateBounced__c, et4ae5__DateUnsubscribed__c
et4ae5__IndividualLink__c
et4ae5__Journey__c
et4ae5__MC_CDC_Journey__c
et4ae5__SendDefinition__c
et4ae5__SendJunction__c
et4ae5__SMSDefinition__c
et4ae5__SMSJunction__c
et4ae5__SupportRequest__c
et4ae5__Triggered_Send_Execution__c
et4ae5__UEBU__c

Going further