How to extract duplicate delivery sent data to one recipient in Adobe Campaign Classic | Adobe Higher Education
Skip to main content
Level 2
March 27, 2024
Risolto

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

  • March 27, 2024
  • 1 risposta
  • 733 visualizzazioni

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

 

Questo argomento è stato chiuso alle risposte.
Migliore risposta di ParthaSarathy

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.

1 risposta

ParthaSarathy
Community Advisor
Community Advisor
March 27, 2024

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~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
iSantoshkAutore
Level 2
March 29, 2024

Hi @parthasarathy,

Thank you so munch your help. Its working.