Used SQL
Finally able to manage queries in Google BigQuery to target audiences by participation in different events through Mailchimp campaigns