Page 1 of 1

Unsubscribe Date

PostPosted: Wed Nov 19, 2014 9:35 pm
by Osensnolf
How do I export a list of people based on their unsubscribe date?

I know how to export anyone who has unsubscribed, but if I want to run it across all list of people who unsubscribed today, how do I do that?

Also, if someone clicks the unsubscribe link yesterday and today, which date will show in the system?

THanks

Re: Unsubscribe Date

PostPosted: Sun Aug 30, 2015 3:43 am
by mmm
One way could be to run this directly in the MySQLadmin as a triggered process.

Re: Unsubscribe Date

PostPosted: Wed Sep 02, 2015 3:22 am
by MaBoRaK
mmm wrote:One way could be to run this directly in the MySQLadmin as a triggered process.


This is a good idea to have always the last unsubscribers :D also, you can use the column "fbl" in the unsubscribe table, if the "fbl" column Equals 1 then the unsuscribe was processed by FBL.

Re: Unsubscribe Date

PostPosted: Wed Sep 02, 2015 5:02 pm
by mmm
Osensnolf wrote:How do I export a list of people based on their unsubscribe date?

I know how to export anyone who has unsubscribed, but if I want to run it across all list of people who unsubscribed today, how do I do that?

Also, if someone clicks the unsubscribe link yesterday and today, which date will show in the system?

THanks



Not sure if you can unsubscribe twice!?! ;)

Re: Unsubscribe Date

PostPosted: Wed Sep 02, 2015 5:07 pm
by mmm
MaBoRaK wrote:
mmm wrote:One way could be to run this directly in the MySQLadmin as a triggered process.


This is a good idea to have always the last unsubscribers :D also, you can use the column "fbl" in the unsubscribe table, if the "fbl" column Equals 1 then the unsuscribe was processed by FBL.



The FBL=1 may need a special bribe to stay on ;)
Which may be truly a good sort criterion for more than this reason. Perhaps unsubscribers are even clustered, then such areas need special marketing attention.