Is constant contact a good fit for this use case.

[AlanJ7943]

We are going to run queries against a large SQL database to collect customer info for particular event driven email campaigns.

Examples would be all new customers would get an email with an offer if they come back again.  That same customer would never get the new customer email again but they will get other event driven emails that will not be sent to the other people in the list they originally listed with.

With Constant Contact being powered by persistent lists is there a way for me to efficiently do want I want to do?  Can I just create and destroy lists for each event driven campaign, send the emails, then destroy the list since  that list will only be valid for the context for which it was generated?

[John__B]

Hello AlanJ7943,

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.

Everything that you mentioned is definitely possible with Constant Contact. Contact lists can be created or deleted at any time. In terms of the example you provided with all new customers receiving an offer email once and then continuing to receiving other relevant event driven emails, you could utilize an automated email series with a list-join trigger. Once a contact is added to a list connected to an automated series in this way, they would receive a series of emails that you add in the order and delay periods that you configure in the series settings. Below I’m including a detailed support article with more information about automated email series:

Create an Automated Email Series:

https://knowledgebase.constantcontact.com/articles/KnowledgeBase/27935-Choosing-a-Trigger-for-Your-A...

In terms of our API, you could utilize various endpoints to add or delete contacts and contact lists. Below I’m including a quick start guide for our V3 API as well as our documentation on some of these endpoints.

V3 API Quick Start Guide:

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

Import Contacts Using a CSV File:

https://developer.constantcontact.com/api_reference/index.html#!/Bulk_Activities/contactsCSVImport

Import Contacts Using JSON Payload:

https://developer.constantcontact.com/api_reference/index.html#!/Bulk_Activities/bulkImportContactsJ...

Delete Contacts in Bulk:

https://developer.constantcontact.com/api_reference/index.html#!/Bulk_Activities/postContactDelete

POST (Create) a List:

https://developer.constantcontact.com/api_reference/index.html#!/Contact_Lists/createList

Delete a List:

https://developer.constantcontact.com/api_reference/index.html#!/Contact_Lists/deleteListActivity

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

Regards,