Thanks for the thorough reply and explanation of the thought process. I agree with you conceptually - just trying to figure out the best way to get to that end point. It's not that important that we address the child by name - just generally by grade. However, occasionally we might use this to look up a child to find out who their parent/email is - but that's a minor need. We receive the data en masse each year in an excel spreadsheet where each row is a student and then in that row we can have between 1 and 5 email addresses. But for now we can just solve for one email address. The issue comes up with siblings so in our excel sheet we may have 3 rows (3 different students who are all siblings in different grades) and they all have the same email address (these are elementary students so we have a parent email). Grade is also a value on their excel row. So an example of 3 rows I might have are: John Smith - Grade 2 - mamasmith@... Jane Smith - Grade 4 - mamasmith@.... Jim Smith - Grade 5 - mamasmith@.... If I uploaded these 3 records as is, my understanding is I would end up with one constant contact record with the name and grade of whichever record is the final one processed. At a minimum what I need to end up with is a constant contact record with mamasmith email and then either tags for each grade they are in, or mamasmith to be in 3 different lists, one for each grade she has kids in. If we can get the kids names in too, great - but I could live without it if I can just tie the parent to grades in as automated a way as possible. I'm trying to figure out the quickest way to do this without having to go one by one through each record and tagging each grade they are in before import. Truly appreciate any insight or advice you can provide. I'm quite adept at Excel so don't mind doing some pre-clean up work to the sheet before uploading if necessary - just trying to avoid the one record at a time.
... View more
We would like to use Constant Contact for our School PTA but are wondering how to set up this scenario. Child A has an email address (that of Parent A). Their sibling Child B (in a different grade) has the same email address (that of Parent A). Some communications are school wide (should go to both children) but some are grade specific (should only go to child in that grade). Since Constant Contact uses email as their unique key - how do I set up these two separate students. Setting up the parent as the unique contact and then custom fields with each child will not work for us as some families have 4-5 children in the school and we don't know the parent linkage (systematically) - we'd have to somehow manually go through every single record and somehow determine all of the parent's children. Is there not some way to use something else as a key field - such as combination of child's name + email address? Is there some other solution we are missing?
... View more