Salesforce Marketing Cloud (formerly Exact Target) is a multi-tool marketing platform designed to effectively manage a brand's interactions with current (and potential) customers across multiple channels.

The technology behind the platform allows for more efficient and effective management of marketing activities. The platform allows the creation of multichannel experiences, contacting customers in the right channel, at the right time (email, SMS, push, social media advertisements, etc.) and increasing customer acquisition and sales.

Kondado's integration with Salesforce Marketing Cloud makes it easier than ever to plan, monitor, analyze and make decisions by bringing lots of data into your Data Warehouse and Data Lake.

Adding the data source

To automate Salesforce Marketing Cloud ETL with Kondado for your database, follow the steps below:

2) You will be redirected to the login page specific to the user account selected in step (1). Copy the URL that will be generated:

3) With the URL in hand, you must obtain your company's subdomain by searching for the value before “.login”. In the example in step (2), this value will be mcx1072k138f919oowzqewciw06, which is obtained as follows:

https://mcx1072k138f919oowzqewciw06.login.exacttarget.com

4) Save the subdomain obtained in step (3), as it will be used to create the data source in Kondado;

5) Continue with your login and access the Salesforce Marketing Cloud platform;

6) Once logged in, locate your username on the right of the top bar, click on it and then on “Setup”;

7) On the new page, locate in the left sidebar the route Apps > Installed Packages;

8) On the Installed Packages page, you will see the list of connected applications. To create the Kondado integration, click on the “New” button located at the top right of the listing;

9) After clicking on the button, enter a name and a description (for example Kondado and kondado.com.br) and click on “Save”;

10) After creating the Installed Package, in the “DETAILS” tab, locate the “Components” section and click on the “Add Component” button;

11) In the first step of the popup, select the “API Integration” option and click “Next”;

12) In the next step, select the “Server-to-Server” option and click “Next”;

13) Now is the time to select the permissions/properties of the Kondado integration. Mark the Data > Data Extensions category as Read and Write and the categories listed below as Read only. After checking the permissions, click on “Save”:

Email, OTT, Push, SMS, Social, Web, Documents and Images, Saved Content, Automations, Journeys, Audiences, List and Subscribers, Marketing Cloud Connect, File Locations, Tracking Events, Approvals, Calendar, Campaign, Tags, Workflows, Accounts, OTT Channels, Users e Webhooks

14) After adding the Component, copy the values of “Client Id” and “Client Secret” located in the tab “DETAILS” > Components > API Integration:

16) Fill in the values as follows:

• Subdomain: The value obtained in step (3)
• Client ID and Client Secret: The values obtained in step (14)

Now just click on SAVE and everything will be ready for you to start replicating your Salesforce Marketing Cloud data to your Data Warehouse!

Pipelines

Relationship Chart

Subscribers

Main object

Attributes

Emails

Events

Main object

PartnerProperties

Folders

List Sends

List Subscribers

Main object

PartnerProperties

Lists

Sends

Main object

PartnerProperties

Data Extension

This pipeline can be integral or incremental. For it to be incremental, it is necessary that: (i) there is a column of type timestamp (or Date for SFMC) that marks when the record was updated or inserted that is selected to be sent to the integration (if there are timestamp columns, but that do not have this behavior, the ideal is to leave the integration as integral) ; (ii) the records are not deleted from the table (if they are, the ideal is to leave the integration as integral);. Once both these conditions are met, you can mark the integration as incremental in the last step when creating the integration, also selecting the incremental column. Incremental updates will always read data from the savepoint date minus 1 day backwards.