I'm trying to track the connections between our promotions and orders a bit more loosely than just by the source associated with the order: my idea was to look for every event in T_PROMOTION where the customer had engaged the promotion in some way (say, opened an email, or clicked on a link) and then look for any orders by that customer within a certain period after the activity.
I assumed that I would look for orders after the activity, but it turns out that the overwhelming majority of promotions associated with orders seem to have their activity logged about 4 minutes after the order date. When it comes to our online ticket sales/email promotions most, though not all, do appear to occur in a reasonable sequence, but I was curious if anyone could tell my why so many promotions generally have their activity logged after an associated order?
I'm also a little disappointed that T_PROMOTION only logs one response and response date per source per customer: it means that any prior activity is lost to the latest action, so a user who opens an email, then opens it again later will lose the first email record, and all record of opening will be lost if they click on a link, and then _that_ will be lost if they later forward it to a friend.
Gavin,
What email provider are you using? WordFly or Mail2? We use Mail2 and get this information from there. They have “engagement” reports that you can query on from their app. Then we save that as a “saved search” or import the list back into Tessie.
Gloria Ormsby Director of Information Systems Flynn Center for the Performing Arts 153 Main Street Burlington, VT 05401 802-652-4506 www.flynncenter.org www.flynntix.org Follow us on Facebook Follow us on Twitter
Check out our: Performances Special Events Classes Gallery School Programs
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gawain Lavers Sent: Tuesday, September 10, 2013 6:19 PM To: Gloria Ormsby Subject: [Tessitura Technical Forum] understanding T_PROMOTION
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Hi Gloria,
We use Wordfly, and we certainly have some information about how our email campaigns are picked up and read, but we can only track that directly through to a purchase if they use a promo code. What I'm trying to pick up is instances of a non-promo related email potentially influencing a sale.
Something I've discovered when trying to proof my output is that there seem to be some email readers that (I'm guessing) "load" emails periodically even if the user isn't reading them. I found a number of users whose promotion track suggested that they would suddenly read 20 or 30 of our emails in a single day, which seemed unlikely.
Hah - I wouldn't completely discount those people. I'm one of them! I have a yahoo account that I clear through whenever I think about it (which is usually every couple of weeks, but sometimes mroe) I might easily blow through a bunch of emails from one org in a single sitting. I'll have to dig into our stats and see if I see similar patterns. Do you see that happening for one particular provider?
FWIW,
Heather