Hi Everyone
We're having a "hybrid" set up in which we collect new data via the AEP Web SDK on e-commerce websites. For this, we're using the corresponding standard XDM field of commerce.order.priceTotal to get our revenue metric within Customer Journey Analytics (CJA). Additionally, we have Adobe Analytics backfill data coming in via the native connector through AEP into CJA. This data, however, does only contain the standard mapped fields coming from the legacy s.products string represented in XDM as productListItems.priceTotal and productListItems.quantity. Originally, in Adobe Analytics both information were used to calculate the revenue metric on the fly. Now, to ensure seamless reporting across historic and new data, we want to build a custom metric that "mimics" this calculation.
Are there any best practices or additional documentation around this? Unfortunately, couldn't find anything.
Thank you in advance!
Best
Nicolas