• Replies 6 replies
  • Subscribers 360 subscribers
  • Views 165 views
  • Users 0 members are here
Related

Triggered emails list question

Samantha Smith
$organization

Hi guys,

I've recently started getting to grips with Triggered Emails and putting together the lists to run them. I want to create a list of every constituent that booked to a certain show 3 days ago, with the ticket purchase acting as the trigger.

So far, I've managed to successfully pull a list of everyone who booked within 3 days using the criteria;
Ticket Production IN Ticket Production Season
Ticket Order Date >= DayRunDate -3

However when I use the Ticket Order Date criteria with a different operator to get only constituents who booked 3 days ago;
TicketOrderDate = DayRunDate -3

the count returns 0 constituents.

I thought from reading the documentation and my previous experience with Extractions and List Builder that this criteria would have given me the data I need, especially as Tessitura won't let me select any other operators such as Like or Has that may give an exact date. From checking the original list using the operator >= there are customers who booked exactly 3 days ago, I can see that there is data there, it just doesn't appear when I use the operator =. Has anyone else had this problem?

Sam

Parents
  • $organization

    Hi Sam -

    I'm just going to pipe in here to backtrack a couple of these replies. Normally you would use BETWEEN in a list when you want something for an entire day, but with triggered emails you generally want a dynamically created date which cannot be done with the BETWEEN operator sadly (if it can, someone correct me and make me very happy!)

    What you end up having to do to get around this is create TWO segments in your list:

      Ticket Order Date >= DayRunDate -3

      Ticket Order Date <= DayRunDay -3

    This looks really weird, but with both of them in there what it will do is translate it to something like:

      Ticket Order Date >= 12/13/2012 12:00:00 AM

      Ticket Order Date <= 12/13/2012 11:59:59 PM

    This gives you anyone with a ticket order on the entire day - and is the only way to set up your list if you want to use a dynamic date with your triggered emails.

    So Sam - you were half way there. 

    Hope that makes sense!

    Heather

Reply
  • $organization

    Hi Sam -

    I'm just going to pipe in here to backtrack a couple of these replies. Normally you would use BETWEEN in a list when you want something for an entire day, but with triggered emails you generally want a dynamically created date which cannot be done with the BETWEEN operator sadly (if it can, someone correct me and make me very happy!)

    What you end up having to do to get around this is create TWO segments in your list:

      Ticket Order Date >= DayRunDate -3

      Ticket Order Date <= DayRunDay -3

    This looks really weird, but with both of them in there what it will do is translate it to something like:

      Ticket Order Date >= 12/13/2012 12:00:00 AM

      Ticket Order Date <= 12/13/2012 11:59:59 PM

    This gives you anyone with a ticket order on the entire day - and is the only way to set up your list if you want to use a dynamic date with your triggered emails.

    So Sam - you were half way there. 

    Hope that makes sense!

    Heather

Children