• Replies 2 replies
  • Subscribers 332 subscribers
  • Views 240 views
  • Users 0 members are here
Related

New to File Subscribers

Nicole Wetzell
$organization

Hi Everyone - I'd like to pull a list of subscribers who are new to file and purchased a specific subscription package, but can't figure out the criteria. Could anyone share how to pull this? Thanks!

Parents
  • $organization

    Here's the SQL I use in Extraction Manager...

    SELECT DISTINCT cust.customer_no
    FROM V_CUSTOMER_WITH_PRIMARY_GROUP AS cust
    JOIN T_TICKET_HISTORY AS th ON cust.expanded_customer_no = th.customer_no AND th.season IN (8,9,10,11,12,13,14,15,16,17,18,19,20,2,5,27,31) --all performance seasons
    JOIN TR_PRICE_TYPE AS pt ON th.price_type = pt.id AND pt.price_type_category <> 4 --exclude comps
    WHERE cust.inactive = 1
    GROUP BY cust.customer_no
    HAVING MIN(th.prod_season_no) = 1166 AND MAX(th.prod_season_no) = 1166 AND COUNT(th.season) = 1
    ORDER BY cust.customer_no

Reply
  • $organization

    Here's the SQL I use in Extraction Manager...

    SELECT DISTINCT cust.customer_no
    FROM V_CUSTOMER_WITH_PRIMARY_GROUP AS cust
    JOIN T_TICKET_HISTORY AS th ON cust.expanded_customer_no = th.customer_no AND th.season IN (8,9,10,11,12,13,14,15,16,17,18,19,20,2,5,27,31) --all performance seasons
    JOIN TR_PRICE_TYPE AS pt ON th.price_type = pt.id AND pt.price_type_category <> 4 --exclude comps
    WHERE cust.inactive = 1
    GROUP BY cust.customer_no
    HAVING MIN(th.prod_season_no) = 1166 AND MAX(th.prod_season_no) = 1166 AND COUNT(th.season) = 1
    ORDER BY cust.customer_no

Children
No Data