NinjaCat System ID: thinknear:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

API Name: address

NinjaCat System ID: thinknear:DIM_address

Data Type: text

API Name: advertiserID

NinjaCat System ID: thinknear:DIM_advertiserID

Data Type: text

Aggregates To: DIM_ADVERTISER_ID

API Name: advertiserName

NinjaCat System ID: thinknear:DIM_advertiserName

Data Type: text

NinjaCat System ID: thinknear:DIM_ATTRIBUTION_WINDOW_attributionWindow

Data Type: text

NinjaCat System ID: thinknear:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

API Name: city

NinjaCat System ID: thinknear:DIM_city

Data Type: text

Aggregates To: DIM_CITY

API Name: clientName

NinjaCat System ID: thinknear:DIM_clientName

Data Type: text

API Name: country_code

NinjaCat System ID: thinknear:DIM_country_code

Data Type: text

API Name: creativeName

NinjaCat System ID: thinknear:DIM_creativeName

Data Type: text

NinjaCat System ID: thinknear:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

NinjaCat System ID: thinknear:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

API Name: date

NinjaCat System ID: thinknear:DIM_date

Data Type: date

Aggregates To: DIM_DATE

NinjaCat System ID: thinknear:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

NinjaCat System ID: thinknear:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

API Name: dma_nielson

NinjaCat System ID: thinknear:DIM_dma_nielson

Data Type: text

API Name: endDate

NinjaCat System ID: thinknear:DIM_endDate

Data Type: date

Aggregates To: DIM_END_DATE

NinjaCat System ID: thinknear:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

API Name: IOID

NinjaCat System ID: thinknear:DIM_IOID

Data Type: text

API Name: IOName

NinjaCat System ID: thinknear:DIM_IOName

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

API Name: lineItemID

NinjaCat System ID: thinknear:DIM_LineItemID

Data Type: text

API Name: lineItemName

NinjaCat System ID: thinknear:DIM_LineItemName

Data Type: text

API Name: locationName

NinjaCat System ID: thinknear:DIM_locationName

Data Type: text

NinjaCat System ID: thinknear:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

NinjaCat System ID: thinknear:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

NinjaCat System ID: thinknear:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

NinjaCat System ID: thinknear:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

API Name: startDate

NinjaCat System ID: thinknear:DIM_startDate

Data Type: date

Aggregates To: DIM_START_DATE

API Name: state

NinjaCat System ID: thinknear:DIM_state

Data Type: text

Aggregates To: DIM_STATE

NinjaCat System ID: thinknear:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

NinjaCat System ID: thinknear:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

NinjaCat System ID: thinknear:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

API Name: zip_code

NinjaCat System ID: thinknear:DIM_zip_code

Data Type: text

API Name: call_conversions

NinjaCat System ID: thinknear:MET_call_conversions

Data Type: integer

API Name: clicks

NinjaCat System ID: thinknear:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

API Name: conversions

NinjaCat System ID: thinknear:MET_conversions

Data Type: integer

Aggregates To: MET_CONVERSIONS

NinjaCat System ID: thinknear:MET_conversion_rate

Data Type: decimal

Display As: percent

Aggregates To: MET_CONVERSION_RATE

Formula: thinknear:MET_conversions / thinknear:MET_ActionLeadingToConv

NinjaCat System ID: thinknear:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

NinjaCat System ID: thinknear:MET_cpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Formula: (1000 * thinknear:MET_spend / thinknear:MET_impressions)

NinjaCat System ID: thinknear:MET_ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: thinknear:MET_clicks / thinknear:MET_impressions

API Name: drive_conversions

NinjaCat System ID: thinknear:MET_drive_conversions

Data Type: integer

API Name: impressions

NinjaCat System ID: thinknear:MET_impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

API Name: other_conversions

NinjaCat System ID: thinknear:MET_other_conversions

Data Type: integer

NinjaCat System ID: thinknear:MET_pccr

Data Type: integer

Formula: thinknear:MET_conversions / thinknear:MET_clicks

API Name: scheduled_impressions

NinjaCat System ID: thinknear:MET_scheduled_impressions

Data Type: integer

API Name: spend

NinjaCat System ID: thinknear:MET_spend

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

API Name: under_100_meter_total

NinjaCat System ID: thinknear:MET_under_100_meter_total

Data Type: integer

API Name: under_100_meter_unique

NinjaCat System ID: thinknear:MET_under_100_meter_unique

Data Type: integer

API Name: under_200_meter_total

NinjaCat System ID: thinknear:MET_under_200_meter_total

Data Type: integer

API Name: under_200_meter_unique

NinjaCat System ID: thinknear:MET_under_200_meter_unique

Data Type: integer

API Name: under_33_meter_total

NinjaCat System ID: thinknear:MET_under_33_meter_total

Data Type: integer

API Name: under_33_meter_unique

NinjaCat System ID: thinknear:MET_under_33_meter_unique

Data Type: integer

API Name: under_50_meter_total

NinjaCat System ID: thinknear:MET_under_50_meter_total

Data Type: integer

API Name: under_50_meter_unique

NinjaCat System ID: thinknear:MET_under_50_meter_unique

Data Type: integer

API Name: url_conversions

NinjaCat System ID: thinknear:MET_url_conversions

Data Type: integer