How to sort lead report by email opens in salesforce

Highlighted
Anonymous
Not applicable

How to sort lead report by email opens in salesforce

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!
1 REPLY 1
Highlighted
Anonymous
Not applicable

Re: How to sort lead report by email opens in salesforce

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!