Hello! Has anyone tried adding an Output item that includes something like "Segment Number?"
Our direct mail lists have multiple segments, and then often I complete some manual manipulation & deletion after extracting. But it would be helpful to know who is in a "high priority" segment and should not be cut from the list. I do not want to handle this through sources; I want just one source for the mailing piece.
I can't figure out an easy way to do this, so I'm wondering if anyone else has found a trick. Thank you!
Hello Jean! This is Amelia with Tessitura Network Support. We’re happy to assist you with this question. I’ve created a Support ticket where we’ll work with you to find a resolution. We’ll also relay our findings from that ticket in this forum post, but if you have any other questions or concerns in the meanwhile please let us know.
This gives you Segment number and you could put it into a view
select a.ka_no as extraction_id, a.description as extraction, b.keycode as segment_no, b.description as segment, c.customer_no, suppression_flag from BIExtract.T_KA_HEADER a Join BIExtract.T_KEYCODE b on a.ka_no = b.ka_no join BIExtract.T_CUST_KEYCODE c on b.keycode = c.keycode and a.ka_no = c.ka_no where suppression_flag = 'N' -- and a.ka_no = 1144 Order by a.ka_no, b.keycode, c.customer_no
Hi! My colleague and I were just discussing this the other day. We are now in v16 and she recalled that in v15 the priority number was one of the first four output columns in the text file that were not part of our output set. She had used it for the exact same reason - cutting people from the list if needed - without us having to add it to an output set. We don't see it anymore in v16, but just thought I'd mention it here.
Hi Jean - and everyone else interested in this! Mae with Tessitura Network Support here - segment ID is a part of our standard extraction output, but it wasn't clear in the documentation for v16. Thank you for calling this to our attention. We've updated the documentation, which you can find here: https://www.tessituranetwork.com/Help_System_v160/TN-Application/Segmentation-Sets/Standard-Segmentation-Output.htm Segment ID is included towards the end of the standard output, just before the phone details! If you're not finding that to be the case in your system, please do open a Support ticket and let us know!