Detailed Broadlog/Contact History for campaigns
We have an ask where we one to store one to many information against a broadlog entry. For example we are sending multiple deals in an email and want to store the details of those deals associated with the broadlog entry. So one entry will have 2 child records into the second table say "detailedBroadlogRcp" if one customer is sent 2 deals via the email.
The manual way could be that in the workflow business team writes the deals record after the delivery activity. We prefer to design the platform in a way that it will be automatically processed by the platform instead of business team writting to the table after the delivery activity.
Thinking about it as something similar to HCL Unica Detailed Contact History.
A high level representation of the data used in campaign. I can tweak things around as long as we can have a provision to write into the detailedBroadlogRcp from delivery itself
| Recipient Id | Deal Id | Additional Fields |
| 1 | 101 | |
| 1 | 102 | |
| 1 | 103 | |
| 2 | 103 |
The Detialed Boradlog Should Like This
| Broadlog Id | Type of Info | Id of the Type |
| 1001 | Deal | 101 |
| 1001 | Deal | 102 |
| 1002 | Deal | 101 |
| 1001 | Prop Score | 95 |
| 1002 | Prop Score | 92 |