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.
| Field | Description | Data Type |
| Currency Display | Convert transactions to a selected currency | string |
| Fiscal Year Transaction Date | Date the transaction occurred in the fiscal year (if available) | date |
| Transaction Date | Date the transaction occurred | date |
| Transaction Type | Type of transaction. Example: Volunteering Volunteer Signup | string |
| First Transaction Date | Date of first transaction | date |
| Last Transaction Date | Date of last transaction | date |
| Transaction Count | Number of volunteering transactions | number |
Cause Projects
Details about cause projects.
| Field | Description | Data Type |
| Cause Project ID | Unique identifier for a cause project | string |
| Project Address City | City where the project is located or where work is carried out | string |
| Project Address Postal Code | Postal or ZIP code where the project is located or where work is carried out | string |
| Project Address State or Province | State or province where the project is located or where work is carried out | string |
| Project Address Street | Address of the project | string |
| Project Caption | Typically the operating organization or a summary of a project | string |
| Project Created Date | Date and time the project was created | date |
| Project Deactivated Date | Date and time the project was deactivated | date |
| Project Description | Project description | string |
| Project Facebook | Project Facebook | string |
| Project Map Location | Project latitude and longitude, to use with map charts | string |
| Project Name | The project to which the donation was directed "General" refers to no specific project | string |
| Project Phone Number | Project telephone number | string |
| Project Twitter | Project Twitter | string |
| Project Website | Project Website | string |
| Project Country | Country where the project is located or where work is carried out | string |
Causes
Details about causes.
| Field | Description | Data Type |
| Cause Address City | City where the cause is located | string |
| Cause Address Postal Code | Postal or ZIP code where the cause is located | string |
| Cause Address State or Province | State or province where the cause is located | string |
| Cause Address Street | Cause street address | string |
| Cause Category | Category name for a cause. Example: NTEE category | string |
| Cause Category Code | Unique code for the cause category and subcategory Example: NTEE code | string |
| Cause Country | Country where the cause is located | string |
| Cause Email | Email of the cause | string |
| Cause ID | Unique identifier for the cause | string |
| Cause Map Location | Cause latitude and longitude, to use with map charts | location |
| Cause Name | Name of the nonprofit (organization) | string |
| Cause Status | Indicator for if the cause is currently active or inactive | string |
| Cause Subcategory | Subcategory for a cause. Example: NTEE subcategory code | string |
| Cause Type | Description of charitable status | string |
| Cause Website | Website for the cause | string |
Company
Company details.
| Field | Description | Data Type |
| Company Fiscal Year Start Date | Start month for the company fiscal year (if available) | date |
| Company Name | Company Name | string |
| Company Program Name | Name of the program | string |
| Company Program Site | URL for the program site | string |
Giving Opportunities
Giving opportunity details.
| Field | Description | Data Type |
| Giving Opportunity Code | Unique identifier for the giving opportunity | string |
| Giving Opportunity Created Date | Date the giving opportunity was created | date |
| Giving Opportunity Creator Email | Opportunity creator's email | string |
| Giving Opportunity Creator First Name | Opportunity creator's first name | string |
| Giving Opportunity Creator Full Name | Opportunity creator's full name | string |
| Giving Opportunity Creator Last Name | Opportunity creator's last name | string |
| Giving Opportunity Deadline Date | Last date donations are accepted | date |
| Giving Opportunity Description | Description of the giving opportunity | string |
| Giving Opportunity End Date | End date of the giving opportunity | date |
| Giving Opportunity Facebook | Facebook page URL for the giving opportunity | string |
| Giving Opportunity Goal | Target donation amount | number |
| Giving Opportunity Label | List of reporting tags for the giving opportunity | string |
| Giving Opportunity Last Updated Date | Date the giving opportunity was last updated | date |
| Giving Opportunity Name | Name of the giving opportunity | string |
| Giving Opportunity Publication Status | Published status of the giving opportunity | string |
| Giving Opportunity Source | Source of the giving opportunity, e.g. user, company | string |
| Giving Opportunity Status | Current status of the giving opportunity, managed by admin | string |
| Giving Opportunity Summary | Summary of the giving opportunity | string |
| Giving Opportunity Tags | List of tags for the giving opportunity | string |
| Giving Opportunity Twitter | Twitter name for the giving opportunity | string |
| Giving Opportunity URL | URL to access the giving opportunity | string |
| Giving Opportunity Website | Website for the giving opportunity | string |
| Peer Match Associated (Yes/No) | Indicator of a peer-matched opportunity | yes/no |
Users
User details.
| Field | Description | Data Type |
| About Me | User's profile about me | string |
| Custom Fields | Demographic file fields | string |
| Employee ID | User’s employee ID | string |
| My Cause | User’s favorite causes | string |
| Profile Fields | User’s profile fields | string |
| Username | User's unique username | string |
| System User ID | Unique identifier for system user | string |
| User Accepted Terms of Use (Yes/No) | Indicates if a user accepted terms of use | yes/no |
| User Accepted Terms of Use Date | Date of terms of use acceptance | date |
| User Address City | User’s city | string |
| User Address Country | User’s country | string |
| User Address Postal Code | User’s postal or ZIP code | string |
| User Address State or Province | User’s state or province | string |
| User Address Street | User’s street address | string |
| User Badges | User’s earned badges | string |
| User Created Date | User account creation date | date |
| User Deactivated Date | User account deactivation date | date |
| User Email | User's email address | string |
| User First Name | User's first name | string |
| User Full Name | User's full name | string |
| User Initials | User's initials | string |
| User Interests | User's selected interests | string |
| User Language | User's language | string |
| User Last Login Date | User's last login date | date |
| User Last Name | User's last name | string |
| User Preferred Name | User's preferred name | string |
| User Roles | User's administrator roles | string |
| User Skills | User's selected skills | string |
| User Instance Country | User's assigned instance country | string |
| User Status | User's current status | string |
| User Time Zone | User's time zone | string |
| User Time Zone Offset | Hour offset for user's time zone | string |
| Payroll Number | Payroll number of the user | string |
| User Tshirt Size | User’s t-shirt size | string |
| Transacted User Count | Number of users that have a volunteer transaction | number |
Volunteer Opportunities
Volunteer opportunity details.
| Field | Description | Data Type |
| Contact Email | Volunteer opportunity contact email | string |
| Contact Email 2-5 | Additional volunteer opportunity contact email | string |
| Contact Name | Volunteer opportunity contact name | string |
| Contact Name 2-5 | Additional volunteer opportunity contact name | string |
| Contact Phone | Volunteer opportunity contact phone number | string |
| Contact Phone 2-5 | Additional volunteer opportunity contact phone number | string |
| Volunteer Opportunity Country Code | The country code of the volunteer opportunity | string |
| Volunteer Opportunity Created Date | Date and time that the volunteer opportunity was created | string |
| Volunteer Opportunity Description | Description for the volunteer opportunity | string |
| Volunteer Opportunity Descriptors | Event descriptors associated with the volunteer opportunity | string |
| Volunteer Opportunity End Date | End date for the volunteer opportunity | date |
| Volunteer Opportunity Facebook | Facebook for the volunteer opportunity | string |
| Volunteer Opportunity Featured | Indicates if the volunteer opportunity is featured | string |
| Volunteer Opportunity ID | Unique identifier for the volunteer opportunity | string |
| Volunteer Opportunity Interest Tags | Interest tags associated with the volunteer opportunity | string |
| Volunteer Opportunity Internal Notes | Internal notes associated with the volunteer opportunity | string |
| Volunteer Opportunity Last Updated Date | Date and time that the volunteer opportunity was last updated | date |
| Volunteer Opportunity Local End Date | End date for the volunteer opportunity in the local time of the volunteer opportunity | date |
| Volunteer Opportunity Local Start Date | Start date for the volunteer opportunity in the local time of the volunteer opportunity | date |
| Location City | City where the volunteer opportunity is taking place | string |
| Location Country | Country where the volunteer opportunity is taking place | string |
| Location Name | Common display name for the location of the volunteer opportunity | string |
| Location Notes | Notes about the location of the volunteer opportunity | string |
| Location Postcode | Postal or ZIP code where the volunteer opportunity is taking place | string |
| Location State or Province | State or province where the volunteer opportunity is taking place | string |
| Location Street | Street address where the volunteer opportunity is taking place | string |
| Multiple Locations | Indicates if there are multiple locations for the volunteer opportunity | string |
| Volunteer Opportunity Name | Name of the volunteer opportunity | string |
| Volunteer Opportunity Override Signup | Indicates if the users can sign up for the volunteer opportunity past the maximum number of signups | string |
| Volunteer Opportunity Owner Name | Name of the owner of the volunteer opportunity | string |
| Volunteer Opportunity Owner Email | Email of the owner of the volunteer opportunity | string |
| Volunteer Opportunity Public | Indicates if the volunteer opportunity is open to the public | string |
| Volunteer Opportunity Publish State | Current published state of the volunteer opportunity | string |
| Volunteer Opportunity Recurrence | Indicates if the volunteer opportunity is one-time or recurring | string |
| Volunteer Opportunity External Author Name | Name of the volunteer opportunity author if the opportunity was created externally | string |
| Volunteer Opportunity Reward Name | Name of the rewards associated with the volunteer opportunity | string |
| Volunteer Opportunity Scheduling Information | Scheduling information associated with the volunteer opportunity | string |
| Volunteer Opportunity Signup Notification | Indicates if the volunteer opportunity owner is notified of signups | string |
| Volunteer Opportunity Skill Tags | Skill tags associated with the volunteer opportunity | string |
| Volunteer Opportunity Source | Indicates who has created the volunteer opportunity | string |
| Volunteer Opportunity Start Date | Start date for the volunteer opportunity | date |
| Volunteer Opportunity Status | Status of the volunteer opportunity. Example: Approved | string |
| Volunteer Opportunity Summary | Short summary of the volunteer opportunity | string |
| Volunteer Opportunity Time Zone Name | Time zone for the volunteer opportunity | string |
| Volunteer Opportunity Twitter | Twitter for the volunteer opportunity | string |
| Volunteer Opportunity URL | URL of the volunteer opportunity | string |
| Volunteer Opportunity Waiver | Indicates if the volunteer opportunity requires a waiver | string |
| Volunteer Opportunity Waiver URL | URL for the volunteer opportunity waiver, if required | string |
| Volunteer Opportunity Website | Website for the volunteer opportunity | string |
| Volunteer Opportunity Count | Number of unique volunteer opportunities | number |
| Volunteer Opportunity Lives Impacted | Number of lives impacted by a volunteer opportunity | number |
Volunteer Shifts
Volunteer shift details.
| Field | Description | Data Type |
| Shift Accept Waitlist | Indicates if the volunteer opportunity allows a waitlist | string |
| Shift Allow Guests | Indicates if the shift allows guests to sign up | string |
| Shift Created Date | Date and time the volunteer shift was created | date |
| Shift End Date | End date and time for the volunteer shift | date |
| Shift ID | Unique identifier for the volunteer shift | string |
| Shift Name | Name of the volunteer shift | string |
| Shift Start Date | Start date and time for the volunteer shift | date |
| Shift Count | Number of unique volunteer shifts | number |
| Shift Length (Hours) | Length of the volunteer shift in hours | number |
| Shift Maximum Sign-up | Maximum number of people that can sign up for a volunteer shift | number |
Volunteer Signups
Volunteer signup details.
| Field | Description | Data Type |
| Sign-up for Volunteer Match (Yes/No) | Indicates if the user signed up for a Volunteer Match opportunity | yes/no |
| Sign-up ID | Unique identifier for the shift sign-up | string |
| Volunteer Shift Reminder Date | Date and time that a reminder is sent to users signed up for a shift | date |
| Volunteer Sign-up T-Shirt Size | T-shirt size the user selected when signing up for a shift | string |
| Volunteer Waiver Accepted (Yes/No) | Indicates if the user has accepted the volunteer waiver, if required | yes/no |
| Number of Guests | Number of guests that are signed up for a volunteer opportunity | number |
Volunteer Submissions
Volunteer submission details.
| Field | Description | Data Type |
| Comments to Admin | Comments to admin provided by the user for their volunteer time submission | string |
| Email Date | Date and time for the email sent to the volunteer | date |
| Volunteer During Work Hours (Yes/No) | Indicates if the volunteer time took place during work hours | yes/no |
| Contact Email | Contact email entered by the user for a volunteer time submission | string |
| Contact Name | Contact name entered by the user for a volunteer time submission | string |
| Contact Phone | Contact phone number entered by the user for a volunteer time submission | string |
| Volunteer Submission Rewards Currency | Currency of the rewards for the volunteer submission | string |
| Volunteer Submission Date of Service (End) Date | End date and time for tracked volunteer hours | date |
| Volunteer Submission Date of Service (Start) Date | Start date and time for tracked volunteer hours | date |
| Volunteer Submission ID | Unique identifier for tracked time submission | string |
| Reporting Tags | Reporting labels for the tracked time submission | string |
| Volunteer Submission Opportunity Name | User-entered opportunity name or cause/project name | string |
| Volunteer Submission Reward Rejection Message | Message entered by admin when a tracked time submission is denied | string |
| Volunteer Submission Reward Type | Name of the type of volunteer reward | string |
| Volunteer Submission Reward Type Intended | Name of the type of intended volunteer reward | string |
| Volunteer Submission | Status of the tracked time submission. Example: Approved, Denied | string |
| Volunteer Submission Status Change Date | Date and time that the submission status changed | date |
| Volunteer Submission Approval ID | Unique identifier for a tracked time approval | string |
| Volunteer Submission Comments | Feedback provided by the user for their volunteer time submission | string |
| Volunteer Submission Tracked by Email | Indicates if the volunteer submission was tracked through a reminder email | string |
| Volunteer Reward Amount | Amount of rewards given to the user for tracked time | number |
| Volunteer Reward Amount Common Currency | Amount of donation currency rewarded for volunteer time | number |
| Volunteer Reward Points | Points given to the user for tracked time | number |
| Volunteer Submission Rating (Stars) | Volunteer opportunity rating given by the user (1-5 stars) | number |
| Volunteer Submission Time (Hours) | Time spent volunteering (hours) | number |
| Volunteer Submission Time (Minutes) | Time spent volunteering (minutes) | number |