List of people who have unsubscribed, then been sent an email | Community
Skip to main content
Julia_Rosentha3
Julia_Rosentha3
Level 2
November 20, 2018
Question

List of people who have unsubscribed, then been sent an email

  • November 20, 2018
  • 2 replies
  • 7694 views

Sorry if this has been answered elsewhere, but could I have some help please? I need to generate a list of people who have unsubscribed, and since then, have been sent an email.

But because there's no "then" option in the filter rules of a smartlist i think this might be impossible. The only filter rules currently available are "any" or "all",but they won't help in this case. And, even if I date stamped the unsubscribe action, I still wouldn't be able to setup the smartlist rules to say;

Unsubscribe = true

Was sent email = true

     Date = after unsubscribe date stamp

I know i could generate a list of unsubscribes and export with interesting moment fields, then do a clunky vlookup or IF statement to work this out, but preferred method is to do it in MKTO if possible.

Any ideas would be much appreciated! Thank you

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    Darrell_Alfons2
    Darrell_Alfons2
    Level 10
    November 20, 2018

    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

      SanfordWhiteman
      SanfordWhiteman
      Level 10
      November 20, 2018

      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.

        Darrell_Alfons2
        Darrell_Alfons2
        Level 10
        November 20, 2018

        Oh Man!! did not know that.

        Thanks Sanford, sorry @Julia Rosenthal​ guess it will not work.

        F
        Adobe Employee
        falvaresAdobe Employee
        Adobe Employee
        November 20, 2018

        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

        SanfordWhiteman
        SanfordWhiteman
        Level 10
        November 20, 2018

        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.

        F
        Adobe Employee
        falvaresAdobe Employee
        Adobe Employee
        November 20, 2018

        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

          Terms & ConditionsAccessibility statement

          Loading footer...