Connecting to Constant Contact

Constant Contact is an easy-to-use email marketing service, which helps to 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.

Constant Contact-Specific Features and Limitations

Skyvia has the following limitations for Constant Contact:

  • In Data Integration product, Constant Contact connections are supported only for packages, using new data integration runtime. Make sure you select the Use new runtime check box on the tab bar if you want to use Constant Contact in your package.

  • Skyvia Backup does not support Constant Contact backup.

  • Objects that support import operations: AccountEmails, CampaignActivitySchedule (INSERT); Campaigns, ContactCustomFields, ContactLists, Contacts (INSERT, UPDATE, DELETE).

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

  • 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 fields as JSON arrays, for example:

    [{ "format_type": 5, "from_name": "NAME", "from_email": "email@test.com", "reply_to_email": "email@test.com", "subject": "SUBJECT", "html_content": "CONTENT" }]

    Where NAME, email@test.com, 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.

  • Some of the Constant Contact objects can be accessed only via their parent objects. For example, to query CampaignActivities, Constant Contact API requires the ID of the corresponding Campaigns. 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 user. 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 much 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.

    Because of this, it is strongly recommended to use filters on the parent object fields when querying data from such child objects. This reduces the number of parent object records, for which child object data must be queried.

  • Skyvia Backup is limited in restoring Constant Contact data. When querying data via Constant Contact API, for some objects Constant Contact returns not all the data that are required for inserting a corresponding record to Constant Contact, or Constant Contact requires data for the record in different format than it returns. Thus, Skyvia Backup cannot restore deleted/updated campaigns and contacts.

Constant Contact Connections

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

  1. Click +NEW in the top menu.
  2. Open the Select Connector page by clicking Connection in the menu on the left.
  3. In the opened pane, click Constant Contact.
  4. In the Connection Editor page, specify a connection name that will be used to identify the connection.

    Connection Editor window

  5. Click Sign In with Constant Contact.
  6. In the opened window enter your Constant Contact credentials and click Sign in.

    Log In window

  7. The list of requested permissions is displayed. Click Allow.
  8. Click Create Connection to create the connection.