You can sync columns from your source to Marketing Cloud's attribute sets.
Ensure all the required fields in each attribute set is completed. For example, to add an email address, both Email Address and HTML Enabled must be mapped. Refer to the Usage section of the Creating Contacts documentation.
Field mapping is needed to map other columns in your results to the data extension containing data for your journey.
In the data extension, there is a required attribute email_address which means that you will have to map a result column to that attribute. You can do this in Hightouch by typing the attribute name in the mappings section.
If enabled, Hightouch will create a Data Extension for you the first time the
The Data Extension's name can be specified as well. The name defaults to the
model name, and it will be used for the Data Extension's customer key as well.
The Data Extension will only be created the first time the sync runs. Hightouch
will not modify the name or customer key of the Data Extension after the first
run. If you want to change the name or customer key, you will have to create a
If FTP is selected, Hightouch will upload a file via FTP to SFMC. Then,
Hightouch will create and run an Import Definition to import the file to the
Data Extension. This is done in batches. After each batch, Hightouch processes
the SFMC results file to determine row errors.
FTP mode requires:
FTP credentials to be configured for the destination in Hightouch.
Username, which is typically a ~10 digit numeric ID.
Password or private key with a corresponding public key uploaded to SFMC.
The private key in the Hightouch destination configuration should be the full
private key, starting with -----BEGIN...PRIVATE KEY-----. You can generate
a private-public key pair with a tool like
A private key passphrase if required by your private key.
The following permissions granted to the installed package in SFMC:
File location read and write
Automation read, write, and execute
The default mode uses only the SOAP API and works in smaller batches. FTP mode
is generally faster.
You can map from your source to any field in your Data Extension. Make sure that
you include all non-nullable fields when syncing new objects to the Data
Extension. In upsert mode, it's possible to send requests that don't have all
non-nullable fields, but only if the object already exists in the Data
Extension. For new objects, non-nullable fields are required.
Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.
Connection issues with your data warehouse?
Confusing API responses from destination systems?
Unsupported destination objects or modes?
Help with complex SQL queries?
If you see something that's missing from our app, let us know and we'll work with you to build it!
We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.