Skip to main content

CASE

CASE

Main Menu

  • Learning
      • In-Person Events
      • Online Events
      • Past Events
      • CASE Learning Center
      • Onboard Into Advancement
    • Scholarships
    • CASE@Campus
    • CASE Academy
    • Present at a Conference

    CASE Academy

    CASE Academy

    Join us at CASE Academy and unlock the leader within you. At this exclusive online course,  you’ll embark on a learning journey alongside colleagues from diverse advancement disciplines.

  • Resources
    • Library
      • Advancement Resource Catalog
      • Subject Guides
      • CASE Files
      • Sample Collections
      • Sample Submission Guidelines
    • Currents Magazine
    • Bookstore
    • Educational Partners Directory
    • Newsroom
    • Public Policy
    • All Resources

    Advancement Resource Catalog

    ARC

    Visit the CASE Library's database and search through more than 15,000 articles, books, and white papers. Start your search.

  • Insights
    • Getting Started
    • Today’s Opportunities
    • Building Strategy
    • Surveys
    • CASE Global Reporting Standards

    CASE Global Standards

    Global Standards

    Learn about the common set of standards, guidelines, and definitions for reporting the results of educational philanthropy activities at schools, colleges, and universities across the globe.  

  • Awards
    • Circle of Excellence
    • Global Individual Achievement Awards
    • Independent School Awards
    • Individual Achievement Awards
      • Distinguished Service Awards
      • CASE Leadership Award
      • Previous Winners
    • CASE District Awards
    • CASE Commonfund College and University Foundation Award
    • Award Recipients

    Circle of Excellence Awards

    COE

    CASE’s annual Circle of Excellence Awards showcase outstanding work in advancement. Meet our exceptional award winners.

  • Connect
    • Regions
      • Africa
      • Asia-Pacific
      • Europe
      • Latin America
      • US/Canada
      • Regional Councils
    • Districts
    • Communities
    • Schools
    • Community Colleges
    • College and University Foundations
    • U.S. Advocacy Action Center
    • Volunteer
    • Educational Partners
      • Engage with CASE
      • Marketing Opportunities Available with CASE
      • Industry Advisory Council
      • Educational Partners Directory
      • CASE Standards Champions
      • CASE Media Kit
    • CASE Multi-Cultural Network

    Educational Partners

    Educational Partners

    Meet CASE's Educational Partners - industry thought leaders working with CASE to strengthen schools, colleges, and universities.

  • Talent
    • Career Central
    • CASE Advancement Internship US-Canada
      • Become a Host Institution
      • Intern Spotlight
    • CASE Graduate Trainee Programmes
      • Asia-Pacific
      • Europe
      • US and Canada

    Career Central

    Career Central

    Visit CASE's Career Central to build your team or look for new career opportunities. 

  • About
    • Championing Advancement: CASE Strategic Plan
    • Celebrating 50 Years
    • What CASE Stands For
    • The Evolution of CASE
      • Board Leadership
      • Volunteer Leadership
      • President's Page
    • Offices & Staff
      • Washington D.C.
      • London
      • Mexico City
      • Singapore
      • Senior Staff Listing
    • Membership
    • Giving to CASE
      • Giving Opportunities
      • Impact of Giving
      • Legacy Giving
    • Online Newsroom
      • CASE in the News
      • CASE Experts
      • CASE Media Kit
    • Careers at CASE

    CASE Future Fund

    CASE Future Fund

    In celebration of CASE’s 50th anniversary, CASE is proudly establishing the Future Fund – a visionary philanthropic initiative poised to support and shape the future of the advancement profession. Support the Future Fund. 

  • Membership
    • Create/Manage My Account
    • Become an Institutional Member
    • CASE Membership Primary and Secondary Coordinators
    • Explore Membership Benefits
    • Membership Directory
    • Membership Tutorial Videos

    Member Benefits

    Member Benefits

    Strengthen your advancement operation, including the latest research and trends in advancement, career and professional development programs, and publications. 

    See all membership benefits and contact us today! 

  • Give to CASE
  • Log in
  • Alerts

    You must login to see your alerts.

  • Search
  • Shopping Cart
Alerts

You must login to see your alerts.

Shopping Cart

Breadcrumb

  1. Home
  2. CASE Awards
  3. Circle of Excellence
Franklin College Logo

Automating Alumni Engagement Metrics Reporting

Year: 2022
Award Level: Gold
Award Winner(s): Franklin College
Award: Circle of Excellence
Category: Advancement Services | Data and Analytics
AEM Dashboard AEM - Data Model and Snippet
From the Nominator

"When CASE released the white paper on the Alumni Engagement Metrics (AEM) project in 2019, our team jumped at the chance to begin tracking our engagement in more ways than just alumni giving percentage. Thankfully, the framework CASE created helped us get started. 

We began to identify and track each touchpoint we could in our CRM, Raiser's Edge NXT. From there, we had to have a way to report on this information. Over 100 queries were developed in Raiser's Edge to supply the information necessary for the AEM survey. This worked well for an annual survey, but in order to use the data to strategically guide our work, our team needed to see this information more frequently. So, a custom report had to be created. Originally in Excel, the report contained our metrics by month and by mode, compared to previous years. This quickly became untenable as it required significant staff time to update manually each month. 

