The subscription report is a document in CSV format that contains information about subscriptions, such as their creation date, customer email, and active SKU.

You can generate the report using the Generate report endpoint.

The following types of reports are available:

• Subscriptions with status
• Subscriptions scheduled between dates
• Subscriptions updated between dates
• Subscriptions created between dates
• Subscriptions triggered between dates

You can also use the endpoint <a href=https://developers.vtex.com/docs/api-reference/subscriptions-api-v3#get-/api/rns/pvt/reports>List report templates to learn the types of reports you can generate.

In this article, you’ll learn more about the data returned by each type of subscription report.

The subscriptionsWithStatus report returns subscription data based on the status of the cycle run.

The columns correspond to specific information about the subscription, as described below:

Field name	Description
ID	Subscription ID.
Customer Email	Email address of the customer.
Customer Id	The ID of the customer.
Status	Status of the subscription when the report was created.

TRIGGERED: A subscription cycle run was triggered.

IN_PROCESS: The subscription is being processed by the system (temporary status).

FAILURE: An internal error occurred while running the subscription.

SUCCESS: The subscription cycle was processed successfully.

EXPIRED: The subscription wasn't renewed and exceeded the current deadline.

ORDER_ERROR: The subscription cycle failed due to a place order error.

PAYMENT_ERROR: The subscription cycle failed due to a payment error.

SKIPPED: The subscription cycle was skipped; the subscription will run in the next cycle.

SUCCESS_WITH_NO_ORDER: A subscription cycle was successfully processed, but the associated order has no items.

SUCCESS_WITH_PARTIAL_ORDER: A subscription cycle was successfully processed and has a partial order associated.

RE_TRIGGERED: A manual re-run of the subscription cycle was triggered.

SCHEDULE_UPDATED: The next subscription cycle date was updated.

| Has Active Items | Indicates whether the subscription has active items.

TRUE: Has active items.

FALSE: No active items.

| Is Skipped | Indicates the subscription cycle will be skipped.

TRUE: The cycle will be skipped.

FALSE: The cycle won't be skipped.

| Next Purchase Date | Date of the next scheduled purchase. | | Last Purchase Date | Date of the last purchase. | | Periodicity | Frequency of the subscription. | | Interval | Subscription interval. | | Purchase Day | Day of the subscription purchase. | | AddressId | ID of customer address. | | AddressType | Type of address. | | PaymentSystem Name | Payment method used in the subscription. | | Account Id | ID of the account. | | Selected Sla | The Service Level Agreement (SLA) selected. | | Cycle | Number that identifies the cycle of the subscription. | | Created At | Date the subscription was created. | | Last Update | Date of the last update. | | Subscriptions Items Count | Number of items in the subscription. | | Subscriptions Item Id | ID of the subscription item. | | Subscriptions Item Status | Status of the subscription item. | | Subscriptions Item Sku Id | SKU of the subscription item. | | Subscriptions Item PriceAtSubscriptionDate | Item price at subscription time. | | Subscriptions Item Quantity | Number of items in the subscription. | | Subscriptions Item Is Skipped | Indicates if the item will be skipped.

TRUE: The item will be skipped.

FALSE: The item won't be skipped.

| Subscriptions Item Cycle | Cycle of the subscription item. | | Subscriptions Item OriginalOrder | Original order of the subscription item. |

The subscriptionsScheduledBetweenDate report returns data on subscriptions scheduled within a date range.

The columns correspond to specific information about the subscription, as described below:

Field name	Description
ID	Subscription ID.
Customer Email	Email address of the customer.
Customer Id	The ID of the customer.
Status	Status of the subscription when the report was created.

TRIGGERED: A subscription cycle run was triggered.

IN_PROCESS: The subscription is being processed by the system (temporary status).

FAILURE: An internal error occurred while running the subscription.

SUCCESS: The subscription cycle was processed successfully.

EXPIRED: The subscription wasn't renewed and exceeded the current deadline.

ORDER_ERROR: The subscription cycle failed due to a place order error.

PAYMENT_ERROR: The subscription cycle failed due to a payment error.

SKIPPED: The subscription cycle was skipped; the subscription will run in the next cycle.

SUCCESS_WITH_NO_ORDER: A subscription cycle was successfully processed, but the associated order has no items.

SUCCESS_WITH_PARTIAL_ORDER: A subscription cycle was successfully processed and has a partial order associated.

RE_TRIGGERED: A manual re-run of the subscription cycle was triggered.

