Determining when a user started bouncing

[user61100]

Hi,

I'm trying to find an easier way to clean up one of our mailing lists. There are many bounces on it and they need to be investigated. 

I want to tag users who have been bouncing for more than a certain amount of time, for example, one year. Then I will bulk delete them from our database.

Right now, we have only two choices:

1. Go to each email send and look at the engagement history of each account one by one. This is tedious and LOOOOONG!
2. Select everything and delete them. This is not a good idea either because it may be due to something else (e.g. changing email addresses). And since we have very close contact with the members of our list, we can almost always reach out to them manually.

What I would like is a way to query the database with something like "Find me all the accounts that have been bouncing weekly for more than 1 year." (Hmm, that's a good idea for an AI-backed database query system…) Then I would bulk-delete those only. And the rest I could investigate manually or restrict more so I have fewer to do manually.

Is this already possible? If so, how would I go about doing that?

Thanks,

L

[Courtney_E]

Hello user61100,

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.

Constant Contact provides developers with free access to our V3 API endpoints for developers building their own application for integration. You can get started using our API by visiting our documentation here:

https://v3.developer.constantcontact.com/api_guide/getting_started.html 

Additionally, you can utilize our API Reference Page to find body schemas & values, as well as test the functionality of our available endpoints to see how they will work once programmed within your application:

https://v3.developer.constantcontact.com/api_reference/index.html

When building your program, the endpoint calls for retrieving the bounces might look something like this:

GET a Collection of Email Campaigns
https://v3.developer.constantcontact.com/api_reference/index.html#!/Email_Campaigns/retrieveEmailCam...

GET Details About a Single Email Campaign

https://v3.developer.constantcontact.com/api_reference/index.html#!/Email_Campaigns/retrieveEmailCam...

GET an Email Bounces Report

https://v3.developer.constantcontact.com/api_reference/index.html#!/Email_Reporting/getBounces

GET an Email Sends Report (to get the corresponding date/time of the send/bounce)

https://v3.developer.constantcontact.com/api_reference/index.html#!/Email_Reporting/getSends

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

You can also reach our team directly/securely via email at webservices@constantcontact.com