Mapping Leads to Customers
End table result: lead_customer
| lead_id | customer_id |
| lead111 | cus999 |
| lead222 | NULL |
| lead333 | NULL |
| lead444 | cus888 |
Depending on your business, this process can be difficult. But the end result is simple -
create a two-column table where each customer_id is attached to exactly one lead_id.