AUTOMATION_RECIPIENT Table Data Is Missing From the Destination

Question

Why does the AUTOMATION_RECIPIENT table in my destination does not contain all the corresponding data available in my source?

Environment

Connector: Mailchimp

Answer

A deleted list member or members may cause this issue. When you delete a list member in Mailchimp, its activity (sent, open, click, and bounce) is also deleted. As a result, the data Fivetran syncs into your destination may be a little less than the aggregate reporting in Mailchimp's dashboard.