Topic
Segment based on mailing category
Topic posted February 23, 2012 by Michael Bailey, last edited March 5, 2012
257 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
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
Be the first to rate this
|
Sign in to rate this
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.
Be the first to rate this
|
Sign in to rate this