Messy trade-show spreadsheet problems from marketing ops
Importing 1,400 FinTech Summit scans into Salesforce. Raw sheet has single `Full Name` column, mixed countries (`UK`, `Great Britain`, `United Kingdom`), `Phone` missing `+` prefixes, and notes mixed with booth demo requests. Need clean CSV headers + validation rules.
Standardized Salesforce Campaign Member CSV schema
Headers: `email,first_name,last_name,company,website_domain,job_title,country_iso2,state_code,phone_e164,lead_source,campaign_id,booth_intent_tier,gdpr_opt_in_date,rep_notes`
Validation Rules:
- `country_iso2`: Normalize `UK/Great Britain` -> `GB`; enforce `state_code` only when `US`/`CA`.
- `website_domain`: Extract root domain (`stripe.com`) excluding free webmail (`gmail.com` -> blank).
- `booth_intent_tier`: Picklist [`Hot - Demo Requested`, `Warm - Scanned`, `Partner/Press`].