Tag Archives: Constant Contact

Revoking access

To gain access to your Constant Contact data, Analytics Edge obtains an “Oauth token” when you log in to your account through the connector (use the Add Account function on the Accounts Wizard).  Once that token is issued, you no longer need to log in with the account and password — the token is accepted all by itself.

Note that the account is still verified before use, so even if an oauth token is issued for an account/login, if that account is deactivated, the oauth tokens will fail.

If it is necessary to revoke a token, the only way to do this is to send a request to Constant Contact Web Services group (webservices@constantcontact.com) telling them to revoke all Oauth tokens issued to your account from the application “Analytics Edge Account Login”.

Campaigns

get-campaignsUse this wizard to get a list of the Constant Contact campaigns in the account.

Analytics Edge will automatically make multiple queries to retrieve all of the campaigns, or you can limit it to just the most recent few by entering a limit number.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Limit – using a limit of 0 will download all campaigns for the account. You can limit the number by entering a value.

Status – you can download campaigns with a specific status. Typically people are interested only in campaigns that have been SENT.

Modified Since – If you are only interested in more recent campaigns, you can use this option to pick a start date or time period (relative to today).

Campaign Details

get-a-campaignUse this Analytics Edge wizard to get details about a specific Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Update Summary – by default Constant Contact will return the last scheduled update, but you can get the most recent results by requesting to update the summary.

Accounts

accountsThis wizard is used to authorize Constant Contact login accounts to be used by the various queries.

One account can be designated as the Default account, and is identified by an asterisk (*).

Constant Contact Account Authorization

From the Analytics Edge ribbon menu, select the Constant Contact – Accounts menu.

Enter a reference name to identify this account, and click the Add Account button. Reference names can be anything, but should be a clear reminder of the account itself.

Log in to Constant Contact

Log in to your Constant Contact account and click the Log In button.

Click Grant Access

Click the Grant Access button on the confirmation screen.

Select the account you just created in the list and click the Make Default button.

Campaign Reports – Summary

campaign-reports-summaryUse this wizard to get summary statistics about the selected Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Campaign Reports – Bounces

campaign-reports-bouncesUse this wizard to get details about bounced messages for the selected Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Limit – using a limit of 0 will download all bounces for the campaign. You can limit the number by entering a value.

Created Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Campaign Reports – Clicks

campaign-reports-clicksUse this wizard to get details about clicks for the selected Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Limit – using a limit of 0 will download all clicks for the campaign. You can limit the number by entering a value.

Created Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Campaign Reports – Clicks on Link

campaign-reports-click-linkidUse this wizard to get details about specific link clicks for the selected Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Link ID – enter the link id for the link of interest. You can get the link id from the Campaign Reports – Clicks report.

Limit – using a limit of 0 will download all click details for the campaign link. You can limit the number by entering a value.

Created Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Campaign Reports – Forwards

campaign-reports-forwardsUse this wizard to get details about forwarded messages for the selected Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Limit – using a limit of 0 will download all forwards for the campaign. You can limit the number by entering a value.

Created Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Campaign Reports – Opens

campaign-reports-opensUse this wizard to get details about opened messages for the selected Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Limit – using a limit of 0 will download all opens for the campaign. You can limit the number by entering a value.

Created Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Campaign Reports – Sends

campaign-reports-sendsUse this wizard to get details about sent messages for the selected Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Limit – using a limit of 0 will download all sends for the campaign. You can limit the number by entering a value.

Created Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Campaign Reports – Unsubscribes

campaign-reports-unsubscribesUse this wizard to get details about unsubscribes (opt-outs) for the selected Constant Contact campaign. The campaign is identified by the campaign ID number. You can use the campaign selector popup to pick a campaign from those available, enter an asterisk (*) to automatically get the most recently sent campaign, or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Campaign ID – enter a campaign id number, enter * to get the most recently sent campaign, or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup campaign selection wizard to pick the campaign of interest export_icon&16. Select the campaign in the popup and click OK to get the campaign id.

Limit – using a limit of 0 will download all unsubscribes for the campaign. You can limit the number by entering a value.

Created Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Contact Listing

get-contactsUse this wizard to get the contacts for a specific Constant Contact account.

Analytics Edge will automatically make multiple queries to retrieve all of the contacts, or you can limit it to just the most recently modified few by entering a limit number.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Limit – using a limit of 0 will download all contacts for the account. You can limit the number by entering a value.

Status – you can download contacts with a specific status. Typically people are interested only in contacts that are ACTIVE.

Email – if you want to get a specific contact record by email address, you can enter the exact address here.

Modified Since – If you are only interested in more recent campaigns, you can use this option to pick a start date or time period (relative to today).

Contact Details

get-contactUse this wizard to get details about a specific contact in your Constant Contact account.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter the contact id number, use an Excel cell reference to the value (use the button provided) top_left_expand_icon&16, or select the contact by email address from the popup list export_icon&16.

Lists

listsUse this wizard to get the Constant Contact lists in the account.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Modified Since – If you are only interested in more recently modified lists, you can use this option to pick a start date or time period (relative to today).

