Create enriched lead records and log to campaign sheets

Leads arrive with messy phone formats and ad text, slowing qualification for campaign managers. Standardize phones, extract campaign and unit codes, post qualified leads and log rows so follow-up happens same day.