contact_list property_hs_list_size vs actual member count discrepancy

Developer Support APIs & Integrations
1

Hi,

We’re syncing HubSpot data to our warehouse via Fivetran and noticing a consistent discrepancy between the list size shown in the HubSpot UI and the property_hs_list_size field in the contact_list table.

Example: our “FR-speaking Mailable Contacts” active list shows 9,208 in the HubSpot segment view, but property_hs_list_size returns 8,559 a 650 contact gap. The property_hs_total_size_calculated_at timestamp is recent (today), so this doesn’t seem to be a sync lag issue.
List size also not synced since a few week

2

Hi @PBellier,
Thank you for posting to the Community! I’d like to tag in some of our Top Contributors to see if they have any ideas on next steps -- Hi @HubSpot_Corey @franksteiner79 and @GeorgeBThomas do you have any suggestions for @PBellier on this discrepancy?
Cassie, Community Manager