List Details

list

Use this wizard to get details about a specific Constant Contact list in the account given the list id number.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

List ID – enter the list id number or click the lookup button export_icon&16 to pick from the available lists in the account.

List Members

list-membersUse this wizard to get the contacts in a specified list.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

List ID – enter the list id number or click the lookup button export_icon&16 to pick from the available lists in the account.

Limit – using a limit of 0 will download all list members (contacts / email addresses) for the account. You can limit the number by entering a value.

Modified Since – If you are only interested in more recently modified lists, you can use this option to pick a start date or time period (relative to today).

Contact Report – Contact Activities

contact-report-contact-activitiesUse this wizard to get details about the activity of a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Limit – using a limit of 0 will download all activity for the contact. You can limit the number by entering a value.

Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Contact Report – Summary by Campaign

contact-report-summary-by-campaignUse this wizard to get details about the summary by campaign id of a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Contact Report – Summary

contact-report-summaryUse this wizard to get details about the summary actions of a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Contact Report – Bounces

contact-report-bouncesUse this wizard to get details about the bounces of a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Limit – using a limit of 0 will download all activity for the contact. You can limit the number by entering a value.

Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Contact Report – Clicks

 

contact-report-clicksUse this wizard to get details about the clicks of a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Limit – using a limit of 0 will download all activity for the contact. You can limit the number by entering a value.

Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

l

Contact Report – Forwards

contact-report-forwardsUse this wizard to get details about the forwards of a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Limit – using a limit of 0 will download all activity for the contact. You can limit the number by entering a value.

Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Contact Report – Opens

contact-report-opensUse this wizard to get details about the opens of a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Limit – using a limit of 0 will download all activity for the contact. You can limit the number by entering a value.

Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Contact Report – Sends

contact-report-sendsUse this wizard to get details about the sent campaigns for a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Limit – using a limit of 0 will download all activity for the contact. You can limit the number by entering a value.

Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Contact Report – Unsubscribes

contact-report-unsubscribesUse this wizard to get details about the unsubscribes of a selected contact (email address) in Constant Contact. The contact is identified by the contact ID number. You can use the contact selector popup to pick a contact from those available or reference a value in a worksheet cell.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Contact ID – enter a contact id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

If the list is not overly large, you can also use the popup contact selection wizard to pick the contact of interest export_icon&16. Select the contact’s email in the popup and click OK to get the contact id.

Limit – using a limit of 0 will download all activity for the contact. You can limit the number by entering a value.

Since – If you are only interested in more recent items, you can use this option to pick a start date or time period (relative to today).

Bulk Export Contacts

bulk-export-contactsUse this wizard to export large numbers of contacts from a specific Constant Contact list.

Constant Contact bulk export requests are “batch” operations – they are submitted and you need to wait for the report to run before you can download the results. This function will wait a period of time for the export to complete, checking every 5 seconds, and then will download the data when it is ready. If the operation takes too long, use the bulk activity status wizard to see when it finishes, then use the bulk activity download wizard to get the results.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

List ID – enter a contact list id number or enter an Excel worksheet cell reference (use the button provided) top_left_expand_icon&16.

You can also use the popup list selection wizard to pick the list of interest export_icon&16. Select the list in the popup and click OK to get the list id.

Sort By – the downloaded file can be pre-sorted by email address or by descending date added. [2015-04-15 Constant Contact has confirmed the sort by email address option is reversed (z-to-a instead of a-to-z) and the descending date option does not work. These should start working properly when they fix their server]

Export Date Added – if you want the date that the contact was added to the list exported, check this box.

Export Added By – if you want to know how each contact was added to the list, check this box.

Column Names to Include – select the column names to include in your export. To select multiple columns, hold the Ctrl-key down while selecting items.

Bulk Export Status

bulk-activity-statusUse this wizard to check the status of a bulk export request.

Constant Contact bulk export requests are “batch” operations – they are submitted and you need to wait for the report to run before you can download the results. This function will check to see what the status of your bulk export requests. Use the bulk activity download wizard to get the results.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Status – used to filter which activity types you want to get. (optional)

Type – used to filter which activity types you want to get. (optional)

Bulk Export Download

bulk-download-exported-fileUse this wizard to download the results of a delayed bulk export operation.

Constant Contact bulk export requests are “batch” operations – they are submitted and you need to wait for the report to run before you can download the results. This function will download the results of a completed operation.

Account – you can select a specific account, use the * Default account, or use an Excel cell reference (click the button provided) top_left_expand_icon&16.

Activity ID – enter the activity id (or Excel cell reference) of the completed bulk export activity. Use the Bulk Export Status function to get the activity id number.

 

* Constant Contact Help

The Constant Contact Connector for Analytics Edge makes it possible to interact directly with the Constant Contact API, automating your downloads and updates. The connector supports many Constant Contact methods, including Campaign Reports, Contact Lists and Bulk Contacts Download. Read the Tutorial.

ribbon

To get started, install the connector and authorize access for your account.