Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

[ACC V6.1.1] Grouping campaign statistics by recipient

sqwgglz
Level 3
Level 3

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:

1639681_pastedImage_0.png

Help me Adobe Gods.

Kevin

2 Replies
Jonathon_wodnicki
Community Advisor
Community Advisor

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
Level 10
Level 10

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