Sphere reactivation from a CRM export

I am uploading a CSV export from my CRM with columns: [LIST COLUMNS, e.g. name, last contact date, how we met, closed transaction date, notes].

1. Segment contacts into: Past clients (closed with me), Warm sphere (contacted in last 12 months), Cold sphere (12+ months), Unknown. Show a count per segment.
2. For the top 30 contacts by relationship strength (closed deals first, then most recent contact), write a personal 1-2 sentence text for each that references something specific from their notes. If notes are empty, write a simple genuine check-in, no real estate pitch.
3. Output as a table: Name | Segment | Draft text | Suggested follow-up date.
4. List any contacts with missing phone or email so I can clean them up.

Rules: Do not invent details that are not in the notes. No sales language in the first message. Keep each text under 280 characters.