I'm pretty new to subscription reporting so please excuse my ignorance. I'm trying to pull package info: number of packages, number of performances in package, number of seats etc. and figured the best place to pull from was t-lineitem. I can mostly get what I want.
The problem I'm having is with orders that have been upgraded or have an alternate: alt_upgrd_ind in ('u','a')
What is the best way to select the correct line items for these orders? I originally thought of using Priority but that doesn't work quite right.
If I'm barking up the wrong tree entirely, please let me know.Thanks,Dale
Hi Dale,
You might try lineitems that are marked as primary (primary_ind='Y'). The Packages cube in T-stats might help you with this as well. Here's a sample showing Fixed vs. Flex pages, with their package size (number of performances), and a count of orders and package seats.
Best,Chris
__________________________________________ Chris Wallingford Product Manager | JCA 575 Eighth Ave., 21st Floor | New York, NY 10018 Phone: 203-468-9123 | Fax: 212-465-2349 chris.wallingford@jcainc.com | twitter www.jcainc.com | twitter | blog
Helping Non-Profits Work Smarter Visit JCA’s blog for the latest insights into how nonprofits can work smarter!
Chris,
Any idea on how to pull a renewal rate report in T-Stats? We don't use the New and Renewal Mode of Sale religiously and we don't have price types. So it seems like I have to pull some kind of list that says had this season and this season.
Any help would be appreciated.
Thanks.
Adria