Report Guide: Donations
This reference explains some of the common fields used to pull data for Donation Reports.
Donation Reports
| Category | Name | Field ID | Context | Possible Values (if relevant) |
|---|---|---|---|---|
| Transactions | UUID | uuid | This is the UUID associated with the Donation Reference Number. This can be found in the donation record. | |
| Transactions | Id | id | ||
| Transactions | Created At | createdAt | The time the transaction was processed. This format is controlled via your Organisation Settings → Timezone Settings. | YYYY-MM-DD HH:MM UTC |
| Transactions | Mode | mode | Indicates whether the campaign was in live or test mode. | TEST / LIVE |
| Transactions | Processing | processing | Indicates whether it’s a once-off or recurring payment. | ONCE / RECURRING |
| Transactions | Status | status | The state of the payment at the time the report was generated. | OK / FAILED / PENDING |
| Transactions | Type | type | Whether the source of the donation was online (via donation form) or offline (e.g. imported, Facebook, manual). | ONLINE / OFFLINE |
| Transactions | Method Type | methodType | The payment method used. | CARD / APPLE_PAY / GOOGLE_PAY |
| Transactions | Method | method | The payment gateway used. | STRIPE_INTENT / PAYPAL |
| Transactions | Donation Total Display Total Amount |
donationTotal displayTotal amount |
The numerical donation value regardless of currency. E.g. if a campaign’s base is AUD and a donation is made in USD, this value reflects the original number. | E.g. 36 USD → “36” |
| Transactions | Total | total | The donation amount plus the Raisely Fee, regardless of currency. | E.g. 36 USD + 1.58 USD → “37.58” |
| Transactions | Order Total | orderTotal | The value of tickets, merchandise, or registration fees, in the campaign’s currency. | |
| Transactions | Campaign Display Total Campaign Amount |
campaignDisplayTotal campaignAmount |
The donation value in the campaign’s currency, based on the conversion rate at the time of processing. Also displayed on the Campaign Dashboard (rounded to whole numbers). | E.g. 36 USD → “55.57” AUD |
| Transactions | Net | N/A | The donation amount in campaign currency minus the gateway fee. | E.g. 55.57 AUD - 1.91 AUD → “53.66” AUD |
| Transactions | Raisely Fee | fee | The value of the opt-in Raisely fee, regardless of currency. | E.g. 5 USD → “5” |
| Transactions | Gateway Fee Campaign Fee |
N/A campaignFee |
The payment gateway’s processing fee plus tax, shown in the configured currency (usually the campaign’s base currency). | E.g. 0.48 AUD + 0.05 AUD → “0.53” AUD |