This page contains descriptions and links to reports and websites that are of use to University Relations Coordinators. Each link
provides specific information about which login to use to access the report or web page.
Note that all links open a new tab in your browser.
Information for and about Donors
Pledge Audit Tool - The pledge audit tool presents (by
default) all overdue, currently due, and future pledges for the UMCPF foundation. Parameters on this report
allow you to expand the tool to include the other foundations, other pledge statuses, or to filter the report accordingly. Login with your UR account.
Pledge Reminders Tool - The pledge reminders tool presents an interface for reviewing and generating current and 60-days past due pledge
reminders for the UMCPF foundation. Login with your UR account.
Individual Pledge Summary - If you know the pledge
number, you can produce a one-page overview of the pledge with all the information we know about it. This
is used daily by Principal Gifts for their strategy sessions. We can also use it to see pledge summaries
for Trustees. Login with your UR account.
Donor Strategy Report - Principal Gifts uses this report to run strategy meetings for Presidential donors. It includes
summary information about the donor, as well as the current strategy (which is now stored in Advance).
Login with your UR account.
Donor Strategy Spreadsheet - This report
provides a summary of strategies for a group of prospects in spreadsheet form. It includes
summary information about the donor, as well as the current strategy (which is stored in Advance as strategic notes on the prospect).
Login with your UR account.
Donor Acknowledgment Report - This report is
used to help with donor acknowledgment. You can pull a list of donations to a school or college over a period of time. Each gift is recorded as a
single row, with detailed information about joint and additional donors (e.g. In Honor Of), as well as premium information.
Login with your UR account.
UR Dashboard - Executive dashboard that you can also see on
your phone. Note that the text may seem large in a web browser. Login with your UR account.
Gift Processing System - (Chrome or Firefox
recommended) This is the new system for submitting
gifts to the Gift Acceptance office. Gift Acceptance also
uses this system to review, process and load gifts into
Advance in a paperless environment. If you do not have
access, please contact Business Applications. Login
with your University (Timesheets) account. DO NOT prefix with AD.
Blackbaud Financial Reporting for Account Administrators - This is the online tool
that account administrators across campus can use to
see day-old reporting of all projects managed by UMCPF.
It presents endowment values, spendable income, and
current transaction summaries with drill-through on everything. This
information resides in Blackbaud. Permission Restricted. Please contact the University Foundation Office to request access.
Blackbaud Transaction Details (Audit) Dump - When auditors ask for detailed transaction dumps, this is the tool
to use. It has all GL transactions for a given date range, with zero-sum
balance data, as it contains both sides of every GL transaction. If you try
to run more than one month, there may be too much data, but you can
merge it in a single spreadsheet using copy-past. This information
resides in Blackbaud. Permission Restricted. Please contact the University Foundation Office to request access.
Main Campaign Report-by Type and Source - The
main report that is produced monthly showing YTD
activity and campaign-to-date activity. This is the report that Carolyn sends out. Login with your UR account.
Unit Progress Campaign Reports - This is the other
monthly report that most Deans use to track their progress against goal. It presents YTD and Campaign
to date totals by C/S/U. It also shows their FY goal and their campaign goal, and progress towards that
goal. Login with your UR account.
Gift Table - This is the report we use to count million dollar
gifts. It combines gifts and pledges from the same primary
donor which are made on the same day (think Smith or
Iribe) into a single "big" gift. It builds a gift table by gift
size, and includes goals, prospect, and pipeline information as well. Note
that the numbers on this report do not always agree with the campaign
report because it counts future gifts (that may not be a part of the
campaign). Login with your UR account.
Gift Summary - Provides a detailed transaction listing of all donations made within a chosen date range and for a chosen amount range. Defaults by yesterday's date, minimum donation of $1,000.00. Login with your UR account.
DO Metrics, Portfolio Analysis, Contact Reports
Major DO Metrics and Portfolio Report - The report monitors key metrics such as visits, gifts from
proposals, and "over the transom" gifts from donors within a DO's portfolio. It is also an easy
way to look at a DO's portfolio and how that portfolio is distributed
across donor stages. Login with your UR account.
Annual Giving DO Metrics Report - The report monitors key
metrics such as visits, gifts from proposals, and "over the transom" gifts from donors within a DO's portfolio.
It is also an easy way to look at a DO's portfolio and how that portfolio is
distributed across donor stages. Login with your UR account.
Proposal Pipeline Report - This report can be used to see all proposals for a development office or
individual DO. Login with your UR account.
Contact Reports and Visits - This report provides
information about contact reports filed by development officers. It can be filtered to specific
contact report types (e.g. visit or communication), outcomes, office, and date. Login with your UR account.
Historical Regional Analysis - This report provides
summary information about a geocode or state. Geocodes include counties in MD, VA, PA, and DE and also
major metropolitan areas around the US. You can also filter by school and major. Login with your UR account.