Reporting plugins bloat the database and still guess at who your best customers are. Here is how I build RFM scores from WooCommerce order data in Pandas, and what the segments are actually good for.
A jewelry retailer’s smart crop kept locking onto diamond reflections, because edge detection flagged every one of them. Harris corner detection found the structural points instead. Here is the R score logic and the OpenCV implementation.
A store selling pet supplies and gaming gear had a search bar that put cat nip next to Logitech mice. Notes on how self-attention and the Query-Key-Value setup finally gave that search enough context to tell an animal from a USB device.
A weather dashboard that tells people what to wear, built on Databricks and GPT-4o-mini instead of a pile of if-statements. Covers the extraction class, the LLM transformation step, and the hourly job that keeps the Delta Table fresh.
A price tracker taught me that a hand-built Google scraper dies within two days. Here is why I hand that job to SerpApi now, plus the PHP wrapper I reuse and the latency setting that matters at scale.
A client once sent me a 50-page persona PDF that said nothing about why people abandon checkout. Functional personas built with AI from support tickets and order notes tell you what a customer is trying to finish and where they stop.
A WooCommerce client’s GPT search assistant was inventing products and discount codes. Prompt engineering did not fix it. Confidence thresholds, source links, and honesty about the limits did.
A client spent six months AI-powering their onboarding flow and ended up with hallucinated shipping dates. The prompt was never the problem, the context was. Here is what UX has to own before the model ships.
An 85% churn score with no reason attached is a support ticket waiting to happen. What worked instead: a plain-language because statement, the charts behind a link, and code that maps feature names to words.
A client’s organic traffic fell off a cliff and nothing on their site was broken. Google had started answering the queries itself. Here is what I checked, and where the real work sits in a WordPress build.