Skip to main content

Discount Applied Metrics Data Source

Zuora

Discount Applied Metrics Data Source

This feature is deprecated and is not enabled by default. Contact Zuora Global Support to enable this feature in your tenant.

You are strongly recommended to disable the Discount Applied Metrics when the Order Metrics feature is enabled.

This feature does not support account level discounts.

Use the Discount Applied Metrics data source to understand how the MRR and TCV of Rate Plan Charges are affected by discounts. Each record in the Discount Applied Metrics data source corresponds to an application of a Discount Rate Plan Charge to another Rate Plan Charge.

A Discount Rate Plan Charge is a Rate Plan Charge that uses one of the following charge models:

  • Discount-Fixed Amount
  • Discount-Percentage

See Discount Charge Models for more information.

The following objects are available in the Discount Applied Metrics data source:

Object Description

Discount Applied Metrics

Contains the following fields:

  • Created By ID - The Zuora user who created the discount application.
  • Created Date - The date when the discount application was created.
  • Discount Rate Plan Charge ID - The internal ID of the Rate Plan Charge that represents the discount. To obtain information about the Rate Plan Charge that the discount applies to, use the Rate Plan Charge object in the data source.
  • End Date - The latest date that the discount applies.
  • ID - The internal ID of the discount application.
  • MRR - The monthly recurring revenue associated with the discount. This value is negative.
  • Start Date - The earliest date that the discount applies.
  • TCV - The total contract value of the discount. This value is negative.
  • Updated By ID - The Zuora user who last updated the discount application.
  • Updated Date - The date when the discount application was last updated.

Account

The customer account information. Note this is the Invoice Owner account.

Amendment

The change made to subscription. Contains the following fields:

  • Auto Renew
  • Code
  • Contract Effective Date
  • Created By ID
  • Created Date
  • Current Term
  • Current Term Period Type
  • Customer Acceptance Date
  • Description
  • Effective Date
  • ID
  • Name
  • Renewal Setting
  • Renewal Term
  • Renewal Term Period Type
  • Resume Date
  • Service Activation Date
  • Specific Update Date
  • Status
  • Subscription ID
  • Suspend Date
  • Term Start Date
  • Term Type
  • Type
  • Updated By ID
  • Updated Date

Bill To

The contact associated with the account to whom your product or service is billed.

Default Payment Method

The default payment method used to make payments.

Entity

The entity that the data relates to. Part of the Multi-entity feature. Contains the following fields:

  • Address 1
  • Address 2
  • City
  • Country
  • Created By ID
  • Created Date
  • Display Name
  • Email
  • ID
  • Name
  • Postal Code
  • State
  • Updated By ID
  • Updated Date

Parent Account

Refers to the parent account associated with the customer account, if applicable.

Product

The product information. Contains the following fields:

  • AllowFeatureChanges
  • Category
  • Created By ID
  • Created Date
  • Description
  • Effective End Date
  • Effective Start Date
  • ID
  • Name
  • NetSuite Integration ID
  • NetSuite Integration Status
  • NetSuite Item Type
  • NetSuite Sync Date
  • SKU
  • Updated By ID
  • Updated Date

Product Rate Plan

The rate plan coming from the product catalog. Contains the following fields:

  • Created By ID
  • Created Date
  • Description
  • Effective End Date
  • Effective Start Date
  • ExternalldSourceSystem
  • Grade
  • ID
  • Name
  • Updated By ID
  • Updated Date

Product Rate Plan Charge

The product rate plan charge information coming from the product catalog. Contains the following fields:

  • Accounting Code
  • Apply Discount To
  • Bill Cycle Day
  • Bill Cycle Type
  • Billing Period
  • Billing Period Alignment
  • Billing Timing
  • Charge Model
  • Charge Type
  • Created By ID
  • Created Date
  • Default Quantity
  • Deferred Revenue Account
  • Description
  • Discount Level
  • End Date Condition
  • ID
  • Included Units
  • Legacy Revenue Reporting
  • List Price Base
  • Max Quantity
  • Min Quantity
  • Name
  • Number Of Period
  • Overage Calculation Option
  • Overage Unused Units Credit Option
  • Price Change Option
  • Price Increase Percentage
  • Rating Group
  • Recognized Revenue Account
  • Revenue Recognition Code
  • Revenue Recognition Rule Name
  • Revenue Recognition Trigger
  • Smoothing Model
  • Specific Billing Period
  • Tax Code
  • Tax Mode
  • Taxable
  • Trigger Event
  • UOM
  • Up To How Many Periods
  • Up To Periods Type
  • Updated By ID
  • Updated Date
  • Usage Records Rating Option
  • Use Discount Specific Accounting Code
  • Use Tenant Default For Price Change
  • Weekly Bill Cycle Day

Rate Plan

Refers to the rate plan or pricing plan information associated with the subscription. Contains the following fields:

  • Amendment Type: Note that a filter on this field using the unequal operator cannot return those Rate Plan records with a blank Amendment Type field. 
  • Created By ID
  • Created Date
  • Externally Managed Plan ID: a text field. This field indicates the unique identifier of a rate plan purchased on a third-party store.
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan
  • Name
  • Original Rate Plan ID: the original ID of the subscription rate plan, which is the ID of the subscription rate plan in the version-1 subscription
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan
  • Subscription Rate Plan Number
  • Updated By ID
  • Updated Date

Rate Plan Charge

The Rate Plan Charge that the discount applies to.

Sold To

The contact associated with the account to whom your product or service is sold.

Subscription

The subscription to which the rate plan is associated. Contains the following fields:

  • Auto Renew
  • Cancelled Date
  • Contract Acceptance Date
  • Contract Effective Date
  • Cpq Bundle Json ID
  • Created By ID
  • Created Date
  • Creator Account ID
  • Creator Invoice Owner ID
  • Current Term
  • Current Term Period Type
  • ID
  • Initial Term
  • Initial Term Period Type
  • Invoice Owner ID
  • Invoice Separate
  • Name
  • Notes
  • Opportunity Close Date
  • Opportunity Name
  • Original Created Date
  • Original ID
  • Previous Subscription ID
  • Quote Business Type
  • Quote Number
  • Quote Type
  • Renewal Setting
  • Renewal Term
  • Renewal Term Period Type
  • Service Activation Date
  • Status
  • Subscription End Date
  • Subscription Start Date
  • Term End Date
  • Term Start Date
  • Term Type
  • Updated By ID
  • Updated Date
  • Version