Exporting a CSV file of your subscriptions can provide valuable insights into your customer base and streamline your data management processes. This feature allows you to easily analyze subscription trends, manage billing information, and integrate data into other business tools.
In this article, you'll learn how to export a CSV file of your subscriptions step-by-step, ensuring you have the information you need.
Exporting your reviews
From your Yotpo Subscriptions main menu, go to Subscriptions.
- Use the filters to define which subscriptions you want to export. You can filter by product, charge date, status, and more.
- On the right of the screen, click Export to CSV file.
- Select whether you want to export the subscriptions that match your search, or all subscriptions.
- Enter the email address you want the report sent to.
- Click Send email.
The email will include a link to download a CSV file containing all of your subscription data. The time it takes for the email to reach your inbox depends on the size of the file.
Understanding your exported subscription data
Your exported subscriptions are formatted into a CSV spreadsheet file. The table below describes the headers of the spreadsheet (the top row) and the types of information that belong in each column.
Not all columns are relevant for all subscriptions.
| Column header | Description |
|---|---|
| Billing interval frequency | How often the customer is charged for their subscription. For example, a value of 1 means they're charged once per billing interval unit (week or month or year). |
| Billing interval unit | Which time unit is used to charge the customer (month, week, quarter, year) |
| Cancellation comment | Feedback left by the customer if they cancelled the subscription |
| Cancellation reason | The customer's response to the cancellation survey |
| Canceled at | The timestamp of when the subscription was canceled |
| Created at | The timestamp of when the subscription was created |
| Currency code | The currency the customer is charged in (USD, EUR, etc.) |
| Customer email | The email associated with the customer's account |
| Delivery price | How mush the customer is charged for each delivery |
| Expires after billing cycles | Which discount codes were applies to the subscription |
| External customer ID | The number of billing cycles until the subscription expires. If the subscription is ongoing, the value will be 0. |
| External product ID | The Shopify customer ID |
| External subscription ID | The Shopify product ID |
| External variant ID | The Shopify product variant ID |
| Is in dunning | Whether the subscription is in dunning (true, false) |
| Is one-time product | Whether the product is a one-time purchase (true, false) |
| Is prepaid | Whether the subscription is under a prepaid plan (true, false) |
| Last status updated at | The timestamp of when a status change was last made to the subscription |
| Next billing date | The date the customer will next be charged |
| Order interval frequency | How often the customer receives the subscription |
| Order interval unit | Which time unit is used between orders (month, week, quarter, year) |
| Product title | The name of the product |
| Quantity | How many units of the product are included in the subscription |
| Recurring price | The standard charge for the customer's subscription |
| Shipping address | The address subscriptions are sent to |
| Shipping address city | The city subscriptions are sent to |
| Shipping address country | The country subscriptions are sent to |
| Shipping address first name | The first name associated with the shipping address |
| Shipping address last name | The last name associated with the shipping address |
| Shipping address phone | The phone number associated with the shipping address |
| Shipping address province | The province subscriptions are sent to. This could be a state, province, oblast, etc. |
| Shipping address ZIP | The area code subscriptions are sent to |
| Skipped product | Whether the product was skipped (true, false) |
| SKU | The stock keeping unit number of the product |
| Status | The status of the subscription (active, paused, canceled, expired) |
| Total recurring orders | The total number of times the order was processed |
| Updated at | The last date a change was made to the subscription |
| Variant title | The name of the product variant |