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

Avatar

Avatar
Validate 1
Level 1
bkoth
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Affirm 1
View profile

Avatar
Validate 1
Level 1
bkoth
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Affirm 1
View profile
bkoth
Level 1

24-02-2020

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
bkoth
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Affirm 1
View profile

Avatar
Validate 1
Level 1
bkoth
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Affirm 1
View profile
bkoth
Level 1

25-02-2020

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...

Answers (2)

Answers (2)

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

24-02-2020

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.

Avatar

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

13 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

13 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
fsakjlfdsakljfd
Level 4

24-02-2020

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.