Dimensions (20)

Account

NinjaCat System ID: mailchimp:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

campaign

API Name: campaign_title

NinjaCat System ID: mailchimp:DIM_campaign

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Campaign Group

NinjaCat System ID: mailchimp:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign Type

API Name: type

NinjaCat System ID: mailchimp:DIM_campaignType

Data Type: text

Display As: title_case

Aggregates To: DIM_CAMPAIGN_TYPE

Currency

NinjaCat System ID: mailchimp:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: mailchimp:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date Sent

API Name: send_time

NinjaCat System ID: mailchimp:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: mailchimp:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: mailchimp:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: mailchimp:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Industry Type

API Name: industry_stats.type

NinjaCat System ID: mailchimp:DIM_industryType

Data Type: text

Last Click Date

API Name: clicks.last_click

NinjaCat System ID: mailchimp:DIM_lastClickDate

Data Type: datetime

Display As: date_time

Last Open Date

API Name: opens.last_open

NinjaCat System ID: mailchimp:DIM_lastOpenDate

Data Type: datetime

Display As: date_time

Month Of Year

NinjaCat System ID: mailchimp:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: mailchimp:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Quarter

NinjaCat System ID: mailchimp:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: mailchimp:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: mailchimp:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Week Of Year

NinjaCat System ID: mailchimp:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: mailchimp:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (32)

Abuse Reports

API Name: abuse_reports

NinjaCat System ID: mailchimp:MET_abuseReports

Data Type: integer

Avg. List Click Rate per Campaign

API Name: list_stats.click_rate

NinjaCat System ID: mailchimp:MET_listClickRate

Data Type: integer

Avg. List Open Rate per Campaign

API Name: list_stats.open_rate

NinjaCat System ID: mailchimp:MET_listOpenRate

Data Type: integer

Avg. List Subscription Rate per Month

API Name: list_stats.sub_rate

NinjaCat System ID: mailchimp:MET_listSubscriptionRate

Data Type: integer

Avg. List Unsubscription Rate per Month

API Name: list_stats.unsub_rate

NinjaCat System ID: mailchimp:MET_listUnsubscriptionRate

Data Type: integer

Bounce Syntax Errors

API Name: bounses.syntax_errors

NinjaCat System ID: mailchimp:MET_bounceSyntaxErrors

Data Type: integer

Click Rate

NinjaCat System ID: mailchimp:MET_clickRate

Data Type: decimal

Display As: percent

Formula: (mailchimp:MET_uniqueClicks / (mailchimp:MET_emailsSent - mailchimp:MET_softBounces - mailchimp:MET_hardBounces))

Clicks

API Name: clicks.clicks_total

NinjaCat System ID: mailchimp:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

Count (Unique Dimensions)

NinjaCat System ID: mailchimp:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

Ecommerce Total Orders

API Name: ecommerce.total_orders

NinjaCat System ID: mailchimp:MET_ecommerceTotalOrders

Data Type: integer

Ecommerce Total Revenue

API Name: ecommerce.total_revenue

NinjaCat System ID: mailchimp:MET_ecommerceTotalRevenue

Data Type: decimal

Display As: currency

Ecommerce Total Spent

API Name: ecommerce.total_spent

NinjaCat System ID: mailchimp:MET_ecommerceTotalSpent

Data Type: decimal

Display As: currency

Emails Sent

API Name: emails_sent

NinjaCat System ID: mailchimp:MET_emailsSent

Data Type: integer

Aggregates To: MET_SENT

Facebook Likes

API Name: facebook_likes.facebook_likes

NinjaCat System ID: mailchimp:MET_facebookLikes

Data Type: integer

Facebook Recipient Likes

API Name: facebook_likes.recipient_likes

NinjaCat System ID: mailchimp:MET_facebookRecipientLikes

Data Type: integer

Facebook Unique Likes

API Name: facebook_likes.unique_likes

NinjaCat System ID: mailchimp:MET_facebookUniqueLikes

Data Type: integer

Is Unique: True

Forwards Count

API Name: forwards.forwards_count

NinjaCat System ID: mailchimp:MET_forwardsCount

Data Type: integer

Forwards Opens

API Name: forwards.forwards_opens

NinjaCat System ID: mailchimp:MET_forwardsOpens

Data Type: integer

Hard Bounces

API Name: bounces.hard_bounces

NinjaCat System ID: mailchimp:MET_hardBounces

Data Type: integer

Industry Abuse Rate

API Name: industry_stats.abuse_rate

NinjaCat System ID: mailchimp:MET_industryAbuseRate

Data Type: decimal

Display As: percent

Industry Bounce Rate

API Name: industry_stats.bounce_rate

NinjaCat System ID: mailchimp:MET_industryBounceRate

Data Type: decimal

Display As: percent

Industry Click Rate

API Name: industry_stats.click_rate

NinjaCat System ID: mailchimp:MET_industryClickRate

Data Type: decimal

Display As: percent

Industry Open Rate

API Name: industry_stats.open_rate

NinjaCat System ID: mailchimp:MET_industryOpenRate

Data Type: decimal

Display As: percent

Industry Unopen Rate

API Name: industry_stats.unopen_rate

NinjaCat System ID: mailchimp:MET_industryUnopenRate

Data Type: decimal

Display As: percent

Industry UnsubscribeRate

API Name: industry_stats.unsub_rate

NinjaCat System ID: mailchimp:MET_industryUnsubscribeRate

Data Type: decimal

Display As: percent

Open Rate

NinjaCat System ID: mailchimp:MET_openRate

Data Type: decimal

Display As: percent

Formula: (mailchimp:MET_uniqueOpens / (mailchimp:MET_emailsSent - mailchimp:MET_softBounces - mailchimp:MET_hardBounces))

Opens

API Name: opens.opens_total

NinjaCat System ID: mailchimp:MET_opens

Data Type: integer

Aggregates To: MET_OPENS

Soft Bounces

API Name: bounces.soft_bounces

NinjaCat System ID: mailchimp:MET_softBounces

Data Type: integer

Unique Clicks

API Name: clicks.unique_clicks

NinjaCat System ID: mailchimp:MET_uniqueClicks

Data Type: integer

Is Unique: True

Aggregates To: MET_UNIQUE_CLICKS

Unique Opens

API Name: opens.unique_opens

NinjaCat System ID: mailchimp:MET_uniqueOpens

Data Type: integer

Is Unique: True

Aggregates To: MET_UNIQUE_OPENS

Unique Subscriber Clicks

API Name: clicks.unique_subscriber_clicks

NinjaCat System ID: mailchimp:MET_uniqueSubscriberClicks

Data Type: integer

Is Unique: True

Unsubscribed

API Name: unsubscribed

NinjaCat System ID: mailchimp:MET_unsubscribed

Data Type: integer

Aggregates To: MET_UNSUBSCRIBED