This guide presents the process to set up the ExactTarget Appexchange integration with the Salesforce platform. To complete this setup, the ExactTarget power user/administrator must have Salesforce administrative privileges. Lacking those privileges, you can directly contact yourinternal Salesforce administrator or salesforce.com.
ExactTarget for Appexchange extends advanced email marketing capabilities to Salesforce. This integration uses your customer and prospect data in Salesforce because it's current and specific to your business needs. Using a single data model, the integration creates emails with the ExactTarget application. Because the data effectively resides all in one place, you can see how your customers interact with your business and act on information tied to them. With this integration for Salesforce Enterprise and Unlimited Editions, you can quickly build and deploy advanced email marketing campaigns.
ExactTarget for Appexchange enables marketers to create and send more relevant emails because it uses Salesforce data to create personalization and dynamic email content. ExactTarget accomplishes this by pulling substitution values for personalization strings from Salesforce and considering Salesforce values when it evaluates dynamic content. Personalization and content aretied directly to your Salesforce standard and customfields.
With this integration, marketers can get a complete view of how a contact, lead, or account responds to email campaigns because ExactTarget pushes emailtracking data to Salesforce. Marketers can create adhoc reports and dashboards with this rich set ofdata, thereby achieving more control over how theircustomers view and respond to their data.
Those with Salesforce and ExactTarget admin status perform the configuration, specific to their release.This section covers features found in the full release.The Salesforce Install package contains approximately 70 custom items including field definitions, object definitions, links, folders, dashboard, and documents. The Deploy package contains four custom objects. By means of defaults specific to your setup, the configuration process is straightforward.
Salesforce configuration consists of enabling the email opt-out field to indicate someone has unsubscribed from emails. This field must be enabled in contact and lead views. By doing so, youset field-level security based on user role: visible or read only. ExactTarget recommends the visible setting. Note that to update an opt-in/opt-out status, the field must be visible. Once configured, this field is added to the page layout.
You can create page layouts to control the display of fields. Page layouts control the layout and organization of buttons, fields, s-controls, custom links, and related lists. They also help determine which fields are visible, read only, and required. Page layouts can include s-controls that run when a user clicks a custom link or button, or that are rendered within a field section when the page displays. You can create different page layouts for use by different profiles and record types and set field-level security settings to further restrict users' access to specific fields.
After you configure your Salesforce account, you configure and map your ExactTarget account to it. By doing so, you create a current data repository to use for dynamic, relevant customer-specific emails and followup responses.
To install the ExactTarget for Appexchange package, use the following link:
https://login.salesforce.com/?startURL=%2Fpackaging%2FinstallPackage.apexp%3Fp0%3D04t3000000099fC
NOTE: For sandbox account installations, change "login" in the above link to your subdomain as assigned by Salesforce.
You must be an administrator on your Salesforce instance to download and install ExactTarget for Appexchange. The Salesforce administrator determines access to Salesforce and ExactTarget for Appexchange based on Salesforce profiles, either by setting the Remove Ability to Send Email permission or removing the Send ExactTarget Email link from the web layout.
Follow these steps to install ExactTarget for Appexchange:
NOTE: With the exception of user security level, ExactTarget recommends that you use the setup defaults.
Once this process is complete, you can configure the Custom Objects and Layouts in Salesforce.
The installation and deployment process populates your Salesforce account with all the custom objects, custom tabs, and custom links of ExactTarget for Appexchange. It's necessary to configure these elements in your Salesforce account.
NOTE: If your ExactTarget uses the S4 instance, you must modify the custom links for the following items in your Salesforce configuration process:
Navigate to the Setup screen in ExactTarget to change the beginning of these links from https://members.exacttarget.com/... to https://members.s4.exacttarget.com. You can find more instructions about the configuration process here. Please contact your Implementation Consultant with any questions you may have about these links.
ExactTarget for Appexchange uses the standard Email Opt Out field for contact and lead records to indicate someone has unsubscribed from emails. Because Salesforce defaults this field to be neither visible nor editable in the standard contact and lead views, you must enable this field for the integration.
Follow these steps to enable the Email Opt Out field for contacts:
ExactTarget recommends that you check Visible to make the Email Opt Out field visible to all user Profiles. Determine the profiles, if any, to have Read Only access to this field.
ExactTarget recommends you don't check Read Only for user profiles using the integration.
The field must be visible in order to update a lead or contract's opt-in/opt-out status. We recommend you don't check the Read Only checkbox for the administrator user profile.
NOTE: You must still add the Email Opt Out field to the page layout.
Repeat the steps taken to enable the Email Opt Out field for Contacts to enable it for Leads.
ExactTarget recommends that you check Visible to make the Email Opt Out field visible to all user Profiles.
Determine the profiles, if any, to have Read Only access to this field. ExactTarget recommends you don't check Read Only for user profiles using the integration.
The field must be visible in order to update a lead or contract's opt-in/opt-out status. ExactTarget recommends leaving the Read Only checkbox unchecked for the administrator user profile.
You can configure the custom objects and edit page layouts to expose the integration to your users.
Follow these steps to add custom components to the contacts layout:
NOTE: ExactTarget recommends that you select the following fields: Email Name, Date Sent, Subject Line, Opened, Date Opened, and Number of Total Clicks. However, you can designate any of the Available Fields to display on the related list.
NOTE: ExactTarget recommends that you sort by Date Sent in descending order.
Follow these steps to customize the Lead layout:
NOTE: ExactTarget recommends that you select the following fields: Email Name, Date Sent, Subject Line, Opened, Date Opened, and Number of Total Clicks. However, you can designate any of the Available Fields to display on the related list.
NOTE: ExactTarget recommends that you sort by Date Sent in descending order.
Follow these steps to add custom components to the campaign layout:
NOTE: ExactTarget recommends you select the following fields: Email Name, Subject Line, Date Sent, Number Sent, Open Rate, and Click-through Rate. These fields exist as part of this installation. To remove one of them, do so by selecting it from Selected Fields, then click Remove. You can designate any of the Available Fields to display on the related list.
NOTE: ExactTarget recommends you sort by Date Sent in descending order.
Within Salesforce.com, you must authorize the IP addresses used by ExactTarget. If you do not perform this procedure, the integration may not work. Follow these steps to update the IP ranges.
| IP Start Address | IP End Address |
| 206.246.141.81 | 206.246.141.81 |
| 206.246.157.1 | 206.246.157.6 |
| 66.231.91.250 | 66.231.91.252 |
| 66.231.94.250 | 66.231.94.252 |
| 64.79.134.164 | 64.79.134.164 |
Depending on your security settings, you may also have IP address restrictions in place for account login activity. If you have implemented this optional step, you need to add the same IP address range above as well. Follow the steps below to enter that IP address range:
Prior to completing the configuration in your ExactTarget account, you'll see elements of the integration. These elements include:
Complete the following tasks for each element to configure your ExactTarget account.
NOTE: Complete these steps for all your Lock and Publish accounts (in addition to your administrative account) if you use an ExactTarget Enterprise account.
The administrative setup must be complete before you can configure other elements.
To initiate the integration between ExactTarget and Salesforce, you must provide a valid user name and password. This account (known as the tracking user) pushes tracking results back to your Salesforce account.
ExactTarget recommends that the tracking username and password that you provide has an administrator role (or API user role) in Salesforce. This role ensures that all tracking results are able to be posted from ExactTarget back into Salesforce. The system also uses the tracking user to to validate a valid session status for SSO Salesforce users to ExactTarget. Also, the tracking password should be set to expire after one year. You can determine how often the password expires in Salesforce.com.
The ExactTarget application authenticates to Salesforce on a single-user-to-single-user basis. The application stores only the username and the associated Salesforce.com login, except for the tracking user.
NOTE: The password you provide is transported via SSL and encrypted via AES256 encryption.
Follow these steps to set the password to expire in one year:
To initiate the integration between ExactTarget and Salesforce, do this:
NOTE: The Salesforce Org ID in this field may have a different number of characters than the ID you see in your Salesforce account. This is acceptable if the first 15 characters match. If they don't, please contact an ExactTarget customer support representative.
NOTE: To add the members of the Forward-to-a-Friend list to your Salesforce database, you can export the list from ExactTarget and then import it into Salesforce. Opt-ins are not automatically added as Leads to Salesforce.
If you set up your account as a sandbox, you can use this account instance to test the ExactTarget for Appexchange integration. The data in this account remains separate from your production data, and this data will not be synced between the sandbox and the production account when you change the location to where the integration points. Contact your Salesforce representative to set up a sandbox account if you wish to use one.
To enable your Salesforce users to send ExactTarget emails from within Salesforce, map each user to a corresponding ExactTarget user. Each user must have an individual ExactTarget account, and shared accounts are not usable as part of this integration. Users can only send to leads and contact to which they have access in Salesforce. This also determines what emails are accessible to a user who initiates a lookup as part of the send process.
Follow these steps to map users from Salesforce to ExactTarget:
By mapping ExactTarget attributes to appropriate Salesforce fields, ExactTarget knows what data to pull from your Salesforce account. Then it can insert personalization and generate dynamic content to the emails you send to Salesforce leads and contacts. When you map the ExactTarget attributes to the appropriate Salesforce fields you complete your configuration.
NOTE: You cannot map the default attributes:
You can choose from the Salesforce default, lead, contact, and account fields. Otherwise, you can create the Salesforce lead, contact and account fields you want to map to ExactTarget attributes. Do this when you configure your Salesforce account.
Follow these steps to map ExactTarget attributes to appropriate Salesforce fields, do this:
NOTE: Checking this box overrides the properties you defined for this attribute on the General tab, but only for sends to Salesforce Leads and Contacts. The value information displayed on the Profile Center reflects the values stored for the Lead or Contact in Salesforce. Any changes made via the Profile Center are reflected in Salesforce. ExactTarget attributes mapped to Salesforce Account fields cannot be displayed on the Profile Center because they can't be edited.
Map all corresponding ExactTarget attributes to Salesforce account, contact, and lead field because:
The following Salesforce fields can be mapped to ExactTarget Attributes:
| Saleforce Field Type | ExactTarget Attribute Type | Notes |
| Date/Time | Date | Time portion will be truncated. |
| Formula (Date/Time) | Date | Time portion will be truncated. |
| Formula (Text) | Date | The data type for this attribute in ExactTarget is Date, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Text | Date | The data type for this attribute in ExactTarget is Date, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Text Area | Date | The data type for this attribute in ExactTarget is Date, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Text Area (long) | Date | The data type for this attribute in ExactTarget is Date, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Currency | Numeric | If the numeric value stored in this Salesforce field includes a decimal value, ExactTarget will round to he nearest whole value. |
| Formula (Currency) | Numeric | If the numeric value stored in this Salesforce field includes a decimal value, ExactTarget will round to he nearest whole value. |
| Formula (Number) | Numeric | If the numeric value stored in this Salesforce field includes a decimal value, ExactTarget will round to he nearest whole value. |
| Formula (Percent) | Numeric | If the numeric value stored in this Salesforce field includes a decimal value, ExactTarget will round to he nearest whole value. |
| Formula (Text) | Numeric | The data type for this attribute in ExactTarget is Numeric, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Number | Numeric | The data type for this attribute in ExactTarget is Numeric, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Percent | Numeric | The data type for this attribute in ExactTarget is Numeric, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Text | Numeric | The data type for this attribute in ExactTarget is Numeric, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Text Area | Numeric | The data type for this attribute in ExactTarget is Numeric, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Text Area (long) | Numeric | The data type for this attribute in ExactTarget is Numeric, the field in Salesforce is set to Text. Due to this, the substitutions of values could fail. |
| Currency | Text | Value will be formatted as nnn,nnn.nn. |
| Date | Text | Value will be formatted as yyyy-mm-dd. |
| Date/Time | Text | Value will be formatted as yyyy-mm-dd hh:mm:ss. |
| Lookup Relationship | Text | The SalesforceID stored for this field will be the value used when making substitutions into the email. |
| Master-Detail Relationship | Text | The SalesforceID stored for this field will be the value used when making substitutions into the email. |
| Number | Text | Value will be formatted as nnn,nnn.nn. |
| Percent | Text | Value will be formatted as nn.n%. |
| Boolean | HTML Preference | When mapping the Salesforce field type to the ExactTarget HTML preference, a value of "true" in Salesforce will indicate text emails in ExactTarget, while a false or null value indicates HTML emails. Customers indicate their preference in their profile center, which then saves their choice in the ExactTarget application and the corresponding Salesforce contact or lead record. |
With ExactTarget for Appexchange, Salesforce is the database of record for all emails sent to leads and contacts. To get your data as current as possible, particularly opt-in status, ExactTarget recommends that you export all leads and contacts with a status of unsubscribed from the ExactTarget application and import them in to Salesforce. Ignoring this recommendation, however, doesn't impact the ExactTarget for Appexchange integration.
Follow these steps to export subscribers from ExactTarget:
NOTES: At a minimum, include Email Address and SFContact ID in your export. These fields are critical when importing into Salesforce. It is also advisable to include First Name and Last Name in your export. For detailed instructions on how to do a Search for Subscribers and an Export of Subscribers, please consult the ExactTarget Online Help.
After exporting the list of leads and contacts with a status of unsubscribed, it's necessary to prepare it for import into Salesforce to ensure that the records synchronize.
Follow these steps to prepare a file to import into Salesforce:
Before you import a file, prepare the file, as described in Importing File into Salesforce: Preparation.
Follow these steps to import a file into Salesforce:
NOTES: For detailed instructions on how execute an import using the Import My Accounts and Contacts tool, please consult the Salesforce online help. If you have records that share the same email address, those records will not be updated during the import. ExactTarget will still honor the unsubscribe status of these Contacts or Leads and will not send them an email.
If you are uninstalling version 1 of the Salesforce integration in favor of version 2, see the Uninstalling v1 of Salesforce Integration guide.
Follow these steps to uninstall ExactTarget for Appexchange, do this:
It may be necessary to restrict access to the ExactTarget tab to some users. You can hide the tab from those users.
Follow these steps to restrict access to and hide the ExactTarget tab:
When you classify your users by their profile, you can assign user permissions as a group. For example, user profile type can include:
Based on their user profiles, you can restrict multiple users from viewing the ExactTarget tab in the Salesforce menu bar:
A Person Account in Saleforce is sometimes known as B2C, or Business-to-Consumer account. This account option in Salesforce merges an account with a single related contact in a single view. ExactTarget for Appexchange supports sending to Person Accounts natively through the related Person Account's related contact.
You can send a mass email to a Person account by using:
To enable sending to Person Accounts, you can download that package from here:
https://login.salesforce.com/?startU...4t30000000AuEu
You can configure the custom objects and edit page layouts to expose the integration to your users.
Follow these steps to add custom components to the Person Account layout:
You will need to modify the Person Account page layout in place of the contact Page Layout. You modify Person Account Layout via Setup -> Customize -> Accounts -> Person Accounts -> PA Layouts. You can create page layouts to control the display of fields. Page layouts control the layout and organization of buttons, fields, s-controls, custom links, and related lists. They also help determine which fields are visible, read only, and required. Page layouts can include scontrols that run when a user clicks a custom link or button, or that are rendered within a field section when the page displays. You can create different page layouts for use by different profiles and record types and set field-level security settings to further restrict users' access to specific fields.
After you configure your Salesforce account, you configure and map your ExactTarget account to it. By doing so, you create a current data repository to use for dynamic, relevant customer-specific emails and follow-up responses.
Follow these steps to generate reports using Person Accounts.