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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by ParthaSarathy

Hi @isantoshk ,

In Query, set targeting and filtering dimension as broadLogRcp

Add data > add the below fields

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.

Accepted solution

Community Advisor

In Query, set targeting and filtering dimension as broadLogRcp

Add data > add the below fields

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.

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups

Level 2

Thank you so munch your help. Its working.

Sign up