SCHEDULE_UPDATED: The next subscription cycle date was updated.

| Has Active Items | Indicates whether the subscription has active items.

TRUE: Has active items.

FALSE: No active items.

| Is Skipped | Indicates the subscription cycle will be skipped.

TRUE: The cycle will be skipped.

FALSE: The cycle won't be skipped.

| Next Purchase Date | Date of the next scheduled purchase. | | Last Purchase Date | Date of the last purchase. | | Periodicity | Frequency of the subscription. | | Interval | Interval between orders. | | Purchase Day | Day of the subscription purchase. | | AddressId | ID of the customer address. | | AddressType | Type of address. | | PaymentSystem Name | Payment method used in the subscription. | | Account Id | ID of the account. | | Selected Sla | The Service Level Agreement (SLA) selected. | | Cycle | Number that identifies the cycle of the subscription. | | Created At | Date the subscription was created. | | Last Update | Date of the last update. | | Subscriptions Items Count | Number of items in the subscription. | | Subscriptions Item Id | ID of the subscription item. | | Subscriptions Item Status | Status of the subscription item. | | Subscriptions Item Sku Id | SKU of the subscription item. | | Subscriptions Item PriceAtSubscriptionDate | Item price at subscription time. | | Subscriptions Item Quantity | Number of items in the subscription. | | Subscriptions Item Is Skipped | Indicates if the item will be skipped.

TRUE: The item will be skipped.

FALSE: The item won't be skipped.

| Subscriptions Item Cycle | Cycle of the subscription item. | | Subscriptions Item OriginalOrder | Original order of the subscription item. |

The subscriptionsUpdatedBetweenDate report returns data on subscriptions updated within a date range.

The columns correspond to specific information about the subscription, as described below:

Field name	Description
ID	Subscription ID.
Customer Email	Email address of the customer.
Customer Id	The ID of the customer.
Status	Status of the subscription when the report was created.

TRIGGERED: A subscription cycle run was triggered.

IN_PROCESS: The subscription is being processed by the system (temporary status).

FAILURE: An internal error occurred while running the subscription.

SUCCESS: The subscription cycle was processed successfully.

EXPIRED: The subscription wasn't renewed and exceeded the current deadline.

ORDER_ERROR: The subscription cycle failed due to a place order error.

PAYMENT_ERROR: The subscription cycle failed due to a payment error.

SKIPPED: The subscription cycle was skipped; the subscription will run in the next cycle.

SUCCESS_WITH_NO_ORDER: The subscription cycle was completed successfully, but no items were in the order.

SUCCESS_WITH_PARTIAL_ORDER: A subscription cycle was completed successfully with a partial order.

RE_TRIGGERED: A manual re-run of the subscription cycle was triggered.

SCHEDULE_UPDATED: The next subscription cycle date was updated.

| Has Active Items | Indicates whether the subscription has active items.

TRUE: Has active items.

FALSE: No active items.

| Is Skipped | Indicates the subscription cycle will be skipped.

TRUE: The cycle will be skipped.

FALSE: The cycle won't be skipped.

| Next Purchase Date | Date of the next scheduled purchase. | | Last Purchase Date | Date of the last purchase. | | Periodicity | Frequency of the subscription. | | Interval | Interval between orders. | | Purchase Day | Day of the subscription purchase. | | AddressId | ID of customer address. | | AddressType | Type of address. | | PaymentSystem Name | Payment method used in the subscription. | | Account Id | ID of the account. | | Selected Sla | The Service Level Agreement (SLA) selected. | | Cycle | Number that identifies the cycle of the subscription. | | Created At | Date the subscription was created. | | Last Update | Date of the last update. | | Subscriptions Items Count | Number of items in the subscription. | | Subscriptions Item Id | ID of the subscription item. | | Subscriptions Item Status | Status of the subscription item. | | Subscriptions Item Sku Id | SKU of the subscription item. | | Subscriptions Item PriceAtSubscriptionDate | Item price at subscription time. | | Subscriptions Item Quantity | Number of items in the subscription. | | Subscriptions Item Is Skipped | Indicates if the item will be skipped.

TRUE: The item will be skipped.

FALSE: The item won't be skipped.

| Subscriptions Item Cycle | Cycle of the subscription item. | | Subscriptions Item OriginalOrder | Original order of the subscription item. |

The subscriptionsCreatedBetweenDate report returns data on subscriptions created within a date range.

