ODBC Driver for MailChimp

Build 20.0.7654

ReportDomainPerformance

Statistics for the top-performing email domains in a campaign.

テーブル固有の情報

ReportDomainPerformance では、SELECT がサポートされています。

Select

このテーブルからデータを取得するにはCampaignId を指定する必要があります。WHERE 句に何も指定されていない場合は、アカウントで使える最初のものが使用されます。

Columns

Name Type Description
CampaignId [KEY] String The CampaignId for the table.
Domain String The name of the domain (gmail.com, hotmail.com, yahoo.com).
EmailsSent Integer The number of emails sent to that specific domain.
Bounces Integer The number of bounces at a domain.
Opens Integer The number of opens for a domain.
Clicks Integer The number of clicks for a domain.
Unsubs Integer The total number of unsubscribes for a domain.
Delivered Integer The number of successful deliveries for a domain.
EmailsPct Double The percentage of total emails that went to this domain.
BouncesPct Double The percentage of total bounces that came from this domain.
OpensPct Double The percentage of total opens that came from this domain.
ClicksPct Double The percentage of total clicks tht came from this domain.
UnsubsPct Double The percentage of total unsubscribes taht came from this domain.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654