Subscription View

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

The measures calculated by this view are:

Name	Measure Type	Description
Average Adjustment Amount	Average	The mean of the adjustment amount for all records.
Average Days Since Created	Average	Average number of days elapsed since the created date.
Average Duty Amount	Average	The mean of the duty amount for all records.
Average Handling Adjustment Amount	Average	The mean of the handling adjustment amount for all records.
Average Handling Amount	Average	The mean of the handling amount for all records.
Average Handling Tax Total	Average	The mean of the handling tax total for all records.
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 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 Shipping Adjustment Amount	Average	The mean of the shipping adjustment amount for all records.
Average Shipping Amount	Average	The mean of the shipping amount for all records.
Average Shipping Tax Total	Average	The mean of the shipping tax total for all records.
Average Total	Average	The mean of the total for all records.
Subscription Count	Count	Count of all subscriptions.
Total Adjustment Amount	Sum	The sum of the adjustment amount for all records.
Total Duty Amount	Sum	The sum of the duty amount for all records.
Total Handling Adjustment Amount	Sum	The sum of the handling adjustment amount for all records.
Total Handling Amount	Sum	The sum of the handling amount for all records.
Total Handling Tax Total	Sum	The sum of the handling tax total for all records.
Total Shipping Adjustment Amount	Sum	The sum of the shipping adjustment amount for all records.
Total Shipping Amount	Sum	The sum of the shipping amount for all records.
Total Shipping Tax Total	Sum	The sum of the shipping tax total for all records.
Total Total	Sum	The sum of the total for all records.

The dimensions included in this view are:

Name	Data Type	Description
Is Card Tokenized	Yes/No	If true, the card information is stored in the customer’s account.
Payment Service Card ID	String	The ID received from the payment service for the credit card.
Address 1	String	First address line for the contact.
Address 2	String	Second address line for the contact.
Address 3	String	Third address line for the contact.
Address 4	String	Fourth address line for the contact.
Address Type ID	String	A unique identifier for the address type.
Billing Email Address	String	The email address for the customer account.
Billinginfo Payment Type	String	The type of payment such as credit card, check, or PayPal Express.
Channel Code	String	A user-provided unique identifier for the channel.
City/Town	String	The city or town for the contact’s address.
Company/Organization	String	The company or organization name entered for a customer account.
Country Code	String	The country code for the contact’s address.
Created Date	Datetime	The timestamp of the date and time that the subscription was created.
Currency Code	String	In addition to the original transactional currency, monetary amounts will also be converted to this currency.
Customer Account ID	String	A system-generated unique identifier for the customer account.
Duty Amount	Number	The duty amount for all items.
Email Address	String	The email address for the customer account.
First Name	String	The first name of the customer.
Frequency Unit	String	The type of subscription frequency (days, year, or month).
Frequency Value	String	The numeric value against the frequency (such as 3 months or 30 days).
Handling Tax Total	Number	Calculated total tax amount for handling costs, if the order is subject to sales tax.
Home Phone Number	String	The home phone number for the contact.
IP Address	String	A captured and stored IP address.
Is Card Used Recurring	Yes/No	If true, the credit card is charged on a regular interval.
Is Same Billing Shipping Address	Yes/No	If yes, the system overrides the customer’s billing address information with the supplied fulfillment information.
Is Validated	Yes/No	Whether this address has been validated.
Last Name	String	The last name of the customer.
Middle Name	String	Contact middle name or initial.
Mobile Phone Number	String	Mobile phone number for the contact.
Next Order Date	Datetime	Calculated next continuity order date (the current order date + frequency).
Ordinal	String	The continuity order number.
Payment ID	String	A system-generated unique identifier for the payment.
Payment or Card Type	String	The payment or card type provided in the billing contact for the order.
Payment Term	String	The payment term for a purchase order (e.g. net 30) used as payment for the order.
Payment Term Code	String	Payment term code of purchase order.
Payment Type	String	The type of payment such as credit card, check, or PayPal Express.
Payment Workflow	String	The source of data for this payment.
Postal Code	String	Postal code for the contact address.
Price List Code	String	A user-provided unique identifier for the price list.
Purchase Order Number	String	The storefront identifier of the purchase order used as payment for the order.
Reason	String	The reason description for an action.
Shipping Amount	Number	Amount of shipping charges.
Shipping Method Name	String	The carrier-supplied name for the shipping service type, such as UPS Ground or 2nd Day Air.
Shipping Tax Total	Number	The total amount of tax incurred on the shipping charges.
Site ID	Number	A system-generated unique identifier.
Site Name	String	A user-provided, human-readable name for the site.
State/Province	String	The state or province for the contact address.
Subscription Status	String	The current status of the subscription: Abandoned, Accepted, Cancelled, Completed, Errored, Pending, Pending Review, Processing, or Validated.
Subscription ID	String	A system-generated unique identifier for the subscription.
Subscription Number	Number	The numeric subscription number.
Tenant ID	Number	A system-generated unique identifier for the tenant.
Days Since Created	Number	The number of days elapsed since the created date.
Days Since Updated	Number	The number of days elapsed since the updated date.
Hours Since Created	Number	The number of hours elapsed since the created date.
Hours Since Updated	Number	The number of hours elapsed since the updated date.
Minutes Since Created	Number	The number of minutes elapsed since the created date.
Minutes Since Updated	Number	The number of minutes elapsed since the updated date.
Adjustment Amount	Number	The amount of the order-level adjustment, which can be a positive or negative amount.
Handling Adjustment Amount	Number	The amount of the handling-level adjustment.
Handling Amount	Number	The handling cost, excluding taxes and discounts.
Shipping Adjustment Amount	Number	The total of shipping-level adjustments.
Total	Number	The total monetary amount including items, sales tax, shipping costs, and other fees.
Transactional Currency Code	String	The currency in which the transaction was denominated.
Updated Date	Datetime	The timestamp of the date and time that the subscription was most recently updated.
User ID	String	A system-generated unique identifier for the user.
Work Phone Number	String	The work phone number for the contact.