NinjaCat System ID: perfect_audience:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

API Name: ad_click_url

NinjaCat System ID: perfect_audience:DIM_ad_click_url

Data Type: text

API Name: ad_dimensions

NinjaCat System ID: perfect_audience:DIM_ad_dimensions

Data Type: text

API Name: ad_facebook_body

NinjaCat System ID: perfect_audience:DIM_ad_facebook_body

Data Type: text

API Name: ad_facebook_title

NinjaCat System ID: perfect_audience:DIM_ad_facebook_title

Data Type: text

API Name: ad_id

NinjaCat System ID: perfect_audience:DIM_ad_id

Data Type: text

Aggregates To: DIM_AD_ID

API Name: ad_name

NinjaCat System ID: perfect_audience:DIM_ad_name

Data Type: text

Aggregates To: DIM_AD_NAME

API Name: ad_nid

NinjaCat System ID: perfect_audience:DIM_ad_nid

Data Type: text

API Name: ad_state

NinjaCat System ID: perfect_audience:DIM_ad_state

Data Type: text

API Name: ad_type

NinjaCat System ID: perfect_audience:DIM_ad_type

Data Type: text

NinjaCat System ID: perfect_audience:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

API Name: campaign_id

NinjaCat System ID: perfect_audience:DIM_campaign_id

Data Type: text

Aggregates To: DIM_CAMPAIGN_ID

API Name: campaign_name

NinjaCat System ID: perfect_audience:DIM_campaign_name

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

API Name: campaign_nid

NinjaCat System ID: perfect_audience:DIM_campaign_nid

Data Type: text

API Name: campaign_state

NinjaCat System ID: perfect_audience:DIM_campaign_state

Data Type: text

API Name: campaign_type

NinjaCat System ID: perfect_audience:DIM_campaign_type

Data Type: text

API Name: conversion_id

NinjaCat System ID: perfect_audience:DIM_conversion_id

Data Type: text

API Name: conversion_name

NinjaCat System ID: perfect_audience:DIM_conversion_name

Data Type: text

API Name: conversion_nid

NinjaCat System ID: perfect_audience:DIM_conversion_nid

Data Type: text

NinjaCat System ID: perfect_audience:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

NinjaCat System ID: perfect_audience:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

API Name: date

NinjaCat System ID: perfect_audience:DIM_date

Data Type: date

Aggregates To: DIM_DATE

NinjaCat System ID: perfect_audience:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

NinjaCat System ID: perfect_audience:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

NinjaCat System ID: perfect_audience:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

NinjaCat System ID: perfect_audience:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

NinjaCat System ID: perfect_audience:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

NinjaCat System ID: perfect_audience:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

NinjaCat System ID: perfect_audience:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

NinjaCat System ID: perfect_audience:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

NinjaCat System ID: perfect_audience:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

NinjaCat System ID: perfect_audience:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

API Name: adjusted_conversion_revenue

NinjaCat System ID: perfect_audience:MET_adjusted_conversion_revenue

Data Type: decimal

Display As: currency

API Name: adjusted_post_click_revenue

NinjaCat System ID: perfect_audience:MET_adjusted_post_click_revenue

Data Type: decimal

Display As: currency

API Name: adjusted_post_view_revenue

NinjaCat System ID: perfect_audience:MET_adjusted_post_view_revenue

Data Type: decimal

Display As: currency

API Name: click_conversions

NinjaCat System ID: perfect_audience:MET_conversions

Data Type: integer

Aggregates To: MET_CLICK_CONVERSIONS

API Name: clicks

NinjaCat System ID: perfect_audience:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

NinjaCat System ID: perfect_audience:MET_conversion_rate

Data Type: decimal

Display As: percent

Aggregates To: MET_CONVERSION_RATE

Formula: perfect_audience:MET_conversions / perfect_audience:MET_ActionLeadingToConv

API Name: costs

NinjaCat System ID: perfect_audience:MET_costs

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

NinjaCat System ID: perfect_audience:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

NinjaCat System ID: perfect_audience:MET_cpc

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: perfect_audience:MET_costs / perfect_audience:MET_clicks

NinjaCat System ID: perfect_audience:MET_cpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Formula: perfect_audience:MET_costs / perfect_audience:MET_impressions

NinjaCat System ID: perfect_audience:MET_ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: perfect_audience:MET_clicks / perfect_audience:MET_impressions

API Name: impressions

NinjaCat System ID: perfect_audience:MET_impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

API Name: post_click_revenue

NinjaCat System ID: perfect_audience:MET_post_click_revenue

Data Type: decimal

Display As: currency

Aggregates To: MET_POST_CLICK_REVENUE

API Name: post_view_revenue

NinjaCat System ID: perfect_audience:MET_post_view_revenue

Data Type: decimal

Display As: currency

Aggregates To: MET_POST_VIEW_REVENUE

API Name: revenue

NinjaCat System ID: perfect_audience:MET_revenue

Data Type: decimal

Display As: currency

Aggregates To: MET_REVENUE

API Name: view_conversions

NinjaCat System ID: perfect_audience:MET_view_conversions

Data Type: integer

Aggregates To: MET_VIEW_CONVERSIONS