Newsletter Logs

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
9/16/2013 5:05:22 PM
Gravatar
Total Posts 26

Newsletter Logs

Hi guys

Is there a log for when emails are unsubscibed from a newsletter? I have a client organisation who is complaining of emails dropping off a newsletter, I suspect the members are unsubscribing, unless there are other reasons for emails coming off a subscription? Anyway I can answer their queries would be great.

​I have bought a couple of beers in advance thanks!

Hurricane

9/17/2013 12:04:12 PM
Gravatar
Total Posts 18439

Re: Newsletter Logs

Hi Hurricane,

Thanks for the beers! Much appreciated as always!

If they are truly getting unsubscribed then before the subscription row is deleted from mp_LetterSubscribe table it is logged into the mp_LetterSubscribeHx table for history of the unsubscribe activity. But there is currently nothing in the UI to view that data so you would have to access the database directly.

Another thing to understand about newsletter subscriptions is if an anonymous user (ie not logged into the site and possibly not even yet a site member) subscribes via the Newsletter Sign Up Module then a verification email is sent to the address to activate the subscription. If they never click the link then they don't get verified and newsletter is only sent to verified subscriptions. So an email could be in the list but not verified and therefore no mail is sent to it. However site members who sign up while logged in are considered already verified.

Another thing to consider is whether the message is getting blocked by spam filters or landing in the spam inbox without being noticed by the subscriber. It is getting more and more difficult these days to send any kind of bulk email without getting flagged as spam and users may just think they are not getting the newsletter but it is landing in the spam box. Recently gmail was blocking all of the forum notifications sent from this site or if not blocking it was flagging it as spam even though it was valid subscribers to the forums.

Hope that helps,

Joe

9/17/2013 8:24:06 PM
Gravatar
Total Posts 26

Re: Newsletter Logs

Thanks Joe, I will check the table of mp_LetterSubscribeHx, I can see the email address in the log for earlier newsletters (which is very cool by the way) but it is dropped off in further newsletter logs, so I'm guessing it has to be an unsubscribe.

Thanks again

Hurricane

9/17/2013 9:11:51 PM
Gravatar
Total Posts 26

Re: Newsletter Logs

Hi Joe

Still a bit puzzled, there are multiple entries for the email address concerned in the table mp_LetterSubscribeHx with the right letterinfo, they are all verified but the address does not come up in the subscribers admin facility when searched. Any more advice you can give me? Do we see anything that might identify if they unsubscribed, my client is worried email addresses may be dropping off on their own.

Thanks again

Hurricane

9/18/2013 6:55:06 AM
Gravatar
Total Posts 18439

Re: Newsletter Logs

Right mp_LetterSubscribeHx is the history table and there is no UI to view it. It is a history of unsubscribes. You will not see this data in the UI.

Current subscribers are in the mp_LetterSubscribe table which is what you see from the UI.

When a user clicks unsubscribe the subscription row from mp_LetterSubscribe is copied into mp_LetterSubscribeHx with the current date as the end date showing when they unsubscribed and then the row is deleted from mp_LetterSubscribe so they are no longer subscribed.

​So when you see the email multiple times in mp_LetterSubscribeHx that means he has subscribed and then unsubscribed multiple times.

I would check the newsletter and make sure that the unsubscribe link is clearly labeled and that there is not an unsubscribe link that is labeled incorrectly since the user is apparently clicking it and does not seem to realize he is unsubscribing.

9/18/2013 5:44:54 PM
Gravatar
Total Posts 26

Re: Newsletter Logs

Thanks so much Joe thats very helpful, much appreciated.

You must sign in to post in the forums. This thread is closed to new posts.