Export subscriptions
Purpose
The purpose of this document is to explain how to create export subscriptions and explain the data presented in the export. This document has two sections:
🗃️ Procedure to create export
📑 Explain data
After configuring and creating the report, you will receive a notification to view the generated data. You must download the information in CSV format to proceed with the analysis.
🗃️ Procedure to create export
Go to the Subscription section.
Subscription sectionSelect the filters to apply.
Click on the configuration of filtersSelect filters and apply.Click on the icon to process the data
Wait for a notification when the report is finished, click on that to open the report.
Notification by email
Notification by system messages
Download the report
📑 Explain data
Here's a description of the columns shown in the report generated in CSV format:
Field | Type | Description |
---|---|---|
Subscription | #️⃣ uuid | Unique identifier assigned to the subscription. |
First name | 👤 text | Customer name |
Last name | 👤 text | |
Customer email | ||
Product | ✏️ text | Name of product |
Variation | ✏️ text | Name of product variation |
Plan id | #️⃣ uuid | Unique identifier assigned to the plan |
Plan | ✏️ text | Name of plan |
Plan period | ✏️ text | Plan frequency (monthly, quarterly, yearly etc) |
Country | 🏠 text | Customer address |
State | 🏠 text | |
Zip code | 🏠 text | |
City | 🏠 text | |
Line | 🏠 text | |
Line2 | 🏠 text | |
Next payment date | 📅 date | Date to the next payment |
Next payment amount | 💲 money | Amount to the next payment |
Orders | 🎲 numeric | Total number of paid orders placed |
Total charged | 💲 money | Total amount charged of all orders. |
Total refunded | 💲 money | Total amount refunded of all orders (includes chargebacks). |
Created | 📅 date | Subscription creation date. |
I hope this description helps you understand the columns and the information presented in the CSV report.