Report: Subscription data
This report contains all data about the Subscriptions each user has. A Subscription means that a user have purchased an offer of offer_type: Subscription and will have a cyclical billing period. Offers of offer_type: Subscription that have been added to a user through the Magine Pro Console is not a Subscription and will not show up in this report.
Each row in the report will be for one date, one User and one Offer. This means that if a user have Subscriptions to two Offers at the same date, that user will appear on two rows for that date. If the user have been downgraded from their Subscription (i.e. they no longer have an Entitlement and don't have access to the content anymore), that user ID will no longer appear in this report for new dates.
Each date will get a new report. A report for one day can be updated during the following three days after it was created to make sure any potential issues with the export gets automatically solved.
COLUMNS
All timestamps in this report are in UTC.
date - The date when the user had this Subscription. Set to YYYY-MM-DD 23:59 to show that this data was taken after the date had ended.
user_id - The ID of the user that had this Subscription during this date.
offer_id - The ID of the Offer that the user had a Subscription for.
status - The status of the Subscription which tells you in which phase the Subscription is in. Statuses more thoroughly explained further down.
trial_end - Timestamp when the users Trial will end, or when it ended, for this Subscription.
expiry - Timestamp when this Subscription expire. This is the date that the user will be billed the next time if they have not cancelled the Subscription before.
cancelled_at - If the user have cancelled their subscription, this is the Timestamp when it was cancelled. User will still keep the Subscription until the Expiry date when the user will be downgraded.
latest_renewal - The last timestamp when this Subscription was renewed.
periodicity - The periodicity of which this Subscription is being renewed. Could be Monthly or Yearly.
How to understand what state each users subscription is in?
A Subscription can be in several different states for a user. Given the data in this report, it's possible to figure out each of those states, but also decide on which granularity you want to count the different states of a Subscription.
The first thing that give you information about the state of the users Subscription is the column status. Possible values for this column is:
trial - The user have an active trial and have not yet been charged anything. If the user does not cancel their Subscription, they will be billed when the trial period ends.
active - The user have an active Subscription that they have been charged for (unless they have a 100% discount, but they are still counted as paying subscribers)
cancelled - The user have cancelled their Subscription and will be downgraded the next billing cycle. The user could both have cancelled while in Trial or when the Subscription was Active.
payment_reqiured - The expiry date for this Subscription have passed and we are trying to charge this user. Either we will be able to charge the user and the Subscription is renewed, or the user will eventually be downgraded. The Subscription can enter this state both from Trial and from Active
So how do I actually separate my trial users from Paying subscribers?
In many cases you want to separate users that are in Trial from Paying subscribers independent if they have cancelled their Subscription or if we're in the process of trying to charge the subscription fee from them. This is the easiest way to separate that:
Trial subscriber: If expiry = trial_end, then the user will be a Trial Subscriber.
Paying subscriber: If expiry != trial_end or trial_end is null, then the user will be a Paying subscriber (independent if the user have 100% discounts or not)