Reporting Studio Donation Explore glossary

There's a lot of fields and measures available in Reporting Studio, which also means a lot of terms. This glossary may be a helpful guide while you're building your reports.

Dimensions are descriptive information. Measures are numerical.

Common Fields

Fields commonly used in reports.

FieldDescriptionData Type
Currency DisplayConvert transactions to a selected currencystring
Fiscal Year Transaction DateDate the transaction occurred in the fiscal year (if available)date
Transaction DateDate the transaction occurreddate
Transaction TypeType of transaction. Example: Donation, Manual Adjustmentstring
First Transaction DateDate of first transactiondate
Last Transaction DateDate of last transactiondate

Cause Projects

Details about cause projects.

FieldDescriptionData Type
Cause Project IDUnique identifier for a cause projectstring
Project Address CityCity where the project is located or where work is carried outstring
Project Address Postal CodePostal or ZIP code where the project is located or where work is carried outstring
Project Address State or ProvinceState or province where the project is located or where work is carried outstring
Project Address StreetAddress of the projectstring
Project CaptionTypically the operating organization or a summary of a projectstring
Project Created DateDate and time the project was createddate
Project Deactivated DateDate and time the project was deactivateddate
Project DescriptionProject descriptionstring
Project FacebookProject Facebookstring
Project Map LocationProject latitude and longitude, to use with map chartsstring
Project NameThe project to which the donation was directedstring
Project Phone NumberProject telephone numberstring
Project TwitterProject Twitterstring
Project WebsiteProject Websitestring
Project CountryCountry where the project is located or where work is carried outstring

Causes

Details about causes.

FieldDescriptionData Type
Cause Address CityCity where the cause is locatedstring
Cause Address Postal CodePostal or ZIP code where the cause is locatedstring
Cause Address State or ProvinceState or province where the cause is locatedstring
Cause Address StreetCause street addressstring
Cause CategoryCategory name for a cause. Example: NTEE categorystring
Cause Category CodeUnique code for the cause category and subcategory Example: NTEE codestring
Cause CountryCountry where the cause is locatedstring
Cause EmailEmail of the causestring
Cause IDUnique identifier for the causestring
Cause Map LocationCause latitude and longitude, to use with map chartslocation
Cause NameName of the nonprofit (organization)string
Cause StatusIndicator for if the cause is currently active or inactivestring
Cause SubcategorySubcategory for a cause. Example: NTEE subcategory codestring
Cause TypeDescription of charitable statusstring
Cause WebsiteWebsite for the causestring

Company

Company details.

FieldDescriptionData Type
Company Fiscal Year Start DateStart month for the company fiscal year (if available)date
Company NameCompany Namestring
Company Program NameName of the programstring
Company Program SiteURL for the sitestring

Converted Currency Amounts

Amounts converted into a selected common currency.

FieldDescriptionData Type
Currency ConversionThe common currency all transactions are converted to based on the Currency Filterstring
Adjustment Match Amount (Selected Currency)Amount manually drawn from user match budget in the selected common currencynumber
Corporate Donation Amount (Selected Currency)Amount donated by the company. Includes donations grants and sponsorships in the selected common currencynumber
Corporate Match Amount (Selected Currency)Amount matched by the company to a donation in the selected common currencynumber
Rewards Donation Amount (Selected Currency)Amount donated with user rewards in the selected common currencynumber
Total Corporate Donation Amount (Selected Currency)The total amount of corporate funds going to causes the sum of the corporate donation amount and the corporate match amount in the selected common currencynumber
Total Donation Amount (Selected Currency)The total donation amount from user and corporate funds, including user donations, external donations rewards, corporate donations, and corporate matches in the selected common currencynumber
Total User Donation Amount (Selected Currency)Total of user platform donations and external donations in the selected common currencynumber
User Donation Amount (Selected Currency)Amount donated by the user in the selected common currencynumber
User External Donation Amount (Selected Currency)Amount donated by the user in the selected common currencynumber
Cause Support Fee (Cause Funded) (Selected Currency)Cause support fee paid by the cause in the selected common currencynumber
Cause Support Fee (Company Funded) (Selected Currency)Cause support fee paid by the company in the selected common currencynumber
Merchant Fee (Cause Funded) (Selected Currency)Merchant fee paid by the cause in the selected common currencynumber
Merchant Fee (Company Funded) (Selected Currency)Merchant fee paid by the company in the selected common currencynumber
Corporate Internal Transfer (Selected Currency)Amount of the internal transfer transaction made by the company. Example: seeding, issuing rewards, in the selected common currencynumber
User Internal Transfer (Selected Currency)Amount of the internal transfer transaction made by a user. Example: gift cards, adding funds, in the selected common currencynumber

