cancel
Showing results for 
Search instead for 
Did you mean: 
Constant Contact wants to help you succeed! We’re celebrating our professional service programs on the Constant Contact Community this month and you have a chance to try one of the services for free! Learn more.

To get a excel file or the report file of sent email campaign using an API

Occasional Contributor

To get a excel file or the report file of sent email campaign using an API

I'm trying to find a way to get the excel or report file of all the sent email campaigns using an API call. I do see that, there is reporting as a service which allows us to download the excel or file manually. In order to automate the same it would be helpful if someone could direct me to an API.

3 REPLIES 3
Highlighted
Moderator

Re: To get a excel file or the report file of sent email campaign using an API

Hello @RebeccaMonteleone,

 

Thank you for reaching out to Constant Contact's API Support.

 

You can find our v2 API documentation here: https://developer.constantcontact.com

 

You will want to specifically look at the sections of the API docs related to https://developer.constantcontact.com/docs/campaign-tracking/email-campaign-tracking-.html.

 

Please keep in mind the API does not provide a single Excel file like our website UI does. It will provide the raw data in a JSON format which you can then put in Excel or any other database you wish to use.


Regards,
Jimmy D.
Tier II API Support Engineer
Occasional Contributor

Re: To get a excel file or the report file of sent email campaign using an API

Hello @Jimmy!

 

Thank you for your reply. I think I didn't justify on the explanation of my question. What I'm looking for is the complete details that we are able to access in case of report download. The information we get on the report comprises of all the demographic information along side other details which I'm  unable get it through the email tracking API. Is there any way that I can get the whole information that's appearing in the form excel to be accessed with the help of an API? I have attached the sample data that I'm speaking about.

image.png

It would be helpful if you could direct me on this.

 

Regards,

Rebecca

 

Moderator

Re: To get a excel file or the report file of sent email campaign using an API

Hi @RebeccaMonteleone,

 

The API does not give the data in the same way. Any of the reporting endpoints will provide you with the contactID and not the email address, name, etc. of the contact. You would then use the contactID to retrieve the details of the contact and put that information together in your database.

 

The API is designed to provide the information so you can populate it on your end and then manipulate it in any manner you need. Here is an example of how I might accomplish what you are looking to do.

 

I would GET all campaigns that have been sent so you have those campaignIDs.

https://developer.constantcontact.com/docs/email-campaigns/email-campaigns-collection.html?method=GE...

 

Then you can use the campaignIDs to GET the sent reports.

https://developer.constantcontact.com/docs/campaign-tracking/send-activities-collection.html?method=...

 

The sent report shows you both the contactID and the email address. If you then want all of the information you have for the contact (such as names, physical address, etc.) you can GET the contact information.

https://developer.constantcontact.com/docs/contacts-api/contacts-resource.html?method=GET

 

You would store all of this data in your own database and put it together in whatever report format that you want.


Regards,
Jimmy D.
Tier II API Support Engineer