Why Are Records With the Subscription Status Not opted Missing From the EMAIL_SUBSCRIPTION_CHANGE Table?

Question

I can see customers with the subscription status Not opted in my source. Why are these records missing from the EMAIL_SUBSCRIPTION_CHANGE table in my destination?

Environment

Connector: HubSpot

Answer

We use the changeType parameter of the HubSpot API's View subscriptions timeline for a portal endpoint to determine the data we sync to the EMAIL_SUBSCRIPTION_CHANGE table. Specifically, we sync data from the returned output when changeType=SUBSCRIPTION_STATUS.

HubSpot only assigns the above changeType value when a customer either subscribes or unsubscribes from the applicable email subscription. See HubSpot's Email Subscriptions API Overview documentation for more information.

If a customer appears in HubSpot with the subscription status Not opted, they have yet to subscribe or unsubscribe. In such cases, HubSpot's API won't return the above changeType value, and we won't sync the record to the EMAIL_SUBSCRIPTION_CHANGE table.