-
Re: List of people who have unsubscribed, then been sent an email
Darrell AlfonsoNov 20, 2018 10:21 AM (in response to Julia Rosenthal)
Julia,
You can use "data value changed" , attribute = unsubscribed , and then you will have date options.
And then was sent email = time frame.
Hope that helps!
Darrell
-
Re: List of people who have unsubscribed, then been sent an email
Sanford Whiteman Nov 20, 2018 10:30 AM (in response to Darrell Alfonso)Except the Data Value Changes activity is aged out after 90 days.
I would say there's actually way to do this accurately within or without Marketo if you haven't already been archiving Activity Logs.
-
-
Re: List of people who have unsubscribed, then been sent an email
Floyd Alvares Nov 20, 2018 10:51 AM (in response to Darrell Alfonso)Hi Darrell,
Welcome to the new Data Retention Policy: Marketo Activities Data Retention Policy - Under the Hood
Thanks,
Floyd
-
-
Re: List of people who have unsubscribed, then been sent an email
Julia Rosenthal Nov 20, 2018 2:26 PM (in response to Sanford Whiteman)Thanks Sanford, informative as usual
-
-
-
Re: List of people who have unsubscribed, then been sent an email
Floyd Alvares Nov 20, 2018 10:50 AM (in response to Julia Rosenthal)Hi Julia,
Is there any specific reason you are looking for this information? When a record is unsubscribed - and I hope you mean the system unsubscribe of Marketo, then there should be no reason why a record should receive any marketing related email.
Of course operational emails are different, but then again you would not send an operational email unless it was deemed "operational".
But other than that, there is no "easy" way to identify records that would have been sent an email after unsubscibing.
You should definitely leverage creating the "Unsubscribed date" field and "Last email sent date" and then you could query something like
Unsubscribe Date is "after" said date
Was sent email date "between" said date and today.
and run a month check to see if records meet this criteria and then export these from your Smart List.
Hope this helps.
Thanks,
Floyd
-
Re: List of people who have unsubscribed, then been sent an email
Sanford Whiteman Nov 20, 2018 11:22 AM (in response to Floyd Alvares)I hope you mean the system unsubscribe of Marketo, then there should be no reason why a record should receive any marketing related email.
Well, there is if they later resubscribe! And because of the lack of a permanent audit trail you can't after the fact determine the person's trajectory.
But, more likely in line with the OP's reasoning, it also can be useful to know just how many times you've ignored their Unsubscribed value. People can unreasonably twist the rules of what qualifies as Operational and rightfully get complaints.
-
Re: List of people who have unsubscribed, then been sent an email
Floyd Alvares Nov 20, 2018 10:58 AM (in response to Sanford Whiteman)Yes I totally agree to this Sanford.
Guess it is time to start building out an Unsubscribe Program that allows you to capture this information due to the lack of activity information.
Floyd
-
-
Re: List of people who have unsubscribed, then been sent an email
Julia Rosenthal Nov 20, 2018 2:25 PM (in response to Floyd Alvares)1 of 1 people found this helpfulThis was more of an example, to represent multiple times where i've wanted to build a smartlist with a similar condition. i.e. generate a list a list of people who did 'x' , but only AFTER doing 'y', but have never been able to find a decent solution. The unsubscribe example was just a simple way to represent this sort of scenario, we'd never actually have a need to run this exact smartlist [maybe for an audit or sense check]. I'm all for keeping tidy unsubscribe data, not worth the damage to do it any other way. If people don't want to hear from you, the worst thing you can do is keep contacting them.
Thanks for your reply. If i'm not mistaken, there's no way of running a list similar to what i've described here, in MKTO, correct? The only way is to create a few date/time stamps for various activities, and export to excel and do it there, correct?
Thanks again
Jules
-
Re: List of people who have unsubscribed, then been sent an email
Alex Venus Nov 21, 2018 1:21 AM (in response to Julia Rosenthal)Wouldn't the lead activity log act as your audit trail should you receive a complaint?
I appreciate this isn't a solution to your question, but this shouldn't be an issue due to system.unsubscribe.
I have witnessed marketers labelling promotional emails as 'operational' in my time though, so could be worth using the setup listed by Floyd.
-
Re: List of people who have unsubscribed, then been sent an email
Sanford Whiteman Nov 21, 2018 8:49 AM (in response to Alex Venus)It can't be your audit trail as-is, because the most important activities in this case are aged out.
If you keep an offline archive then you can use it as a reference (although technically it could be altered in transit, it's a good faith effort).
-
Re: List of people who have unsubscribed, then been sent an email
Alex Venus Nov 21, 2018 8:52 AM (in response to Sanford Whiteman)Ah so after 90 days they will disappear from the activity log too? Yikes.
-
Re: List of people who have unsubscribed, then been sent an email
Sanford Whiteman Nov 21, 2018 11:39 AM (in response to Alex Venus)The Filled Out Form will last for 25 months. But the proof of their Data Value Change only lasts 90 days. In my experience in regulated industry it's not sufficient to have a partial log, or really even to have to go to Marketo ad hoc at all. It needs to be stored offline continuously, at least every week.
-
Re: List of people who have unsubscribed, then been sent an email
Erek Bond Dec 5, 2018 4:30 PM (in response to Sanford Whiteman)I realize this is off the original topic, but what suggestions do you have for storing the activity log offline?
-
Re: List of people who have unsubscribed, then been sent an email
Sanford Whiteman Dec 5, 2018 8:45 PM (in response to Erek Bond)I realize this is off the original topic, but what suggestions do you have for storing the activity log offline?
Do you mean literally suggestions for storing? (That is, not the retrieval part but permanently storing after the file is downloaded.)
If you need both storage and reporting, I recommend storing activity logs in a timeseries db (OpenTSDB, etc.). People often make the mistake of trying to use a traditional SQL database, which is not the right fit.
However, for pure archival, a tsdb may be too obscure (like if regulators need to query it). A tsdb also rearranges the original data via compression and is geared toward aggregation, rather than individual lookups. So if you need a lossless one-to-one mirror of an Activity Log, you'd want a partitioned SQL table.
-
-
-
-
-
-
-