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 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
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?
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.
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.
For some reason when im trying it now its saying its invalid paramiters.
Can you give me the updated api key and access token
Have a great day!
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/...