Brightroll Fields

Suggest Edits

Dimensions (46)

Account

NinjaCat System ID: brightroll:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

API Name: Ad

NinjaCat System ID: brightroll:DIM_adName

Data Type: text

Aggregates To: DIM_AD_NAME,DIM_AD

Ad Position

API Name: Ad Position

NinjaCat System ID: brightroll:DIM_adPosition

Data Type: text

Ad Size

API Name: Layout

NinjaCat System ID: brightroll:DIM_adSize

Data Type: text

Advertiser Category

API Name: Advertiser Category

NinjaCat System ID: brightroll:DIM_advertiserCategoryName

Data Type: text

Advertiser Group

API Name: Advertiser Group

NinjaCat System ID: brightroll:DIM_advertiserGroup

Data Type: text

Advertiser Name

API Name: Advertiser

NinjaCat System ID: brightroll:DIM_advertiserName

Data Type: text

Advertiser Sub Category

API Name: Advertiser Sub-Category

NinjaCat System ID: brightroll:DIM_advertiserSubCategory

Data Type: text

Age

API Name: Age

NinjaCat System ID: brightroll:DIM_age

Data Type: text

Browser Type

API Name: Browser Type

NinjaCat System ID: brightroll:DIM_browserType

Data Type: text

Campaign

API Name: Order

NinjaCat System ID: brightroll:DIM_campaignName

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Campaign Group

NinjaCat System ID: brightroll:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

City

API Name: City

NinjaCat System ID: brightroll:DIM_city

Data Type: text

Aggregates To: DIM_CITY

Country

API Name: Country

NinjaCat System ID: brightroll:DIM_country

Data Type: text

Display As: country

Aggregates To: DIM_COUNTRIES,DIM_COUNTRY

Creative

API Name: Creative

NinjaCat System ID: brightroll:DIM_creativeName

Data Type: text

Currency

NinjaCat System ID: brightroll:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: brightroll:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

date

API Name: Day

NinjaCat System ID: brightroll:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: brightroll:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: brightroll:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

Designated Marteging Area (DMA)

API Name: Market Area

NinjaCat System ID: brightroll:DIM_dma

Data Type: text

Desktop OS

API Name: Os

NinjaCat System ID: brightroll:DIM_desktopOs

Data Type: text

Device Type

API Name: Device Type

NinjaCat System ID: brightroll:DIM_deviceType

Data Type: text

Aggregates To: DIM_DEVICE_TYPE

Domain Name

API Name: Domain

NinjaCat System ID: brightroll:DIM_domainName

Data Type: text

Exchange Deal Name

API Name: Exchange Deal Id

NinjaCat System ID: brightroll:DIM_exchangeDealName

Data Type: text

Exchange/Publisher Name

API Name: Publisher

NinjaCat System ID: brightroll:DIM_publisherName

Data Type: text

External Id

NinjaCat System ID: brightroll:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Gender

API Name: Gender

NinjaCat System ID: brightroll:DIM_gender

Data Type: text

Aggregates To: DIM_GENDER

Inventory Type

API Name: Inventory Type

NinjaCat System ID: brightroll:DIM_inventoryType

Data Type: text

Line Billing Method

API Name: Line Billing Method

NinjaCat System ID: brightroll:DIM_lineBillingMethod

Data Type: text

Line Goal Type

API Name: Goal Type

NinjaCat System ID: brightroll:DIM_lineGoalType

Data Type: text

Line Name

API Name: Line

NinjaCat System ID: brightroll:DIM_lineName

Data Type: text

Media Type

API Name: Media Type

NinjaCat System ID: brightroll:DIM_mediaType

Data Type: text

Mobile OS

API Name: Device Category

NinjaCat System ID: brightroll:DIM_mobileOs

Data Type: text

Month Of Year

NinjaCat System ID: brightroll:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: brightroll:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Pixel

API Name: Pixel

NinjaCat System ID: brightroll:DIM_pixelName

Data Type: text

Pixel Id

API Name: Pixel Id

NinjaCat System ID: brightroll:DIM_pixelId

Data Type: text

Pixel Parameter

API Name: Pixel Query String

NinjaCat System ID: brightroll:DIM_pixelParameter

Data Type: text

Row

NinjaCat System ID: brightroll:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

State

API Name: Region

NinjaCat System ID: brightroll:DIM_state

Data Type: text

Aggregates To: DIM_STATE

Subdomain

API Name: Subdomain

NinjaCat System ID: brightroll:DIM_subdomain

Data Type: text

System Account ID

NinjaCat System ID: brightroll:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Targeted Audience Name

API Name: Target Segment

NinjaCat System ID: brightroll:DIM_targetedAudienceName

Data Type: text

Week Of Year

NinjaCat System ID: brightroll:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: brightroll:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (62)

100% Complete

API Name: 100% Complete

NinjaCat System ID: brightroll:MET_complete100

