Maborak Technologies - Community Forum

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

One way could be to run this directly in the MySQLadmin as a triggered process.

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 also, you can use the column "fbl" in the unsubscribe table, if the "fbl" column Equals 1 then the unsuscribe was processed by FBL.

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!?!

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 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.