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 | |
βοΈ email | 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.