Author Topic: User Selection - All on List X but NOT List Y  (Read 3076 times)

boundless

  • Posts: 54
    • View Profile
    • http://www.wealthbeyondreason.com
User Selection - All on List X but NOT List Y
« on: May 06, 2005, 04:42:03 pm »
Maybe I don't know enough about SQL to determine whether this can already be done, but I'd love to be able to do a user selection based on this criteria:

All users who are on list X who are NOT on list Y

I would use this ALL the time because of the way my leads are generated through third-party promotions.

Can this already be done?

Bob
================================================

Bob Doyle
Wealth Beyond Reason!
Wealth, Science, and the Law of Attraction
http://www.WealthBeyondReason.com

===================================================

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
User Selection - All on List X but NOT List Y
« Reply #1 on: May 06, 2005, 05:19:32 pm »
Bob,

I don't think this can be done with the current rule-based sending or a slight variation - the SQL query will have to be compounded.  In essence, we want the values "Not Active", "Not Unconfirmed", etc. in the first dropdown on the user selection page.  I haven't been able to figure out the SQL yet but will make another effort ASAP. It's refreshed in my work notes and I will take a look right now to see if I come up with some new information.

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

boundless

  • Posts: 54
    • View Profile
    • http://www.wealthbeyondreason.com
User Selection - All on List X but NOT List Y
« Reply #2 on: May 06, 2005, 06:03:36 pm »
Quote from: "DW"
Bob,

I don't think this can be done with the current rule-based sending or a slight variation - the SQL query will have to be compounded.  In essence, we want the values "Not Active", "Not Unconfirmed", etc. in the first dropdown on the user selection page.  I haven't been able to figure out the SQL yet but will make another effort ASAP. It's refreshed in my work notes and I will take a look right now to see if I come up with some new information.

Regards


To be crystal clear with real examples:

List 11 is a leads list.

List 59 responded to a promotion. They may already be on list 11.

I want to send follow-up to list 59, unless they are on list 11.

A while back you wrote me a "remove prospects" list. Maybe I could put that in a cron job that runs before each daily mail? I could define the "removal" parameters in the cron job that runs before the mail goes out.

Does that sound like that would work?


:)

Bob
================================================

Bob Doyle
Wealth Beyond Reason!
Wealth, Science, and the Law of Attraction
http://www.WealthBeyondReason.com

===================================================

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
User Selection - All on List X but NOT List Y
« Reply #3 on: May 09, 2005, 03:20:48 am »
Bob,

A delete script would be very simple and could be run before dailymail.  The complexity with performing the 'Not Active' user selection is because I'd like for it to be all in one query.  With a custom script we can perform many queries to easily perform the removal.

So, what is it you would like to do?  Before sending to list 59 do you want to remove all users who are also on list 11?  Won't this interfere with future mailings?

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

boundless

  • Posts: 54
    • View Profile
    • http://www.wealthbeyondreason.com
User Selection - All on List X but NOT List Y
« Reply #4 on: May 09, 2005, 05:05:02 am »
Quote from: "DW"
Bob,


So, what is it you would like to do?  Before sending to list 59 do you want to remove all users who are also on list 11?  Won't this interfere with future mailings?
Regards


Any follow-up I do with list 59 would either be about them becoming a customer or joining list 11 - so if they're already on list 11, they don't need the follow-up from list 59.

You already wrote me a "remove prospects" script a while back. I just want to know if I can put that in my cron before my daily mail.

Bob
================================================

Bob Doyle
Wealth Beyond Reason!
Wealth, Science, and the Law of Attraction
http://www.WealthBeyondReason.com

===================================================

mr.trevor

  • Posts: 125
    • View Profile
User Selection - All on List X but NOT List Y
« Reply #5 on: May 09, 2005, 10:33:23 am »
Excuse my comments but I am just trying to clear up my own thoughts on what is asked for here.
This sounds like when setting up a new 'second' list, of having an option in that setup, of selecting to automatically remove the subscriber from a previously predetermined 'first' list.
If that is correct, then a new subscriber to the 'second' list would be simply moved from the 'first' list (prospects) to the 'second' list (customers). (Or deleted from list one and added to list two.)
Or, maybe you don't want to remove from the first list and I have just lost the plot (again..!).
TrevorW