Excel MProfile- Individuals with Campaign Primary Constituency Attribute

Where is it?

Link to Report: https://businessintelligence.dsc.umich.edu/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=Aaqb_CxYELBKk1zx4af__Pc

BusinessObjects Folder Path: Public Folders/UM-Maintained/Development/DART Development Reports by Category/Constituent MProfile 9.0/

What does it do?

MProfiles

MProfiles show the Lifetime Recognition Total and campaign totals for constituents meeting the user-supplied criteria.

This Report

This report is designed to pull a list of all active individual constituents based on their "Campaign-Primary Constituency" Constituent Attribute. Optional Prompts allow the User to restrict the result to those with an active address in a specified geographic region.

Format

This version of the report is specifically designed to be used with the BusinessObjects Scheduler to run and save as an Excel file. More info below.

Keywords

MProfile Individuals Constituent Attribute Primary Constituency

Why use this report?

Use it if you want to find constituents based on their "Campaign-Primary Constituency" Constituent Attribute, and then view a holistic overview of their DART records.

How to use this report?

Scheduling

Please refer to this article for more information on scheduling reports: https//teamdynamix.umich.edu/TDClient/83/Portal/KB/ArticleDet?ID=7265

Running the Report Directly

Click the highlighted icon to bring up the user prompts.

If the report is taking too long to run, schedule the report (see above).

Prompts

You then need to set the prompts. (Prompts act as questions that help you to customize the information in a report to suit your own needs!)

Below are the available prompts (with explanation) —

  • Enter Constituent Attribute Value (Required)

    • Allows User to type in a specific "Campaign-Primary Constituency" Constituent Attribute value. (Available values seen in table below)

    • AAUM DEDU FCIT KIN OUD_DEI SPH
      ATH DENG FEH LAW PFG STAMPS
      BGA DENT FLNT LSA PHAR SWK
      BHL DRBN FMGT LSI RACK TAUBMAN
      CEW EDUC FNUR MED ROSS ULIB
      CLEM ENG FORD Medical School SEAS UMMA
      DASL FAS GSI MRDO SI UMS
      DCOB FCHS ISR NURS SMTD  

      • NOTE:  A drop-down list of values is not available for this field.

Address Information

Answer one or more of the following prompts to restrict display based on active addresses.  To pull for a specific City or County be sure to also fill in the State Code prompt.

  • Enter 'Yes' to search by Primary Address Only

    • Enter 'Yes' to restrict your search to primary addresses only that match the geographic regions specified

    • To search all active addresses (i.e., Home, Business, Seasonal, Other, etc.), leave prompt blank

  • Select Primary Metro Area

    • Allows user to enter or select a primary metro area

      • Primary Metro Area is defined as a Major city and all cities within a reasonable (~45 Minute) commute

    • E.g. Detroit, Chicago, etc. 

  • Select Greater Metro Area

    • Allows user to enter or select a greater metro area.  The Greater Metro Area is defined as Major city and all adjacent suburbs.

    • E.g. Greater Houston, TX includes Houston, Woodlands, Katy

  • Select Major Gift Region

    • Allows user to enter or select a specific Major Gift Region

    • E.g., Southern States

  • Enter City

    • Allows user to enter the name of a specific City or a series of City Names

    • NOTE: Capitalization and Punctuation must match DART exactly

  • Select County

    • Allows user to select one or more counties

  • Enter State Code

    • Allows user to enter two-letter State Code

    • E.g., MI, TX, CA, etc.

  • Select Zip Code

    • Allows user to enter one or more Zip Codes

  • Select Country

    • Allows user to enter or select a specific country

For Unit Giving Information

Answer one or more of the following prompts to be displayed. Giving will be totaled based on all prompts answered. Leave blank if site giving is not required.

  • Enter Starting Fiscal Year

    • Use this to limit Recognition Totals since a specified Fiscal Year

      NOTE: Starting Fiscal Year does NOT affect Victors For Michigan Totals

  • Enter Ending Fiscal Year

    • Allows user to limit Recognition Totals to before a specified Fiscal Year

    • E.g., inputting 2022 will only display Recognition Totals before 2022

Site or Site Rollup Giving

Answer one of the following prompts to be displayed. Note that you may select multiple fields for each individual prompt, but you should not use multiple prompts. Giving will be totaled based on all prompts answered. If none selected, U-M total (all 3 campuses combined) will be shown.

  • Select SCU Rollup
    • SCU = School, College, or Unit; all of the parts of the Development community that OUD provides support to; most divisions of UM have their own Development shop
    • E.g., Law School
  • Select VP Area Rollup
    • This selects all sites that will roll up to the Vice Provost Areas 
    • E.g., Exec. VP for Medical Affairs

  • Select Campus Rollup

    • All sites roll up to the campus level

      E.g., University of Michigan-Dearborn

  • Select MPathways DeptID

    • E.g., 320000; 170001

  • Select Site Name

    • NOTE: This field does NOT include any rollup

  • Select Designation LookupID

    • You may select one or more Designation LookupID

      E.g., 364686 for Solar Car Team

Unit Campaign Giving

Answer to include campaign totals to a specific unit campaign.

  • Select Unit Campaign Name

    • E.g., Law School - Victors for Michigan

Specific Communication Codes

NOTE: Codes are displayed on Excel Output tab, Individuals with codes are not excluded!

  • Select SCU Specific Communication Preference Codes

    • You may select one or more Communication Preference(s) specific to their SCU to include in the report

      E.g., No Contact - Alumni Association

Report Tabs

There are 4 different report tabs:

  • Condensed Excel Output

    Streamlined version with less details and only totals for Lifetime, Campaign, Section1, and Section1 Campaign are shown.

  • Expanded Excel Output

    Facilitates export to Excel.  

    Information is arranged so that a constituent's information is contained on a single row.  Contains Giving and Rating information but does not contain children/step children, or top areas of interest.

  • Excel UM by FY

    Facilitates export to Excel.

    Shows University wide recognition totals for Commitments and Expectancies Due, plus Gift Payments Received by Fiscal Year for the current and 9 prior fiscal years.

  • Excel Sec1 by FY

    Facilitates export to Excel. 

    Shows Section Selected recognition totals for Commitments and Expectancies Due, plus Gift Payments Received by Fiscal Year for the current and 9 prior fiscal years.

Print Article