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

Products - break down by one another (based on s.products)

bkoth
Level 1
Level 1

Hi guys

 

quick question: is there any way to find out / break down products that have been in the s.products string at the same time?

 

e.g. s.products = "prod1,prod2,prod3";

or another time s.products = "prod2,prod3,prod4,prod1";

 

What I would like to know is which other products prod1 has been in the products string with and how often.

This seems to be an essential feature which I have not managed to find yet.

 

Best

Björn

1 Accepted Solution
bkoth
Correct answer by
Level 1
Level 1

found this Adobe page which answers my question or at least provides enough information to take it from here. Thanks for your responses!

https://docs.adobe.com/content/help/en/analytics-learn/tutorials/analysis-workspace/building-freefor...

View solution in original post

0 Replies
fsakjlfdsakljfd
Level 5
Level 5

If you make a hit level segment ' hit: product = a' and apply that to a table or panel it should return any products that were inside the same hit.

pabloc82923542
Level 9
Level 9

You have 2 options one should be out of the box. the other you need to report 1 at a time.

 

The first and ideal is a cross sell report. It will show a selected product and any other products in order of frequency it was sold with. The problem is that its a one to many relationship.

 

Option 2

If you capture a transaction ID at time of purchases and then associate all items in s.product then you can compare what items at time of a given purchase were sold together. You then could filter in exel combo matches... not as nice as cross sell.

 

A sort of thisr option is make a segment. For products in a transaction.

bkoth
Correct answer by
Level 1
Level 1

found this Adobe page which answers my question or at least provides enough information to take it from here. Thanks for your responses!

https://docs.adobe.com/content/help/en/analytics-learn/tutorials/analysis-workspace/building-freefor...

View solution in original post