This is an unusual question, and I realize there may not be a solution, but I'd appreciate any feedback: We have a large number of contacts who appear on multiple lists. I am trying to understand if there is a way to differentiate/export more information about their list membership from the CONTACT side (i.e., I'm not looking for campaign activity or anything like that, I want this data across all contacts regardless of activity). For example: when I export contacts, list memberships appear in one column, comma separated. For those contacts on multiple lists, the order their list memberships appear in the export does not follow any apparent logic (alphabetical, etc). Is there any meaning we can construe from the order in which the lists export, e.g. do they correspond to the order in which the contact joined the lists? (Relatedly: is there a way for each list to receive its own column in the contact export, rather than all lists appearing together in a single cell?) Or, is there another way to export a large number of contacts with richer data about list membership (e.g., date they joined a list)? I am aware of the Contact Added/Contact Updated fields and wonder if similar data is stored for list membership. Appreciate any feedback!
... View more