Extracting all Campaign Activity to a File.....for load to External Database

New Member

Extracting all Campaign Activity to a File.....for load to External Database

Hi All,

I am new to Constant Contact and am currently evaluating whether Constant Contact provides all of the capabilities I am looking for.  The biggest capability I am looking for is to be able to extract all activity(send, open, click, opt, bounce, etc.) across all of my camapigns so that I can load it into a seperate database for analysis, more complex reporting, and for future segmentation based on user acitivty.

In looking through some of the API documentation it appeared that activity could only be downloaded for a specific campaign or for a specific contact.  Can this be altered so that activity can be downloaded across all camapigns and for all users within my account?

If someone could let me know if and how(sample code) this could be accomplished it would be much appreciated.




CTCT Employee

Re: Extracting all Campaign Activity to a File.....for load to E

Hi Justin,

We do not have the ability to create a bulk activity to export your campaign reporting data. Currently, reporting data can be returned for a specific campaign by Obtaining a Campaigns Results, which will give you reporting statistics for a specific campaign. Alternatively, you can Obtain Campaign Results for a Contact which will give you reporting details for an individual contact across multiple campaigns.


I hope that this information helps. Please let me know if you have any other questions or concerns regarding this. Thanks.

David J

New Member

Thanks for the reply.  Is

Thanks for the reply.  Is this functionality that may be coming down the road or is it something that is really not being considered?

Also, for 3rd party apps that provide detailed reporting about Constant Contact activity are they doing this through existing APIs or do they have access to this data that is not open to all users?

CTCT Employee

api questions


I can send an email to our web services engineers with this feature request; however I am not sure what the timeline would be for something like this.

Currently all third party apps must use the same existing API's that are available to all users.


Benjamin Soder
NOC Analyst
Constant Contact
Developer Portal

View API documentation, code samples, get your API key.

Visit Page

Constant Contact Would Like To Hear From You!

We want to hear from customers like you about your favorite features and how they have helped your business or organization. Tell us by answering a few questions in...

Read More