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.
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
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
From: Gawain Lavers <bounce-gawainlavers9512@tessituranetwork.com> Sent: 9/13/2013 1:18:39 PM
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.
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!