search

tbar0970 / jethro-pmm

Jethro Pastoral Ministry Manager
GNU General Public License v3.0
36 stars 26 forks source link

FR: MailChimp sync merge should merge first names of contacts with the same email address #891

Open jefft opened 1 year ago

jefft commented 1 year ago

Occasionally a couple share an email address, and we'll have two persons in Jethro:

"John Doe" <johnandjane@gmail.com>
"Jane Doe" <johnandjane@gmail.com>

When Jethro's Mailchimp syncer syncs to Jethro, only the first contact (e.g. "John Doe" <johnandjane@gmail.com>) gets synced, and Mailchimp emails get addressed only to John.

It would nice if the Mailchimp syncer could concatenate names (group_concat(firstname, ' and ')) of joint accounts, and sync only one combined address, which would then (in Mailchimp) be "John and Jane Doe" <johnandjane@gmail.com>

tbar0970 commented 1 year ago

The tricky part is that the mailchimp sync includes merge tags (custom fields in Mailchimp) for gender, congregation, age bracket and status. These could all be different for the two people.

Did somebody notice because they were using a first_name keyword in an email or something like that?