Excel Add-In for MailChimp

Build 20.0.7695

テーブル

本製品 はMailChimp のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、MailChimp テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

CData Excel Add-In for MailChimp テーブル

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
ListMemberEvents Events information for a specific list.
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.
ListMemberTags Tags assigned to a certain member/members.
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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695