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.
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
supporter id | Supporter id | yes | Identifier of the supporter |
supporter external ref | External reference | yes | External reference, the reconciliation key with an external CRM |
supporter donor type | Donor type | Supporter type (INDIVIDUAL, COMPANY, ORGANIZATION, FAMILY, GROUP) | |
supporter first name | First name | yes | First name |
supporter last name | Last name | yes | Last name |
supporter company | Company | yes | Company name |
supporter date of birth | Date of birth | Date of birth | |
supporter place of birth | Place of birth | Place of birth | |
supporter title | Title | Title | |
supporter job | Job | Job | |
supporter code | Supporter code | Internal supporter code | |
supporter full name | Full name | yes | Full name, already composed |
supporter sex | Sex | Sex | |
supporter phone | Phone | yes | Phone |
supporter mobile | Mobile | Mobile | |
supporter email | yes | ||
supporter tax identification number | Tax identification number | Tax code | |
supporter vat | VAT | VAT number | |
supporter address | Address | yes | Address |
supporter address2 | Address line 2 | yes | Second address line |
supporter city | City | yes | City |
supporter province | Province | yes | Province |
supporter zip | Zip | yes | Zip code |
supporter country code | Country code | yes | Country code |
supporter accepts email marketing | Accepts email marketing | yes | Consent to email communications |
supporter accepts sms marketing | Accepts SMS marketing | yes | Consent to SMS communications |
supporter accepts phone marketing | Accepts phone marketing | Consent to phone communications | |
supporter accepts postal marketing | Accepts postal marketing | Consent to postal communications | |
supporter accepts profilation marketing | Accepts profiling marketing | Consent to profiling | |
supporter tags | Supporter tags | yes | Tags of the supporter |
supporter note | Supporter note | yes | Notes on the supporter |
supporter donations count | Donations count | Number of donations of the supporter, drafts excluded | |
supporter donated total | Total donated | yes | 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 | yes | Number of paid payments |
supporter average donation | Average donation | Average amount per paid payment | |
supporter archived | Archived | Whether the supporter is archived | |
supporter create date | Supporter creation date | Creation date of the supporter | |
supporter update date | Supporter update date | Last update date of the supporter | |
supporter source campaign | Source campaign | Campaign the supporter came from | |
supporter channel | Channel | Channel (application) the supporter came from | |
supporter import id | Import | Identifier of the import that created it | |
supporter merged with id | Merged with | Identifier of the supporter it was merged into | |
supporter stripe customer id | Stripe customer id | Stripe 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
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
donation id | Donation id | always | Identifier of the donation |
donation external ref | Donation external reference | yes | External reference of the donation |
donation tags | Donation tags | yes | Tags of the donation |
donation code | Donation code | yes | Code of the donation |
donation state | Donation state | yes | State (draft, pending, active, past_due, done, revoked) |
donation amount | Donation amount | yes | Amount of the donation |
donation frequency | Frequency | yes | Frequency (ONEOFF, MONTHLY, ANNUALLY) |
donation note | Donation note | yes | Notes on the donation |
donation completed date | Donation date | yes | Completion date |
donation create date | Donation creation date | Creation date of the donation | |
donation update date | Donation update date | Last update date of the donation | |
donation past due date | Past due date | Date the recurring donation became past due | |
donation revoked date | Revoked date | Revocation date | |
donation channel | Donation channel | Channel (application) it came from | |
donation import id | Donation import | Identifier of the import that created it | |
checkout token | Checkout token | Token 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
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
campaign name | Campaign | yes | Campaign title |
campaign id | Campaign id | Identifier of the campaign | |
campaign code | Campaign code | yes | Code of the campaign |
campaign slug | Campaign slug | yes | Slug of the campaign |
campaign tags | Campaign tags | Tags of the campaign | |
cost example name | Destination | yes | Chosen destination |
cost example quantity | Destination quantity | Quantity of the destination | |
peer campaign slug | Peer campaign | Slug of the peer-to-peer fundraiser | |
peer campaign supporter id | Collected by (supporter id) | yes | Identifier of the supporter who collected the donation |
peer campaign supporter name | Collected by | yes | Name of the supporter who collected the donation |
Payment method
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payment method | Payment method | yes | Label of the payment method |
payment method id | Payment method id | Identifier of the payment method | |
payment method processor | Payment processor | yes | Processor (manual, stripe, paypal, satispay, sumup) |
payment method stripe payment type | Stripe payment type | Stripe payment type of the method | |
payment method paypal payment type | PayPal payment type | PayPal payment type of the method | |
payment method sumup payment type | SumUp payment type | SumUp payment type of the method | |
payment method include in certificate | Included in tax certificates | Whether 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:
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
payments count | Payments count | yes | Number of paid payments |
payments paid total | Total paid | yes | Total collected |
payments first date | First payment date | yes | Date of the first collection |
payments last date | Last paid payment date | yes | Date of the last collection |
Last payment, whatever its state:
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
amount | Last payment amount | yes | Amount of the last payment, whatever its state |
payment date | Last payment date | yes | Date of the last payment, whatever its state |
last payment id | Last payment id | Identifier of the last payment | |
last payment state | Last payment state | State of the last payment (PENDING, PAID, REFUNDED, FAILED) | |
last payment processor fee | Last payment processor fee | Processor fee on the last payment: see processor fee and net amount | |
last payment net amount | Last payment net amount | Net 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
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
last payment stripe intent id | Stripe intent id | yes | Stripe payment intent (pi_...) |
last payment stripe charge id | Stripe charge id | Charge of the intent (ch_... or py_...), the id Stripe reports in payouts and balance transactions | |
last payment stripe payment method id | Stripe payment method id | Stripe payment method used (pm_...) | |
donation stripe subscription id | Stripe subscription id | Stripe subscription of the recurring donation (sub_...) |
PayPal
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
last payment paypal order id | PayPal order id | PayPal order, on one-off donations | |
last payment paypal capture id | PayPal capture id | yes | Capture of the order: the transaction id of a one-off donation in the PayPal dashboard |
last payment paypal sale id | PayPal sale id | yes | Sale of a single installment of a subscription: the transaction id of an installment in the PayPal dashboard |
donation paypal subscription id | PayPal subscription id | PayPal subscription of the recurring donation (I-...) |
Satispay
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
last payment satispay payment id | Satispay payment id | yes | Satispay payment |
last payment satispay external code | Satispay external code | External code of the Satispay payment |
SumUp
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
last payment sumup transaction code | SumUp transaction code | yes | SumUp transaction code |
last payment sumup merchant code | SumUp merchant code | SumUp merchant code | |
last payment sumup device serial number | SumUp device serial number | Serial number of the SumUp device | |
last payment sumup transaction time | SumUp transaction time | Time of the SumUp transaction, in UTC |
SumUp data is there only for payments reconciled from a SumUp report.
Card
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
last payment card brand | Card brand | Card brand | |
last payment card last4 | Card last 4 digits | Last 4 digits of the card | |
last payment card exp month | Card expiry month | Card expiry month | |
last payment card exp year | Card expiry year | Card expiry year | |
last payment card funding | Card funding | Card funding type (credit, debit, prepaid) | |
last payment card country | Card country | Card country | |
last payment card fingerprint | Card fingerprint | Card fingerprint: the same on every payment made with the same card | |
last payment card processor reference | Card processor reference | Reference of the card at the processor |
Account
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
last payment bank account last4 | Bank account last 4 digits | Last 4 digits of the SEPA account | |
last payment bank account processor reference | Bank account processor reference | Reference 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).
| Column | Name in Riseact | Default | Meaning |
|---|---|---|---|
privacy_<code> | consent label | yes | Privacy consents of the organization, one per definition |
custom_<key> | field name | yes | Custom fields of the supporter and of the donation, one per field |