Avatar

Correct answer by
Level 1

There are many ways to skin a cat in AC.

In this case, you'll be looking for the recipient delivery logs (usually named nms:broadLog in standard set-ups)

Depending on your set-up you could select the targeting and filtering dimension as per below: _sqwgglz_1-1617882587600.png

then target the delivery ID (or label or internal name if they are unique enough) to select the correct delivery for them in your filtering conditions.

_sqwgglz_2-1617882674676.png

 

If not, you could write a query searching for the delivery logs starting from the recipient table. Something like:

_sqwgglz_3-1617882867366.png

 

Moreover, if you need all the data from the campaign itself, you could select the [delivery/@workflow-id] or [delivery/@operation-id] which would take into consideration any delivery present in the workflow, or any delivery present in the campaign, respectfully.

 

These fields are usually hidden though so will require displaying the advanced fields. Click here:

_sqwgglz_1-1617883298808.png

and voila!:

_sqwgglz_2-1617883341134.png

 

Note: I've added that the "Status = Sent" so removes any quarantined records;

and "Send a Proof = No" so you're only dealing with recipient records.

 

Hope this helps,

_sqwgglz

View solution in original post