{"id":322858,"date":"2025-11-28T07:23:29","date_gmt":"2025-11-28T07:23:29","guid":{"rendered":"https:\/\/peraltafinancing.com\/analytics\/kevin-hillstrom-minethatdata-diagnosing-a-problem\/"},"modified":"2025-11-28T07:23:29","modified_gmt":"2025-11-28T07:23:29","slug":"kevin-hillstrom-minethatdata-diagnosing-a-problem","status":"publish","type":"post","link":"https:\/\/fivemor.com\/?p=322858","title":{"rendered":"Kevin Hillstrom: MineThatData: Diagnosing a Problem"},"content":{"rendered":"


\n<\/p>\n

\n

Ever wonder how I quickly diagnose issues?<\/span><\/p>\n

This week, I’m going to share a handful of tables used in my Elite Program runs. Many of you already participate in the Elite Program. Most of you should have something comparable that you look at internally. It’s been my experience that those who don’t have something comparable “make up” a lot of theories about why business is good\/bad.<\/span><\/p>\n

Here is a Rolling Twelve Month analysis. Look at the table, and tell me what this business did to cook the books.<\/span><\/p>\n

\n
<\/a><\/div>\n


<\/span><\/div>\n

There are many “rolling analysis skeptics”. These are the kind of folks who, in my hobby (headphone), like treble-enhanced planar magnetic drivers. They want all the details. I’m more of a tube amp kind of person, I like a warmer signature, smoothed over. I want a longitudinal view of a business. I want to see when the merchant made a mistake. I want to see when the finance professional injected herself into the business. I want to see when a marketer made a mistake. I want to see all of that in the context of time.<\/span><\/p>\n

This is one of those situations where the CEO might tell me that everything is fine, the business is stable at around $40,000,000 per year, top-line sales.<\/span><\/p>\n

No. The business is cooking the books.<\/span><\/p>\n

Why do I say that?<\/span><\/p>\n

The two columns on the far right side of the table.<\/span><\/p>\n

\n
    \n
  • Demand from Items Selling Above Their Average Price Point.<\/span><\/li>\n
  • Demand from Items Selling Below Their Average Price Point.<\/span><\/li>\n<\/ul>\n

    Let’s say you have an item that sells for $49.99. The marketer decides to run a promotion, 40% off. Now the item sells for $29.99. When the item sells for $49.99, it is selling at\/above their historical average price point. When the item sells for $29.99, it sells below their historical average price point.<\/span><\/p>\n

    Now go back to the two columns on the far right side of the table.<\/span><\/p>\n

    Items selling at\/above their historical price point:<\/span><\/p>\n

    \n
      \n
    • $27.9 million past year.<\/span><\/li>\n
    • $30.5 million a year ago.<\/span><\/li>\n
    • $31.7 million two years ago.<\/span><\/li>\n
    • $31.0 million three years ago.<\/span><\/li>\n<\/ul>\n<\/div>\n

      Here are items selling below their historical price point.<\/span><\/p>\n

      \n
        \n
      • $12.7 million past year.<\/span><\/li>\n
      • $10.0 million a year ago.<\/span><\/li>\n
      • \u00a0 $9.2 million two years ago.<\/span><\/li>\n
      • $10.9 million three years ago.<\/span><\/li>\n<\/ul>\n<\/div>\n

        The past year tells us an interesting story. Full-priced selling declined by $2.6 million while off-priced selling increased by $2.7 million.<\/span><\/p>\n

        In other words, Management “cooked the books” … they likely saw that they weren’t going to meet budget, so they lowered prices via promotions to get the top-line “in-line”.<\/span><\/p>\n

        Either this company has an inventory problem (rectified by clearing out products at lower prices), it is missing budget (which often causes an inventory problem) due to lower customer response, it has a forecast issue (the forecast was mistakenly assigned to be too high for what customers can deliver), or all off the above.<\/span><\/p>\n

        Are there other ways to diagnose this issue? Of course. Are you using other methods? Too often, the answer is “no”. There’s just speculation … which is fun … but isn’t meaningful.<\/span><\/p>\n<\/div>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"

        Ever wonder how I quickly diagnose issues? This week, I’m going to share a handful of tables used in my Elite Program runs. Many of you already participate in the Elite Program. Most of you should have something comparable that you look at internally. It’s been my experience that those who don’t have something comparable […]<\/p>\n","protected":false},"author":1,"featured_media":317197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12033],"tags":[150097,13773,13772,13774,4106],"dealstore":[],"offerexpiration":[],"class_list":["post-322858","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","tag-diagnosing","tag-hillstrom","tag-kevin","tag-minethatdata","tag-problem"],"yoast_head":"\nKevin Hillstrom: MineThatData: Diagnosing a Problem - Som2ny Network<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fivemor.com\/?p=322858\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kevin Hillstrom: MineThatData: Diagnosing a Problem - Som2ny Network\" \/>\n<meta property=\"og:description\" content=\"Ever wonder how I quickly diagnose issues? This week, I’m going to share a handful of tables used in my Elite Program runs. Many of you already participate in the Elite Program. Most of you should have something comparable that you look at internally. It’s been my experience that those who don’t have something comparable […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fivemor.com\/?p=322858\" \/>\n<meta property=\"og:site_name\" content=\"Som2ny Network\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-28T07:23:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG\" \/>\n\t<meta property=\"og:image:width\" content=\"741\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fivemor.com\/?p=322858#article\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/?p=322858\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\"},\"headline\":\"Kevin Hillstrom: MineThatData: Diagnosing a Problem\",\"datePublished\":\"2025-11-28T07:23:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=322858\"},\"wordCount\":511,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=322858#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG\",\"keywords\":[\"Diagnosing\",\"Hillstrom\",\"Kevin\",\"MineThatData\",\"Problem\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fivemor.com\/?p=322858#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fivemor.com\/?p=322858\",\"url\":\"https:\/\/fivemor.com\/?p=322858\",\"name\":\"Kevin Hillstrom: MineThatData: Diagnosing a Problem - Som2ny Network\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=322858#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=322858#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG\",\"datePublished\":\"2025-11-28T07:23:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fivemor.com\/?p=322858#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fivemor.com\/?p=322858\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/?p=322858#primaryimage\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG\",\"width\":741,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fivemor.com\/?p=322858#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fivemor.com\/?bp_activities=1\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kevin Hillstrom: MineThatData: Diagnosing a Problem\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fivemor.com\/#website\",\"url\":\"https:\/\/fivemor.com\/\",\"name\":\"Som2ny Network\",\"description\":\"Daily Deals\",\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fivemor.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/fivemor.com\/#organization\",\"name\":\"Som2ny Network\",\"url\":\"https:\/\/fivemor.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png\",\"width\":300,\"height\":86,\"caption\":\"Som2ny Network\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/fivemor.com\"],\"url\":\"https:\/\/fivemor.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kevin Hillstrom: MineThatData: Diagnosing a Problem - Som2ny Network","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fivemor.com\/?p=322858","og_locale":"en_US","og_type":"article","og_title":"Kevin Hillstrom: MineThatData: Diagnosing a Problem - Som2ny Network","og_description":"Ever wonder how I quickly diagnose issues? This week, I’m going to share a handful of tables used in my Elite Program runs. Many of you already participate in the Elite Program. Most of you should have something comparable that you look at internally. It’s been my experience that those who don’t have something comparable […]","og_url":"https:\/\/fivemor.com\/?p=322858","og_site_name":"Som2ny Network","article_published_time":"2025-11-28T07:23:29+00:00","og_image":[{"width":741,"height":630,"url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fivemor.com\/?p=322858#article","isPartOf":{"@id":"https:\/\/fivemor.com\/?p=322858"},"author":{"name":"admin","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371"},"headline":"Kevin Hillstrom: MineThatData: Diagnosing a Problem","datePublished":"2025-11-28T07:23:29+00:00","mainEntityOfPage":{"@id":"https:\/\/fivemor.com\/?p=322858"},"wordCount":511,"commentCount":0,"publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"image":{"@id":"https:\/\/fivemor.com\/?p=322858#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG","keywords":["Diagnosing","Hillstrom","Kevin","MineThatData","Problem"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fivemor.com\/?p=322858#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fivemor.com\/?p=322858","url":"https:\/\/fivemor.com\/?p=322858","name":"Kevin Hillstrom: MineThatData: Diagnosing a Problem - Som2ny Network","isPartOf":{"@id":"https:\/\/fivemor.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fivemor.com\/?p=322858#primaryimage"},"image":{"@id":"https:\/\/fivemor.com\/?p=322858#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG","datePublished":"2025-11-28T07:23:29+00:00","breadcrumb":{"@id":"https:\/\/fivemor.com\/?p=322858#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fivemor.com\/?p=322858"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/?p=322858#primaryimage","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/11\/Slide1.JPG","width":741,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/fivemor.com\/?p=322858#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fivemor.com\/?bp_activities=1"},{"@type":"ListItem","position":2,"name":"Kevin Hillstrom: MineThatData: Diagnosing a Problem"}]},{"@type":"WebSite","@id":"https:\/\/fivemor.com\/#website","url":"https:\/\/fivemor.com\/","name":"Som2ny Network","description":"Daily Deals","publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fivemor.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/fivemor.com\/#organization","name":"Som2ny Network","url":"https:\/\/fivemor.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/#\/schema\/logo\/image\/","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png","width":300,"height":86,"caption":"Som2ny Network"},"image":{"@id":"https:\/\/fivemor.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png","caption":"admin"},"sameAs":["https:\/\/fivemor.com"],"url":"https:\/\/fivemor.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/322858","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=322858"}],"version-history":[{"count":0,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/322858\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/media\/317197"}],"wp:attachment":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=322858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=322858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=322858"},{"taxonomy":"dealstore","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fdealstore&post=322858"},{"taxonomy":"offerexpiration","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fofferexpiration&post=322858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}