m having an issue with the contact segment is not making the association between the contact and the company filter field in the segment.
For “platform__ABC”, 6,000 contacts appear in the segment based on the value “Yes” on their associated company table which seems correct; however, for “platform__XYZ”, ZERO contacts appear base don their associated company table field even though the SQL query shows the company table has been populated for 1,145 companies properly. None of the linked contacts appear in the segment.
Does anyone know whats going on here?
SQL
1145 for XYZ
Select count(*) from lead_map.MAP2q_companies
WHERE lead_map.MAP2q_companies.platform__xyz = "Yes"
And 2279 for ABC:
Select count(*) from lead_map.MAP2q_companies
WHERE lead_map.MAP2q_companies.platform__abc = "Yes"