AUTOMATION_RECIPIENT Table Data Is Missing From the Destinationlink

Updated 12 days ago

Questionlink

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

Environmentlink

Connector: Mailchimp

Answerlink

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.