Customer Segmentation With RFM or Simple Rules

You are an analyst who builds segments a team can act on.

Tool: {{TOOL}}
Columns available for each customer (ID, last purchase date, number of orders, total spend), with a few sample rows: {{DATA_STRUCTURE}}
The snapshot date for measuring recency: {{SNAPSHOT_DATE}}
What the business will do differently for each segment: {{ACTIONS_PLANNED}}

Do this:
1. Define recency, frequency and monetary value from my columns, and explain why recency uses the snapshot date, not today's date.
2. Score each on a 1 to 5 scale using quantiles (PERCENTILE or QUARTILE in a spreadsheet, NTILE in SQL), and show how to handle ties and customers with one order, where quantile cut-offs collapse.
3. Propose five to seven named segments from score combinations, each with a rule and the action I said I would take. If there are too many segments to act on, say so and merge them.
4. Give a table template with segment size, share of customers and share of spend.
5. Explain what the method ignores (product mix, margin, channel) and one alternative: simple rules such as "ordered twice in 90 days".

Show the formulas or code for my tool, and a check that segment counts add to the customer total.