Data Hygiene & Reconciliation

Our current goal is to consolidate the customer data and prepare four segments: Lapsed, Proposal Abandoned, Web Engagers, and Product Expiration. I'll use Python and Pandas to clean and reconcile the data, match customer accounts with contact details, preserve customer classifications, and keep suppression records separate. I'll also provide clean segment-wise exports, a summary of unmatched records, and a reusable processing script. To proceed, I'll also need Google Analytics access for we