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 (automation_emails, automations, campaigns, landing_pages, lists, unsubscribes)
as a dimension.
Click Sort, then select Date (automation_emails, automations, campaigns, landing_pages, lists, unsubscribes).
Select Ascending.
Edit the 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
The following article is a guide to automating reports with your Mailchimp connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Mailchimp reports. To begin creating ...Missing Campaigns in Google Ads
This article will address the following issue: Performance Max campaigns do not appear in report. Cause Performance Max campaigns can only be reported at the Campaign level. Solution Ad group or Ad level reports will not include Performance Max ...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, ...How to Avoid Duplicate Reports in Looker Studio
After making a copy of a report, you may notice that changes made to the copy reflect on the original. This article will show you how this happens and how to fix it. What Is a Duplicate Report? When a copy is made, selecting from available data ...