• Replies 1 reply
  • Subscribers 413 subscribers
  • Views 66 views
  • Users 0 members are here
Related

Extraction/List Assistance

Amy Aldrich
$organization

Hello,

I need to find the following information to be able to print subscription tickets in these specific groups. The one component I can't seem to figure out is how to find subscribers with multiple subscription packages. I am creating an extraction and then saving this data to a list.

  • Subscribers who have been coming for 10+years with multiple packages in their ticket order
  • Subscribers who have been coming for 10+ years with just one package in their order
  • Subs who have been coming for less than 10 years with multiple packages in their ticket order
  • Subs who have been coming for less than 10 years with just one package in their ticket order

Any advice would be greatly appreciated!

Thanks,

Amy

  • $organization

    Amy -

    This is something we've always had an issue with. I usually pull this information for my box office from SQL because it is just easier. We've set up a yearly attribute that identifies customers with multiple subs. We update that via the big list I pull after rollovers, and then the box office manually sets it when they process one. This allows the box office to pull a list without me if they need to during the season.

    I should (but haven't yet) just set it up as a nightly procedure.  If you have manual edit abilities for your list, there is probably some SQL that your admin could come up with to pull your multiple subs. 

    - Heather