I'd like to upload transaction id data source, please see the following data source:
# Order Status template file (user) | |||||
# | Products | Revenue | Units | Orders | Purchase ID |
Date | Product | Price | Quantity | Orders | transactionID |
08/10/2017/18/00/00 | product-name-1 | 400 | 1 | 1 | 123456 |
08/10/2017/18/00/00 | product-name-2 | 600 | 2 | 1 | 123456 |
the two products were purchased in one same transaction, but when I upload it, the total order number is 2.
so my questions are:
1) how to make order unique when multiple products were purchased in one transaction id?
2) in the target report suite, the default
currency code is US Dollar, but the price in the sample is Chinese Yuan(CNY),
how can I make revenue metric in omniture shows 1000, not 6700(1000*6.7 exchange rate) ?
Thanks,
Alex
Views
Replies
Total Likes
Hi, just an occurance, but how about removing the Orders Column? The Purchase ID is the key, so the number of Orders is equal to the unique Purchase IDs.
Views
Replies
Total Likes
Have you tried adding an additional column that holds the same value as the transaction id and use unique instances metric on that one?
Views
Replies
Total Likes
Hi Alex,
I've solved point #1 adding the column "currency code" but I'm still struggling with point #1. Did you find any solution?
Thanks,
Giada
Views
Replies
Total Likes
alexw14008173 I have the exact same problem as #1. Were you able to solve that?
Thanks!
Views
Replies
Total Likes
alexw14008173Here is one more, I have the exact same issue as #1. any idea?
Thanks!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Like
Replies
Views
Likes
Replies