Data Type: integer

Aggregates To: MET_100%_COMPLETE

100% Complete Rate

API Name: 100% Complete Rate

NinjaCat System ID: brightroll:MET_completeRate100

Data Type: decimal

Display As: percent

25% Complete

API Name: 25% Complete

NinjaCat System ID: brightroll:MET_complete25

Data Type: integer

Aggregates To: MET_25%_COMPLETE

25% Complete Rate

API Name: 25% Complete Rate

NinjaCat System ID: brightroll:MET_completeRate25

Data Type: decimal

Display As: percent

50% Complete

API Name: 50% Complete

NinjaCat System ID: brightroll:MET_complete50

Data Type: integer

Aggregates To: MET_50%_COMPLETE

50% Complete Rate

API Name: 50% Complete Rate

NinjaCat System ID: brightroll:MET_completeRate50

Data Type: decimal

Display As: percent

75% Complete

API Name: 75% Complete

NinjaCat System ID: brightroll:MET_complete75

Data Type: integer

Aggregates To: MET_75%_COMPLETE

75% Complete Rate

API Name: 75% Complete Rate

NinjaCat System ID: brightroll:MET_completeRate75

Data Type: decimal

Display As: percent

Campaign Management Fee

API Name: Order Management Fee

NinjaCat System ID: brightroll:MET_orderManagementFee

Data Type: decimal

Display As: currency

Clicks

API Name: Clicks

NinjaCat System ID: brightroll:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

Click Through Conversions

API Name: Click Through Conversion

NinjaCat System ID: brightroll:MET_clickThroughConversions

Data Type: integer

Aggregates To: MET_CLICK_THROUGH_CONVERSIONS

Click Through CPA

NinjaCat System ID: brightroll:MET_clickThroughCpa

Data Type: decimal

Display As: currency

Formula: brightroll:MET_spend / brightroll:MET_clickThroughConversions

Conversions

API Name: Conversion

NinjaCat System ID: brightroll:MET_conversions

Data Type: integer

Aggregates To: MET_CONVERSIONS

Conversion Value

API Name: ROAS Action Value

NinjaCat System ID: brightroll:MET_conversionValue

Data Type: integer

Aggregates To: MET_CONVERSION_VALUE

Count (Unique Dimensions)

NinjaCat System ID: brightroll:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

CPA

API Name: CPA

NinjaCat System ID: brightroll:MET_cpa

Data Type: integer

Aggregates To: MET_CPA

CPC

NinjaCat System ID: brightroll:MET_AverageCpc

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: brightroll:MET_spend / brightroll:MET_clicks

CPM

API Name: Advertiser eCPM

NinjaCat System ID: brightroll:MET_cpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Cross Device Conversions

API Name: Cross device conversions

NinjaCat System ID: brightroll:MET_crossDeviceConversions

Data Type: integer

CTR

NinjaCat System ID: brightroll:MET_Ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: brightroll:MET_clicks / brightroll:MET_impressions

CVR

API Name: Conversion Rate

NinjaCat System ID: brightroll:MET_cvr

Data Type: decimal

Display As: percent

Drop Rate at 0%

API Name: Drop Rate at 0%

NinjaCat System ID: brightroll:MET_dropRate0

Data Type: decimal

Display As: percent

Drop Rate at 25%

API Name: Drop Rate at 25%

NinjaCat System ID: brightroll:MET_dropRate25

Data Type: decimal

Display As: percent

Drop Rate at 50%

API Name: Drop Rate at 50%

NinjaCat System ID: brightroll:MET_dropRate50

Data Type: decimal

Display As: percent

Drop Rate at 75%

API Name: Drop Rate at 75%

NinjaCat System ID: brightroll:MET_dropRate75

Data Type: decimal

Display As: percent

Filtered Clicks

API Name: filtered clicks

NinjaCat System ID: brightroll:MET_filteredClicks

Data Type: integer

Filtered Impressions

API Name: filtered impressions

NinjaCat System ID: brightroll:MET_filteredImpressions

Data Type: integer

Impression Distribution Nonmesureable

API Name: Impression Distribution Nonmeasurable

NinjaCat System ID: brightroll:MET_impressionDistributionNonMesureable

Data Type: integer

Impression Distribution Nonviewable

API Name: Impression Distribution Nonviewable

NinjaCat System ID: brightroll:MET_impressionDistributionNonViewable

Data Type: integer

Impression Distribution Viewable

API Name: Impression Distribution Viewable

NinjaCat System ID: brightroll:MET_impressionDistributionViewable

Data Type: integer

Impressions

API Name: Impressions

NinjaCat System ID: brightroll:MET_impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

Inventory Cost

API Name: Publisher Earnings

NinjaCat System ID: brightroll:MET_inventoryCost

Data Type: decimal

Display As: currency

Management Fee

API Name: Seat Management Fee

NinjaCat System ID: brightroll:MET_managementFee

