Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Data Source with Transaction ID and Orders

Avatar

Level 2

Hi, I'm settting up a new data source with of type "Generic - Transaction ID". The transactions represent leads. We want to upload the offline orders from those leads.

In the Data Source Help, it says: "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."

It's not clear though how to handle the "Orders" column for an order with multiple products. If I'm supposed to have multiple rows per product with the same Transaction ID, what value am I supposed to use in the "Orders" column in those rows? If I set it to 1 in each row, then I get more than 1 orders in total. Any ideas?

0 Replies