Donation Reports

Donation Report details.

FieldDescriptionData Type
DR CodeUnique identifier for the Donation Reportstring
DR Created DateDate the Donation Report was createddate
DR Payment StatusPayment status for the Donation Report. Example: Paid, Partialstring
DR AmountThe amount attached to each transaction that will appear on the Donation Reportnumber
DR Amount (with Fees)Donation Report amount including the company-funded cause support fees and merchant feesnumber
Total DR Corporate Contribution AmountThe total contribution amount from corporate funds in DR, including corporate donations, corporate match amounts, internal transfers, and rewardsnumber
Total DR User Contribution AmountThe total contribution amount from user funds in DR including user donations and internal transfersnumber

Donor Details

Donor details.

FieldDescriptionData Type
Donor Address CityCity where donor is locatedstring
Donor Address CountryCountry where donor is locatedstring
Donor Address PostcodePostcode where donor is locatedstring
Donor Address State or ProvinceState or province where donor is locatedstring
Donor Address StreetStreet where donor is locatedstring
Donor EmailEmail address of the donorstring
Donor First NameFirst name of the donorstring
Donor Full AddressFull address of the donorstring
Donor Full NameFull name of the donorstring
Donor InitialsInitials of the donorstring
Donor Last NameLast name of the donorstring
Donor Privacy SharingDonor's privacy preference for this transactionstring

Foundations

Foundation details.

FieldDescriptionData Type
Foundation CodeUnique identifier for the foundationstring
Foundation NameName of the foundationstring
Foundation TypeType of foundation. Example: registered non-charitablestring

Friendraisers

Friendraiser details.

FieldDescriptionData Type
Friendraiser Canceled DateDate the friendraiser was canceleddate
Friendraiser CodeUnique identifier for the friendraiserstring
Friendraiser CountryCountry code for the location of the friendraiserstring
Friendraiser Created DateDate the friendraiser was createdstring
Friendraiser Creator EmailEmail address of the user that created the friendraiserstring
Friendraiser Creator System User IDSystem user ID of the user that created the friendraiserstring
Friendraiser CurrencyDefault currency for the friendraiserstring
Friendraiser End DateEnd date of the friendraiserdate
Friendraiser GoalTarget donation amount for the friendraisernumber
Friendraiser GreetingMessage at the top of the friendraiser page welcoming donorsstring
Friendraiser NameName of the friendraiserstring

Giving Opportunities

Giving opportunity details.

