Constant Contact

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.

Establishing Connection

To create a connection, log in with a Constant Contact account. Skyvia stores only the OAuth authentication token. Skyvia does not store your credentials.

Creating Connection

To create a Constant Contact connection, perform the following steps:

Connection Editor window

  1. Click Sign In with Constant Contact.

  2. Enter your Constant Contact credentials and click Sign in.

    Log In window

  3. Give your consent to the list of requested permissions.

Grant 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:

OBJECT FIELD
Campaigns CampaignActivities

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.

Connector Specifics

Object Specifics

Campaigns

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:

[{ "format_type": 5, "from_name": "NAME", "from_email": "[email protected]", "reply_to_email": "[email protected]", "subject": "SUBJECT", "html_content": "CONTENT" }]

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

Operation Object
INSERT, UPDATE, DELETE Campaigns, ContactCustomFields, ContactLists, Contacts
INSERT AccountEmails, CampaignActivitySchedule

Incremental Replication and Synchronization

Skyvia supports Incremental Replication for the following Constant Contact objects: Campaigns, ContactCustomFields, ContactLists, Contacts, EmailBouncesReport, EmailDidNotOpensReport, EmailForwardsReport, EmailOpensReport, EmailOptoutsReport, EmailSendsReport, EmailUniqueOpensReport. Skyvia detects only the newly created records for the objects with the *Report suffix in their names.

Skyvia supports Synchronization for the following ConstantContact objects: Campaigns, ContactCustomFields, ContactLists, Contacts.

Supported Actions

Skyvia supports all the common actions for Constant Contact.

On This Page