Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

Report: Entitlement data

This report contains all data about the entitlements each user has. An entitlement means the user has access to the content. It can be activated through the purchase of an offer or manually added to an account through the console.

Each row in the report will be for one date, one User and one Offer. This means that if a user is entitled to two Offers at the same date, that user will appear on two rows for that date.

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 this entitlement was active. 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 entitlement during this date.

  • offer_id - The ID of the Offer that the user was entitled to.

  • offer_type - The type of the Offer. E.g. Subscription, Rental or Thirdparty.

  • active_from - The timestamp during this date when the Entitlement was first active. If it's set to YYYY-MM-DD 00:00 it means that the user had an Entitlement to this Offer the day before as well.

  • active_to - The timestamp during this date when the Entitlement was last active. If it's set to YYYY-MM-DD 23:59 it means that the user had an Entitlement to this Offer the day after as well.

  • purchased_at - The timestamp when the Entitlement was first added. It could have been added either by purchase from the User, adding it through the Magine Pro Console or through the Reseller API.

  • expiry - The timestamp when this Entitlement will expire and no longer be active, i.e. the user lose access to the content they are entitled to watch.

  • deleted_at - If the Entitlement have been deleted from a user, this is the timestamp when it was deleted. The Entitlement could have been deleted through the Magine Pro Console or through the Reseller API.

  • provider_name - If the Offer has offer_type: Thirdparty, it will have a name of the provider, e.g. Apple or Google.

  • external_offer_id - If the Offer has offer_type: Thirdparty, this is the ID that have been taken from the third party store.

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.