Salesforce Marketing Cloud

Creating the data source

Requirements

Active Salesforce Marketing Cloud (ExactTarget) account.
Access to the Installed Packages area in SFMC.
Permission to create an API Integration > Server-to-Server package.

Instructions

Go to the Salesforce Marketing Cloud login page at https://mc.exacttarget.com, enter your username and click Next.
You will be redirected to the login page for your specific account. Copy the full URL that is generated in the browser (it contains your company subdomain).
From this URL, identify your subdomain by taking the value before .login. In the example above, the subdomain is mcx1072k138f919oowzqewciw06, taken from https://mcx1072k138f919oowzqewciw06.login.exacttarget.com.
Keep this subdomain value. You will use it later when creating the Salesforce Marketing Cloud connector in Kondado.
Finish logging in and access the Salesforce Marketing Cloud interface.
Once logged in, click your user in the top-right corner and then click Setup.
In the Setup page, in the left sidebar, go to Apps > Installed Packages.
On the Installed Packages page you will see the list of connected applications. To create the integration with Kondado, click the New button in the upper-right corner.
Enter a Name and Description for the package (for example, Name: Kondado, Description: kondado.com.br) and click Save.
After creating the Installed Package, in the DETAILS tab, find the Components section and click the Add Component button.
In the first step of the popup, select API Integration and click Next.
In the next step, choose Server-to-Server and click Next.
Then select the permissions/properties for the integration with Kondado. For Data > Data Extensions, select both Read and Write, and for the other relevant categories select at least Read. After configuring permissions, click Save.
After adding the Component, copy the Client Id and Client Secret values from the DETAILS > Components > API Integration section.
In the Kondado app, go to the Add connectors page and select the Salesforce Marketing Cloud connector.
Fill in the connector fields as follows:
- Subdomain: the value identified in step (3).
- Client ID and Client Secret: the values obtained in step (14).

After configuring the connector, click SAVE and you will be ready to start integrating your Salesforce Marketing Cloud data into your Data Warehouse.

Pipelines

Relationship chart

Click to expand

Data Extension

Replication type: Incremental or Full (user configurable)

Parameters:

Data Extension: Select which data extension you would like to replicate

This pipeline can be full or incremental, and for it to be incremental, the following conditions must be met: (i) there must be a timestamp column (or Date for SFMC) that marks when the record was updated or inserted, and this column must be selected to be sent to the pipeline (if timestamp columns exist but do not behave this way, the pipeline should remain full); (ii) records must not be deleted from the table (if they are deleted, the pipeline should remain full). Once both conditions are satisfied, you can mark the pipeline as incremental in the final step of its creation and also select the incremental column. The incremental update will always read data starting from one day before the savepoint date

Data retrieved from a specific Marketing Cloud data extension.

Campo	Tipo
_kdd_rowkey	text	[en] Replication key generated for each row.
col_x	text	[en] Generic value captured from the data extension (column X).
col_y	boolean	[en] Boolean indicator returned from the data extension column Y.
col_z	timestamp	[en] Timestamp value returned from the data extension column Z.

Emails

Replication type: Incremental with update window

Parameters:

Update window (days): How many days previous to the savepoint records can still be replicated
Read start date (Savepoint): Initial date for the data replication

Relationships:

folder → Folders > id

Stored Marketing Cloud email definitions with content, folder, and status metadata.

Campo	Tipo
id	text	[en] Read-only identifier for an object. Some objects use the ObjectID property as the Marketing Cloud unique ID
status	text	[en] Defines status of object. Status of an address.
name	text	[en] Name of the object or property
customerkey	text	[en] User-supplied unique identifier for an object within an object type. This property corresponds to the external key assigned to an object in Marketing Cloud.
emailtype	text	[en] Defines preferred email type
characterset	text	[en] Indicates encoding used in an email message. Valid values include
preheader	text	[en] Contains text used in preheader of email message on mobile devices
partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
client__id	text	[en] Specifies the account ownership and context of an object
modifieddate	timestamp	[en] Indicates the last time object information was modified
hasdynamicsubjectline	boolean	[en] Indicates whether email message contains a dynamic subject line
createddate	timestamp	[en] Read-only date and time of the object's creation
contentcheckstatus	text	[en] Indicates whether content validation has completed for this email message
folder	text	[en] Specifies folder information Folders > > id
ishtmlpaste	boolean	[en] Indicates whether email message was created via pasted HTML
objectid	text	[en] System-controlled, read-only text string identifier for object
categoryid	text	[en] Specifies the identifier of the folder containing the email
isactive	boolean	[en] Specifies whether the object is active
subject	text	[en] Contains subject area information for a message

