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
You can set the APIKey to the key you generate in your account settings.
IMAGE
Parameter | Description |
---|---|
APIKey | The API key used for accessing your MailChimp account. |
Login To https://login.mailchimp.com
IMAGE
Click your profile name to expand the Account Panel, and choose Account.
IMAGE
Click the Extras drop-down menu and choose API keys.
IMAGE
Copy an existing API key or click the Create a Key button.
IMAGE
Name your key descriptively, so you know what application uses that key.
IMAGE
Copy the API Key.
Reference to create API key: http://kb.mailchimp.com/integrations/api-integrations/about-api-keys .
To Check for the data migrations:
Add a new connection in Loome Integrate as shown.
IMAGE
IMAGE
IMAGE
Using the connection string parameters created, Verify the connection using the VERIFY CONNECTION Option in Loome Integrate. Once the Connection is verified, Insert the Connection Using Insert Option.
IMAGE
IMAGE
Create a Job Using ADD A JOB option in Loome Integrate name the job, Set the Logging Mode and Save the job.
IMAGE
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
Choose a Data Migration Task.
IMAGE
Choose the source and the destination for the migration of data. Name the Task.
IMAGE
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
Execute the Job. Check for results and the details of the data migrated in Execution History.
IMAGE
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)
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 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. |