NinjaCat System ID: adroll:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

API Name: Ad

NinjaCat System ID: adroll:DIM_Ad

Data Type: text

Aggregates To: DIM_AD_NAME,DIM_AD

API Name: Campaign

NinjaCat System ID: adroll:DIM_Campaign

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

NinjaCat System ID: adroll:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

NinjaCat System ID: adroll:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

NinjaCat System ID: adroll:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

API Name: Date

NinjaCat System ID: adroll:DIM_Date

Data Type: date

Aggregates To: DIM_DATE

NinjaCat System ID: adroll:DIM_DAY_OF_WEEK

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

NinjaCat System ID: adroll:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

NinjaCat System ID: adroll:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

NinjaCat System ID: adroll:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

NinjaCat System ID: adroll:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

NinjaCat System ID: adroll:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

NinjaCat System ID: adroll:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

NinjaCat System ID: adroll:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

NinjaCat System ID: adroll:DIM_YEAR

Data Type: text

Aggregates To: DIM_YEAR

API Name: assist_revenue

NinjaCat System ID: adroll:MET_assist_revenue

Data Type: decimal

Display As: currency

API Name: assists

NinjaCat System ID: adroll:MET_assists

Data Type: integer

API Name: click_revenue

NinjaCat System ID: adroll:MET_click_revenue

Data Type: decimal

Display As: currency

API Name: clicks

NinjaCat System ID: adroll:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

API Name: click_throughs

NinjaCat System ID: adroll:MET_click_throughs

Data Type: integer

NinjaCat System ID: adroll:MET_Conversions

Data Type: integer

Aggregates To: MET_CONVERSIONS

Formula: (adroll:MET_click_throughs + adroll:MET_view_throughs)

API Name: cost

NinjaCat System ID: adroll:MET_cost

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

NinjaCat System ID: adroll:MET_AverageCPA

Data Type: decimal

Display As: currency

Aggregates To: MET_CPA

Formula: (adroll:MET_cost / (adroll:MET_click_throughs + adroll:MET_view_throughs))

NinjaCat System ID: adroll:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

NinjaCat System ID: adroll:MET_AverageCpc

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: (adroll:MET_cost / adroll:MET_clicks)

NinjaCat System ID: adroll:MET_AverageCpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Formula: (1000 * adroll:MET_cost / adroll:MET_impressions)

NinjaCat System ID: adroll:MET_Ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: (adroll:MET_clicks / adroll:MET_impressions)

API Name: impressions

NinjaCat System ID: adroll:MET_impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

API Name: view_revenue

NinjaCat System ID: adroll:MET_view_revenue

Data Type: decimal

Display As: currency

API Name: view_throughs

NinjaCat System ID: adroll:MET_view_throughs

Data Type: integer