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.
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.