[ACC V6.1.1] Grouping campaign statistics by recipient

[sqwgglz]

Hey gang.

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.

Kevin

[Jonathon_wodnicki]

Hi,

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.

Thanks,

-Jon

[pablo_rosero1]

Thanks Jonathon!

Here's some information on the Enrichment activity, in case you're not familiar with it:

Enriching data

Hope this helps!

All the best,

Pablo