Skip to main content

Donations export

One row per donation, with supporter, campaign, payment method and transaction identifiers.

The first column is always donation 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. The default selection differs from the supporters and payments exports.

Supporter columns​

Every supporter column has the supporter prefix. In the export dialog the label is the one of the supporters export: supporter first name is First name.

ColumnName in RiseactDefaultMeaning
supporter idSupporter idyesIdentifier of the supporter
supporter external refExternal referenceyesExternal reference, the reconciliation key with an external CRM
supporter donor typeDonor typeSupporter type (INDIVIDUAL, COMPANY, ORGANIZATION, FAMILY, GROUP)
supporter first nameFirst nameyesFirst name
supporter last nameLast nameyesLast name
supporter companyCompanyyesCompany name
supporter date of birthDate of birthDate of birth
supporter place of birthPlace of birthPlace of birth
supporter titleTitleTitle
supporter jobJobJob
supporter codeSupporter codeInternal supporter code
supporter full nameFull nameyesFull name, already composed
supporter sexSexSex
supporter phonePhoneyesPhone
supporter mobileMobileMobile
supporter emailEmailyesEmail
supporter tax identification numberTax identification numberTax code
supporter vatVATVAT number
supporter addressAddressyesAddress
supporter address2Address line 2yesSecond address line
supporter cityCityyesCity
supporter provinceProvinceyesProvince
supporter zipZipyesZip code
supporter country codeCountry codeyesCountry code
supporter accepts email marketingAccepts email marketingyesConsent to email communications
supporter accepts sms marketingAccepts SMS marketingyesConsent to SMS communications
supporter accepts phone marketingAccepts phone marketingConsent to phone communications
supporter accepts postal marketingAccepts postal marketingConsent to postal communications
supporter accepts profilation marketingAccepts profiling marketingConsent to profiling
supporter tagsSupporter tagsyesTags of the supporter
supporter noteSupporter noteyesNotes on the supporter
supporter donations countDonations countNumber of donations of the supporter, drafts excluded
supporter donated totalTotal donatedyesSum of the amounts of paid payments
supporter active recurring countActive recurring donationsRecurring donations (monthly or yearly) in active state
supporter first donation dateFirst donation dateDate of the first paid payment
supporter last donation dateLast donation dateDate of the last paid payment
supporter payments countPayments countyesNumber of paid payments
supporter average donationAverage donationAverage amount per paid payment
supporter archivedArchivedWhether the supporter is archived
supporter create dateSupporter creation dateCreation date of the supporter
supporter update dateSupporter update dateLast update date of the supporter
supporter source campaignSource campaignCampaign the supporter came from
supporter channelChannelChannel (application) the supporter came from
supporter import idImportIdentifier of the import that created it
supporter merged with idMerged withIdentifier of the supporter it was merged into
supporter stripe customer idStripe customer idStripe customer of the supporter (cus_...)

The statistics are computed as in the supporters export: paid payments only, payment dates rather than creation dates, empty cells for supporters with no donations.

Donation columns​

ColumnName in RiseactDefaultMeaning
donation idDonation idalwaysIdentifier of the donation
donation external refDonation external referenceyesExternal reference of the donation
donation tagsDonation tagsyesTags of the donation
donation codeDonation codeyesCode of the donation
donation stateDonation stateyesState (draft, pending, active, past_due, done, revoked)
donation amountDonation amountyesAmount of the donation
donation frequencyFrequencyyesFrequency (ONEOFF, MONTHLY, ANNUALLY)
donation noteDonation noteyesNotes on the donation
donation completed dateDonation dateyesCompletion date
donation create dateDonation creation dateCreation date of the donation
donation update dateDonation update dateLast update date of the donation
donation past due datePast due dateDate the recurring donation became past due
donation revoked dateRevoked dateRevocation date
donation channelDonation channelChannel (application) it came from
donation import idDonation importIdentifier of the import that created it
checkout tokenCheckout tokenToken of the checkout the donation was made with, the ?co= parameter of its URL. Empty for donations that did not go through the checkout, such as imported or manually entered ones

Campaign​

ColumnName in RiseactDefaultMeaning
campaign nameCampaignyesCampaign title
campaign idCampaign idIdentifier of the campaign
campaign codeCampaign codeyesCode of the campaign
campaign slugCampaign slugyesSlug of the campaign
campaign tagsCampaign tagsTags of the campaign
cost example nameDestinationyesChosen destination
cost example quantityDestination quantityQuantity of the destination
peer campaign slugPeer campaignSlug of the peer-to-peer fundraiser
peer campaign supporter idCollected by (supporter id)yesIdentifier of the supporter who collected the donation
peer campaign supporter nameCollected byyesName of the supporter who collected the donation

