cancel
Showing results for 
Search instead for 
Did you mean: 

Report to track emails and contacts at the same time

Occasional Advisor

Report to track emails and contacts at the same time

I'm looking to make a Pivot Table in Excel, Or any way to make a report that properly tracks each contact/email as well as each campaign.

There already is an option when you go into each campaign to export the info, when you do this, you get each email/contact the campaign was sent to and that's all.

1. I'm suggesting/asking if you can add another column on the excel sheet with the status of each contact/email.

2. Also Id like to be able to see each contact, whether they are usually opening the emails or not etc. At the moment when you export all contacts, here too it only shows the contact info and emails, Id like for it to generate a column with the campaigns they participated in and the status.

3. Also by contacts there already is for unsubscribed a folder where it automatically sends all unsubscribed, can you make that for bounced emails, Did not open emails, so on so forth, as well. And here too, if there's a column with the info I described above it'll make it so much easier to track all emails and all the progress

 

Im surprised this hasnt been implemented in the past.

 

Please let me know if there currently are ways to do what i explained.

 

Thank you

7 REPLIES 7
Moderator

Re: Report to track emails and contacts at the same time

Hello @ReuvenR,

 

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

 

I will pass along your feedback/suggestions to our developers. As for being able to do this on your own; you can take a look at our API documentation. The reporting information for email campaigns is something you can retrieve using our API; then you can manipulate that data however you would like.

 

Our documentation can be located here. https://developer.constantcontact.com/docs/developer-guides/overview-of-api-endpoints.html

 

The specific documentation for retrieving email campaign reporting is located here. https://developer.constantcontact.com/docs/campaign-tracking/email-campaign-tracking-.html


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

Re: Report to track emails and contacts at the same time

Thank you,

I will go over it now and see if its at all helpful.

Is there a way though to manipulate the report i described through the API?

 

Occasional Advisor

Re: Report to track emails and contacts at the same time

Whats the API Key?

Moderator

Re: Report to track emails and contacts at the same time

Hi @ReuvenR,

 

The API key and Access Token are similar to a username and password for authenticating with our API. If you would like to create one please look over this article; it has step by step instructions on how to generate that information.

 

https://community.constantcontact.com/t5/Community-News/How-to-generate-an-API-Key-and-Access-Token/...

 

There is no way inside of Constant Contact to manipulate the reporting information the way you are currently looking to do. We are working to increase our reporting capabilities and offer more information and how you can interact with that data.


Regards,
Jimmy D.
Tier II API Support Engineer
Highlighted
Occasional Advisor

Re: Report to track emails and contacts at the same time

For some reason when im trying it now its saying its invalid paramiters.

Can you give me the updated api key and access token

 

Thank you!

Have a great day!

Moderator

Re: Report to track emails and contacts at the same time

Hello @ReuvenR,

 

As mentioned in my previous post the API Key and Access Token can be obtained by following the steps in this article. https://community.constantcontact.com/t5/Community-News/How-to-generate-an-API-Key-and-Access-Token/...


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

Re: Report to track emails and contacts at the same time

Thanks I got it!