Standard schemas
The out-of-the-box nms:remaMatch schema contains the reaction log table, i.e. the relation between individuals, hypothesis and transaction table. This schema shall be used as an inheritance schema for the reaction logs’ final destination table.
The nms:remaMatchRcp schema also comes as a standard, it contains the storage of reaction logs for Adobe Campaign recipients ( nms:recipient ). In order to be used, it will need to be extended to be mapped to a transaction table (containing purchases, etc.).
Transaction tables and transaction details
The transaction table must include direct links towards individuals.
You can also add a table containing transaction details. This is not directly linked to individuals.
If we take a receipt for example, a transaction table is linked to a contact (receipt table) and a receipt lines table is only linked to the receipt table (detail table). You can then configure the hypothesis directly at the level at which the receipt line table is linked to the receipt table.
We highly recommend adding an event date.
The following schema shows joins between the different tables once configuration is complete: