Subscriptions report

This report provides detailed information about customer subscriptions on your marketplace.

Although the term subscription does not appear in the user interface, a subscription represents a company entitlement to use a product. If you examine details on an order from the orders listing page, you can view subscription details. See View order details for more information.

note

This report is available to Marketplace Managers, Network Managers, and Developers. This feature must be enabled by AppDirect for your marketplace and for your role. Contact your AppDirect technical representative for information. Additionally, some of the fields described in the table may not be included for your role. To see all of the available fields, click the Choose Fields tab in the Customize reports section on the Create Reports page. See Create reports for more information. For more information about subscriptions, see the Orders topics in the AppDirect documentation center.

Recommended fields appear by default in the report. However, when you create a report, you can remove default fields or add different fields. If Marketplace Managers create custom attributes (see Create custom attributes), you can also include those fields when you create the report. Only custom attributes that were created in your marketplace (not child marketplaces) are displayed.

In the following table, the last column indicates whether or not the column is included by default.

Heading	Description	Included by default?
Owner Name	Name of the customer who purchased the product.	Y
Owner User ID	Unique identifier for the customer who purchased the product to which the order applies.	Y
Owner UUID	Unique identifier on the marketplace of the customer who purchased the product to which the order applies (used when making API calls).	Y
Owner Email	Email of the customer who purchased the product to which the order applies.	Y
Owner Company Name	Name of the company that purchased the product.	Y
Owner Company ID	Identifier on the marketplace of the company that purchased the product.	Y
Owner Company Phone	Phone number of the company that purchased the product.	Y
Subscription ID	Unique identifier of the subscription on the marketplace	N
Subscription UUID	Identifier on the marketplace that defines the company’s subscription to the product(remains unique even if the subscription ownership changes within a company).	Y
Product Name	Name of the application or product	Y
Product ID	Unique identifier of the application on the marketplace	Y
Vendor Name	Name of the application developer.	Y
Vendor ID	Unique identifier on the marketplace for the application developer.	Y
Application Name	Name of the application or product.	Y
Application ID	Unique identifier of the application on the marketplace.	Y
Is Application Buyable	Indicates whether or not an application can be purchased. Possible values: Y, N	N
Application Last Modification Date	Last date on which an application was modified.	N
Edition Name	Name of the edition associated with the application or product.	Y
Subscription Created Within Report Date Range	The report only includes subscriptions that were created within the specified report date range. Possible values: Y/N	N
Subscription Last Modified Date	Last date on which the subscription was modified	N
Edition ID	Identifier on the marketplace of the product edition .	Y
Product type	The product type for the purchased application or product. Sample values include: web app stacked, domain reseller, cloud services, physical product	N
Product Classification	The product type's classification. Possible values: base product, add on.	N
Unit Type List	Comma-separated list of unit types associated with the subscription.	N
Add-On Parent Product ID	Name of the parent product associated with the current subscription. This field is only populated if the subscription is for a product add-on.	N
Quantity	The number of units or volume purchased	Y
Quantity Per Unit	Describes the number of items per pricing unit included in the subscription (for example, 100 users, 10 servers).	N
Add-On Parent Product Name	Name of the parent product associated with the current subscription. This field is only populated if the current subscription is for a product add-on.	N
Revenue Model Type	Revenue model describing how the application purchased is charged. Possible values: free, one time, recurring, tiered.	N
Product Line Name	List of product lines associated with the application purchased.	N
Product Attribute - Attribute Only	List of attributes associated with the application purchased.	N
Product Attribute - Option Only	List of attribute options associated with the application purchased.	N
Product Attribute	List of attributes along with its options associated with application purchased. For example: {"Attributes":"Feature Apps", "Attributes":"Free" }.	N
Customer Group Name	List of industry or customer groups associated with the application purchased.	N
Customer Group Name	List of industry or customer groups associated with the application purchased.	N
Add-On Parent Subscription UUID	Subscription UUID of the parent subscription associated with the current subscription. This field is only populated if the current subscription is for a product add-on.	N
Microsoft Domain Name	Microsoft domain name associated with the purchasing company. Listed only when the purchased application is integrated with Microsoft.	N
Microsoft Tenant ID	Microsoft tenant ID associated with the purchasing company. Listed only when the purchased application is integrated with Microsoft.	N
Subscription Status	Status of the subscription. Possible values can include: initialized, failed, free trial, free trial expired, active, suspended, canceled.	N
Active Order ID	Identifier for an order for which the last payment was successful.	Y
Billing Frequency	Frequency of an order for which the last payment was successful	Y
Total Fee	Fee for an order for which the last payment was successful	Y
Active Order Start Date	Start date of the company’s active order for the productY	Y
Active Order Frequency	Frequency of an order for which the last payment was successful.	Y
Active Order Total Fee	Fee for an order for which the last payment was successful.	Y
Current Order Start Date	Start date of the company’s active order for the product	N
Subscription Start Date	Start date of the subscription (does not include setup fees)	N
Suspension Date	Date on which the order or subscription was suspended	N
First Order ID	ID of the first order of a subscription (does not include setup fees)	N
Discount Code	Discount code applied to the subscription.	N
Discount Creation Date	Date on which the discount was created.	N
Discount ID	Unique identifier of the discount.	N
Discount Percentage	Percent discount applied to the subscription.	N
Pricing Item ID List	Comma-separated list of the pricing plan item IDs associated with the subscription.	N
Discount Price	Discount price applied to the subscription.	N
Payment Plan ID	Unique identifier of the payment plan.	N
Payment Plan Last Modification Date	Last date on which the payment plan was modified.	N
Currency	Currency in which the product is purchased.	Y
Subscription Creation Date	Date on which the order is generated.	Y
Active Order Status	Order status. Possible values: active, canceled, deleted, failed, finished, free trial canceled, free trial expired, initialized, one time, pending remote creation, pending user approval, suspended and upcoming. For a description of each status, see Order and subscription statuses.	Y
Creation Date	Date on which the order is generated.	Y
Order Status	Order status. Possible values: active, canceled, deleted, failed, finished, free trial canceled, eree trial expired, initialized, one time, pending remote creation, pending user approval, suspended and upcoming. For a description of each status, see Order and subscription statuses.	Y
Assigned Users	Users that currently have access to the product.	Y
Subscription End Date	Date on which the order is canceled.	Y
Sales Agent ID	External identifier on the marketplace for the sales agent associated with the order.	Y
Sales Agent Name	Name of the sales agent associated with the order.	Y
Sales Agent Email	Email address of the sales agent associated with the order.	Y
Sales Agent Company Name	Name of the company that employs the sales agent associated with the order.	Y
Sales Agent Company External ID	External identifier for the company of the sales agent associated with this subscription.	N
Sales Agent Company ID	Identifier for the company of the sales agent associated with this subscription.	N
Sales Agent Company UUID	Unique universal identifier for the company of the sales agent associated with this subscription.	N
Sales Agent User External ID	Sales agent user's external ID on the marketplace.	N
Sales Agent Company Phone	Sales agent's company's phone number.	N
Sales Agent Company Phone Extension	Sales agent's company's phone number extension.	N
Sales Agent Company Fax	Sales agent's company's fax number.	N
Sales Agent Company Fax Extension	Sales agent company's fax number extension.	N
Sales Agent Company Street 1	Address information for the sales agent's company.	N
Sales Agent Company Street 2	Additional address information for the sales agent's company.	N
Sales Agent Company State	Sales agent company's state.	N
Sales Agent Company Country	Sales agent company's country.	N
Sales Agent Company Zip	Sales agent company's ZIP code.	N
Vendor Company External ID	Application developer's external identifier on the marketplace.	N
Vendor Company UUID	Application developer's unique universal identifier.	N
Vendor Company Phone	Application developer's phone number.	N
Vendor Company Phone Extension	Application developer's phone number extension.	N
Vendor Company Fax	Application developer's fax number.	N
Vendor Company Fax Extension	Application developer's fax number extension.	N
Vendor Company Street 1	Application developer's address information.	N
Vendor Company Street 2	Application developer's additional address information.	N
Vendor Company State	Application developer's state.	N
Vendor Company Country	Application developer's country.	N
Vendor Company Zip	Application developer's ZIP code.	N
Owner Company External ID	Purchasing owner's external identifier.	N
Owner Company UUID	Purchasing owner's unique universal identifier.	N
Owner User External ID	Purchasing company's eternal identifier on the marketplace.	N
Owner Company State	Purchasing company's state.	N
Owner Company Street 1	Purchasing company's address.	N
Owner Company Street 2	Purchasing company's additional address information .	N
Owner Company Zip	Purchaser's company ZIP code.	N
Owner Company Country	Purchasing company's country.	N
Owner Company Phone Extension	Purchasing company's phone number.	N
Owner Company Fax	Purchasing company's fax number.	N
Owner Company Fax Extension	Purchasing company's fax number extension.	N
End Date	Date on which the order is canceled.	N
End of Contract Date	Calculated end of contract date based on creation date and application’s minimum contract duration.	N
Edition Code	Edition identifier specified by the application Developer.	N
Edition UUID	Unique universal identifier of the purchased application or product.	N
Application UUID	Unique universal identifier of the product on the marketplace.	N
Application Custom Integration	Indicates if the application purchased has custom integration. Possible values: Google Apps, MOSI (Microsoft Online Services), Mozy	N
Sales Agent UUID	Sales agent’s unique universal identifier on the marketplace.	N
Product Category	List of product categories associated with application purchased.	N
Product Sub Category	List of product sub categories associated with application purchased.	N
Product Category & Sub Category	List of product categories and subcategories, separated by ampersand, that are associated with the application purchased. For example: New Category App=&Services=Audit & Consulting&Services=Engineering & Integration&Services=Design&Web Development=	N
External Vendor Identifier	Unique identifier used by the application vendor associated with a subscription	N
Subscription UUID	Unique universal identifier on the marketplace of the company’s product subscription (remains unchanged even if the subscription ownership is transferred to another user within the company)	N
Microsoft Order ID	Unique identifier for a specific Microsoft order	N
Microsoft Subscription ID	Unique identifier for a specific Microsoft subscription	N
External Partner Identifier	Subscription ID assigned by the marketplace selling the product	N
External Reference Code	Purchase order reference code	N
Minimum Contract Duration	Minimum contract duration (integer value, or null if no contract exists)	N
Price Per Unit	Price paid for each unit purchased	N
Edition Last Modification Date	Last date on which the edition was modified	N
Payment Plan UUID	Universal unique identifier (UUID) of the payment plan in the marketplace	N
Minimum Contract Duration	Minimum contract duration (integer value, or 0 if no contract exists)	N
Payment Plan UUID	Universal unique identifier (UUID) of the payment plan in the marketplace.	N