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

SOLVED

Data Sources

setaylor
Level 3
Level 3

I am using Data Sources to add order information. When I use the “Orders” column for line items in that order, it adds the orders as total.

 

Example:

OrderID: #1234567890

#1234567890 Product1: (Order = 1)

#1234567890 Product2: (Order = 1)

#1234567890 Product3: (Order = 1)

 

Total orders for that one OrderID is now 3, when it needs to be 1.

How do I update the template to correct this so it does not total like this, and marks the OrderID as 1 order instead of counting all of its line items?

1 Accepted Solution
Gigazelle
Correct answer by
Employee
Employee

If you're tying multiple products to the same order, you'll want to use full processing data sources and use the products column as laid out on this page here:

https://marketing.adobe.com/resources/help/en_US/sc/datasources/datasrc_full_processing.html

View solution in original post

6 Replies
TanmayMathur
Level 10
Level 10

Hi,

I can't say for sure but maybe the problem lies in the mapping of the metrics. You may want to revisit that an check. Let us know if you find anything. 

Thanks!

TM

Gigazelle
Correct answer by
Employee
Employee

If you're tying multiple products to the same order, you'll want to use full processing data sources and use the products column as laid out on this page here:

https://marketing.adobe.com/resources/help/en_US/sc/datasources/datasrc_full_processing.html

View solution in original post

setaylor
Level 3
Level 3

Ok, then how do you attribute ORDER to all line items in a single order, so it does not increment to the actual OrderID?

If you use a 0, this does not work.

TanmayMathur
Level 10
Level 10

Hi,

Could you provide Data Sources file having the columns (after obfuscating confidential data) and what type of data source have you implemented ?

Regards,

TM

setaylor
Level 3
Level 3

I am using: Generic Data Source (Transaction ID) template file

I have attached an add and subtract example. The Data Sources - Add works great, except that it counts the OrderID line items into the OrderID.

When trying to use the subtract, or a negative value, nothing happens, but all uploads are successful.

ercany
Level 2
Level 2

I doubt that this can be an accepted answer. Full Processing doesn't allow merging Visitor IDs. Quote: "... even if the visitor ID in uploaded data matches data collected using JavaScript or other AppMeasurement library, the visitor profiles are not connected from an eVar allocation perspective."

In most cases this is a showstopper, since data sources are used to upload additional data. For a data source with Transaction ID, there is no way to avoid duplicate orders if an order contains multiple products?

If yes, following statement from the Data Source Help is actually false: "Product information (from s.products) is not contained in the visitor profile "snapshot," so you must upload any associated product data in the data source file along with the transaction ID. Note that you can specify only one product per row, so you might need to upload multiple rows with the same transaction ID to include all products."