Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

how to make order unique when multiple products were purchased in one transaction id

Avatar

Level 1

I'd like to upload transaction id data source, please see the following data source:

      

# Order Status template file (user)
#ProductsRevenueUnitsOrdersPurchase ID
DateProductPriceQuantityOrderstransactionID
08/10/2017/18/00/00product-name-140011123456
08/10/2017/18/00/00product-name-260021123456

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

5 Replies

Avatar

Level 1

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.

Avatar

Level 1

Have you tried adding an additional column that holds the same value as the transaction id and use unique instances metric on that one?

Avatar

Level 1

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

Avatar

Level 2

alexw14008173 I have the exact same problem as #1. Were you able to solve that?

Thanks!