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!
SOLVED

Transactional data

Avatar

Level 2

Hi Team,

How can I handle transactional data? Where I want audiences, who have purchased 3 products naming tablet, phone and laptop. I want to know what was the amount for which they have purchased as I want to target people who have purchased 3 products with a total sum of Rs. $78000 amount. How can do that?

If we want to tag a product with a price and product id as well. How can we do that in the below case that you have mentioned? If it is going to follow the sequence?

“products”=“tablet|phone|laptop|”

“price”=“100|200|300"       Like this?

Product id = “p1|p2|p3”

Thanks in advance.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi girishk10214964,

Build a Visitor based segment as follows to target the described audience:

Revenue >= 78000

AND

HIT (product = tablet AND Orders exists)

AND

HIT (product = phone AND Orders exists)

AND

HIT (product = laptop AND Orders exists)

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Hi girishk10214964,

Build a Visitor based segment as follows to target the described audience:

Revenue >= 78000

AND

HIT (product = tablet AND Orders exists)

AND

HIT (product = phone AND Orders exists)

AND

HIT (product = laptop AND Orders exists)