Constant Contact is an easy-to-use email marketing service that helps create effective email marketing and other online marketing campaigns to meet customers’ business goals.
Data integration: Skyvia supports importing data to and from Constant Contact, exporting Constant Contact data to CSV files, replicating Constant Contact data to relational databases, and synchronizing Constant Contact data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Constant Contact backup.
Query: Skyvia Query supports Constant Contact.
To create a Constant Contact connection, perform the following steps:
- Click Sign In with Constant Contact.
Enter your Constant Contact credentials and click Sign in.
- Give your consent to the list of requested permissions.
Additional Connection Parameters
Suppress Extended Requests
Constant Contact API returns only part of the fields for some objects when querying multiple records. To query the values of additional fields, Skyvia performs additional extended requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls.
The list of such additional fields is the following:
To reduce the number of API calls, select the Suppress Extended Requests checkbox. However, please note that some fields in such objects are unavailable in Skyvia (return empty values) even if they have values in Constant Contact because its API does not return them without extended requests.
The Campaigns object stores data about campaign activities as a JSON array. If you need to load data into the Campaigns object, you must map the Name, and Activities fields and provide values for the Activities field as JSON arrays, for example:
Where NAME, [email protected], SUBJECT, and CONTENT should be replaced with the respective values. You may also add the preheader parameter and physical_address_in_footer and document_properties objects to records in the JSON array.
Campaign activity data, stored in the Activity field of the Campaigns object is also available via the CampaignActivities object.
You can access some Constant Contact objects only via their parent objects. For example, to query CampaignActivities, Constant Contact API requires the ID of the corresponding Campaigns record. To get records from a number of other objects, Constant Contact API requires the ID of the corresponding CampaignActivity. These are the following objects: EmailLinksReport, EmailDidNotOpensReport, EmailBouncesReport, EmailBouncesReport, EmailForwardsReport, EmailForwardsReport, EmailOpensReport, EmailOptoutsReport, EmailSendsReport, EmailUniqueOpensReport, EmailPreviews, CampaignActivitySchedule, CampaignActivitySendHistory.
Skyvia does not require the ID of the parent object from users. If you don’t specify the IDs of the parent objects (for example, in a filter), Skyvia queries all the parent object records first, takes their IDs, and then queries child object records for each parent object record. This allows querying child objects without knowing their parents, but this method takes time and consumes many API calls. It uses at least one API call for every parent object record. Thus, working with child objects without filtering them on their parents can be very slow and use additional API calls.
We strongly recommend using filters by the parent object fields when querying data from child objects. This reduces the number of parent object records for which child object data must be queried.
DML Operations Support
|INSERT, UPDATE, DELETE||Campaigns, ContactCustomFields, ContactLists, Contacts|
Incremental Replication and Synchronization
Objects that support Synchronization and Replication with Incremental Updates: Campaigns, ContactCustomFields, ContactLists, Contacts.
Skyvia supports all the common actions for Constant Contact.