How to integrate SAS with Constant Contact
Constant Contact is online email marketing software that helps small businesses stay in communication with customers by creating customized emails and sending them to your contact lists to increase returns. If your business uses this software, integrating your account with the Constant Contact app in the portal will automatically push data from your calls into your contacts list. This eliminates the need for you to do double the work, converting messages into new Constant Contact entries.
In this article we'll discuss:
Connect Constant Contact with Your SAS Account
Setting Contact Data Parameters
If Don't update existing contacts. Create new ones. is chosen, SAS will look for an email match in your Constant Contact installation. If there is no match, it will create a new contact. If there is an email match, it will do nothing.
If Update contacts by overwriting any data with details from SAS. is chosen, SAS will look for an email match in your Constant Contact installation. If there is a match, it will overwrite any existing customer data with data we've received from the call.
If Update contacts by appending details from SAS without overwriting existing data. is chosen, SAS will look for an email match in your Constant Contact installation. If there is a match, it won't overwrite data but will add any new details received.
Map Contact Data
Once the configurations are set, you'll need to create the content of the contact we'll be adding to Constant Contact.
SAS will allow you to use specific SAS script variables to populate Constant Contact's contact variables. If you select SAS, the third column will allow you to select a script variable.
Text gives you the option to type your own static data rather than using SAS variables. If you select Text, the second third will be a blank box where you can type specific information.
Note that the system will automatically map First Name, Last Name, and Email, so the Constant Contact drop down list will not include those variables.
Click Map data, and you'll see your field listed next to Mappings.
Mapping Address Fields
In the call script builder, the Address step consists of 5 connected fields: [Address1], [Address2], [City], [State], [ZipCode]. If you select Address from the script variables list, it will populate all 5 fields into only the specific Constant Contact address field you select. So, in order to map data individually to Constant Contact, you'll need to use the Text option, entering the variables as listed above.
If you map all Address fields, your Mappings will look similar to the list below:
Integrate Constant Contact into Your Script
With all of your integration settings complete, you'll need to add the integration into your SAS script.