Skip to main content
The Subscription Cancelled Item view provides dimensions and measures related to the items cancelled within a subscription. The measures calculated by this view are:
NameMeasure TypeDescription
Average Days Since CreatedAverageAverage number of days elapsed since the created date.
Average Days Since UpdatedAverageAverage number of days elapsed since the updated date.
Average Hours Since CreatedAverageAverage number of hours elapsed since the created date.
Average Hours Since UpdatedAverageAverage number of hours elapsed since the updated date.
Average Item Tax TotalAverageAverage of the item tax total for all subscription cancelled items.
Average Minutes Since CreatedAverageAverage number of minutes elapsed since the created date.
Average Minutes Since UpdatedAverageAverage number of minutes elapsed since the updated date.
Average QuantityAverageAverage of the quantity for all subscription cancelled items.
Average Shipping Tax TotalAverageAverage of the shipping tax total for all subscription cancelled items.
Average TotalAverageAverage of the monetary amount including items, sales tax, shipping costs, and other fees for all subscription cancelled items.
Average Unit List PriceAverageAverage of unit list price for all subscription cancelled items.
CountCountThe count of all subscription cancelled item records.
Total Item Tax TotalSumSum of the item tax for all subscription cancelled items.
Total QuantitySumSum of the quantity for all subscription cancelled items.
Total Shipping Tax TotalSumSum of the shipping tax for all subscription cancelled items.
Total TotalSumSum of the monetary amount including items, sales tax, shipping costs, and other fees for all subscription cancelled items.
Total Unit List PriceSumSum of the unit list price for all subscription cancelled items.
The dimensions included in this view are:
NameData TypeDescription
Cancelled Reason Action NameStringThe corresponding action for which this reason was given, such as CANCEL_ITEM or ADJUSTMENTS_APPLIED, for the cancelled item.
Cancelled Reason CodeStringA unique code given to each reason, such as “FoundBetterPrice,” for the cancelled item.
Cancelled Reason DescriptionStringA user-readable form of the reason, such as “Found better price,” for the cancelled item.
Created DateDatetimeThe timestamp of the date and time subscription was created.
Currency CodeStringIn addition to the original transactional currency, monetary amounts will also be converted to this currency.
Discount Applied On Sale PriceNumberThe discount applied on the cancelled item.
Is Product DiscountedYes/NoIndicates whether or not the included product has a discount.
Order IDStringA system-generated unique identifier of the order with which the subscription item is associated.
Unit List PriceNumberThe price that the item is listed for in the storefront.
QuantityNumberThe number of units of the item ordered.
Transactional Currency CodeStringThe currency in which the transaction was denominated.
Days Since CreatedNumberNumber of days elapsed since the created date.
Days Since UpdatedNumberNumber of days elapsed since the updated date.
Hours Since CreatedNumberNumber of hours elapsed since the created date.
Hours Since UpdatedNumberNumber of hours elapsed since the updated date.
Minutes Since CreatedNumberNumber of minutes elapsed since the created date.
Minutes Since UpdatedNumberNumber of minutes elapsed since the updated date.
Item Tax TotalNumberThe total amount of calculated tax for the item.
Shipping Tax TotalNumberThe total amount of tax incurred on the shipping charges.
TotalNumberThe total monetary amount including items, sales tax, shipping costs, and other fees.
Updated DateDatetimeThe timestamp of the date and time that the subscription item was most recently updated.