Question
There is less automation_recipient_table data available in the warehouse than there is in MailChimp. What is causing this?
Environment
Connector: Mailchimp
Answer
A potential cause of this discrepancy is due to a deleted list member (or members). When you delete a list member in Mailchimp, their activity (sent, open, click, bounce) is also deleted. As a result, the data Fivetran delivers will sum to slightly less than the aggregate reporting in Mailchimp's dashboard.