Column Definitions
✕| Column | Definition |
|---|---|
| ADDRESS | The geographic location associated with fundraising activities, typically representing donor locations, campaign regions, or organizational addresses. This field enables geographic analysis of donation patterns and helps identify regional fundraising performance and donor distribution across different areas. |
| AVG_AMOUNT | The average monetary value per individual gift or contribution within a specific category or designation. This is calculated by dividing the total amount by the gift count to show typical giving levels. |
| CATEGORY | The broad classification or type of funding received by the university. This groups donations, grants, and other financial contributions into major categories to help analyze funding patterns and compare with peer institutions. |
| DESIGNATION | The specific purpose, fund name, or detailed description of how the funding is intended to be used within the university. This provides more granular detail than the broader category classification. |
| DONATIONS | The total number of individual donation transactions received during the specified period or campaign. This count includes all separate giving instances, regardless of amount, and provides insight into donor engagement levels and fundraising activity volume. Each donation represents a single act of giving by a contributor. |
| PERIOD_OR_NAME | The time period covered by the fundraising analysis or the specific name of a fundraising campaign or initiative. This field can represent either a date range (like quarters or fiscal years) or the title of a particular fundraising effort, allowing for both temporal and campaign-specific reporting views. |
| REPORT_TYPE | The category or classification of fundraising report being generated. This field identifies the specific type of analysis or summary being presented, such as donor demographics, campaign performance, or financial summaries. It helps organize and categorize different analytical views of fundraising data for management and stakeholder review. |
| TOTAL_AMOUNT | The combined monetary value of all gifts and contributions received for a specific category or designation. This represents the aggregate financial impact and total funding secured. |
| UNIQUE_DONORS | The count of distinct individual donors who made contributions during the specified period or campaign. This metric eliminates duplicate counting when the same person makes multiple donations, providing a true measure of donor base size and reach. It helps assess fundraising effectiveness in attracting and engaging supporters. |