Subscription Report
There are 4 filter groups that provide different kinds of filters for subscriptions - Basic, Subscriptions, Organizations, Offers.
Basic filter group includes Reseller, Customer, Vendor, Offer, Subscription Status, Auto Renew Enabled, Trial, Microsoft NCE.
In this view of the report you can find following information: Customer / Customer Vendor ID (where available) / Customer ERP ID / Admin Account Email (Adobe only) / External Offer ID / Offer name / Offer type / is NCE / Internal Subscription ID / External Subscription ID / Subscription Start Date / Subscription End Date / Term duration (months) / Status / Auto renew Enabled / Auto Renew Change Date / Billing Cycle / Vendor / Quantity (on start) / Seller Unit Cost (on start) / Customer Unit Cost (on start) / Customer Total Cost (on start) / Seller to Customer Margin (on start, %) / Quantity (today) / Seller Unit Cost (today) / Seller Total Cost (today) / Customer Unit Cost (today) / Customer Total Cost (today) / Seller to Customer Margin (Today, %)
Subscriptions filter group includes Vendor, Subscription, Auto Renew Enabled, Auto Renew Change Date, Trial, Microsoft NCE, Subscription Start Date, Currency, Subscription Status.
The subscriptions filter group has a special filter Auto Renew Change Date that is useful to track and take action on subscriptions that recently have their Auto Renew disabled which means that they are likely to churn.
Few things for this particular filter:
This change date is based on Auto Renew status change checks that are done daily, so in some cases, it may deviate from the actual change date by 1 day.
We have data for this change date starting from July 2022, so if the Auto Renew status changed before that, it may not appear in the report.
The "Days until subscription end date" filter is currently set up to display 999 days. If selected 999, the report will show all the subscriptions, even with longer expiration dates.
Organizations filter group includes Reseller, Customer, Vendor, Reseller Country
Offers filter group includes Vendor, Product, Offer, Offer Type, Trial, Microsoft NCE, Custom Offer Properties, External Offer Id.