How to extract duplicate delivery sent data to one recipient in Adobe Campaign Classic

[iSantoshk]

Hi Experts,

Need Help on how to extract the duplicate delivery sent to one recipient from same campaign.

I have checked from broadlog schema, and unable do expression group by using count of Delivery label.

We need to Count of same delivery sent to same recipient, Campaign Code, Event Date.

Please help me on this asap.

Thank you

[ParthaSarathy · Accepted solution]

Hi @iSantoshk ,

In Query, set targeting and filtering dimension as broadLogRcp

Add data > add the below fields

• [recipient/@id]
• ToDate(@eventDate)
• Campaign Code
• Count(@id)

and group [recipient/@id] , ToDate(@eventDate) and Campaign Code

In Advanced parameter, Enable 'Disable automatic adding of the primary keys of the targeting dimension' checkbox and start the workflow.

[iSantoshk]

Hi @ParthaSarathy,

Thank you so munch your help. Its working.