+ Start a Discussion

Help with Lead and Campaign reporting!

I'm trying to create a Lead report to track lead conversion ratios. However I want to exclude Leads that came from certain Opportunities or don't have Opportunities. Since standard Lead reports don't include any Campaign fields, I created a Custom Report Type where Lead is the Primary Object (A) and Campaign History is the (B) item and ""A" records may or may not have related "B" records." is select, because not all Leads come from a Campaign.

I thought this would do it. I created a report from this Custom Report Type and was able to see all Leads where some had associated Campaigns and some didn't. However when I then filtered on all Leads where the Campaign ID was blank, the report remained the same however all the Leads that previously had a Campaign shown for them, still where there and the Campaign column was just blank.

Can anyone help?