• Replies 6 replies
  • Subscribers 360 subscribers
  • Views 161 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

  • $organization

    Try using TicketOrderDate between DayRunDate -3 and DayRunDate -3.  If you use date = X the system will add a time stamp to the end of the date and because you have no sales with the exact time stamp you are getting no results.  If you use between with the same dates it will capture all times that day.

  • $organization

    You should reach out to Jamie O'Brien at New 42nd Street.  She is a whiz at setting up triggered emails :)

  • $organization

    For dates you should always use logical operator between in List Manager …

     

    From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Samantha Smith
    Sent: Friday, December 14, 2012 8:05 AM
    To: Sabina Spilkin
    Subject: [Tessitura Next Generation Forum] Triggered emails list question

     

    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




    You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

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

  • $organization in reply to Heather Laidlaw Kraft (she/her)

    Thanks for the tips guys!

    I tried using 2 separate segments as you suggested Heather and it works perfectly. Like you say, it looks strange and it wouldn't have occurred to me as I'm so used to using 1 segment per requirement, but it makes sense now I've got it up and running. Thank you!

  • Former Member
    Former Member $organization in reply to Samantha Smith

    yep - I had this same issue. 

    But when I used 2 parameters of 

    Ticket Date <= DayRunDate -1

    TicketDate >= DayRunDate -1


    I was able to pull just folks that attended yesterday's show(s).

     

    Thanks!

    Lisa Girard

    Arvada Center