Export subscriptions

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

  1. Go to the Subscription section.

    Subscription section
  2. Select the filters to apply.

    Click on the configuration of filters
    Select filters and apply.
  3. Click on the icon to process the data

  4. Wait for a notification when the report is finished, click on that to open the report.

    1. Notification by email

    2. Notification by system messages

  5. Download the report

πŸ“‘ Explain data

Here's a description of the columns shown in the report generated in CSV format:

Field

Type

Description

Field

Type

Description

Subscription

#️⃣ uuid

Unique identifier assigned to the subscription.

First name

πŸ‘€ text

Customer name

Last name

πŸ‘€ text

Email

βœ‰οΈ 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.