Skip to main content

Supporters export

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

The tables list every available column. Default marks the ones already selected when you open the export dialog (or ask for the fields through the API); the others are added by hand.

Profile columns​

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

ColumnName in RiseactDefaultMeaning
idIdalwaysIdentifier of the supporter
supporter external refExternal referenceyesExternal reference, the reconciliation key with an external CRM
donor typeDonor typeyesSupporter type (INDIVIDUAL, COMPANY, ORGANIZATION, FAMILY, GROUP)
first nameFirst nameyesFirst name
last nameLast nameyesLast name
companyCompanyyesCompany name
date of birthDate of birthyesDate of birth
place of birthPlace of birthyesPlace of birth
titleTitleyesTitle
jobJobyesJob
phonePhoneyesPhone
mobileMobileyesMobile
emailEmailyesEmail
tax identification numberTax identification numberyesTax code
vatVATyesVAT number
addressAddressyesAddress
cityCityyesCity
provinceProvinceyesProvince
zipZipyesZip code
country codeCountry codeyesCountry code
accepts email marketingAccepts email marketingyesConsent to email communications
accepts sms marketingAccepts SMS marketingyesConsent to SMS communications
accepts phone marketingAccepts phone marketingyesConsent to phone communications
accepts postal marketingAccepts postal marketingyesConsent to postal communications
accepts profilation marketingAccepts profiling marketingyesConsent to profiling
tagsSupporter tagsyesTags of the supporter
noteSupporter noteyesNotes on the supporter

Additional columns​

The importer does not know them.

ColumnName in RiseactDefaultMeaning
codeSupporter codeyesInternal supporter code
full nameFull nameFull name, already composed
sexSexSex
address2Address line 2Second address line
archivedArchivedWhether the supporter is archived
create dateSupporter creation dateyesCreation date of the supporter
update dateSupporter update dateLast update date of the supporter
source campaignSource campaignCampaign the supporter came from
channelChannelChannel (application) the supporter came from
import idImportIdentifier of the import that created it
merged with idMerged withIdentifier of the supporter it was merged into
stripe customer idStripe customer idStripe customer of the supporter (cus_...)

Statistics​

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

ColumnName in RiseactDefaultMeaning
supporter donations countDonations countyesNumber of donations of the supporter, drafts excluded
supporter donated totalTotal donatedyesSum of the amounts of paid payments
supporter active recurring countActive recurring donationsyesRecurring donations (monthly or yearly) in active state
supporter first donation dateFirst donation dateyesDate of the first paid payment
supporter last donation dateLast donation dateyesDate of the last paid payment
supporter payments countPayments countyesNumber of paid payments
supporter average donationAverage donationAverage 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.

Privacy and custom fields​

One column for each privacy consent and each supporter custom field defined in the organization, all selected by default.

ColumnName in RiseactDefaultMeaning
privacy_<code>consent labelyesPrivacy consents of the organization, one per definition
custom_<key>field nameyesCustom fields of the supporter, one per field