You can export the list of your members as a CSV file at any time. To do so, log in, click on "Members" and then on "Export as CSV". You can then import the CSV file into a spreadsheet application such as Excel or Google Sheets and process it further there. The CSV file consists of rows and columns. Each row contains the data of one member. These are the columns:
first_name: first name
last_name: last name
email: email address
plan_name: name of the plan
plan_monthly_amount_cents: the price (in euro cents) that the member pays each month, for both monthly and annual memberships.
gifted: TRUE if the membership is a gift membership, FALSE if not
subscription_period: length of a billing period: annual membership (annual) or monthly membership (monthly)
subscription_state: current status of the membership. The following statuses exist:
active: an active, paying membership that has not been cancelledin_trial: only relevant if you offer trial memberships: the member has an active trial membership within the trial period. If the member does not cancel during the trial period, the status changes to an active membership (active).
ℹ️ In the members table and in the filter options, the "in_trial" status is simply called "trial".guest: an active guest membership at the invitation of an active, paying member.not_renewing: the member has cancelled the membership, but the membership is still running until the end of the paid period or the trial period (expires_at or trial_ends_at). Until then, the member can still read posts behind the paywall, use an ad blocker without being interrupted by Adblock Detection, and so on. After the end of the period, the membership is then listed as cancelled (cancelled).not_renewing_gift: gift memberships are always "not_renewing", as they are one-off purchases rather than subscriptions.cancelled: when a member has cancelled and the end of the paid period or the free trial period has been reached, the membership is listed as cancelled. Guest memberships are also listed as cancelled once they have been ended by the guest, by the inviting member or by Steady. A former member can then no longer read posts behind the paywall (if activated), and Adblock Detection (if activated) will become active again if the former member uses an ad blocker.cancelled_gift: a gift membership that has endedplan_id: ID of the plan
utm_campaign: campaign attribution – filled if the member signed up via a link or paywall with a campaign parameter
new_plan_name / new_plan_monthly_amount_cents: name and monthly price (in cents) of the plan the membership will switch to at the next renewal – filled after a plan change or price increase, otherwise empty
subscribed_at: date on which the membership or trial membership was taken out
trial_ends_at: date on which the trial membership ends (7 or 30 days after the start, depending on your trial settings). If the member does not cancel, the status then changes to an active membership. This field is empty if there is no trial membership.
cancelled_at: date of cancellation. This field is empty if no cancellation has taken place.
expires_at: the date on which the membership or trial membership ends. This field is empty if no cancellation has taken place.
The following fields are empty unless you require an address for a specific plan and the member has filled in their address.
shipping_first_name: first name
shipping_last_name: last name
shipping_company_name: company name
shipping_street_and_number: street and house number
shipping_city: city
shipping_zip_code: postal code
shipping_state: state/province
shipping_country_code: country
Please handle the CSV file with care. Do not store it in a publicly accessible place, and delete it after use.
Got a question we haven’t answered in our Help Centre? You can contact us at support@steadyhq.com.