Skip to Content
Menu
This question has been flagged
2 Replies
494 Views

Struggling with Email Marketing which doesn’t have the intelligence to filter out duplicate target email addresses, when using multiple mailing lists to invite people to an event. Ideally, when adding a new Mailing the the Email-marketing Campaign, one would expect that a recipient filter can be composed that checks if a particular email has already been sent to that recipient.

How does one deal with people (who subscribe to multiple mailing list and) who need to be invited to an event just once? 

  • Can a ‘target email address filter by email ID’ be composed so only those people in the subscribed mailing lists, who haven’t yet received the invite, will receive the email invite to the event?
  • How do you make a query over all mailing lists, so that it can be used as an target email mailing list with unique email-ID's, to be used to invite them to the event?

Regards,

Bart

Avatar
Discard
Author Best Answer

I have been freshly re-thinking my problem, and can solve it quite simply:

  • Email Marketing DOES filter duplicates, but only WITHIN one Mailing, not within a Campaign. (Maybe Marketing Automation does this also within a Campaign?)
  • In the recipient Filter, there is no way to combine recipients from “Event Registrations” and “Mailing Contacts”
    • Importing the registrations as contacts in a Mailing List to workaround this problem does not help, as the Mailings’ recipient Filters take the Mail-ID, not the Email itself to deduplicate the target recipient set.
    • One has to manually label each mailing contact corresponding to the contact registered to earlier Events as a member of a manually created MailingList:“Contacts from earlier Event Registrations”, otherwise duplicate contacts with same email address are not seen as duplicates!!!

e.g. 12 Mailing Lists to be sent in phases:

  • Week1: List 1-4
  • Week2: List 5-8
  • Week3: List 9-12

Deduplication works over ALL contacts in ALL Mailing lists like this:

  • Send Mailing1 in Week1 to contacts in List 1-4
  • Schedule Mailing2 for Week2 to contacts in List 5-8 AND not in List 1-4
  • Schedule Mailing3 for Week3 to contacts in List 9-12 AND not in List 1-8

Avatar
Discard
Best Answer

Basically, you could use odoo studio to make a check on the other lists if a specific email address already exists. The requirement you are expressing is very special for your needs as many companies maintain multiple lists for different purposes with people being part of each list.

In order to invite each person only once, you could create a new list. You export all the lists to this very new list and delete duplicate using excel. Then you can upload the contacts in that new list that will for sure only contain each name once.


Good luck

Eva Pinter

Avatar
Discard
Author

Hi Eva, did it as per your suggestion via Excel PowerQuery. Would you happen to know how to export a list from Odoo that tells me from which Mailing List the Email was picked when it was sent?

Author

I meant to say, not from which Mailing list, but by which defined "Receiver" the Email was selected? (Event Subscription, Mailing List, Mailing contact,....)