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, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected 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:
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.
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.
Constant Contact Connections
To create a Constant Contact connection, perform the following steps:
- Click +NEW in the top menu.
- Open the Select Connector page by clicking Connection in the menu on the left.
- In the opened pane, click Constant Contact.
In the Connection Editor page, specify a connection name that will be used to identify the connection.
- Click Sign In with Constant Contact.
In the opened window enter your Constant Contact credentials and click Sign in.
- The list of requested permissions is displayed. Click Allow.
- Click Create Connection to create the connection.
Supported Actions and Actions Specifics
Constant Contact connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.