The columns correspond to specific information about the subscription, as described below:

Field name	Description
ID	Subscription ID.
Customer Email	Email address of the customer.
Customer Id	The ID of the customer.
Status	Status of the subscription when the report was created.

TRIGGERED: A subscription cycle run was triggered.

IN_PROCESS: The subscription is being processed by the system (temporary status).

FAILURE: An internal error occurred while running the subscription.

SUCCESS: The subscription cycle was processed successfully.

EXPIRED: The subscription wasn't renewed and exceeded the current deadline.

ORDER_ERROR: The subscription cycle failed due to a place order error.

PAYMENT_ERROR: The subscription cycle failed due to a payment error.

SKIPPED: The subscription cycle was skipped; the subscription will run in the next cycle.

SUCCESS_WITH_NO_ORDER: A subscription cycle was successfully processed, but the associated order has no items.

SUCCESS_WITH_PARTIAL_ORDER: A subscription cycle was successfully processed and has a partial order associated.

RE_TRIGGERED: A manual re-run of the subscription cycle was triggered.

SCHEDULE_UPDATED: The next subscription cycle date was updated.

| Has Active Items | Indicates whether the subscription has active items.

TRUE: Has active items.

FALSE: No active items.

| Is Skipped | Indicates the subscription cycle will be skipped.

TRUE: The cycle will be skipped.

FALSE: The cycle won't be skipped.

| Next Purchase Date | Date of the next scheduled purchase. | | Last Purchase Date | Date of the last purchase. | | Periodicity | Frequency of the subscription. | | Interval | Interval between orders. | | Purchase Day | Day of the subscription purchase. | | AddressId | ID of customer address. | | AddressType | Type of address. | | PaymentSystem Name | Payment method used in the subscription. | | Account Id | ID of the account. | | Selected Sla | The Service Level Agreement (SLA) selected. | | Cycle | Number that identifies the cycle of the subscription. | | Created At | Date the subscription was created. | | Last Update | Date of the last update. | | Subscriptions Items Count | Number of items in the subscription. | | Subscriptions Item Id | ID of the subscription item. | | Subscriptions Item Status | Status of the subscription item. | | Subscriptions Item Sku Id | SKU of the subscription item. | | Subscriptions Item PriceAtSubscriptionDate | Item price at subscription time. | | Subscriptions Item Quantity | Number of items in the subscription. | | Subscriptions Item Is Skipped | Indicates if the item will be skipped.

TRUE: The item will be skipped.

FALSE: The item won't be skipped.

| Subscriptions Item Cycle | Cycle of the subscription item. | | Subscriptions Item OriginalOrder | Original order of the subscription item. |

The executionsBetweenDate report returns data on subscriptions executed within a date range.

The columns correspond to specific information about the subscription, as described below:

Field name	Description
Id	Subscription ID.
OrderGroup	ID of the order generated by the report.
E-mail	Email address of the customer.
Customer Id	The ID of the customer.
Skus	SKUs of the subscription products.
Order	Number of the order.
Value	Price of the subscription.
cycleCount	Number that identifies the cycle of the subscription.
date	Date the subscription was created.
IsInRetry	Indicates if the execution was the result of a retry.

TRUE: The execution was the result of a retry.

FALSE: The execution wasn't the result of a retry.

| Status | Status of the subscription at the time the report was created.

TRIGGERED: A subscription cycle run was triggered.

IN_PROCESS: The subscription is being processed by the system (temporary status).

FAILURE: An internal error occurred while running the subscription.

SUCCESS: The subscription cycle was processed successfully.

EXPIRED: The subscription wasn't renewed and exceeded the current deadline.

ORDER_ERROR: The subscription cycle failed due to a place order error.

PAYMENT_ERROR: The subscription cycle failed due to a payment error.

SKIPPED: The subscription cycle was skipped; the subscription will run in the next cycle.

SUCCESS_WITH_NO_ORDER: A subscription cycle was successfully processed, but the associated order has no items.

SUCCESS_WITH_PARTIAL_ORDER: A subscription cycle was successfully processed and has a partial order associated.

RE_TRIGGERED: A manual re-run of the subscription cycle was triggered.

SCHEDULE_UPDATED: The next subscription cycle date was updated.

| messageParsed | Message returned by Checkout during the subscription run. | | CreatedAt | Date the subscription was created. | LastUpdate | Date of the last update. | | ActiveSkus | Active SKUs in the subscription. |