This is probably a really easy question to answer but I'm having a dumb day.
Basically I want to find Recipient X and count the number of deliveries they've received, opened and clicked.
So the output is something like this:
Help me Adobe Gods.
This can be done with a workflow, querying each table (broadlog, trackinglog) with sum/group by/disable-automatic-adding-of-primary-key, then using enrichments to join the outputs into a single table for extraction or reporting.
Here's some information on the Enrichment activity, in case you're not familiar with it:
Hope this helps!
All the best,