蜜豆视频

Transcript

Hey, what鈥檚 up everybody? This is Doug. In this video, I want to show you how to do cross-sell analysis in Analysis Workspace. So we鈥檝e got a product report here and I鈥檝e got my list of products. I鈥檓 sorting by orders. And so I鈥檝e 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鈥檓 going to get data, but you can see that it鈥檚 not great because it鈥檚 just going to give me this data on the diagonal here. And that鈥檚 because 蜜豆视频 Analytics is comparing this at the most granular level, which in this case is sub-hit. It鈥檚 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鈥檓 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鈥檓 just going to click over there, and let鈥檚 grab a few of these. I鈥檓 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鈥檚 what we鈥檙e 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鈥檝e got this parka and then a swimsuit and a scarf, etc, etc. And you鈥檝e 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鈥檚 sort by that. And then we can see the highest ticket items that were sold together with the boots. Now the way I鈥檝e got this set up right now, of course you鈥檙e 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鈥檙e using classifications. So I鈥檓 going to go back over here and we鈥檙e going to go to Product Type. If I can find it here somewhere, maybe I鈥檒l just search for it. There it is, okay. So I鈥檓 going to drag this on and I鈥檓 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鈥檒l go back to orders. And then again, after boots, which is a hundred percent, obviously because it鈥檚 鈥渂oots鈥� right there. Then you can see the jackets are most often purchased when they buy these specific boots. But maybe you鈥檇 like to also put different types up here as well. So I can just get rid of those guys that I鈥檝e 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鈥檚 on the same order or maybe it鈥檚, 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鈥檒l see here, let鈥檚 keep an eye on this. So first of all, let鈥檚 go down here and we鈥檝e got boots at 7,194. So I鈥檓 going to remember that 7,194. I鈥檓 going to change this to Visitor-based and apply it.

And 7,194 for boots now turns into 14,903. So there鈥檚 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鈥檒l 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. -