Author Topic: filter list before sending  (Read 9640 times)

hilco

  • Posts: 11
    • View Profile
filter list before sending
« on: October 04, 2007, 06:08:09 am »
Hi,

What about the following feature:

Before sending an email to a particulair list, you get an extra option.

Send email to all users from this list (1), but don't send an email to users that are also on list 3.

this means that you compare the two lists, and that you are only sending to the users that are unique.

$unique = array_diff($list_1, $list_3);

I really need this to be able to send mail to my customers that didn't buy a particular product (every product has a list)

This is the only way my situation can be fixed.

hilco

  • Posts: 11
    • View Profile
filter list before sending
« Reply #1 on: October 04, 2007, 06:18:22 am »
wow, I now see that i've posted the exact same question a year ago!

http://listmailpro.com/forum/index.php?topic=1975.0

mike2

  • Posts: 193
    • View Profile
filter list before sending
« Reply #2 on: October 04, 2007, 09:56:29 am »
I don't use user selections much, can't this be done with that?

hilco

  • Posts: 11
    • View Profile
filter list before sending
« Reply #3 on: October 04, 2007, 10:19:55 am »
what do you mean with user selection?

mike2

  • Posts: 193
    • View Profile
filter list before sending
« Reply #4 on: October 04, 2007, 11:23:41 am »
On the left navigation buttons in your ListMail site, goto "User Selection".

Select the two lists and filter duplicates.

hilco

  • Posts: 11
    • View Profile
filter list before sending
« Reply #5 on: October 04, 2007, 02:53:11 pm »
that won't do it. I need to remove the duplicates temporarily, not saving one instance of them.

removing the duplicates is not possible though.

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
filter list before sending
« Reply #6 on: October 04, 2007, 11:32:14 pm »
Greetings,

I apologize for the delay - I've been working a little too passionately on the update. (I really want to get it out this year!!)

I see a post on a similar topic here:
http://listmailpro.com/forum/index.php?topic=1975.0

Have you figured out a hack that works for you?  Can you make a suggestion, perhaps, that could make the User Selection feature able to do what you want?

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

hilco

  • Posts: 11
    • View Profile
filter list before sending
« Reply #7 on: October 05, 2007, 12:22:52 am »
Hi,

I didn't create a hack yet, I was going to create a TEMP list with the `numlist` of 9999 but then I thought that people weren't able to unsubscribe from the original list. only from the TEMP list, and that's useless.

So I was thinking about moving the users to the TEMP list and move them back after my mailing was done, but that isn't slick either, because I now have to keep track of the list they came from and I don't want that.

The user selection should have another option:

AND don't mail users that are ALSO on list #

that will do the job

and to be honest, I am getting replies with people that are asking questions like:
Hey I already purchased that, aren't your records up to date?
and, stop mailing the same email multiple times!

and that I don't like at all! so please help :)

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
filter list before sending
« Reply #8 on: October 05, 2007, 08:08:45 am »
What you want to do should be possible with a User Selection of the type "Custom SQL", as mentioned here:

http://listmailpro.com/forum/index.php?topic=1440.0

Uniques can be filtered simply by adding "GROUP BY email" to the end of the query.  It is not possible to choose which list's user record has priority during the filter, so I recommend setting up your "Remove Link" to unsubscribe users from all lists.

Another way to email users based on products is using a single custom field to store which products they have purchased.  The following format would work:

product1:product2:product3:

(The colon character is used as a separator and should be included in the query)

You could then include or exclude users with User Selection or a custom query by comparing the string "product:".

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

hilco

  • Posts: 11
    • View Profile
filter list before sending
« Reply #9 on: October 05, 2007, 02:04:20 pm »
imho, I don't think it's really user friendly by doing a custom query, I would like to see a nice interface for this  :wink: