How to query delivery log to backfill other table ?

Avatar

Avatar
Level 1
Sheetal11
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
Sheetal11
Level 1

Likes

0 likes

Total Posts

7 posts

Correct reply

0 solutions
View profile
Sheetal11
Level 1

07-12-2020

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. 

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

179 likes

Total Posts

273 posts

Correct reply

160 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile

Avatar
Give Back 10
Employee
craigthonis
Employee

Likes

179 likes

Total Posts

273 posts

Correct reply

160 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 50
View profile
craigthonis
Employee

08-12-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

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

159 likes

Total Posts

928 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

159 likes

Total Posts

928 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

14-12-2020

Hi @Sheetal11,

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

Thanks!