How to sort lead report by email opens in salesforce

[Anonymous]

I have a global database of leads that I want to clean out all contacts that have never engaged in any marketing activities over the past few years. How would I go about sorting my leads by campaign open status? I have been within salesforce reports for over an hour and cannot figure out how to add campaign open as a salesforce report field. 

Thanks for the help!

[Anonymous]

Hi Jonathan! Are you using a Campaigns with Campaign Members SFDC report? You can pull in the Member Status Equals Open. Or you can use a smart list in Marketo for Member of SFDC campaign is any and status equals Open. Hope this helps!