Hi All
We just launched out 22.23 Subscription Campaign and I am on quest for trying to determine the total number of Subscriptions sold. I have tried looking in reports and analytics and am at a lost. Other than going through every constituent account and counting them I can't seem to find a way to find the total number of subscription sold.
1. Is there a report?
In analytic I have been able to create a pivot table with the following criteria
Constituent ID
Sub price type
Total Number of tickets
*****************************
*******************************
Is there a formula to find the total number of subscription sold?
Example:
Kat Alvarez (Constituent )
Student Super series (sub price type)
5 plays @ $20 per play = $100
2 subscriptions = $200
10 tickets total (2 tickets per play)
2 subscription
Data Need
2 subscriptions. -- This is what I am having trouble finding.
$200 (total revenue)
1 student super series (price type)
Thank you for any insight.
Thank you
Kat
Hi Kat,
You should be able to, in Analytics, make a widget that shows this. For example a pivot table with:
Rows: Package (under package details)Value: COUNT( Package Seat Key)
Then you can see a breakdown of your packages, their count, and then total them for overall total packages.
Hope this helps!