CASPERBRAIN JOURNAL
Practical reading for online shops, marketing teams and telesales. Make sense of your data, build customer relationships and give every follow-up a reason.
START HEREInsight you can act onRFM & segmentation · 10 min read
Count distinct eligible orders instead of product rows, then reconcile a six-row export and check the result in a spreadsheet before calculating RFM frequency.
Read the article· 10 min read
Count distinct eligible orders instead of product rows, then reconcile a six-row export and check the result in a spreadsheet before calculating RFM frequency.
Continue reading· 11 min read
Work through three purchase dates for a fictional customer and learn why order date, delivery date, and record-edit date answer different questions — with a reproducible spreadsheet formula and data-quality checks.
Continue reading· 11 min read
A practical guide to CasperBrain's 1-best / 4-weakest quartile convention, with three fictional customer profiles, worked-example tables, a decision matrix, and a pre-action checklist so you never misread a score again.
Continue reading· 13 min read
Learn how to score customers with four independent RFM quartiles (1 = best, 4 = worst), read composite codes like "114", handle ties and small samples, and turn scores into practical retention decisions — with a fully worked eight-customer example.
Continue reading· 15 min read
Three repeat-purchase metrics, one shop: learn to distinguish historical repeat share, period returning-buyer share, and cohort second-order rate — with worked arithmetic, maturity pitfalls, RFM scoring, and a weekly measurement contract.
Continue reading· 11 min read
A practical field-by-field checklist for cleaning order CSV exports before customer analysis — covering date pitfalls, identifier handling, row reconciliation, and a reviewable data handoff.
Continue reading· 16 min read
Use clear counting rules, dated examples and verified customer identities to measure repeat purchases, purchase timing, product cohorts, cross-channel overlap and readiness for follow-up.
Continue reading· 12 min read
A practical first-order follow-up script with permission to continue, experience questions, three outcome branches and complete fictional dialogues for rehearsal.
Continue reading· 14 min read
A practical guide to building a telesales call queue using RFM segmentation—covering priority logic, capacity planning, scripts, service handoffs, measurement, and weekly iteration—without letting analysis override customer consent.
Continue reading· 12 min read
A practical guide to building a structured telesales workflow—covering customer context, handoff, agreed next actions, failure recovery, and measurement—for Thai e-commerce marketing and sales teams.
Continue reading
