Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can use the same connection to export SFMC data. See Salesforce Marketing Cloud ExactTarget Export Integration.

To see sample workflows for importing Salesforce Marketing Cloud data, go to Treasure Boxes.

This data connector is in Beta. For more information, contact support@treasuredata.com.

Table of Contents

Prerequisites

...

Create an Install Package in Salesforce Marketing Cloud

After August 1st, 2019, you can not create a Legacy Package in Salesforce Marketing Cloud, therefore we highly recommend that you create an Enhanced Package.

...

On the Welcome Page, select your name on the top-right corner then select Setup.

...

  • Scroll to the CHANNELS section and select the Read checkbox on Email

  • Scroll to the CONTACT section and select the Read checkbox on Audiences and List and Subscribers

  • Scroll to the DATA section and select the Read and Write checkbox on Data Extensions, Read for Tracking Events

  • Scroll to HUB section and and select the Read checkbox on the Campaign





On the Installed Packages screen, scroll down to the Components panel, then take note of the Client Id and Client Secret. You use the information to write the data from Treasure Data to Salesforce Marketing Cloud.

...

On the Welcome Page, select your name on the top-right corner then select Setup.

...

  • Scroll to the CHANNELS section and select the Read checkbox on Email

  • Scroll to CONTACT section and select the Read checkbox on Audiences and List and Subscribers

  • Scroll to DATA section and select the Read and Write checkbox on Data Extensions, Read for Tracking Events

  • Scroll to HUB section and select the Read checkbox on the Campaign





On the Installed Packages screen, scroll down to the Components panel, then take note of the Client Id, Client Secret and Authentication Base URI. You will use the information to write the data from Treasure Data to Salesforce Marketing Cloud.

...

On the New Authentication screen, select Package Type as Enhanced Functionality Package, then enter the Client Id, Client Secret, and Authentication Base URI (which you obtained when you created the enhanced package in SFMC). Optionally, you could specify Account identifier or MID to access multiple BUs (more detail in How to get MID) and Scope to limit the token's scope (more detail in API scopes). Select Continue.


Enter a Name for this integration and select Done.

...

You will see the new data transfer in progress listed under the My Input Transfers tab and a corresponding job are listed in the Jobs section.


Available Targets

Target

Description

Campaign

The e-mail campaign

Contact

The contact list

Data Extensions

The data extensions to satisfy the need for flexible data storage

Email Events

The events associated with an email marketing send

The target Contact provides an option to ingest data in multiple requests in case you have too many contact model’s model attributes. If you select this option, you also input the number of attributes per request. The default value of this field is 100.

...

The target Data Extensions provides an option to filter data extensions that you want to ingest and another option to enable ingesting shared data extensionextensions.


The target Email Events provides an option to filter:

  • Email name matching pattern (exact or partial match)

  • Email events type that you want to ingest

  • Two options to define a date range to ingesting events on a specific date-time range.