NinjaCat System ID: worth_auto:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

NinjaCat System ID: worth_auto:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

API Name: Campaign ID

NinjaCat System ID: worth_auto:DIM_CampaignId

Data Type: text

Aggregates To: DIM_CAMPAIGN_ID

API Name: Campaign Title

NinjaCat System ID: worth_auto:DIM_CampaignTitle

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

NinjaCat System ID: worth_auto:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

NinjaCat System ID: worth_auto:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

API Name: Create Date

NinjaCat System ID: worth_auto:DIM_date

Data Type: date

Aggregates To: DIM_DATE

NinjaCat System ID: worth_auto:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

NinjaCat System ID: worth_auto:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

NinjaCat System ID: worth_auto:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

API Name: Launch Date

NinjaCat System ID: worth_auto:DIM_LaunchDate

Data Type: date

NinjaCat System ID: worth_auto:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

NinjaCat System ID: worth_auto:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

NinjaCat System ID: worth_auto:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

NinjaCat System ID: worth_auto:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

API Name: Subject

NinjaCat System ID: worth_auto:DIM_Subject

Data Type: text

NinjaCat System ID: worth_auto:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

API Name: URL

NinjaCat System ID: worth_auto:DIM_Url

Data Type: text

API Name: URLID

NinjaCat System ID: worth_auto:DIM_URLID

Data Type: text

API Name: Type

NinjaCat System ID: worth_auto:DIM_Type

Data Type: text

NinjaCat System ID: worth_auto:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

NinjaCat System ID: worth_auto:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

API Name: Total Clicks

NinjaCat System ID: worth_auto:MET_TotalClicks

Data Type: integer

Aggregates To: MET_CLICKS

NinjaCat System ID: worth_auto:MET_clicks_to_opens_rate

Data Type: decimal

Display As: percent

Formula: worth_auto:MET_TotalClicks / worth_auto:MET_TotalOpens

NinjaCat System ID: worth_auto:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

NinjaCat System ID: worth_auto:MET_ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: worth_auto:MET_TotalClicks / worth_auto:MET_TotalEmails

API Name: Desktop Clicks

NinjaCat System ID: worth_auto:MET_DesktopClicks

Data Type: integer

API Name: Mobile Clicks

NinjaCat System ID: worth_auto:MET_MobileClicks

Data Type: integer

NinjaCat System ID: worth_auto:MET_OpensRate

Data Type: decimal

Display As: percent

Formula: worth_auto:MET_TotalOpens / worth_auto:MET_TotalEmails

API Name: Total Emails

NinjaCat System ID: worth_auto:MET_TotalEmails

Data Type: integer

API Name: Total Opens

NinjaCat System ID: worth_auto:MET_TotalOpens

Data Type: integer

Aggregates To: MET_OPENS

API Name: Unique Clicks

NinjaCat System ID: worth_auto:MET_UniqueClicks

Data Type: integer

Aggregates To: MET_UNIQUE_CLICKS

NinjaCat System ID: worth_auto:MET_unique_clicks_to_opens_rate

Data Type: decimal

Display As: percent

Formula: worth_auto:MET_UniqueClicks / worth_auto:MET_TotalOpens

NinjaCat System ID: worth_auto:MET_unique_ctr

Data Type: decimal

Display As: percent

Formula: worth_auto:MET_UniqueClicks / worth_auto:MET_TotalEmails

API Name: Unique Opens

NinjaCat System ID: worth_auto:MET_UniqueOpens

Data Type: integer

Aggregates To: MET_UNIQUE_OPENS

NinjaCat System ID: worth_auto:MET_UniqueOpensRate

Data Type: decimal

Display As: percent

Formula: worth_auto:MET_UniqueOpens / worth_auto:MET_TotalEmails