search

intakedesk / PowerBI-General

Placeholder for issues migrated from Jira
1 stars 0 forks source link

Investigate Leads posted without PID #604

Closed jesusitd closed 3 years ago

jesusitd commented 3 years ago

Ran several queries. Documentation in: https://intakedesk.sharepoint.com/:f:/r/sites/power-bi-docs/Power%20BI%20Desktop%20Files/-%20Data%20Sweeps/2020-08-29%20Leads%20CSTM%20No%20PID%20No%20Subid?csf=1&web=1&e=3dfH3W

Got help from Eduardo and had to recover several times due to Excel spreadsheets miscalculations, including duplicate CRM Lead IDs issue.

jesusitd commented 3 years ago

Sent last query to EG for 2 lines:

UPDATE leads_cstm SET leads_cstm.subid_c = '6187476667169' WHERE leads_cstm.id_c = '1dcb75a4-e229-cbf5-8e73-5efbcb4a9871';
UPDATE leads_cstm SET leads_cstm.subid_c = '6187476667969' WHERE leads_cstm.id_c = 'a2f41c70-646d-0607-79b4-5eeba45c837e';
jesusitd commented 3 years ago

In conversation with Eduardo, this was due to an issue with leads_cstm.phone_carrier_c, where the field limit was 50 and there was a phone carrier (Bright Networks something) trying to push more characters. Thus, leads_cstm was not being written at all.

The field was extended to 60 characters by Ed.

jesusitd commented 3 years ago

Notified resolution through email.