Getting the CATracks reports I need

You may have questions about where to get certain data: can this come from CATracks? Should it be done in the BI tool? Does it need to be an ad-hoc request? Here are some questions to help you figure it out.

Ad-hoc Data Request

  • Are you looking for the absence of information? (i.e., people who haven’t given to Northwestern in a specific timeframe)
  • Are you looking for a sum of giving?
  • Are you looking for mailing list information?
If so, submit an ad-hoc data request, which a report programmer will complete.

To submit an ad-hoc request, fill out the request form, available here: Send the completed form to

Cognos BI Tool

  • Are you trying to identify metrics over time, such as participation or giving rates, or make projections about what might be expected to happen, based on historical patterns?
This type of data is available in the Cognos BI Tool. ARD staff needing Cognos BI training should contact Zachary Germain in the Alumni Relations and Development (ARD) department.

CATracks Advanced Lookups

  • Are you trying to identify information such as gifts given to a school, event attendance, committee membership?
You can find this and other information in CATracks using Advanced Lookups, as well as the numerous available canned reports.

Speak with your local SSR for help with Advanced Lookups and use of CATracks reports. You can find the SSR list posted here:

Keywords:BI, data, alumni, mailing lists, ADEA, CTX, ARD, Alumni Relations and Development   Doc ID:69242
Owner:ADEA .Group:Northwestern
Created:2016-12-06 17:43 CDTUpdated:2019-02-04 11:58 CDT
Feedback:  78   78