Subscription View

The Subscription view provides dimensions and measures related to product subscriptions.

The measures calculated by this view are:

NameMeasure TypeDescription
Average Adjustment AmountAverageThe mean of the adjustment amount for all records.
Average Days Since CreatedAverageAverage number of days elapsed since the created date.
Average Duty AmountAverageThe mean of the duty amount for all records.
Average Handling Adjustment AmountAverageThe mean of the handling adjustment amount for all records.
Average Handling AmountAverageThe mean of the handling amount for all records.
Average Handling Tax TotalAverageThe mean of the handling tax total for all records.
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 Minutes Since CreatedAverageAverage number of Minutes elapsed since the created date.
Average Minutes Since UpdatedAverageAverage number of minutes elapsed since the updated date.
Average Shipping Adjustment AmountAverageThe mean of the shipping adjustment amount for all records.
Average Shipping AmountAverageThe mean of the shipping amount for all records.
Average Shipping Tax TotalAverageThe mean of the shipping tax total for all records.
Average TotalAverageThe mean of the total for all records.
Subscription CountCountCount of all subscriptions.
Total Adjustment AmountSumThe sum of the adjustment amount for all records.
Total Duty AmountSumThe sum of the duty amount for all records.
Total Handling Adjustment AmountSumThe sum of the handling adjustment amount for all records.
Total Handling AmountSumThe sum of the handling amount for all records.
Total Handling Tax TotalSumThe sum of the handling tax total for all records.
Total Shipping Adjustment AmountSumThe sum of the shipping adjustment amount for all records.
Total Shipping AmountSumThe sum of the shipping amount for all records.
Total Shipping Tax TotalSumThe sum of the shipping tax total for all records.
Total TotalSumThe sum of the total for all records.

The dimensions included in this view are:

NameData TypeDescription
Is Card TokenizedYes/NoIf true, the card information is stored in the customer's account.
Payment Service Card IDStringThe ID received from the payment service for the credit card.
Address 1StringFirst address line for the contact.
Address 2StringSecond address line for the contact.
Address 3StringThird address line for the contact.
Address 4StringFourth address line for the contact.
Address Type IDStringA unique identifier for the address type.
Billing Email AddressStringThe email address for the customer account.
Billinginfo Payment TypeStringThe type of payment such as credit card, check, or PayPal Express.
Channel CodeStringA user-provided unique identifier for the channel.
City/TownStringThe city or town for the contact's address.
Company/OrganizationStringThe company or organization name entered for a customer account.
Country CodeStringThe country code for the contact's address.
Created DateDatetimeThe timestamp of the date and time that the subscription was created.
Currency CodeStringIn addition to the original transactional currency, monetary amounts will also be converted to this currency.
Customer Account IDStringA system-generated unique identifier for the customer account.
Duty AmountNumberThe duty amount for all items.
Email AddressStringThe email address for the customer account.
First NameStringThe first name of the customer.
Frequency UnitStringThe type of subscription frequency (days, year, or month).
Frequency ValueStringThe numeric value against the frequency (such as 3 months or 30 days).
Handling Tax TotalNumberCalculated total tax amount for handling costs, if the order is subject to sales tax.
Home Phone NumberStringThe home phone number for the contact.
IP AddressStringA captured and stored IP address.
Is Card Used RecurringYes/NoIf true, the credit card is charged on a regular interval.
Is Same Billing Shipping AddressYes/NoIf yes, the system overrides the customer's billing address information with the supplied fulfillment information.
Is ValidatedYes/NoWhether this address has been validated.
Last NameStringThe last name of the customer.
Middle NameStringContact middle name or initial.
Mobile Phone NumberStringMobile phone number for the contact.
Next Order DateDatetimeCalculated next continuity order date (the current order date + frequency).
OrdinalStringThe continuity order number.
Payment IDStringA system-generated unique identifier for the payment.
Payment or Card TypeStringThe payment or card type provided in the billing contact for the order.
Payment TermStringThe payment term for a purchase order (e.g. net 30) used as payment for the order.
Payment Term CodeStringPayment term code of purchase order.
Payment TypeStringThe type of payment such as credit card, check, or PayPal Express.
Payment WorkflowStringThe source of data for this payment.
Postal CodeStringPostal code for the contact address.
Price List CodeStringA user-provided unique identifier for the price list.
Purchase Order NumberStringThe storefront identifier of the purchase order used as payment for the order.
ReasonStringThe reason description for an action.
Shipping AmountNumberAmount of shipping charges.
Shipping Method NameStringThe carrier-supplied name for the shipping service type, such as UPS Ground or 2nd Day Air.
Shipping Tax TotalNumberThe total amount of tax incurred on the shipping charges.
Site IDNumberA system-generated unique identifier.
Site NameStringA user-provided, human-readable name for the site.
State/ProvinceStringThe state or province for the contact address.
Subscription StatusStringThe current status of the subscription: Abandoned, Accepted, Cancelled, Completed, Errored, Pending, Pending Review, Processing, or Validated.
Subscription IDStringA system-generated unique identifier for the subscription.
Subscription NumberNumberThe numeric subscription number.
Tenant IDNumberA system-generated unique identifier for the tenant.
Days Since CreatedNumberThe number of days elapsed since the created date.
Days Since UpdatedNumberThe number of days elapsed since the updated date.
Hours Since CreatedNumberThe number of hours elapsed since the created date.
Hours Since UpdatedNumberThe number of hours elapsed since the updated date.
Minutes Since CreatedNumberThe number of minutes elapsed since the created date.
Minutes Since UpdatedNumberThe number of minutes elapsed since the updated date.
Adjustment AmountNumberThe amount of the order-level adjustment, which can be a positive or negative amount.
Handling Adjustment AmountNumberThe amount of the handling-level adjustment.
Handling AmountNumberThe handling cost, excluding taxes and discounts.
Shipping Adjustment AmountNumberThe total of shipping-level adjustments.
TotalNumberThe total monetary amount including items, sales tax, shipping costs, and other fees.
Transactional Currency CodeStringThe currency in which the transaction was denominated.
Updated DateDatetimeThe timestamp of the date and time that the subscription was most recently updated.
User IDStringA system-generated unique identifier for the user.
Work Phone NumberStringThe work phone number for the contact.