Contacts linked to Company in segment are not appearing

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"

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”