Events

Replication type: Incremental with update window

Parameters:

Update window (days): How many days previous to the savepoint records can still be replicated
Read start date (Savepoint): Initial date for the data replication

Relationships:

sendid → Sends > id
subscriberkey → Subscribers > subscriberkey

Main object

Marketing Cloud tracking events such as opens, clicks, and bounces per send and subscriber.

Campo	Tipo
sendid	text	[en] Contains identifier for a specific send Sends > > id
subscriberkey	text	[en] Identification of a specific subscriber Subscribers > > subscriberkey
eventtype	text	[en] The type of tracking event
eventdate	timestamp	[en] Date when a tracking event occurred
url	text	[en] Indicates URL included in an event or configuration
partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
client__id	text	[en] Specifies the account ownership and context of an object
correlationid	text	[en] Identifies correlation of objects across several requests
objectid	text	[en] System-controlled, read-only text string identifier for object
batchid	text	[en] Ties triggered send sent events to other events (like clicks and opens that occur at a later date and time)
triggeredsenddefinitionobjectid	text	[en] Identifies the triggered send definition associated with an event. This value also appears in tracking events to allow you to tie those events to a specific triggered send

marketingcloud_events__PartnerProperties

Additional partner metadata associated with each tracking event.

Campo	Tipo
sendid	text	[en] Identifier of the send associated with the event.
subscriberkey	text	[en] Subscriber key involved in the event.
eventtype	text	[en] Type of tracking event (open, click, bounce, etc.).
eventdate	timestamp	[en] Date and time when the event was recorded (UTC).
partnerproperties__name	text	[en] Name of the metadata record supplied by the client and stored by the system
partnerproperties__value	text	[en] Value of the metadata record supplied by the client and stored by the system

Folders

Replication type: Incremental with update window

Parameters:

Update window (days): How many days previous to the savepoint records can still be replicated
Read start date (Savepoint): Initial date for the data replication

Marketing Cloud folder structure with metadata and hierarchy permissions.

Campo	Tipo
id	text	[en] Read-only identifier for an object. Some objects use the ObjectID property as the Marketing Cloud unique ID
name	text	[en] Name of the object or property
allowchildren	boolean	[en] Specifies whether a data folder can have child data folders
partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
client__enterpriseid	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
client__modifiedby	text	[en] Identifier of the user who last modified the record.
client__id	text	[en] Identifier of the client account or business unit that owns the record.
client__createdby	text	[en] Identifier of the user who created the record.
iseditable	boolean	[en] Indicates if the property can be edited by the end-user in the profile center
contenttype	text	[en] Defines the type of content contained within a folder
description	text	[en] Describes and provides information regarding the object
customerkey	text	[en] User-supplied unique identifier for an object within an object type. This property corresponds to the external key assigned to an object in Marketing Cloud
parentfolder__partnerkey	text	[en] Partner key of the parent folder.
parentfolder__contenttype	text	[en] Content type assigned to the parent folder.
parentfolder__description	text	[en] Description stored for the parent folder.
parentfolder__customerkey	text	[en] Customer key (external identifier) of the parent folder.
parentfolder__name	text	[en] Name of the parent folder.
parentfolder__iseditable	boolean	[en] Indicates whether the parent folder can be edited.
parentfolder__objectid	text	[en] ObjectID of the parent folder.
parentfolder__id	text	[en] Numeric ID of the parent folder.
parentfolder__isactive	boolean	[en] Indicates whether the parent folder is active.
parentfolder__allowchildren	boolean	[en] Indicates whether the parent folder allows child folders.
modifieddate	timestamp	[en] Indicates the last time object information was modified
createddate	timestamp	[en] Read-only date and time of the object's creation
objectid	text	[en] System-controlled, read-only text string identifier for object
isactive	boolean	[en] Specifies whether the object is active

List Sends

Replication type: Full

Relationships:

list__id → Lists > id

Email send metrics per list, covering deliveries, bounces, unsubscribes, and exclusions.

