Hi all,

We have a need to run reports to see how many people have subscribed or unsubscribed on a day by day basis. Is there a way to do this?

Thanks

To report on a day by day basis you will want to create a date variable.  You can then use this variable in your report by defining a column definition such as date_group(transactions.created, $date_variable).  When using the variable in a column you will also be forced to create a date filter that limits the time range for the report.

There are a couple different ways that you could show the opt-out transactions.  The most complete report would utilize the transactions table as that will show all end-user actions as well as agent actions that could have changed the opt-in status.  If you are just interested in seeing how many people are opting out of mailings you could create a report that filters off of entries of type unsubscribe on the marketing activities (ma_trans) table.  In this case, your column definition for the date would look like date_group(ma_trans.created, $date_variable).  I have attached a simple report that shows every day in the last month and the total number of unsubscribe transactions for that day.

Aaron

Opt Outs By Day 101428.xml (18 kb)