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

Show Sends by Day on a Mailchimp report

An update to Looker 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

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

    • How to Connect to Mailchimp

      Looking to bring your Mailchimp email marketing data into a single, automated reporting workflow? This guide will walk you through connecting Mailchimp as a data source in Power My Analytics, so you can centralize your campaign and audience metrics, ...

    • 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 Looker Studio. If you're using custom conversions with your Facebook ...

    • Missing Campaigns in Google Ads

      This article will address the following issue: Performance Max (now called Discovery) campaigns do not appear in report. Cause Performance Max/Discovery campaigns can only be reported at the Campaign level. Solution Ad group or Ad level reports will ...

    • SQL error: Exporting report ‘[report name]’, Incorrect string value

      When you see the error message "SQL error: Exporting report '[report name]', Incorrect string value" in your PMA Hub under Exports > SQL > View Logs, it indicates that your MySQL server is unable to process certain characters in your data. Error "SQL ...