MailChimp

Introduction

MailChimp is a marketing automation platform that helps you share email and ad campaigns with clients, customers, and other interested parties. Our approach to marketing focuses on healthy list management practices, beautifully designed campaigns, and powerful data analysis. https://www.datanyze.com/market-share/email-marketing

IMAGE

Connection String

You can set the APIKey to the key you generate in your account settings.

IMAGE

Connection String Parameters

Parameter Description
APIKey The API key used for accessing your MailChimp account.

Connecting to Mailchimp

  1. Login To https://login.mailchimp.com

    IMAGE

  2. Click your profile name to expand the Account Panel, and choose Account.

    IMAGE

  3. Click the Extras drop-down menu and choose API keys.

    IMAGE

  4. Copy an existing API key or click the Create a Key button.

    IMAGE

  5. Name your key descriptively, so you know what application uses that key.

    IMAGE

  6. Copy the API Key.

    Reference to create API key: http://kb.mailchimp.com/integrations/api-integrations/about-api-keys .

Data Migrations

To Check for the data migrations:

  1. Add a new connection in data governor as shown.

    • Go to tasks and click on Connections.

    IMAGE

    • Add a new connection Using Add New Connection Option.

    IMAGE

    • Choose MailChimp Connector from the available Connector Options.

    IMAGE

  2. Using the connection string parameters created, Verify the connection using the VERIFY CONNECTION Option in Data Governor. Once the Connection is verified, Insert the Connection Using Insert Option.

    IMAGE

    IMAGE

  3. Create a Job Using ADD A JOB option in data governor name the job, Set the Logging Mode and Save the job.

    IMAGE

  4. Create a New Task by right clicking job list and then Add a New Task Option. If you want to edit an Existing Task Use Edit Task.

    IMAGE

  5. Choose a Data Migration Task.

    IMAGE

  6. Choose the source and the destination for the migration of data. Name the Task.

    IMAGE

  7. Choose the Tables or the data that need to be migrated from the source to the destination. You can Copy all Tables by checking Copy all tables box. Save The Task.

    IMAGE

  8. Execute the Job. Check for results and the details of the data migrated in Execution History.

    IMAGE

Data Model

The Data Model has three parts: Tables, Views, and Stored Procedures. API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

IMAGE![](./MailChimp_image19.png)

Tables

The Connector for MailChimp models the MailChimp API in Tables so that it can be easily queried and updated. The provider dynamically retrieves custom fields for the ListMembers tables when you connect; any changes you make to these custom fields, such as adding a new field or changing a custom field’s data type, are reflected when you reconnect.

Name Description
AuthorizedApps A list of applications authorized to access the account.
AutomationEmailQueues A summary of the queue for an email in an automation workflow.
AutomationsRemovedSubscribers A summary of the subscribers removed from an automation workflow.
CampaignFeedback A summary of the comment feedback for a specific campaign.
CampaignFolders Folders for organizing campaigns
Campaigns A summary of the campaigns within an account.
ConversationMessages Messages from a specific conversation. Conversation tracking is a feature available to paid accounts that lets you view replies to your campaigns from inside your MailChimp account.
EcommerceCartLines A list of an ecommerce cart’s lines.
EcommerceCarts A list of an account’s ecommerce carts.
EcommerceCustomers A list of an account’s ecommerce customers.
EcommerceOrderLines A list of an ecommerce order’s lines.
EcommerceOrders A list of an account’s ecommerce orders.
EcommerceProducts A list of an account’s ecommerce products.
EcommerceProductVariants A list of an ecommerce product’s variants.
EcommerceStores A list of an account’s ecommerce stores.
FileManagerFiles A listing of all avaialable images and files within an account’s gallery.
FileManagerFolders A listing of all avaialable folders within an account’s gallery.
ListInterestCategories A listing of this list’s interest categories.
ListInterests A list of this category’s interests
ListMemberNotes The last 10 notes for a specific list member, based on date created.
ListMembers Individuals who are currently or have been previously suscribed to this list, including members who have bounced or unsubscribed.
ListMergeFields The merge field (formerly merge vars) for a given list. These correspond to merge fields in MailChimp’s lists and subscriber profiles.
Lists A collection of subscriber lists associated with this account. Lists contain subscribers who have opted-in to receive correspondence from you or your organization.
ListSegmentMembers Individuals who are currently or have been previously suscribed to this list, including members who have bounced or unsubscribed.
ListSegments A list of available segments.
ListsTwitterLeadGenCards Twitter Lead Generation Cards for given List
ListsWebhooks Webhooks configured for the given list.
TemplateFolders Folders for organizing templates
Templates A list an account’s available templates.

Views

Views are tables that cannot be modified. Typically, data that are read-only and cannot be updated are shown as views.

Name Description
AutomationEmails A summary of the emails in an automation workflow.
Automations A summary of the automations within an account.
Conversations A collection of this account’s tracked conversations. Conversation tracking is a feature available to paid accounts that lets you view replies to your campaigns from inside your MailChimp account.
ListAbuse A collection of abuse complaints for a specific list. An abuse complaint occurs when your recipient clicks to ‘report spam’ in their email program.
ListActivity Up to the previous 180 days of daily detailed aggregated activity stats for a given list. Does not include AutoResponder or Automation activity.
ListClients Top email clients used, as measured by their user-agent string
ListGrowthHistory A month-by-month summary of a specific list’s growth activity.
ListMemberActivity The last 50 member events for a list.
ListSignupForms Collection of List Signup Forms
ReportAbuse A list of abuse complaints for a specific list.
ReportAdvice A list of feedback based on a campaign’s statistics.
ReportClickDetails A list of URLs and unique IDs included in HTML and plain-text versions of a campaign.
ReportClickDetailsMembers A collection of members who clicked on a specific link within a campaign.
ReportDomainPerformance Statistics for the top-performing email domains in a campaign.
ReportEmailActivity A list of member’s subscriber activity in a specific campaign.
ReportLocations Top open locations for a specific campaign.
Reports A list of reports containing campaigns marked as Sent.
ReportSentTo A list of subscribers who were sent a specific campaign.
ReportUnsubscribes A list of members who have unsubscribed from a specific campaign.