Extraction Woes - Non-Buyers - No consistant output!

Normal 0 false false false EN-US X-NONE X-NONE

I'm hoping one of the many Tessitura gurus can assist us with a list and/or extraction that on the surface appears simple but is causing us to pull our hair out.

We need to identify everyone in the database who has never purchased a ticket.  Easy enough we thought but we’re having no luck.  We’re in a consortium which has made this a bit of a challenge since we do share constituents.

We have excluded and/or included the appropriate constituencies and excluded price types, MOS, Prod Seasons, etc in our extractions and adjusted priorities multiple times.

Every generated list has a combination of constituents that have been excluded in multiple segments.  We’ve tried every configuration we can think of. There’s no consistency.

Interestingly, when we try to exclude by campaign or appeal, there is no resultant count. Is it possible we lack security rights to the VS_CONTRIBUTION table?

Our next thought was to use a value of <= 0 for ORDER AMOUNT or PAID AMOUNT but these criteria are not available in the tickets folder.  This also doesn’t work for a value corresponding to number of tickets because without an order there is no numerical value in the table.

Does anyone have any suggestions or a set of criteria they’re willing to share that’s been successful for them?

Thanks so much for any and all suggestions. I’m afraid we’ll all be bald very soon!!!