Add incoming lead to two agency CRM pipelines

Inbound leads arrive without pipeline records, leaving campaign managers missing context. It creates or updates opportunities in both agency and client pipelines so managers begin outreach same day.