AUTOMATION_RECIPIENT Table Data Is Missing From the Destinationlink
Updated 12 days ago
Why does the
AUTOMATION_RECIPIENT table in my destination does not contain all the corresponding data available in my source?
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.