Feb 17, 2021 9:13 PM
In the Hubspot UI, we have a dynamic list with about 13k members, but when we look at the contact list member table that's exported into our snowflake warehouse through fivetran, we see 17k unique contact IDs.
The table has a date added field, but no removed field. My guess is that contacts are added to the table when the fit the list criteria but are not removed from the table when they no longer meet the criteria and are removed form the list in Hubspot. Is this correct, or could there be another reason between the discrepancy.