Campo	Tipo
list__id	text	[en] ID of the list associated with an object Lists > > id
sendid	text	[en] Contains identifier for a specific send
forwardedemails	float	[en] Number of emails forwarded for a send
existingunsubscribes	float	[en] Indicates whether unsubscriptions occurred on previous send
unsubscribes	float	[en] Indicates the number of unsubscribe events associated with a send
uniqueopens	float	[en] Indicates number of unique opens resulting from a triggered send
uniqueclicks	float	[en] Indicates number of unique clicks on message
objectid	text	[en] System-controlled, read-only text string identifier for object
duplicates	float	[en] Represent the number of duplicate email addresses associated with a send (exists only when a send occurs to multiple lists)
list__listname	text	[en] Name of the list associated with an object
list__objectid	text	[en] ObjectID of the list associated with an object
list__partnerkey	text	[en] PartnerKey of the list associated with an object
existingundeliverables	float	[en] Indicates whether bounces occurred on previous send
otherbounces	float	[en] Specifies number of Other-type bounces in a send
partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
client__id	text	[en] Specifies the account ownership and context of an object
previewurl	text	[en] Indicates URL used to preview the message associated with a send
numberdelivered	float	[en] Number of sent emails that did not bounce
invalidaddresses	float	[en] Specifies the number of invalid addresses associated with a send
softbounces	float	[en] Indicates number of soft bounces associated with a specific send
numbersent	float	[en] Number of emails actually sent as part of an email send. This number reflects all of the sent messages and may include bounced messages
missingaddresses	float	[en] Specifies number of missing addresses encountered within a send
hardbounces	float	[en] Indicates number of hard bounces associated with a send

List Subscribers

Replication type: Incremental with update window

Parameters:

Update window (days): How many days previous to the savepoint records can still be replicated
Read start date (Savepoint): Initial date for the data replication

Relationships:

listid → Lists > id
subscriberkey → Subscribers > subscriberkey

Main object

Subscribers associated with lists, including status and reference keys per list.

Campo	Tipo
id	text	[en] Read-only identifier for an object. Some objects use the ObjectID property as the Marketing Cloud unique ID
status	text	[en] Defines status of a subscriber's address. Valid values include: Active, Bounced, Held, Unsubscribed, Deleted
listid	text	[en] Defines identification for a list the subscriber resides on Lists > > id
partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
client__id	text	[en] Specifies the account ownership and context of an object
modifieddate	timestamp	[en] Indicates the last time object information was modified
objectid	text	[en] System-controlled, read-only text string identifier for object
createddate	timestamp	[en] Read-only date and time of the object's creation
subscriberkey	text	[en] Identification of a specific subscriber Subscribers > > subscriberkey

marketingcloud_listsubscribers__PartnerProperties

Partner metadata associated with list subscriber records.

Campo	Tipo
id	text	[en] Identifier of the partner properties record.
partnerproperties__name	text	[en] Name of the metadata record supplied by the client and stored by the system
partnerproperties__value	text	[en] Value of the metadata record supplied by the client and stored by the system

Lists

Replication type: Incremental with update window

Parameters:

Update window (days): How many days previous to the savepoint records can still be replicated
Read start date (Savepoint): Initial date for the data replication

Marketing Cloud lists with metadata, external keys, and send status settings.

Campo	Tipo
id	text	[en] Read-only identifier for an object. Some objects use the ObjectID property as the Marketing Cloud unique ID
category	text	[en] ID of the folder that an item is located in
listclassification	text	[en] Specifies the classification for a list. Valid values include: ExactTargetList, PublicationList, SuppressionList
partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
client__id	text	[en] Specifies the account ownership and context of an object
type	text	[en] Indicates type of specific list. Valid values include Public, Private, Salesforce, GlobalUnsubscribe, and Master. Indicates the type of email to send to the address. Valid values include Text and HTML
listname	text	[en] Name of a specific list
description	text	[en] Describes and provides information regarding the object
customerkey	text	[en] User-supplied unique identifier for an object within an object type. This property corresponds to the external key assigned to an object in Marketing Cloud
modifieddate	timestamp	[en] Indicates the last time object information was modified
createddate	timestamp	[en] Read-only date and time of the object's creation
objectid	text	[en] System-controlled, read-only text string identifier for object

Sends

Replication type: Incremental with update window

Parameters:

Update window (days): How many days previous to the savepoint records can still be replicated
Read start date (Savepoint): Initial date for the data replication

Relationships:

email__id → Emails > id

Main object

Aggregated performance metrics for Marketing Cloud sends, including delivery, bounce, and audience counts.

