Supporters export

One row per supporter: profile and donation statistics. The first column is always id.

Profile columns

They have the same name in the importer: a file with only these columns can be re-imported.

Column	Name in Riseact	Meaning
supporter external ref	External reference	External reference, the reconciliation key with an external CRM
donor type	Donor type	Supporter type (INDIVIDUAL, COMPANY, ORGANIZATION, FAMILY, GROUP)
first name, last name	First name, Last name	First and last name
company	Company	Company name
date of birth, place of birth	Date of birth, Place of birth	Date and place of birth
title, job	Title, Job	Title and job
phone, mobile, email	Phone, Mobile, Email	Contacts
tax identification number, vat	Tax identification number, VAT	Tax code and VAT number
address, city, province, zip, country code	Address, City, Province, Zip, Country code	Address
accepts email marketing, accepts sms marketing, accepts phone marketing, accepts postal marketing, accepts profilation marketing	Accepts email marketing, Accepts SMS marketing, Accepts phone marketing, Accepts postal marketing, Accepts profiling marketing	Marketing consents
tags, note	Supporter tags, Supporter note	Tags and notes
custom_<key>	field name	Supporter custom fields

Additional columns

The importer does not know them.

Column	Name in Riseact	Meaning
code	Supporter code	Internal supporter code
full name	Full name	Full name, already composed
sex	Sex	Sex
address2	Address line 2	Second address line
archived	Archived	Whether the supporter is archived
create date, update date	Supporter creation date, Supporter update date	Creation and last update dates
source campaign	Source campaign	Campaign the supporter came from
channel	Channel	Channel (application) the supporter came from
import id	Import	Identifier of the import that created it
merged with id	Merged with	Identifier of the supporter it was merged into
stripe customer id	Stripe customer id	Stripe customer of the supporter
privacy_<code>	consent label	Privacy consents of the organization

Statistics

Computed at export time. They have the supporter prefix here too, so they have the same name in the donations export.

Column	Name in Riseact	Definition
supporter donations count	Donations count	Number of donations of the supporter, drafts excluded
supporter donated total	Total donated	Sum of the amounts of paid payments
supporter active recurring count	Active recurring donations	Recurring donations (monthly or yearly) in active state
supporter first donation date	First donation date	Date of the first paid payment
supporter last donation date	Last donation date	Date of the last paid payment
supporter payments count	Payments count	Number of paid payments
supporter average donation	Average donation	Average amount per paid payment

Unpaid payments (pending, failed, refunded) are not counted in the totals. First and last donation dates are payment dates, not record creation dates: on data imported from a history the difference matters.

A supporter with no donations has empty cells, not zeros.