A Recurring Subscriptions export will export a .csv with the following information related any visitor with a Recurring Pass Price.
These are the fields related to the export:
key: A unique identifier for each record in the report.
service: Indicates the payment service used for the membership (e.g., Stripe, External).
state: The current status of the membership (e.g., Active, Pending, Cancelled).
external_id: An identifier for the subscription in the external payment service.
price: The price of the membership plan.
climber_key: The unique climber ID
first: The first name of the member associated with the membership.
middle: The middle name of the member associated with the membership.
last: The last name of the member associated with the membership.
email: The email of the subscription holder
created_date: The date when the membership was created.
last_billed: The date of the most recent billing for the membership.
next_billing_date: The date when the next billing will occur.
billing_freq_months: The frequency of billing in months (e.g., 1 for monthly billing).
pending_credit: Any pending credit amount that is yet to be applied.
discount: Any discount applied to the membership.
billing_issues: Notes or indicators of any billing issues.
metadata: Notes or indicators of any billing issues.
extras: Notes or indicators of any billing issues.
pass_holders: To whom the passes were issued too, note, if this is not the same as the climber, the passes were transferred.
This report provides a snapshot of the status and details of recurring memberships, including billing information and any potential issues.
If you wish to include the subscription holder without a payment method in the report, ensure to enable “get billing status in download”. This will retrieve the subscribers Payment method status.
