Database relationships


Database relationships

Im new to CC and have looked at the videos and still have a few questions.  If these are answered in a particular resource Id be happy to take your direction.


- It appears Contacts are assigned to Lists.  If a contact is to be managed in more than one list how is it propagated?  

- How do Segments relate to Lists?  

- How do I add custom columns into the Contact list?  
- Can I get a report of Contacts that may be duplicates?  Or are found in multiple Email Lists?  


Again I have not seen any videos that address these kinds of questions so perhaps someone can point me in the right direction.  Thanks


Hi @Gail-Nick


We'd be happy to answer these questions about your contacts! A contact can be placed in more than one list because Constant Contact is designed to recognize contacts by their email addresses and remove duplicates. So if you schedule a campaign to all your lists at once, contacts will only receive it once. You can always see these contacts are on multiple email lists by exporting your contacts and including Lists in the fields you want to include in your export. Once you download this file you can see all the lists a contact is on.


On the other hand, segments relate to lists because you can then take these segments and add them into a list. Our segment tool allows you to customized groups of your contacts  based on specific criteria. This criteria can be email activity, list membership, or even custom contact details you may have created. I hope this helps!

Community & Social Media Support

Did I answer your question? If so, please mark my post as an "Accepted Solution" by clicking the Accept as Solution button in the bottom right hand corner of this post.

You're not alone on your email marketing journey. Connect with a Marketing Advisor to see how they can help you develop the right strategy for your business and get the most out of your Constant Contact experience.