I’m looking for an experienced **Looker Studio / Mailchimp reporting specialist** to help troubleshoot and improve an existing dashboard that pulls Mailchimp data through a connector (Power My Analytics). The current report tracks email campaign performance, but there are inconsistencies in how certain Mailchimp data (such as automations, subject lines, and audience-level reporting) appears in Looker Studio. I need someone who understands how Mailchimp data is structured and how it flows through connectors into Looker so the reporting can be accurate and reliable. **Scope of Work** * Review an existing Looker Studio report connected to Mailchimp * Identify issues with how email campaign and automation data are being surfaced * Recommend the correct dimensions, metrics, and filters to use * Ensure campaign performance metrics (sends, opens, clicks, etc.) are reporting correctly * Advise on best practices for structuring Mailchimp reporting in Looker Studio * Make adjustments to the report so it is clean, stable, and easy to maintain **Tools Involved** * Looker Studio * Mailchimp * Power My Analytics (Mailchimp connector) **Ideal Experience** * Strong experience with Looker Studio dashboards * Familiarity with Mailchimp data structure (campaigns, automations, audiences, etc.) * Experience working with marketing data connectors such as Power My Analytics, Supermetrics, or similar * Ability to troubleshoot data inconsistencies between platforms **Deliverable** A corrected and well-structured Looker Studio report with clear guidance on how the data should be configured moving forward.