We use cookies to make HubSpot's community a better place. Cookies help to provide a more personalized experience and relevant advertising for you, and web analytics for us. To learn more, and to see a full list of cookies we use, check out our Cookie Policy (baked goods not included).
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.
Mar 1, 2022 4:38 PM
@nick_lanspa @dennisedson @Fivetran Was this issue ever resolved? Our team is running into the same issue.
Feb 18, 2021 12:22 PM
Hey @nick_lanspa
Let's see if @Fivetran has any thoughts about this 😀