How to show 1 unique row for each contact that doesn't click within a campaign
I'm trying to build a report that shows the contacts that did not click in any emails within a campaign. The problem i'm running into is that multiple contacts are getting multiple emails in any given month, so although my filter includes Total Clickthroughs is Null, the results have a row for each contact - FOR EACH TIME THEY WERE SENT THE EMAIL - and exceeds the allowed number of results unless I break it down to 1 month at a time. Is there a way to just see the unique contacts deduped who have no clicks?
Tagged:
0