How do I show sends by day on a Mailchimp report?

Show Sends by Day on a Mailchimp report

An update to Data Studio finally allows our customers to create this long-awaited chart. 

This demonstration will show Automation Campaigns. However, it will also work with Standard Campaigns.

Begin at your Automation Campaigns chart on your Mailchimp report. If you are using our template, this will be on page 4.



Set the date range to include the first day of your automation campaign.



With the chart selected, add Date as a dimension.



Click Sort, then select Date.



Select Ascending.



Edit the Total Opens metric by clicking on the pencil icon that appears when you hover over SUM.



Click the Running Calculation drop-down menu.



Select Running Delta.



    • Related Articles

    • Report Subscribes and Unsubscribes Over Time in Mailchimp

      Last updated: June 8, 2026 Applies to: PMA hub, Mailchimp data connector, Data Studio destination Audience: Customers who want to chart day-over-day subscriber growth and unsubscribes from Mailchimp in Data Studio Mailchimp data in Power My Analytics ...

    • Mailchimp Data Connector User Guide

      Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

    • Export a Data Studio Report to PDF

      This article will show you how to export your Data Studio report to a downloadable PDF format. To export your Data Studio report to a PDF, open your report. Click the down arrow on the Share button. Then click Download report. Select the pages you ...

    • ActiveCampaign Data Connector User Guide

      Get valuable insights into your email marketing, automation, and sales performance by connecting your ActiveCampaign account to Power My Analytics. This guide will walk you through setup, reporting capabilities, and important considerations. ...

    • How to Report Custom Conversions in Facebook Ads

      Power My Analytics offers an easy way to include your custom conversions data in your Facebook Ads reports. Follow these steps to get started with reporting custom conversions in Data Studio. If you're using custom conversions with your Facebook Ads ...