FieldDescriptionData Type
Giving Opportunity CodeUnique identifier for the giving opportunitystring
Giving Opportunity Created DateDate the giving opportunity was createddate
Giving Opportunity Creator EmailOpportunity creator's emailstring
Giving Opportunity Creator First NameOpportunity creator's first namestring
Giving Opportunity Creator Full NameOpportunity creator's full namestring
Giving Opportunity Creator Last NameOpportunity creator's last namestring
Giving Opportunity Deadline DateLast date donations are accepteddate
Giving Opportunity DescriptionDescription of the giving opportunitystring
Giving Opportunity End DateEnd date of the giving opportunitydate
Giving Opportunity FacebookFacebook page URL for the giving opportunitystring
Giving Opportunity GoalTarget donation amountnumber
Giving Opportunity LabelList of reporting tags for the giving opportunitystring
Giving Opportunity Last Updated DateDate the giving opportunity was last updateddate
Giving Opportunity NameName of the giving opportunitystring
Giving Opportunity Publication StatusPublished status of the giving opportunitystring
Giving Opportunity SourceSource of the giving opportunity, e.g. user, companystring
Giving Opportunity StatusCurrent status of the giving opportunity, managed by adminstring
Giving Opportunity SummarySummary of the giving opportunitystring
Giving Opportunity TagsList of tags for the giving opportunitystring
Giving Opportunity TwitterTwitter name for the giving opportunitystring
Giving Opportunity URLURL to access the giving opportunitystring
Giving Opportunity WebsiteWebsite for the giving opportunitystring
Peer Match Associated (Yes/No)Indicator of a peer-matched opportunityyes/no
Giving Opportunity CountNumber of distinct giving opportunitiesnumber

Payments

Payment details.

FieldDescriptionData Type
Payable CodeUnique identifier for the cause payment transactionstring
Payment End DateLast day for transactions to be eligible for the paymentdate
Payment Reference NumberUnique reference for the paymentstring
Payment StatusCurrent status of the paymentstring
Payment Status DateDate of last payment status updatestring
Payment TypeMethod of payment to causestring

Peer Match Details

Peer match details.

FieldDescriptionData Type
Peer Match AmountMaximum match amountnumber
Peer Match CodeUnique identifier for the peer matchstring
Peer Match Created DateDate the peer match was createddate
Peer Match Creator Employee IDEmployee ID of peer match creatorstring
Peer Match End DatePeer match end datedate
Peer Match PercentageMatch percentage agreed by matchernumber
Peer Match Start DatePeer match start datedate

Transactions

Transaction details.

FieldDescriptionData Type
CurrencyCurrency of the original transactionstring
Donation Match CampaignsName of match offerstring
Donation Transaction CodeUnique identifier for a donation transaction, displayed in Giving Historystring
Internal Transfer Transaction CodeUnique identifier for the internal transfer transactionstring
Issued Rewards Canceled DateCancellation date of issued reward, available for internal transfersdate
Issued Rewards Expiry DateExpiry date of issued reward, available for internal transfersdate
Issued Rewards IdentifierReward identifier for internal transfersstring
Issued Rewards TypeType of reward issued, available for internal transfers Example: volunteer, new hirestring
Peer Match Fulfilment (Yes/No)Indicate a donation is a peer match fulfilmentyes/no
Redeemed Rewards IdentifiersReward identifier for donated rewards transactionsstring
Reversal (Yes/No)Indicates if a transaction is a reversalyes/no
Reversal DateReversal datedate
Reversal Transaction CodeUnique identifier for the reversal transactionstring
Reversal TypeIndicates what part of a transaction was reversed e.g donation, matchstring
Transaction CommentComment for the recipient cause entered in the and confidential to Benevity donation formstring
Transaction Comment NameName the user entered for their commentstring
Transaction Committed DateDate donation was recordeddate
Transaction DescriptionDescription of the donation or internal transfer transactionstring
Transaction RecurrenceRecurrence of a transaction. Example: one-time recurringstring
Transaction Reference NumberUnique reference for transactionsstring
Transaction SourceSource of funds. Example: payroll, Paypal Cybersource (credit card)string
Transaction TagsTags associated to each transactionstring
Adjustment Match AmountAmount manually drawn from user match budgetnumber
Cause CountNumber of distinct causesnumber
Transacted User CountsNumber of distinct users that made a transactionnumber
Transaction CountNumber of distinct transactionsnumber
Corporate Donation AmountAmount donated by the company. Includes donations grants and sponsorshipsnumber
Corporate Match AmountAmount matched by the company to a donationnumber
Rewards Donation AmountAmount donated with user rewardsnumber
Total Corporate Donation AmountThe total amount of corporate funds going to causes the sum of the corporate donation amount and the corporate match amountnumber
Total Donation AmountThe total donation amount from user and corporate funds, including user donations, external donations rewards, corporate donations, and corporate matches in the selected common currency.The total donation amount from user and corporate funds, including user donations, external donations, rewards, corporate donations, and corporate matchesnumber
Total User Donation AmountTotal of user donations and external donationsnumber
User Donation AmountAmount donated by the user in the selected common currencynumber
User External Donation AmountAmount donated by the user through external match requestsnumber
Cause Support Fee (Cause Funded)Cause support fee paid by the causenumber
Cause Support Fee (Company Funded)Cause support fee paid by the companynumber
Merchant Fee (Cause Funded)Merchant fee paid by the causenumber
Merchant Fee (Company Funded)Merchant fee paid by the companynumber
Corporate Internal TransferAmount of the internal transfer transaction made by the company. Example: seeding, issuing rewardsnumber
User Internal TransferAmount of the internal transfer transaction made by a user. Example: gift cards, adding fundsnumber

