To run queries automatically, you'll need to turn on data sync in Mailchimp for Salesforce. Data sync will add new contacts and update contact information in your Mailchimp audience.
You can also choose to manually run queries. These will add new contacts to your Mailchimp audience, but won't update existing contact information.
About the Query Builder
The Query Builder allows you to pass Salesforce contacts, leads, and campaign members who share specific Salesforce field data into your Mailchimp audience.
You can run a query manually or schedule it to run daily with data sync. Queries run manually will add new contacts to your Mailchimp audience, but won’t update existing contact information. To update existing contact information, you'll need to use data sync.
Things to know
Salesforce contacts and leads who checked the Email Opt-Out field won't be included in query results.
If a lead or contact opts-out in Salesforce after they are added to your Mailchimp audience, they won't be unsubscribed in Mailchimp.
To view tags for a Mailchimp audience in Salesforce when you build a query, click Sync Audience next to the Mailchimp audience name in Salesforce.