Campo	Tipo
id	text	[en] Read-only identifier for an object. Some objects use the ObjectID property as the Marketing Cloud unique ID
status	text	[en] Defines status of object. Status of an address
unsubscribes	float	[en] Indicates the number of unsubscribe events associated with a send
uniqueopens	float	[en] Indicates number of unique opens resulting from a triggered send
additional	text	[en] The ID for a send that customers use as a campaign ID
numbererrored	float	[en] Number of emails not sent as part of a send because an error occurred while trying to build the email
subject	text	[en] Contains subject area information for a message
fromname	text	[en] Specifies the default email message From Name. Deprecated for email send definitions and triggered send definitions
isalwayson	boolean	[en] Indicates whether the request can be performed while the system is is maintenance mode. A value of true indicates that the system processes the request
previewurl	text	[en] Indicates URL used to preview the message associated with a send
partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
client__id	text	[en] Specifies the account ownership and context of an object
numberdelivered	float	[en] Number of sent emails that did not bounce
invalidaddresses	float	[en] Specifies the number of invalid addresses associated with a send
ismultipart	boolean	[en] Indicates whether the email is sent with Multipart/MIME enabled
missingaddresses	float	[en] Specifies number of missing addresses encountered within a send
email__partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
email__id	text	[en] Default email address for object. Indicates if subscriber information can be used for email sends Emails > > id
email__objectid	text	[en] ObjectID of the email associated with the send.
forwardedemails	float	[en] Number of emails forwarded for a send
existingunsubscribes	float	[en] Indicates whether unsubscriptions occurred on previous send
otherbounces	float	[en] Specifies number of Other-type bounces in a send
numbersent	float	[en] Number of emails actually sent as part of an email send. This number reflects all of the sent messages and may include bounced messages
senddate	timestamp	[en] Indicates the date on which a send occurred. CST (Central Standard Time) value
objectid	text	[en] System-controlled, read-only text string identifier for object
duplicates	float	[en] Represent the number of duplicate email addresses associated with a send (exists only when a send occurs to multiple lists)
uniqueclicks	float	[en] Indicates number of unique clicks on message
existingundeliverables	float	[en] Indicates whether bounces occurred on previous send
hardbounces	float	[en] Indicates number of hard bounces associated with a send
emailname	text	[en] Specifies the name of an email message associated with a send
modifieddate	timestamp	[en] Indicates the last time object information was modified
createddate	timestamp	[en] Read-only date and time of the object's creation
softbounces	float	[en] Indicates number of soft bounces associated with a specific send
numbertargeted	float	[en] Indicates the number of possible recipients for an email send. This number does not include unsubscribed or excluded subscribers for a given list or data extension
fromaddress	text	[en] Indicates From address associated with a object. Deprecated for email send definitions and triggered send definitions
numberexcluded	float	[en] Indicates the number recipients excluded froman email send because of a held, unsubscribed, master unsubscribed, or global unsubscribed status

marketingcloud_sends__PartnerProperties

Partner metadata stored for send records.

Campo	Tipo
id	text	[en] Identifier of the partner properties record.
partnerproperties__name	text	[en] Name of the metadata record supplied by the client and stored by the system
partnerproperties__value	text	[en] Value of the metadata record supplied by the client and stored by the system

Subscribers

Replication type: Incremental with update window

Parameters:

Update window (days): How many days previous to the savepoint records can still be replicated
Read start date (Savepoint): Initial date for the data replication

Main object

Marketing Cloud subscribers with identification, status, and delivery preference data.

Campo	Tipo
id	text	[en] Read-only identifier for an object. Some objects use the ObjectID property as the Marketing Cloud unique ID
client__id	text	[en] Specifies the account ownership and context of an object.
partnerkey	text	[en] Unique identifier provided by partner for an object. This property is accessible only via API
createddate	timestamp	[en] date and time of the objects creation
objectid	text	[en] System-controlled, read-only text string identifier for object
emailaddress	text	[en] Contains the email address for a subscriber. Indicates the data extension field contains email address data
subscriberkey	text	[en] Identification of a specific subscriber
status	text	[en] Defines status of object. Status of an address.
emailtypepreference	text	[en] The format to use when sending an email to a subscriber. Valid values include: HTML, Text

marketingcloud_subscribers__attributes

Custom attributes linked to each Marketing Cloud subscriber.

Campo	Tipo
subscriber_id	text	[en] Identifier of the subscriber the attribute belongs to.
name	text	[en] Specifies attributes associated with an object
value	text	[en] Value of the attribute associated with an object

Notes

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information