Guides
Shape Help Center

Basis DSP Fields

Suggest Edits

Dimensions (40)

Account

NinjaCat System ID: centro:DIM_ACCOUNT
Data Type: text
Aggregates To: DIM_ACCOUNT

Ad

API Name: Ad Label
NinjaCat System ID: centro:DIM_Ad
Data Type: text
Aggregates To: DIM_AD_NAME

Ad Id

API Name: Ad Id
NinjaCat System ID: centro:DIM_AdId
Data Type: text

App/Domain Id

API Name: Domain/App ID
NinjaCat System ID: centro:DIM_AppDomainId
Data Type: text

App/Domain Name

API Name: App/Domain Name
NinjaCat System ID: centro:DIM_Domain
Data Type: text

Audience

API Name: Segment Name
NinjaCat System ID: centro:DIM_Audience
Data Type: text

Brand ID

API Name: Brand ID
NinjaCat System ID: centro:DIM_BrandId
Data Type: text

Brand Name

API Name: Brand Name
NinjaCat System ID: centro:DIM_BrandName
Data Type: text

Campaign

API Name: Campaign Name
NinjaCat System ID: centro:DIM_Campaign
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Campaign End Date

API Name: End Date
NinjaCat System ID: centro:DIM_CampaignEndDate
Data Type: text

Campaign Group

NinjaCat System ID: centro:DIM_CampaignGroup
Data Type: text
Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign Id

API Name: Campaign ID
NinjaCat System ID: centro:DIM_CampaignId
Data Type: text

Campaign Start Date

API Name: Start Date
NinjaCat System ID: centro:DIM_CampaignStartDate
Data Type: text

City

API Name: City
NinjaCat System ID: centro:DIM_City
Data Type: text
Aggregates To: DIM_CITY

Country

API Name: Country
NinjaCat System ID: centro:DIM_Country
Data Type: text
Display As: country
Aggregates To: DIM_COUNTRIES

Currency

NinjaCat System ID: centro:DIM_CURRENCY
Data Type: text
Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: centro:DIM_DATA_SOURCE
Data Type: text
Aggregates To: DIM_DATA_SOURCE

Date

API Name: Date
NinjaCat System ID: centro:DIM_Date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: centro:DIM_DAY_OF_MONTH
Data Type: integer
Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: centro:DIM_DAY_OF_WEEK
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK

Device

API Name: Device Type
NinjaCat System ID: centro:DIM_Device
Data Type: text
Aggregates To: DIM_DEVICE_TYPE

DMA Code

API Name: DMA Code
NinjaCat System ID: centro:DIM_DMACode
Data Type: text

DMA Name

API Name: DMA Name
NinjaCat System ID: centro:DIM_DMAName
Data Type: text

External Id

NinjaCat System ID: centro:DIM_EXTERNAL_ID
Data Type: text
Aggregates To: DIM_EXTERNAL_ID

Group ID

API Name: Group ID
NinjaCat System ID: centro:DIM_GroupId
Data Type: text

Group Name

API Name: Group Name
NinjaCat System ID: centro:DIM_GroupName
Data Type: text

Month Of Year

NinjaCat System ID: centro:DIM_MONTH_OF_YEAR
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: centro:DIM_NETWORK
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK

Operating System

API Name: Device OS
NinjaCat System ID: centro:DIM_OS
Data Type: text

Primary Region

API Name: Primary Region
NinjaCat System ID: centro:DIM_PrimaryRegion
Data Type: text

Quarter

NinjaCat System ID: centro:DIM_QUARTER
Data Type: text
Display As: quarter
Aggregates To: DIM_QUARTER

Region

API Name: Region
NinjaCat System ID: centro:DIM_Region
Data Type: text

Row

NinjaCat System ID: centro:DIM_ROW
Data Type: text
Aggregates To: DIM_ROW

Secondary Region

API Name: Secondary Region
NinjaCat System ID: centro:DIM_SecondaryRegion
Data Type: text

Site Id

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Site ID
NinjaCat System ID: centro:DIM_SiteId
Data Type: text

Site Name

Deprecated: 2024-11-07T01:28:37.866Z
API Name: Site Name
NinjaCat System ID: centro:DIM_SiteName
Data Type: text

System Account ID

NinjaCat System ID: centro:DIM_ACCOUNT_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID

Week Of Year

NinjaCat System ID: centro:DIM_WEEK_OF_YEAR
Data Type: text
Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: centro:DIM_YEAR
Data Type: text
Aggregates To: DIM_YEAR

Zip/Postal Code

API Name: Zip/Postal Code
NinjaCat System ID: centro:DIM_ZipCode
Data Type: text

Metrics (38)

100% Complete

API Name: 100% Complete
NinjaCat System ID: centro:MET_Complete100
Data Type: integer

25% Complete

API Name: 25% Complete
NinjaCat System ID: centro:MET_Complete25
Data Type: integer

50% Complete

API Name: 50% Complete
NinjaCat System ID: centro:MET_Complete50
Data Type: integer

75% Complete

API Name: 75% Complete
NinjaCat System ID: centro:MET_Complete75
Data Type: integer

Audio/Video Starts

API Name: Audio/Video Starts
NinjaCat System ID: centro:MET_VideoStarts
Data Type: integer

Click CVR

