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

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": "ema[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

Objects that support Synchronization and Replication with Incremental Updates: Campaigns, ContactCustomFields, ContactLists, Contacts.

Supported Actions

Skyvia supports all the common actions for Constant Contact.