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.
Still having issues?
Send us a ticket and we will get back to you.
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 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 ...What Time Does My Data Refresh?
After you create a report with PMA, your report's data will be updated automatically. This article explains how to choose the sync time for your data to refresh. When Does My Report's Data Refresh? Most connectors default to refresh every day at ...How to Use a Multi-Source Report Template in Looker Studio
Are you a Looker Studio template user looking to streamline your reporting process? Look no further! In this article, we'll cover how to use a multi-source report template in Looker Studio. We'll walk through the steps of selecting data sources, ...