2

I want to do a join report on campaign members of two separate campaigns. I want to join them on the "email" field, or some other specified criteria. (cm1.email = cm2.email) and see the results.

An example: overlap of attendees / registrants of an event A and event B (those associated with both events, each event being a campaign).

Is this possible?

Thanks a lot!

  • worth asking this on salesforce success forum where there are more end users and sysads – cropredy Feb 5 '16 at 21:14
2

It's possible to create such a report by creating a report type "contacts with campaign history and campaign members"

When you then create a matrix report with this report type, you'll be able to see campaigns in columns and members in rows. And of course, it's possible to show other fields, summarize rows and colums, drill down, etc.

A simple screenshot created this way showing the record count of contacts versus campaigns:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.