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

Report: Offers

This report includes all of your Offers that you created in the Magine Pro platform. This report can be used to add more information to the Entitlement or Subscription reports.

This entire report will be replaced every day because any row could have been updated.

COLUMNS

  • offer_id - The unique ID of the Offer.

  • pack_id - ID of the pack that is linked to this offer. Each Offer can only be linked to one pack.

  • offer_title - The default title of the Offer.

  • offer_type - Type of the offer. Let's you know what type of offer it is, e.g. Subscription, Pass or Rental

  • third_party_offer_subtype - If the offer is of type: Thirdparty, it will also have a subtype e.g. Outsourced or Subscription. For all other offer_type's, this column will be empty.

  • provider_name - If the offer is of type: Thirdparty, it will also have a provider_name e.g. Apple or Google. For all other offer_type's, this column will be empty.

  • external_offer_id - If the offer is of type: Thirdparty, it will also have an external_offer_id which is the ID that comes from the thirdparty store. For all other offer_type's, this column will be empty.

  • purchase_available_since - The date from when the Offer would be possible to purchase, if a date is set on the Offer. In the Magine Pro Console it's referenced to as the Start date for the Offer.

  • purchase_available_until - The date until when the Offer would be possible to purchase, if a date is set on the Offer. In the Magine Pro Console it's referenced to as the End date for the Offer.

  • disabled_at - If the Offer have been disabled, this is the timestamp for when it was disabled. Timestamp in UTC.

  • currency - The Currency for the price of the Offer.

  • upfront_price_cents - The price on the Offer in the sub currency. E.g. If the price of the offer is €4.99, the value in this column would be 499.

  • renewal_periodicity - The periodicity of how often an offer of offer_type: Subscription will be renewed. For all other offer_type's, this column will be empty.

  • trial_duration_sec - The length of the trial period in seconds. E.g. a trial period of 7 days would get a value of 604800 seconds. This only applies to offer_type: Subscription. For all other offer_type's, this column will be empty.

  • entitlement_duration_sec - How long the user would get an entitlement to this Offer when they purchase it. This only applies to offer_type's: Rental and Pass. For all other offer_type's, this column will be empty.

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