# 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.

> ![](https://knowledge.powermyanalytics.com/application/sources/images/show-sends-by-day-on-a-mailchimp-report-1.png)

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

> ![](https://knowledge.powermyanalytics.com/application/sources/images/show-sends-by-day-on-a-mailchimp-report-2.png)

With the chart selected, add **Date** as a dimension.

> ![](https://knowledge.powermyanalytics.com/application/sources/images/show-sends-by-day-on-a-mailchimp-report-3.png)

Click Sort, then select **Date**.

> ![](https://knowledge.powermyanalytics.com/application/sources/images/show-sends-by-day-on-a-mailchimp-report-4.png)

Select **Ascending.**

> ![](https://knowledge.powermyanalytics.com/application/sources/images/show-sends-by-day-on-a-mailchimp-report-5.png)

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

> ![](https://knowledge.powermyanalytics.com/application/sources/images/show-sends-by-day-on-a-mailchimp-report-6.png)

Click the **Running Calculation** drop-down menu.

> ![](https://knowledge.powermyanalytics.com/application/sources/images/show-sends-by-day-on-a-mailchimp-report-7.png)

Select **Running Delta.**

> ![](https://knowledge.powermyanalytics.com/application/sources/images/show-sends-by-day-on-a-mailchimp-report-8.png)
