You can export a list of your members in CSV format any time. Log in and click "Members" in the top menu navigation and then "Export as CSV." A CSV file can be imported into a spreadsheet application such as Excel for further use. It displays your members' data in rows and columns. The columns are separated as follows:
first_name: First name
last_name: Last name
email: E-mail address
plan_name: Name of the membership plan
plan_monthly_amount_cents: Price in Euro cents that the member pays monthly (both for monthly and annual plans)
gifted: TRUE if the membership is a gift membership or FALSE if it is not
subscription_period: Length of the billing period, annual or monthly
subscription_state: Current state of the membership. Possible states are:
active: Active, paid membership, which is not cancelled.
in_trial: Only if you offer trial periods: The member has an active trial membership during the trial period. If they do not cancel during the trial period, the membership becomes active.
ℹ️ On the members table itself (and in the available filter), the in_trial state is labelled as "trial".
guest: A guest membership (invited by an active, paid member)
not_renewing: The member has cancelled their membership, but their access runs until the end of the billing period (trial_ends_at or expires_at), and can continue to access content behind the Paywall and Adblock Detection. At the end of the billing period, the membership will switch to cancelled.
Gift memberships are also always not_renewing. The gifted attribute should equal TRUE for gift memberships.
ℹ️ On the members table itself (and in the available filter), the not_renewing state is labelled as "expiring" or "expiring (trial)".cancelled: When a membership has been cancelled and reached the end of the payment period, or a trial membership has been cancelled before the end of the trial period, the membership will be in the cancelled state. Similarly if a guest membership was terminated by the guest, by the member who invited the guest or by Steady. The user will not be able to access text behind the Paywall or Adblock Detection.
ℹ️ On the members table itself (and in the available filter),the cancelled state is labelled as "terminated" or "terminated (trial)" or "terminated (guest)".
subscribed_at: The start date of the membership or trial membership.
trial_ends_at: The date a trial membership ends and (30 days after it started). This field is empty if the member was not on a trial membership
cancelled_at: The date of cancelation. This field is empty if the member didn't cancel.
expires_at: The date a cancelled membership expires, i.e. when the member no longer has access to their membership. This field is empty if the member didn't cancel.
The following fields are empty except if you require a shipping address for your membership and the member has provided this information.
shipping_first_name: First name
shipping_last_name: Last name
shipping_company_name: Company name
shipping_street_and_number: Street name and number
shipping_city: City
shipping_zip_code: Zip code
shipping_state: State
shipping_country_code: Country
Be careful with your CSV export data. Save it in a secure location and delete it after use to protect your members' personal data.
Got a question we haven’t answered in our Help Centre? You can contact us at support@steadyhq.com.