For our gala, one of the things we want to understand after the event is which sponsors are bringing guests who ultimately become donors themselves.

For example, if a sponsor purchases a table and brings eight guests, we want to be able to see how much those eight guests collectively donated during or after the event and attribute that activity back to the sponsor relationship.

Currently, we can assign attendees to tables, create relationships, use tags, or add soft credits, but none of those options give us a simple way to report on the total fundraising generated by a sponsor's group of guests.

Ideally, we could associate attendees with a sponsor, table, or host and then report on metrics such as:

Number of guests associated with that sponsor

Number of those guests who donated

Total amount donated by those guests

Individual donations within the group

New donors acquired through that sponsor or table

This would help us understand which sponsor relationships are creating engagement beyond the initial sponsorship and give us much better information for sponsor stewardship and future gala planning.