contact_reports for all contacts since a date

[RandyR8633]

Is there a way to get all of the activity for all contacts since a date using the API? For example, say I have 1,000 contacts on a list. I want to send an email and know how many opened, clicked, unsubscribed, bounced, etc.

It looks like I could get all 1,000 people and get their activity one at a time. I would prefer to get the activity for all contacts or "all contacts in a list" instead of calling them one at a time.

Is this possible?

Thanks,

Randy

[Courtney_E]

Hello RandyR8633,

Thank you for reaching out to Constant Contact API Developer Support. My team is here to assist outside software developers with questions about building into Constant Contact's API.

Currently, there are not any bulk activities available to accomplish what you are wanting in a more simplified manner. However, based on how you’d prefer to format your application (depending on the number of contacts/campaigns you wish to compare), here are two different ways you could gather the desired data:

Option 1:

1. Get /contacts ( narrow by “lists” parameter if desired).
   GET Contacts Collection:
   https://v3.developer.constantcontact.com/api_reference/index.html#!/Contacts/getContacts
2. Get /reports/contact_reports/{contact_id}/activity_details for each contact, including all desired tracking_activities_list parameters desired.
   GET Contact Activity Details:
   https://v3.developer.constantcontact.com/api_reference/index.html#!/Contacts_Reporting/getContactTra...
3. Append and sort data within your application's code as desired.

Option 2:

1. Get /emails (with parameter set for “after_date” if desired).
   GET a Collection of Email Campaigns:
   https://v3.developer.constantcontact.com/api_reference/index.html#!/Email_Campaigns/retrieveEmailCam...
2. Get /emails/{campaign_id} to get the campaign_activity_id(s) for each campaign from the previous results.
   GET Details About a Single Email Campaign:
   https://developer.constantcontact.com/api_reference/index.html#!/Email_Campaigns/retrieveEmailCampai...
3. Make calls to each specific “email_reports” activity desired for each specified “campaign_activity_id”.
   Email Reporting Overview:
   https://v3.developer.constantcontact.com/api_guide/email_reporting_overview.html
4. Append and sort data within your application's code as desired.

Please have a look and let us know if you have any other questions!

[user6365]

Hi,
I came across with the same issue. Option 1 is not efficient if we a lot of contacts like >200k. Option 2 is also not efficient when we have > 2k email campaigns. What would be helpful and more efficient if there's an endpoint with filter to return only contacts that were interacted such as opens, clicks,..etc, in a specific time range. For instance, we could send a request to ask any contacts that made any interactions from two days ago (updated_after parameter) and the response will include contacts' info, any campaign_activity_id associated with the contacts, and tracking_activities_list like "em_clicks", "em_opens", "em_bounces", and so on. This will help the integration much sufficient and faster.

Is there any endpoints on CC we can find to do that?

Thank you in advance.

[John__B]

Hello user6365,

Thank you for reaching out to Constant Contact API Developer Support. My team is here to assist outside software developers with questions about building into Constant Contact's API.

The V3 API does not currently have an endpoint with the functionality that you’ve described. The 2 methods that Courtney listed above are currently the best options for obtaining contacts that have interacted with your campaigns, however, we greatly appreciate you reaching out to us with this request. It has been submitted for review and consideration by our engineering team. Your feedback and experience with this request is essential to improving our product, so thank you for reaching out to us regarding this matter. 

Please let us know if you have any other questions!

Regards,