Mailchimp

Mailchimp is one of the data sources whose API always returns statistics for all days.

For example, if there is a campaign that lasted two days:

• 1/1/2024: 100 clicks
• 1/2/2024: 200 clicks

Additionally, the API continues to return data for the 3rd day, even after the campaign has ended:

• 1/3/2024: 200 clicks

The total number of clicks for the campaign is not 500 but 200, which is the metric for the last effective day of the campaign.

This creates two problems:

1. When using a dashboard or workflow, metrics are often viewed over date ranges, such as 7 days. The metrics from Mailchimp are summed for the entire period, but these metrics should not be summed. To see the correct value, only the last day of the campaign should be considered.

2. The API continues to show metrics for completed campaigns, even though the campaign is no longer active, and it should not be included in the results for the time range.

   Solution: Create a workflow that uses dynamic date ranges in Dashboards and Workflows.

Let's consider evaluating the effectiveness of Mailchimp campaigns in August. Our focus will be solely on campaigns launched within this month. To achieve this, we will design a workflow that processes Mailchimp data, filtering out campaigns that concluded before August started.

Next, for the campaigns in August, we'll use the last day of August to determine the final metrics of the campaigns.

This method has its limitations; for instance, any revenue generated by Augusts' campaigns in September will be excluded. However, in practice, these long tail revenues are typically minimal.