Skip to main content
Level 2
Mar 27, 2024 11:18 AM UTC
Solved

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.
ParthaSarathy
ParthaSarathyAccepted solution
Community Advisor
Mar 27, 2024 1:32 PM UTC

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.

~  ParthaSarathy S

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Mar 27, 2024 1:32 PM UTC

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.

Translate
~  ParthaSarathy S
iSantoshkAuthor
Level 2
Mar 29, 2024 3:15 AM UTC

Hi @parthasarathy,

Thank you so munch your help. Its working.

Translate