The Subscription Cancelled Item view provides dimensions and measures related to the items cancelled within a subscription.
The measures calculated by this view are:
| Name | Measure Type | Description |
|---|---|---|
| Average Days Since Created | Average | Average number of days elapsed since the created date. |
| Average Days Since Updated | Average | Average number of days elapsed since the updated date. |
| Average Hours Since Created | Average | Average number of hours elapsed since the created date. |
| Average Hours Since Updated | Average | Average number of hours elapsed since the updated date. |
| Average Item Tax Total | Average | Average of the item tax total for all subscription cancelled items. |
| Average Minutes Since Created | Average | Average number of minutes elapsed since the created date. |
| Average Minutes Since Updated | Average | Average number of minutes elapsed since the updated date. |
| Average Quantity | Average | Average of the quantity for all subscription cancelled items. |
| Average Shipping Tax Total | Average | Average of the shipping tax total for all subscription cancelled items. |
| Average Total | Average | Average of the monetary amount including items, sales tax, shipping costs, and other fees for all subscription cancelled items. |
| Average Unit List Price | Average | Average of unit list price for all subscription cancelled items. |
| Count | Count | The count of all subscription cancelled item records. |
| Total Item Tax Total | Sum | Sum of the item tax for all subscription cancelled items. |
| Total Quantity | Sum | Sum of the quantity for all subscription cancelled items. |
| Total Shipping Tax Total | Sum | Sum of the shipping tax for all subscription cancelled items. |
| Total Total | Sum | Sum of the monetary amount including items, sales tax, shipping costs, and other fees for all subscription cancelled items. |
| Total Unit List Price | Sum | Sum of the unit list price for all subscription cancelled items. |
The dimensions included in this view are:
| Name | Data Type | Description |
|---|---|---|
| Cancelled Reason Action Name | String | The corresponding action for which this reason was given, such as CANCEL_ITEM or ADJUSTMENTS_APPLIED, for the cancelled item. |
| Cancelled Reason Code | String | A unique code given to each reason, such as "FoundBetterPrice," for the cancelled item. |
| Cancelled Reason Description | String | A user-readable form of the reason, such as "Found better price," for the cancelled item. |
| Created Date | Datetime | The timestamp of the date and time subscription was created. |
| Currency Code | String | In addition to the original transactional currency, monetary amounts will also be converted to this currency. |
| Discount Applied On Sale Price | Number | The discount applied on the cancelled item. |
| Is Product Discounted | Yes/No | Indicates whether or not the included product has a discount. |
| Order ID | String | A system-generated unique identifier of the order with which the subscription item is associated. |
| Unit List Price | Number | The price that the item is listed for in the storefront. |
| Quantity | Number | The number of units of the item ordered. |
| Transactional Currency Code | String | The currency in which the transaction was denominated. |
| Days Since Created | Number | Number of days elapsed since the created date. |
| Days Since Updated | Number | Number of days elapsed since the updated date. |
| Hours Since Created | Number | Number of hours elapsed since the created date. |
| Hours Since Updated | Number | Number of hours elapsed since the updated date. |
| Minutes Since Created | Number | Number of minutes elapsed since the created date. |
| Minutes Since Updated | Number | Number of minutes elapsed since the updated date. |
| Item Tax Total | Number | The total amount of calculated tax for the item. |
| Shipping Tax Total | Number | The total amount of tax incurred on the shipping charges. |
| Total | Number | The total monetary amount including items, sales tax, shipping costs, and other fees. |
| Updated Date | Datetime | The timestamp of the date and time that the subscription item was most recently updated. |