Choozle Fields

Suggest Edits

Dimensions (18)

Account

NinjaCat System ID: choozle:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Ad Group ID

API Name: ad_group_id

NinjaCat System ID: choozle:DIM_ad_group_id

Data Type: text

Ad Group Name

API Name: ad_group_name

NinjaCat System ID: choozle:DIM_ad_group_name

Data Type: text

Aggregates To: DIM_AD_GROUP_NAME

Campaign ID

API Name: campaign_id

NinjaCat System ID: choozle:DIM_campaign_id

Data Type: text

Aggregates To: DIM_CAMPAIGN_ID

Campaign Name

API Name: campaign_name

NinjaCat System ID: choozle:DIM_campaign_name

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Currency

NinjaCat System ID: choozle:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: choozle:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: date

NinjaCat System ID: choozle:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: choozle:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: choozle:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: choozle:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Month Of Year

NinjaCat System ID: choozle:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: choozle:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Quarter

NinjaCat System ID: choozle:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: choozle:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: choozle:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Week Of Year

NinjaCat System ID: choozle:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: choozle:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (12)

Clicks

API Name: clicks

NinjaCat System ID: choozle:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

Conversions

API Name: conversions

NinjaCat System ID: choozle:MET_conversions

Data Type: integer

Aggregates To: MET_CONVERSIONS

Conv. Rate

NinjaCat System ID: choozle:MET_conversion_rate

Data Type: decimal

Display As: percent

Aggregates To: MET_CONVERSION_RATE

Formula: choozle:MET_conversions / choozle:MET_ActionLeadingToConv

Cost

API Name: advertiser_cost

NinjaCat System ID: choozle:MET_advertiser_cost

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

Cost / Conv.

NinjaCat System ID: choozle:MET_cpa

Data Type: decimal

Display As: currency

Aggregates To: MET_CPA

Formula: choozle:MET_advertiser_cost / choozle:MET_conversions

Count (Unique Dimensions)

NinjaCat System ID: choozle:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

CPC

NinjaCat System ID: choozle:MET_cpc

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: choozle:MET_advertiser_cost / choozle:MET_clicks

CPM

NinjaCat System ID: choozle:MET_cpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Formula: 1000 * choozle:MET_advertiser_cost / choozle:MET_impressions_won

CTR

NinjaCat System ID: choozle:MET_ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: choozle:MET_clicks / choozle:MET_impressions_won

Impressions Bid On

API Name: impressions_bid_on

NinjaCat System ID: choozle:MET_impressions_bid_on

Data Type: integer

Impressions Won

API Name: impressions_won

NinjaCat System ID: choozle:MET_impressions_won

Data Type: integer

Aggregates To: MET_IMPRESSIONS

Win

API Name: win

NinjaCat System ID: choozle:MET_win

Data Type: decimal

Display As: float

Updated 6 months ago