Products - break down by one another (based on s.products) | Community
Skip to main content
B
bkoth
Level 2
February 24, 2020
Solved

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

  • February 24, 2020
  • 3 replies
  • 4078 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by bkoth

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-freeform-tables/cross-sell-analysis-workspace.html#

3 replies

fsakjlfdsakljfd
fsakjlfdsakljfd
Level 5
February 24, 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.

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity Advisor
Community Advisor
February 24, 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.

B
bkothAuthorAccepted solution
Level 2
February 25, 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-freeform-tables/cross-sell-analysis-workspace.html#

Terms & ConditionsAccessibility statement

Loading footer...