Because of our account set-up, we have different customer ids with the same email address. I know this is not efficient, but fixing this has not been a priority. Additionally, for other business-related reasons, we cannot merge them.
There are multiple opt-in points on our website to a newsletter, and people are often signing up in multiple places.
We are building a drip welcome campaign for new subscribers.
The problem is that, since multiple IDs exist for some subscribers, multiple drip campaign emails can initiate per email address.
I’ve created a delay and a batch update in the drip campaign that tags any other concurrently created ids as having already been treated with the drip campaign. This will take care of someone who signs up once on one page and and then 5 minutes later on another.
What I don’t know how to deal with is someone who comes back a few weeks later and signs up again (believe it or not, this happens regularly). They’ll have a new ID and the concurrent batch update will not handle this case.
Ideally, I could call a lookup function that searches to see if a customer already exists with the same email address whose ‘received-drip-campaign’ attribute is “true.” If that is true, then they should not receive it again.
Any suggestions?