Payment method​

ColumnName in RiseactDefaultMeaning
payment methodPayment methodyesLabel of the payment method
payment method idPayment method idIdentifier of the payment method
payment method processorPayment processoryesProcessor (manual, stripe, paypal, satispay, sumup)
payment method stripe payment typeStripe payment typeStripe payment type of the method
payment method paypal payment typePayPal payment typePayPal payment type of the method
payment method sumup payment typeSumUp payment typeSumUp payment type of the method
payment method include in certificateIncluded in tax certificatesWhether the payments are included in tax certificates

payment method, amount and payment date have the importer's names, which it uses to create the payment.

Payments​

Totals, over all the paid payments of the donation:

ColumnName in RiseactDefaultMeaning
payments countPayments countyesNumber of paid payments
payments paid totalTotal paidyesTotal collected
payments first dateFirst payment dateyesDate of the first collection
payments last dateLast paid payment dateyesDate of the last collection

Last payment, whatever its state:

ColumnName in RiseactDefaultMeaning
amountLast payment amountyesAmount of the last payment, whatever its state
payment dateLast payment dateyesDate of the last payment, whatever its state
last payment idLast payment idIdentifier of the last payment
last payment stateLast payment stateState of the last payment (PENDING, PAID, REFUNDED, FAILED)
last payment processor feeLast payment processor feeProcessor fee on the last payment: see processor fee and net amount
last payment net amountLast payment net amountNet amount of the last payment: see processor fee and net amount

Processor identifiers​

They are those of the last payment of the donation, with the last payment prefix. Subscriptions have the donation prefix because they belong to the donation and are the same on every installment.

Stripe

ColumnName in RiseactDefaultMeaning
last payment stripe intent idStripe intent idyesStripe payment intent (pi_...)
last payment stripe charge idStripe charge idCharge of the intent (ch_... or py_...), the id Stripe reports in payouts and balance transactions
last payment stripe payment method idStripe payment method idStripe payment method used (pm_...)
donation stripe subscription idStripe subscription idStripe subscription of the recurring donation (sub_...)

PayPal

ColumnName in RiseactDefaultMeaning
last payment paypal order idPayPal order idPayPal order, on one-off donations
last payment paypal capture idPayPal capture idyesCapture of the order: the transaction id of a one-off donation in the PayPal dashboard
last payment paypal sale idPayPal sale idyesSale of a single installment of a subscription: the transaction id of an installment in the PayPal dashboard
donation paypal subscription idPayPal subscription idPayPal subscription of the recurring donation (I-...)

Satispay

ColumnName in RiseactDefaultMeaning
last payment satispay payment idSatispay payment idyesSatispay payment
last payment satispay external codeSatispay external codeExternal code of the Satispay payment

SumUp

ColumnName in RiseactDefaultMeaning
last payment sumup transaction codeSumUp transaction codeyesSumUp transaction code
last payment sumup merchant codeSumUp merchant codeSumUp merchant code
last payment sumup device serial numberSumUp device serial numberSerial number of the SumUp device
last payment sumup transaction timeSumUp transaction timeTime of the SumUp transaction, in UTC

SumUp data is there only for payments reconciled from a SumUp report.

Card

ColumnName in RiseactDefaultMeaning
last payment card brandCard brandCard brand
last payment card last4Card last 4 digitsLast 4 digits of the card
last payment card exp monthCard expiry monthCard expiry month
last payment card exp yearCard expiry yearCard expiry year
last payment card fundingCard fundingCard funding type (credit, debit, prepaid)
last payment card countryCard countryCard country
last payment card fingerprintCard fingerprintCard fingerprint: the same on every payment made with the same card
last payment card processor referenceCard processor referenceReference of the card at the processor

Account

ColumnName in RiseactDefaultMeaning
last payment bank account last4Bank account last 4 digitsLast 4 digits of the SEPA account
last payment bank account processor referenceBank account processor referenceReference of the SEPA account at the processor

Stripe charges and PayPal sales are recorded only since they were introduced: on earlier installments they are empty, and for PayPal only the subscription id is left.

To reconcile the single installments use the payments export.

Privacy and custom fields​

One column for each privacy consent and each custom field defined in the organization, all selected by default. They do not have the supporter prefix: consents belong to the supporter, custom fields belong to both the supporter and the donation, with the same custom_<key> convention (the key is unique in the organization, so they never overlap).

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