This is a public Forum  publicRSS

Topic

    Michael Bailey
    Segment based on mailing category
    Topic posted February 23, 2012 by Michael BaileyJourneyer, last edited March 5, 2012 
    265 Views, 2 Comments
    Title:
    Segment based on mailing category
    Content:

    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?

    Mike.

    Answer

     

    • Alex Patison

      Michael,

      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.

      Alex

    • 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.

      Mike.

     

    All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.