Hi @DanielTa15 ,
Since you have customer ID in place and consistent SKUs across both sources you can use these to tie the data together in CJA.
Firstly, you would need to make both data sets as part of the same connection, they would need to be joined by the common customer ID. This will stitch the recommended data with the purchase data at the customer level.
With the data sets you would need to ensure that the schemas are set up correctly and that the SKUs are captured in a consistent field across both data sets. The “SKU recommended” from the recommended source would need to be treated as an event-level metric and purchase from the second source as another event level metric.
The reporting should then be straight forward as CJA allows for cross-channel attribution. For your case, you’d look at purchase events and attribute them back to the most recent “recommended SKU” event for that same customer.
You can use the Attribution IQ panel to set up a model where “Recommendation SKU” is the touchpoint and “Purchase” is the conversion.
Since you want to know if the same SKU that was recommended was later purchased, you can set up a dimension overlap analysis:
- Create a breakdown where Purchase SKU is segmented by whether it matched any Recommended SKU for that customer.
- You could also create a calculated metric that counts purchases where SKU = Recommended SKU.
Hope this helps,
Dan
