I have a question. I have Tasks with the Subject "Email Sent" and "Email Opened". If I wanted a Report to show all Contacts with a Task that have "Email Sent" Tasks but not "Email Opened" Tasks, how would I do that?
These Tasks and subject names are being autogenerated from Ebsta.
I tried a custom Report Type Contacts with Tasks and then a cross-filter of "Activities" with a filter criteria of Subject contains "Sent" (indicating the first email sent).
However, I am not sure this is the best way to accomplish this.
2 answers
Hi Andrew, I don't see any problem with your approach. The only thing that I can think of to improve the report would be to add a second filter to exclude tasks with the "Opened" subject, just to make sure.