Upcoming Donations

Upcoming donations details.

FieldDescriptionData Type
Aggregate Report IndicatorSet filter to Yes to finalize aggregate amounts in upcoming donation reports and avoid double counting pending transactionsstring
Upcoming Donation CommentUser comment for the nonprofitstring
Upcoming Donation CurrencyThe currency of the upcoming donationstring
Upcoming Donation IDThe unique upcoming donation identifierstring
Upcoming Donation Matching Opt OutIndicates if the user chose to receive no matchstring
Upcoming Donation Payroll Period End DateThe end date of the user's payroll period for In Progress and upcoming donationsdate
Upcoming Donation Payroll Period NameThe name of the payroll period associated with upcoming donationsstring
Upcoming Donation SourceThe payment method for the upcoming donationstring
Upcoming Donation StatusStatus is Initiated if the upcoming donation collection period has not closed. It is In Progress if the period has closed, but the upcoming donation has not yet been sent to nonprofitstring
Upcoming Donation TypeThe type of upcoming donation: Recurring, One Time or Gift Cardstring
Upcoming Donation Custom Match AmountIf a match is edited, the custom amount is recorded. Otherwise, custom match amount is 0number
User Upcoming Donation AmountThe amount pledged for this transactionnumber

Users

User details.

FieldDescriptionData Type
About MeUser's profile about mestring
Custom FieldsDemographic file fieldsstring
Employee IDUser’s employee IDstring
My CauseUser’s favorite causesstring
Profile FieldsUser’s profile fieldsstring
UsernameUser's unique usernamestring
System User IDUnique identifier for system userstring
User Accepted Terms of Use (Yes/No)Indicates if a user accepted terms of useyes/no
User Accepted Terms of Use DateDate of terms of use acceptancedate
User Address CityUser’s citystring
User Address CountryUser’s countrystring
User Address Postal CodeUser’s postal or ZIP codestring
User Address State or ProvinceUser’s state or provincestring
User Address StreetUser’s street addressstring
User BadgesUser’s earned badgesstring
User Created DateUser account creation datedate
User Deactivated DateUser account deactivation datedate
User EmailUser's email addressstring
User First NameUser's first namestring
User Full NameUser's full namestring
User InitialsUser's initialsstring
User InterestsUser's selected interestsstring
User LanguageUser's languagestring
User Last Login DateUser's last login datedate
User Last NameUser's last namestring
User Preferred NameUser's preferred namestring
User RolesUser's administrator rolesstring
User SkillsUser's selected skillsstring
User Instance CountryUser's assigned instance countrystring
User StatusUser's current statusstring
User Time ZoneUser's time zonestring
User Time Zone OffsetHour offset for user's time zonestring
Payroll NumberPayroll number of the userstring
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Announcements
Stay up-to-date on what's happening at Benevity.