Collaborative Production Reporting

The “Collaborative Production” (ColProd) campaign hierarchy is used to track credit shared for collaborative gifts across multiple university departments when they work together to realize the gift. 

This system allows us to count collaborative gifts toward each fundraising team’s fundraising totals, based on agreed-upon proportions, without counting the same money multiple times (double counting).

When a collaborative gift is made, the total amount goes into one account (AKA shortcode, designation). In Development reporting, the credit is divided among the contributing SCCUs, using a percentage split documented in the gift agreement. This is currently only used for L2M Campaign reporting, but could be applied to other production-based reporting methodologies. It can be used for both revenue and recognition reporting.

DART Transaction

When a collaborative gift is made, it is tagged with the participating units under the “Campaigns” tab, using the ColProd SCCU campaigns.

Uploaded Image (Thumbnail)

Even though the gift is a single financial transaction line-item and donors are not given duplicate recognition records for the same transaction, we are able to use the ColProd campaign information to produce reports that reflect the splits.

Uploaded Image (Thumbnail)

 

Reporting on Collaborative Credit

It’s important to note that the departments (SCCUs) credited in collaborative production reporting may not match where the designated fund or account is officially located. For example, even if a gift to the Lizzie and Jonathan Tish Michigan Culture Internship Fund - 338859 is managed by the Office of the Provost, the gift will not be counted towards this SCCU if it’s not listed as one of the ColProd campaigns. Only the specific SCCUs identified in the ColProd campaign receive recognition.

The total gift amount is split between the participating departments according to agreed percentages. These percentages are shown in the Campaign Subpriority as “collaborative - XX%”, where XX% indicates each department’s share. The combined shares must always total 100% of the gift.

In the example of revenue 19196688, the $250,000 is reported as:

ColProd Name

ColProd SubPriority

Reporting SCCU

Reporting Amount

ColProd-Alfred Taubman CA&UP

40%

TAUBMAN

40 / 100 * 250,000 = $100,000

ColProd-Museum of Art

60%

UMMA

60 / 100 * 250,000 = $150,000

 

 

Note: As of August 2025, there are fewer than ten financial transaction line-items with associated ColProd campaigns and split reporting.