How to query delivery log to backfill other table ? | Community
Skip to main content
S
ssoni-2
Level 2
December 7, 2020
Question

How to query delivery log to backfill other table ?

  • December 7, 2020
  • 2 replies
  • 1625 views

We send many communication and every communcation we send we store the values in seperate table. Unfortunatly we lost that data and now we are trying to find out based on Campaign name or program name search the broadlog table and find out that delivery and join with recipient and and program table to get required value ...... is anyone did this type of work ? Any leads , ideas please let me know. 

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

2 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe Employee
Adobe Employee
December 8, 2020

Hi Sheetal,

 

What data did you lose specifically?  If it was stored in a separate table it may not be something that was originally stored by default. 

 

This type of work is certainly doable because there are keys that allow us to join from the broadlog and recipient tables but more details would be required, as we need to understand what you are trying to pull exactly and the use case.

 

Regards,

Craig

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    December 14, 2020

    Hi @ssoni-2,

    Were you able to resolve this query or do you still need more help here? Do let us know.

    Thanks!

    Sukrity Wadhwa
    S
    ssoni-2Author
    Level 2
    December 16, 2020
    I think I got it how to do it ..
    Terms & ConditionsAccessibility statement

    Loading footer...