Make sure to post to Products. ("Community" is for website feedback.) The moderator just moved your post today.
The answer is that while you could build such a report by daily downloads of the Activity API into your own BI/warehouse db (as you seem to be suggesting) you can't build such highly customized reports within the Marketo UI. The report you're describing, if I'm understanding it correctly, would have to be done offline (specifically because of the "remove duplicates" requirement).