Data Type: decimal

Display As: currency

Mesureable Impressions

API Name: Measurable Impressions

NinjaCat System ID: brightroll:MET_yahooMesureableImpressions

Data Type: integer

Mesureable Rate

API Name: Measurable Rate

NinjaCat System ID: brightroll:MET_yahooMesureableRate1

Data Type: decimal

Display As: percent

Moat Analyzed Impressions

API Name: Moat Impressions Analyzed

NinjaCat System ID: brightroll:MET_moatAnalyzedImpressions

Data Type: integer

Moat AVFH

API Name: Moat GroupM Viewability

NinjaCat System ID: brightroll:MET_moatAvfh

Data Type: integer

Moat AVOC

API Name: Moat AVOC

NinjaCat System ID: brightroll:MET_moatAvoc

Data Type: integer

Moat AVOC Rate

API Name: MOAT AVOC Rate

NinjaCat System ID: brightroll:MET_moatAvocRate

Data Type: decimal

Display As: percent

Moat Mesureability Rate

API Name: MOAT Measurability Rate

NinjaCat System ID: brightroll:MET_moatMesureabilityRate

Data Type: decimal

Display As: percent

Moat Mesureable Impressions

API Name: Moat Measurable Impressions

NinjaCat System ID: brightroll:MET_moatMesureableImpressions

Data Type: integer

Moat Viewable Impressions

API Name: Moat Viewable Impressions

NinjaCat System ID: brightroll:MET_moatViewableImpressions

Data Type: integer

Moat Viewable Rate

API Name: Moat Viewable Rate

NinjaCat System ID: brightroll:MET_moatViewableRate

Data Type: decimal

Display As: percent

Network eCPM

API Name: Network eCPM

NinjaCat System ID: brightroll:MET_networkCpm

Data Type: decimal

Display As: currency

Network Profit

API Name: Network Profit

NinjaCat System ID: brightroll:MET_networkProfit

Data Type: decimal

Display As: currency

Network Profit %

API Name: Network Profit %

NinjaCat System ID: brightroll:MET_networkProfitPercent

Data Type: decimal

Display As: percent

Non-Mesureable Impressions

API Name: Nonmeasurable impressions

NinjaCat System ID: brightroll:MET_yahooNonMesureableImpressions

Data Type: integer

Non-Viewable Impressions

API Name: Nonviewable Impression

NinjaCat System ID: brightroll:MET_nonViewableImpressions

Data Type: integer

Platform Fee

API Name: Seat Tech Fee

NinjaCat System ID: brightroll:MET_platformFee

Data Type: decimal

Display As: currency

Publisher CPM

API Name: Publisher eCPM

NinjaCat System ID: brightroll:MET_publisherCpm

Data Type: decimal

Display As: currency

Publisher Earnings %

API Name: Publisher Earnings %

NinjaCat System ID: brightroll:MET_publisherEarningsPercent

Data Type: decimal

Display As: percent

ROAS

API Name: ROAS

NinjaCat System ID: brightroll:MET_roas

Data Type: decimal

Display As: currency

Aggregates To: MET_ROAS

Skipped Ads

API Name: Skipped Ads

NinjaCat System ID: brightroll:MET_skippedAds

Data Type: integer

Spend

API Name: Advertiser Spending

NinjaCat System ID: brightroll:MET_spend

Data Type: integer

Aggregates To: MET_COST

Third Party Data Fees

API Name: Third Party Data Fees

NinjaCat System ID: brightroll:MET_thirdPartyDataFees

Data Type: decimal

Display As: currency

Total Data Fee

API Name: Seat Data Fee

NinjaCat System ID: brightroll:MET_totalDataFee

Data Type: decimal

Display As: currency

Video Starts

API Name: Start Views

NinjaCat System ID: brightroll:MET_videoStarts

Data Type: integer

Aggregates To: MET_VIDEO_STARTS

Viewable Impressions

API Name: Viewable Impressions

NinjaCat System ID: brightroll:MET_yahooViewableImpressions

Data Type: integer

Aggregates To: MET_VIEWABLE_IMPRESSIONS

Viewable Rate

API Name: Viewable Rate

NinjaCat System ID: brightroll:MET_yahooViewableRate

Data Type: decimal

Display As: percent

View Through Conversions

API Name: View Through Conversion

NinjaCat System ID: brightroll:MET_viewThroughConversions

Data Type: integer

Aggregates To: MET_VIEW_THROUGH_CONVERSIONS

View Through CPA

NinjaCat System ID: brightroll:MET_viewThroughCpa

Data Type: decimal

Display As: currency

Formula: brightroll:MET_spend / brightroll:MET_viewThroughConversions

Yahoo Data Fees

API Name: Yahoo Data Fees

NinjaCat System ID: brightroll:MET_yahooDataFees

Data Type: decimal

Display As: currency

Updated 6 months ago