Solved
Report against AO Emails - want to show unique opens and counts
I am trying to pull a report to show unique opens and unique clicks against a list of AOs.
Using the AO Emails table, I grab the Email Open Count and set the Aggregation field to Count Distinct and the Column Calculations to Sum. I want each AO to show me how many emails were sent, how many participants Opened and how many clicked. If a person opened or clicked multiple times, I want these to count as 1 person in the respective operation.
I am just unable to get this to work. I get numbers that do not match the reality. When I don't put Count Distinct, of course, I get the sum including doubles, triples, etc.
Of course, I can use a filter in the formula like Email Open = true, but then I am limited to that column and loose the capability of reporting number of emails sent, clicked, etc.
I must have missed something...
Using the AO Emails table, I grab the Email Open Count and set the Aggregation field to Count Distinct and the Column Calculations to Sum. I want each AO to show me how many emails were sent, how many participants Opened and how many clicked. If a person opened or clicked multiple times, I want these to count as 1 person in the respective operation.
I am just unable to get this to work. I get numbers that do not match the reality. When I don't put Count Distinct, of course, I get the sum including doubles, triples, etc.
Of course, I can use a filter in the formula like Email Open = true, but then I am limited to that column and loose the capability of reporting number of emails sent, clicked, etc.
I must have missed something...