NinjaCat System ID: centro:MET_ClickCVR
Data Type: decimal
Display As: percent
Formula: 1000 * $row['centro:MET_ctc / centro:MET_Clicks

Clicks

API Name: Clicks
NinjaCat System ID: centro:MET_Clicks
Data Type: integer
Aggregates To: MET_CLICKS

Click-through Convs.

API Name: CTC
NinjaCat System ID: centro:MET_ctc
Data Type: integer

Companion Clicks

API Name: Companion Clicks
NinjaCat System ID: centro:MET_CompanionClicks
Data Type: integer

Companion Click-through Convs.

API Name: Companion CTC
NinjaCat System ID: centro:MET_CompanionCTC
Data Type: integer

Companion CTC Revenue

API Name: Companion CTC Revenue
NinjaCat System ID: centro:MET_CompanionCTCRevenue
Data Type: decimal
Display As: currency

Companion Imps. Won

API Name: Companion Imps. Won
NinjaCat System ID: centro:MET_CompanionImpsWon
Data Type: integer

Completion Rate

NinjaCat System ID: centro:MET_CompletionRate
Data Type: decimal
Display As: percent
Formula: centro:MET_VideoStarts / centro:MET_Complete100

Conversions

API Name: Total Conversions
NinjaCat System ID: centro:MET_Conversions
Data Type: integer
Aggregates To: MET_CONVERSIONS

Conv. Rate

NinjaCat System ID: centro:MET_ConversionRate
Data Type: decimal
Display As: percent
Aggregates To: MET_CONVERSION_RATE
Formula: centro:MET_Conversions / centro:MET_ActionLeadingToConv

Cost / Conv.

NinjaCat System ID: centro:MET_AverageCPA
Data Type: decimal
Display As: currency
Aggregates To: MET_CPA
Formula: centro:MET_TotalSpend / centro:MET_Conversions

Cost Per Completed Video

NinjaCat System ID: centro:MET_CPCV
Data Type: decimal
Display As: currency
Formula: centro:MET_TotalSpend / centro:MET_Complete100

Count (Unique Dimensions)

NinjaCat System ID: centro:MET_COUNT_NC
Data Type: integer
Aggregates To: MET_COUNT_NC

CPC

NinjaCat System ID: centro:MET_AverageCpc
Data Type: decimal
Display As: currency
Aggregates To: MET_CPC
Formula: centro:MET_TotalSpend / centro:MET_Clicks

CPM

NinjaCat System ID: centro:MET_AverageCpm
Data Type: decimal
Display As: currency
Aggregates To: MET_CPM
Formula: 1000 * centro:MET_TotalSpend / centro:MET_Impressions

CTC Revenue

API Name: CTC Revenue
NinjaCat System ID: centro:MET_CTCRevenue
Data Type: decimal
Display As: currency

CTR

NinjaCat System ID: centro:MET_Ctr
Data Type: decimal
Display As: percent
Aggregates To: MET_CTR
Formula: centro:MET_Clicks / centro:MET_Impressions

Data Spend

API Name: Data Spend
NinjaCat System ID: centro:MET_DataSpend
Data Type: decimal
Display As: currency

Event Rate

NinjaCat System ID: centro:MET_EventRate
Data Type: decimal
Display As: percent
Formula: centro:MET_Events / centro:MET_Clicks

Events

API Name: Events
NinjaCat System ID: centro:MET_Events
Data Type: integer

Impressions

API Name: Imps. Won
NinjaCat System ID: centro:MET_Impressions
Data Type: integer
Aggregates To: MET_IMPRESSIONS

Measured Rate

NinjaCat System ID: centro:MET_MeasuredRate
Data Type: decimal
Display As: percent
Formula: centro:MET_TotalMeasuredImps / centro:MET_TotalEligibleImps

Media Spend

API Name: Media Spend
NinjaCat System ID: centro:MET_MediaSpend
Data Type: decimal
Display As: currency

Total CVRM

NinjaCat System ID: centro:MET_CVRM
Data Type: decimal
Display As: percent
Formula: 1000 * centro:MET_Conversions / centro:MET_Impressions

Total Eligible Imps.

API Name: Total Eligible Imps.
NinjaCat System ID: centro:MET_TotalEligibleImps
Data Type: integer

Total Measured Imps.

API Name: Total Measured Imps.
NinjaCat System ID: centro:MET_TotalMeasuredImps
Data Type: integer

Total Revenue

API Name: Total Revenue
NinjaCat System ID: centro:MET_Revenue
Data Type: decimal
Display As: currency

Total Spend

API Name: Total Spend
NinjaCat System ID: centro:MET_TotalSpend
Data Type: decimal
Display As: currency
Aggregates To: MET_COST

Total Viewable Imps.

API Name: Total Viewable Imps.
NinjaCat System ID: centro:MET_ViewableImpressions
Data Type: integer

Viewable Rate

NinjaCat System ID: centro:MET_ViewableRate
Data Type: decimal
Display As: percent
Formula: centro:MET_ViewableImpressions / centro:MET_TotalMeasuredImps

View CVR

NinjaCat System ID: centro:MET_ViewCVR
Data Type: decimal
Display As: percent
Formula: 1000 * centro:MET_vtc / centro:MET_Clicks

View-through Convs.

API Name: VTC
NinjaCat System ID: centro:MET_vtc
Data Type: integer

VTC Revenue

API Name: VTC Revenue
NinjaCat System ID: centro:MET_VTCRevenue
Data Type: decimal
Display As: currency

Updated 4 months ago