Decision Models in the Query LoopModel Answers Go Back into the SQL, and the Controls Check What Changed
In the MerRec case study, we rank 5,000 brands by betweenness centrality in a graph of shared fans to find the brands that connect different shopping communities. But when you run this on real marketplace data, you run into an immediate catalog problem: twelve of the top twenty entries aren't independent brands at all. They are retailers (Walmart, JCPenney, Macy's), store brands (Mainstays), or catch-all bucket labels that sellers select from the brand dropdown (As Seen on TV, Customized & Personalized, Eyeshadow).
Because shoppers across every category buy from Walmart, Walmart creates artificial shortcuts between worlds that no actual manufacturer provides. If you want an honest picture of brand affinity, you have to get those catalog artifacts out of the graph. This post walks through how we pull them out, why naive filtering fails, and how the ranking shifts once the graph is rebuilt.