MailChimp

Estimated reading time: 7 min

MailChimp is an email service provider (ESP), which helps marketers send bulk emails to clients, customers, and other interested parties.

From this article you can learn:

Creating an Integration

From your Slemma account, head over to the Library page and click the plus button at the bottom right. Select Integration from the submenu.

In the following page, you can find MailChimp with one of the following ways:

  1. Scroll down and select MailChimp from the list of Integrations.
  2. Use search to find MailChimp from the list of Integrations.
  3. Choose MailChimp using All dropdown list > Marketing.

You’ll see the Integration settings dialog window. You can select the frequency for the automatic updates on the DATA REFRESH tab, or set weeks settings on the ADVANCED tab. Click OK.

You’ll be directed to a page to sign in. Login to your MailChimp account.

After authorization, the integration will be created and it will appear in your account in the list of objects. Now you are able to share the integration with either individuals or the entire Team, rename or remove the integration. To view the options available for the integration, right click it in the list.

Creating a Dataset

A dataset is a collection of data in a tabular format that is created on one of the possible data sources. The datasets can be used to create dashboards or individual charts.

To create a dataset, click your MailChimp integration in the list and select Browse datasets. From the following page, select which data you want to add to use in your charts.

 

NOTE: Cloud Service Integrations have prebuilt datasets that are not editable.

Click dataset’s name for a description of each dataset.

This data source contains statistics about your campaigns such as the average number of unique opens by send time.

Dimensions

  1. Campaign Name – The title and send time of the campaign
  2. List Name – The name of the list
  3. Type – The type of the campaign. Possible values: regular, plaintext, absplit, rss, variate
  4. Status – The current status of the campaign. Possible values: save, paused, schedule, sending, sent
  5. Send Time – Date a campaign was sent

Measures

  1. Total Opens – The total number of opens for a campaign
  2. Unique Opens – The number of unique opens
  3. Open Rate – The number of unique opens divided by the total number of successful deliveries
  4. Total Clicks – The total number of clicks for a campaign
  5. Unique Clicks – The number of unique clicks
  6. Click Rate – The number of unique clicks divided by the total number of successful deliveries
  7. Emails Sent – The total number of emails sent for this campaign
  8. Delivery Rate – The number of emails sent divided by the total number of successful deliveries
  9. Unsubscribe Count – The total number of unsubscribed members for this campaign
  10. Unique Subscriber Clicks – The total number of subscribers who clicked on a campaign
  11. Successful Deliveries – The number of emails sent was successfully delivered
  12. Unsubscribed Rate – The number of unsubscribed members divided by the total number of successful deliveries
  13. Hard Bounces – The total number of hard bounced email addresses
  14. Soft Bounces – The total number of soft bounced email addresses
  15. Syntax Bounces – The total number of addresses that were syntax-related bounces
  16. Total Bounces – The total number of bounced email addresses
  17. Total Forwards – How many times the campaign has been forwarded
  18. Forwards Opens – How many times the forwarded campaign has been opened
  19. List Open Rate – The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list
  20. List Click Rate – The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list
  21. List Average Subscription Rate – The average number of subscriptions per month for the list
  22. List Average Unsubscription Rate – The average number of unsubscriptions per month for the list
  23. Industry Open Rate – The industry open rate
  24. Industry Click Rate – The industry click rate
  25. Industry Bounce Rate- The industry bounce rate
  26. Industry Unopened Rate – The industry unopened rate
  27. Industry Unsubscribe Rate – The industry unsubscribe rate
  28. Industry Abuse Rate – The industry abuse rate
  29. Total Orders – The total orders for a campaign
  30. Total Spent – The total spent for a campaign. Calculated as the sum of all order totals with no deductions
  31. Total Revenue – The total revenue for a campaign. Calculated as the sum of all order totals minus shipping and tax totals
  32. Facebook Unique Likes – The number of unique likes
  33. Facebook Likes – The number of Facebook likes for the campaign
  34. Facebook Recipients Likes – The number of recipients who liked the campaign on Facebook
  35. Number of Running Campaigns – Number of Running Campaigns

Templates

  1. Bounce Rates by Campaign – Track your trending bounce rate for all campaigns in a given time frame.
  2. Campaign Performance Metrics – View unique opens, unique clicks, emails sent and successful deliveries for campaigns.
  3. Delivery Rate by Campaign (last 30 days) – Show the delivery rate for all campaigns sent over the last 30 days.
  4. Email List Performance – View the number of emails sent, opens and clicks for all lists in a given time frame.
  5. Open Rate vs Click Rate by Campaign – Compare the open and click rates by campaign in a given time frame.
  6. Unique vs Total Clicks by Campaign – Track and compare unique clicks with total clicks for all campaigns.
  7. Unique vs Total Opens by Campaign – Track and compare unique opens with total opens for all campaigns.

