NinjaCat System ID: act_on:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

API Name: Campaign

NinjaCat System ID: act_on:DIM_Campaign

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

API Name: description

NinjaCat System ID: act_on:DIM_description

Data Type: text

NinjaCat System ID: act_on:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

API Name: campaign_id

NinjaCat System ID: act_on:DIM_campaign_id

Data Type: text

Aggregates To: DIM_CAMPAIGN_ID

NinjaCat System ID: act_on:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

NinjaCat System ID: act_on:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

API Name: Date

NinjaCat System ID: act_on:DIM_Date

Data Type: date

Aggregates To: DIM_DATE

NinjaCat System ID: act_on:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

NinjaCat System ID: act_on:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

NinjaCat System ID: act_on:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

API Name: form_source

NinjaCat System ID: act_on:DIM_form_source

Data Type: text

API Name: message_id

NinjaCat System ID: act_on:DIM_message_id

Data Type: text

API Name: subject

NinjaCat System ID: act_on:DIM_subject

Data Type: text

NinjaCat System ID: act_on:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

NinjaCat System ID: act_on:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

API Name: page_id

NinjaCat System ID: act_on:DIM_page_id

Data Type: text

API Name: page_outgoing_clicks_source

NinjaCat System ID: act_on:DIM_page_outgoing_clicks_source

Data Type: text

API Name: page_title

NinjaCat System ID: act_on:DIM_page_title

Data Type: text

API Name: page_incoming_traffic

NinjaCat System ID: act_on:DIM_page_incoming_traffic

Data Type: text

NinjaCat System ID: act_on:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

NinjaCat System ID: act_on:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

API Name: sender_email

NinjaCat System ID: act_on:DIM_sender_email

Data Type: text

API Name: sender_id

NinjaCat System ID: act_on:DIM_sender_id

Data Type: text

API Name: sender_name

NinjaCat System ID: act_on:DIM_sender_name

Data Type: text

NinjaCat System ID: act_on:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

API Name: title

NinjaCat System ID: act_on:DIM_title

Data Type: text

NinjaCat System ID: act_on:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

NinjaCat System ID: act_on:DIM_YEAR

Data Type: text

Aggregates To: DIM_YEAR

API Name: clicked

NinjaCat System ID: act_on:MET_clicked

Data Type: integer

Aggregates To: MET_CLICKS

NinjaCat System ID: act_on:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

NinjaCat System ID: act_on:MET_Ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: (act_on:MET_clicked / act_on:MET_opened)

API Name: bounced

NinjaCat System ID: act_on:MET_bounced

Data Type: integer

API Name: opened

NinjaCat System ID: act_on:MET_opened

Data Type: integer

API Name: delivered

NinjaCat System ID: act_on:MET_delivered

Data Type: integer

API Name: sent

NinjaCat System ID: act_on:MET_sent

Data Type: integer

NinjaCat System ID: act_on:MET_form_submit_rate

Data Type: decimal

Display As: percent

Formula: (act_on:MET_form_submits / act_on:MET_form_impressions)

API Name: submits

NinjaCat System ID: act_on:MET_form_submits

Data Type: integer

API Name: form_impressions

NinjaCat System ID: act_on:MET_form_impressions

Data Type: integer

API Name: form_non_submitters

NinjaCat System ID: act_on:MET_form_non_submitters

Data Type: integer

API Name: form_unique_views

NinjaCat System ID: act_on:MET_form_unique_views

Data Type: integer

Is Unique: True

API Name: hardBounced

NinjaCat System ID: act_on:MET_hardBounced

Data Type: integer

API Name: media_total

NinjaCat System ID: act_on:MET_media_total

Data Type: integer

API Name: unique_views

NinjaCat System ID: act_on:MET_unique_views

Data Type: integer

Is Unique: True

NinjaCat System ID: act_on:MET_OpenRate

Data Type: decimal

Display As: percent

Formula: (act_on:MET_sent / act_on:MET_opened)

API Name: optedOut

NinjaCat System ID: act_on:MET_optedOut

Data Type: integer

API Name: page_outgoing_clicks_from_source

NinjaCat System ID: act_on:MET_page_outgoing_clicks_from_source

Data Type: integer

API Name: page_total_visits

NinjaCat System ID: act_on:MET_page_total_visits

Data Type: integer

API Name: page_total_clicks

NinjaCat System ID: act_on:MET_page_total_clicks

Data Type: integer

NinjaCat System ID: act_on:MET_page_unique_clicks

Data Type: integer

Formula: (act_on:MET_page_unique_known_clicks + act_on:MET_page_unique_unknown_clicks)

API Name: page_unique_known_clicks

NinjaCat System ID: act_on:MET_page_unique_known_clicks

Data Type: integer

API Name: page_unique_known_visits

NinjaCat System ID: act_on:MET_page_unique_known_visits

Data Type: integer

API Name: page_unique_unknown_clicks

NinjaCat System ID: act_on:MET_page_unique_unknown_clicks

Data Type: integer

API Name: page_unique_unknown_visits

NinjaCat System ID: act_on:MET_page_unique_unknown_visits

Data Type: integer

NinjaCat System ID: act_on:MET_page_unique_visits

Data Type: integer

Formula: (act_on:MET_page_unique_known_visits + act_on:MET_page_unique_unknown_visits)

API Name: page_visits_from_source

NinjaCat System ID: act_on:MET_page_visits_from_source

Data Type: integer

API Name: softBounced

NinjaCat System ID: act_on:MET_softBounced

Data Type: integer

API Name: spam

NinjaCat System ID: act_on:MET_spam

Data Type: integer