I have Sage CRM. It has a section called Groups/Target Lists. This is my source of data. I generate lists and at the moment, they are exported to Excel and then uploaded to CC and that is where it ends.
What I would like to do is to be able to send the list directly from CRM to CC and then get click-through/bounce responses to individual contacts, and then the ability to draw stats back on a list level, so percentage of click-throughs, bounces, etc.
Thank you for reaching out to Constant Contact API Support.
The best option it sounds like would be to use our API to bulk import contacts. You would make a POST request to https://api.constantcontact.com/v2/activities/addcontacts with your API Key as a parameter, and your Access Token as an Authorization header. Detailed documentation on this call can be found here: https://developer.constantcontact.com/docs/bulk_activities_api/bulk-activities-import-contacts.html
As for viewing tracking information, you can pull either a Contact Tracking report to get the tracking for a contact individually (https://developer.constantcontact.com/docs/contact-tracking/contact-tracking-all-activities-api.html), you can pull Email Campaign Tracking Reports to see the reporting for an individual email campaign (https://developer.constantcontact.com/docs/campaign-tracking/email-campaign-tracking-.html).
Please let me know if you have any other questions!
Tier II API Support Engineer
Ok thanks for that. So in an example, redaing the API documentation, the end user would first have to create the lists in CC so that when I send the data over, I say which list is to be the target one. Is that right? So, from start to finish, the user would:
My guess is that if the above were right, I would need a way in CRM for the user to track the name of the list. Can you create lists when uploading contacts? If so, I could use the name of the list in CRM.
I would need to have some sort of process to write back the opt-outs in CRM as well.
Am I right in the process above?
You can create a Contact List name through the API so the customer does not have to do this step first you can do this if you need. (https://developer.constantcontact.com/docs/contact-list-api/contactlist-collection.html?method=POST)
Otherwise your process listed I would say is correct. As far as tracking opt-outs when you get the reporting information from one of the two methods David previously provided if you see any opt-outs/unsubscribes listed there that would indicate that you will need to update your database for an opted-out contact. Depending on whether you are getting the information on a contact level or campaign level will determine if you already know who the contact is or not.