With the recent partnership between Microsoft and Blackbaud, we were able to leverage Power BI, Power Automate, and Blackbaud's SKY API to pull data from multiple sources and create an interactive, real-time dashboard containing the AEM data we needed to see. This has freed up valuable staff hours from manual updates and allows for a deeper look at our data across other dimensions such as gender, ethnicity, geography, class years, and more."

From the Judges

This submission is an innovative way of measuring engagement tied to the CASE Alumni Engagement Metrics. A substantive entry supporting data and analytics that has much value to others looking to establish their own metrics and visualizations.

CASE

CASE
  • CASE Communities
  • Member Login
  • Careers at CASE
  • Terms & Conditions
  • Privacy Statement
  • Staff Intranet (link is external)
Connect with CASE
  • Facebook (link is external)
  • Twitter (link is external)
  • LinkedIn (link is external)
  • Instagram (link is external)

CASE Member Support
+1-202-328-CASE [2273]

CASE

CASE
Close
  • Learning
      • In-Person Events
      • Online Events
      • Past Events
      • CASE Learning Center
      • Onboard Into Advancement
    • Scholarships
    • CASE@Campus
    • CASE Academy
    • Present at a Conference

    CASE Academy

    CASE Academy

    Join us at CASE Academy and unlock the leader within you. At this exclusive online course,  you’ll embark on a learning journey alongside colleagues from diverse advancement disciplines.

  • Resources
    • Library
      • Advancement Resource Catalog
      • Subject Guides
      • CASE Files
      • Sample Collections
      • Sample Submission Guidelines
    • Currents Magazine
    • Bookstore
    • Educational Partners Directory
    • Newsroom
    • Public Policy
    • All Resources

    Advancement Resource Catalog

    ARC

    Visit the CASE Library's database and search through more than 15,000 articles, books, and white papers. Start your search.

  • Insights
    • Getting Started
    • Today’s Opportunities
    • Building Strategy
    • Surveys
    • CASE Global Reporting Standards

    CASE Global Standards

    Global Standards

    Learn about the common set of standards, guidelines, and definitions for reporting the results of educational philanthropy activities at schools, colleges, and universities across the globe.  

  • Awards
    • Circle of Excellence
    • Global Individual Achievement Awards
    • Independent School Awards
    • Individual Achievement Awards
      • Distinguished Service Awards
      • CASE Leadership Award
      • Previous Winners
    • CASE District Awards
    • CASE Commonfund College and University Foundation Award
    • Award Recipients

    Circle of Excellence Awards

    COE

    CASE’s annual Circle of Excellence Awards showcase outstanding work in advancement. Meet our exceptional award winners.

  • Connect
    • Regions
      • Africa
      • Asia-Pacific
      • Europe
      • Latin America
      • US/Canada
      • Regional Councils
    • Districts
    • Communities
    • Schools
    • Community Colleges
    • College and University Foundations
    • U.S. Advocacy Action Center
    • Volunteer
    • Educational Partners
      • Engage with CASE
      • Marketing Opportunities Available with CASE
      • Industry Advisory Council
      • Educational Partners Directory
      • CASE Standards Champions
      • CASE Media Kit
    • CASE Multi-Cultural Network

    Educational Partners

    Educational Partners

    Meet CASE's Educational Partners - industry thought leaders working with CASE to strengthen schools, colleges, and universities.

  • Talent
    • Career Central
    • CASE Advancement Internship US-Canada
      • Become a Host Institution
      • Intern Spotlight
    • CASE Graduate Trainee Programmes
      • Asia-Pacific
      • Europe
      • US and Canada

    Career Central

    Career Central

    Visit CASE's Career Central to build your team or look for new career opportunities. 

  • About
    • Championing Advancement: CASE Strategic Plan
    • Celebrating 50 Years
    • What CASE Stands For
    • The Evolution of CASE
      • Board Leadership
      • Volunteer Leadership
      • President's Page
    • Offices & Staff
      • Washington D.C.
      • London
      • Mexico City
      • Singapore
      • Senior Staff Listing
    • Membership
    • Giving to CASE
      • Giving Opportunities
      • Impact of Giving
      • Legacy Giving
    • Online Newsroom
      • CASE in the News
      • CASE Experts
      • CASE Media Kit
    • Careers at CASE

    CASE Future Fund

    CASE Future Fund

    In celebration of CASE’s 50th anniversary, CASE is proudly establishing the Future Fund – a visionary philanthropic initiative poised to support and shape the future of the advancement profession. Support the Future Fund. 

  • Membership
    • Create/Manage My Account
    • Become an Institutional Member
    • CASE Membership Primary and Secondary Coordinators
    • Explore Membership Benefits
    • Membership Directory
    • Membership Tutorial Videos

    Member Benefits

    Member Benefits

    Strengthen your advancement operation, including the latest research and trends in advancement, career and professional development programs, and publications. 

    See all membership benefits and contact us today! 

  • Give to CASE
  • Log in

Search

Popular Searches
Books Advancement events Articles Fundraising Resources CASE Insights Resources Awards CASE Library CURRENTS Talent