I've been having a hard time finding clear documentation on how the standard Campaigns with Influenced Opportunities report works. I have a report that is grouped by campaign name and contact name. For one of the campaigns, there are 159 rows grouped under a blank contact name. From doing a spot check, it looks like the opportunities under the blank contact name also show up in the report under the donor name. Here's a visual example for the same opportunity grouped under the same campaign name:
Why is this happening?
@* Sales Cloud - Best Practices *
@Regina Hodge Campaign Member has a poly morphic lookup that looks up to multiple objects. In this report Contact Name is one of those fields and if you ungroup the records you will find that they are campaign member records related to another object maybe lead or whatever your setup is. You can filter this out if needed by filtering on Contact is not blank
