This is a public Forum  publicRSS


    Michael Bailey
    Segment based on mailing category
    Topic posted February 23, 2012 by Michael BaileyExplorer, last edited March 5, 2012 
    270 Views, 2 Comments
    Segment based on mailing category

    I want to be able to create a segment based on the category/type of mailings that have been sent previously. E.g. create a segment that shows all contacts who received an "Offer" mailing in the last 6 months. Or contacts that have received a "Newsletter" mailing in the last 2 weeks.

    Anyone have any ideas of how to do that?




    • Alex Patison


      How are you identifying these mailings in the first place? How do you know a mailing is an "offer" or a "newsletter"?

      You can't have a customer field/CO on a mailing, just wondering if the name or other mailing attribute gives a clue.


    • Michael Bailey

      Hey Alex,

      The only way I could get this to work is to have a consistent naming convension in for the mailings and use a segment filter of instr(ma_trans.mailing_id,'naming convension') = 1.

      This works, but only if naming convensions are strickly adhered to.