HI everyone
I'm doing some year-end housekeeping. In particular, I'd like to tackle the TR_WEB_SOURCE_NO table which is where you link your Source No for an offer to a user-friendly Promo code for use in TNEW. This table has never had anything deleted in over 10 years. Some entries have been inactivated, but there are many still active from previous years which are no longer in use as they relate to past seasons/events.
What's best practice for managing these? Do you delete entries or just inactivate them? I'd like to delete the really old ones and just inactivate the more recent ones. The documentation for this table does not cover inactivation or deletion. I'm assuming it does not affect reporting as this is usually by Source No/Name rather than promo code.
Any thoughts/reassurances welcome!
Many thanksBest wishes
Dawn
Hi Dawn,
We delete all show-specific offers from the TR_WEB_SOURCE_NO once the show has gone. This keeps it manageable, and we’ve never had any problems with reporting.
We always put the show title in the Text 1 field and can therefore filter by the show name which makes it easier than remembering which source is which.