In this video you will learn how to create a cross-sell report in Analysis Workspace, and extend it even further to any multi-valued dimension or classification.
Hey, what’s up everybody? This is Doug. In this video, I want to show you how to do cross-sell analysis in Analysis Workspace. So we’ve got a product report here and I’ve got my list of products. I’m sorting by orders. And so I’ve got orders, revenue, and revenue per order here. And I want to see which products are sold with other products right? Cross-sell. So you might think that you could take, you know, the product dimension and just drop it in on a column as a filter. And so if I go over here to Orders, for example and I just drop it in as a Filter By and just let it go. Well, I’m going to get data, but you can see that it’s not great because it’s just going to give me this data on the diagonal here. And that’s because Adobe Analytics is comparing this at the most granular level, which in this case is sub-hit. It’s smaller than a hit, it is per-item in the hit. Since when we buy things we are reporting them even multiple items per hit. So I’m just going to do an Undo. And so what we really need to know which items are sold together is to do it per hit. So you might know that if I drag and drop something up to the Segment drop zone here then that by default is going to be per hit. So if I go into my product items, I’m just going to click over there, and let’s grab a few of these. I’m going to grab a few of these and drag 'em up and Shift drop. And if I click on this little information bubble here then you can see indeed this is per hit, okay? And so that’s what we’re looking for. And so now we do see down here, you know, when you have the Timberline GTX boots purchased, you know, for orders, and you got revenue and revenue per order, what are the other things that are the highest? Well obviously itself, but next you’ve got this parka and then a swimsuit and a scarf, etc, etc. And you’ve got these products that were purchased the most with those boots. And then of course, you can also sort by revenue or even revenue by order. Let’s sort by that. And then we can see the highest ticket items that were sold together with the boots. Now the way I’ve got this set up right now, of course you’re going to have to do it item by item, you know, which was sold with the parka, what was sold with the pants, the scarf, etc. But you can also do this per grouping because we have these products classified, or we’re using classifications. So I’m going to go back over here and we’re going to go to Product Type. If I can find it here somewhere, maybe I’ll just search for it. There it is, okay. So I’m going to drag this on and I’m going to replace Product with Product Type. And this is kind of an interesting thing. So you can see when people buy the boots which other product types are they purchasing the most? Or in this case, you know, the highest ticket. But I’ll go back to orders. And then again, after boots, which is a hundred percent, obviously because it’s “boots” right there. Then you can see the jackets are most often purchased when they buy these specific boots. But maybe you’d like to also put different types up here as well. So I can just get rid of those guys that I’ve got up there. And I can go to the Types. And I can select the items here and I can multi-select, or maybe even just grab one and say, jackets, drop that in. And now I can see when people buy jackets the next most popular thing to buy with them is boots, and then hats, shirts, gloves, etc. Now again, remember that this is product type. Now another very cool thing that you can do with this is that you can change this from a hit segment to a visitor base segment. So if I click on this Edit Quick Segment there, kind of drops down there and I can edit that right here on the page. So I have Hit right here. And so this is which items are purchased together on the same purchase. But maybe you want to know, you know, which items are bought by the same people, whether it’s on the same order or maybe it’s, you know, a month later or something like that. So if you want to understand which product types, in this case, are purchased by the same people, then you can change this Hit Segment to a Visitor Segment. And you’ll see here, let’s keep an eye on this. So first of all, let’s go down here and we’ve got boots at 7,194. So I’m going to remember that 7,194. I’m going to change this to Visitor-based and apply it.
And 7,194 for boots now turns into 14,903. So there’s a lot more orders and a lot more revenue, etc. that is associated with people who buy jackets, you know, that might buy things later. In this case, boots. So that’ll give you some additional information on people that buy these different product types. Anyway, I hope that was helpful. As you do this cross-sell analysis analysis workspace is very flexible and very powerful. Have a great day. -