Two suggestions:
- The Mailchimp API data (at least for campaigns) is raw and does not align with the cleaned up click and open data available in Mailchimp. Can the API data include the cleaned up data?
- For the List Members query, can you add a Campaign dimension so I can see data by contact in a specific campaign?
- There are way too many query types. Can they be combined into one or two?