Highlighted

[ACC V6.1.1] Grouping campaign statistics by recipient

Avatar

Avatar

sqwgglz

Avatar

sqwgglz

sqwgglz

05-12-2018

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

Replies

Highlighted

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

03-01-2019

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

Highlighted

Avatar

Avatar

pablo_rosero1

Avatar

pablo_rosero1

pablo_rosero1

03-01-2019

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