This data source contains statistics about your campaign performance in different countries.

Dimensions

  1. Campaign Name – The title and send time of the campaign
  2. Country – The name of country
  3. List Name – The name of the list

Measures

  1. Opens – The number of unique campaign opens for a country
  2. Number of Records – Number of Records

Templates

  1. Opens by Locations – Show the number of opens by location in a given time frame.
  2. Top 10 Locations by Opens – View your top ten countries by opens in a given time frame.

This data source contains a summary of the month-by-month growth activity for a specific list.

Dimensions

  1. List Name – The name of the list
  2. Month History – The month that the growth history is describing

Measures

  1. Existing – Existing members on the list for a specific month
  2. Imports – Imported members on the list for a specific month
  3. Opt-in – Newly opted-in members on the list for a specific month
  4. List Count – List Count

Templates

  1. Email List Monthly Growth – View the cumulative number of email addresses imported, opt-in and existing in your list by day.

This data source contains statistics about your lists such as open rate, click rate and others.

Dimensions

  1. List Name – The name of the list

Measures

  1. Average Subscription Rate – The average number of subscriptions per month for the list
  2. Average Unsubscription Rate – The average number of unsubscriptions per month for the list
  3. Campaign Count – The number of campaigns in any status that use this list
  4. Cleaned Count – The number of members cleaned from the list
  5. Cleaned Count Since Send – The number of members cleaned from the list since the last campaign was sent
  6. Click Rate – The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list
  7. Member Count – The number of active members in the list
  8. Member Count Since Send – The number of active members in the list since the last campaign was sent
  9. Merge Var Count – The number of merge vars for this list
  10. Open Rate – The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list
  11. Target Subscription Rate – The target number of subscriptions per month for the list to keep it growing
  12. Unsubscribe Count – The number of members who have unsubscribed from the list
  13. Unsubscribe Count Since Send – The number of members who have unsubscribed since the last campaign was sent
  14. List Count – List Count

This data source contains information about your member activity such as members count by action.

Dimensions

  1. Campaign Name – The title and send time of the campaign
  2. List Name – The name of the list
  3. Email Address – Email address for a subscriber
  4. Action – One of the following actions: ‘open’, ‘click’, or ‘bounce’
  5. Action Type – The type of the action. If the action is a ‘bounce’, the type of bounce received: ‘hard’, ‘soft’
  6. Timestamp – Date recorded for the action

Measures

  1. Action Count – Action Count

This data source contains information about all of your members such as number of members by lists and interests.

Dimensions

  1. Email Address – Email address for a subscriber
  2. Email Type – Type of email this member asked to get (‘html’ or ‘text’)
  3. Member Status – Subscriber’s current status
  4. Unsubscribe Reason – A subscriber’s reason for unsubscribing
  5. Signup Date – The date the subscriber signed up for the list
  6. Member Rating – Star rating for this member, between 1 and 5
  7. Member VIP Status – VIP status for subscriber
  8. Opt-in Date – The date the subscribe confirmed their opt-in status
  9. Email Client – The list member’s email client
  10. Member Last Change – The date the member’s info was last changed
  11. Member Location – The name of the country for this member
  12. List Name – The name of the list
  13. List Created At – The date that this list was created
  14. List Rating – An auto-generated activity score for the list (0-5)
  15. List Visibility – Whether this list is public or private
  16. Interest Name – The name of the interest
  17. Interest Category Title – The text description of this category

Measures

  1. Member (Distinct сount)
  2. Number of Records

This data source contains information about list members who unsubscribed from a specific campaign.

Dimensions

  1. Campaign Name – The title and send time of the campaign
  2. Unsubscribe Reason – If available, the reason listed by the member for unsubscribing
  3. Timestamp – Date the member opted-out

Measures

  1. Unsubscribe Count – Unsubscribe Count

Templates

  1. Unsubscribe Reason Survey Report – View the number of unsubscribe for all your campaigns.

Creating charts

Click a dataset or integration and select Create dashboard/Create saved chart/Create presentation to start building a chart (please note that presentations are available starting from the Standard Plan).

From the next page, you can choose to create your own chart from scratch, or you can apply one of the templates we created.

  • If you choose to build a new chart from scratch (“Blank” option), the Chart designer will open. Go here to learn how to create a chart in the Chart designer.
  • If you choose a template, a new chart will be added to a dashboard/saved chart/presentation (depending on the way you start the chart creation).
Was this article helpful?
Dislike 0
Views: 216