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.
There is a table called T_EPROMOTION_RESPONSE_HISTORY which will give you the history of changes to a promotion as they were sent from one of the integrated email systems. So you can see each clickthrough and response change that was sent. I can't speak as to the timing of how the email systems (WordFly or Mail2) send their messages to our API for updating this table. Each unique URL that was clicked through is stored in TR_EPROMOTION_URL.
Hope that helps!
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!
Thanks Chuck, that certainly opens up the email side of the issue a bit (we use Wordfly).
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
Gawain,
Do you have Google Analytics? This are two reports from that which might help you. The first one below, choose Conversions, Ecommerce, Product Performance. Then add a secondary dimension of Campaign (under Advertising in the dimension pull down.
The second report is from Traffic Sources, Sources, Campaigns. This one doesn’t show money but rather activity. To see money use the one above. If you want further help let me know.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Heather Kraft Sent: Friday, September 13, 2013 3:06 PM To: Gloria Ormsby Subject: RE: [Tessitura Technical Forum] understanding T_PROMOTION
From: Gawain Lavers <bounce-gawainlavers9512@tessituranetwork.com> Sent: 9/13/2013 1:18:39 PM
Where do you find T_Promotion? I typed it in the search and the only thing that comes up is T_EPROMOTION.... Is T_Promotion located under another system table?
Unknown said: Where do you find T_Promotion? I typed it in the search and the only thing that comes up is T_EPROMOTION.... Is T_Promotion located under another system table?
T_PROMOTION isn't a system table. All of the data located under constituents in Connections -> Promotions lives there. If you've been on Tess a while, T_PROMOTION will get big: ours is over 6 million rows.