Guides
Shape Help Center

Basis Platform Fields

Suggest Edits

Dimensions (84)

Account

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

Ad ID

API Name: ad_id
NinjaCat System ID: centro_basis:DIM_adId
Data Type: text

Ad Label

API Name: ad_label
NinjaCat System ID: centro_basis:DIM_adLabel
Data Type: text

Ad Serving Vendor Id

API Name: ad_serving_vendor_id
NinjaCat System ID: centro_basis:DIM_adServingVendorId
Data Type: text

Ad Serving Vendor Name

API Name: ad_serving_vendor_name
NinjaCat System ID: centro_basis:DIM_adServingVendorName
Data Type: text

App / Domain Name

API Name: app/domain_name
NinjaCat System ID: centro_basis:DIM_appDomainName
Data Type: text

Attributed Event Date Time

API Name: attributed_event_date/time
NinjaCat System ID: centro_basis:DIM_attributedEventDateTime
Data Type: text

Brand Id

API Name: brand_id
NinjaCat System ID: centro_basis:DIM_brandId
Data Type: text

Brand Name

API Name: brand_name
NinjaCat System ID: centro_basis:DIM_brandName
Data Type: text

Campaign

API Name: campaign_name
NinjaCat System ID: centro_basis:DIM_campaignName
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Campaign End Date

API Name: campaign_end_date
NinjaCat System ID: centro_basis:DIM_campaignEndDate
Data Type: date
Aggregates To: DIM_CAMPAIGN_END_DATE

Campaign Id

API Name: campaign_id
NinjaCat System ID: centro_basis:DIM_campaignId
Data Type: text
Aggregates To: DIM_CAMPAIGN_ID

Campaign Start Date

API Name: campaign_start_date
NinjaCat System ID: centro_basis:DIM_campaignStartDate
Data Type: date
Aggregates To: DIM_CAMPAIGN_START_DATE

Campaign Status

API Name: campaign_status
NinjaCat System ID: centro_basis:DIM_campaignStatus
Data Type: text
Aggregates To: DIM_CAMPAIGN_STATUS

Campaign Ugcid

API Name: campaign_ugcid
NinjaCat System ID: centro_basis:DIM_campaignUgcid
Data Type: text

Campaign Uuid

API Name: campaign_uuid
NinjaCat System ID: centro_basis:DIM_campaignUuid
Data Type: text

City

API Name: city
NinjaCat System ID: centro_basis:DIM_city
Data Type: text

Client Id

API Name: client_id
NinjaCat System ID: centro_basis:DIM_clientId
Data Type: text

Client Name

API Name: client_name
NinjaCat System ID: centro_basis:DIM_clientName
Data Type: text

Conversion Attribution Source

API Name: conversion_attribution_source
NinjaCat System ID: centro_basis:DIM_conversionAttributionSource
Data Type: text

Conversion Event Id

API Name: conversion_event_id
NinjaCat System ID: centro_basis:DIM_conversionEventId
Data Type: text

Conversion Event Type

API Name: conversion_event_type
NinjaCat System ID: centro_basis:DIM_conversionEventType
Data Type: text

Conversion Id

API Name: conversion_id
NinjaCat System ID: centro_basis:DIM_conversionId
Data Type: text

Conversion Name

API Name: conversion_name
NinjaCat System ID: centro_basis:DIM_conversionName
Data Type: text

Conversion Revenue

API Name: conversion_revenue
NinjaCat System ID: centro_basis:DIM_conversionRevenue
Data Type: text

Country

API Name: country
NinjaCat System ID: centro_basis:DIM_country
Data Type: text

Creative Id

API Name: creative_id
NinjaCat System ID: centro_basis:DIM_creativeId
Data Type: text
Aggregates To: DIM_CREATIVE_ID

Currency

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

Customer Transaction Id

API Name: customer_transaction_id
NinjaCat System ID: centro_basis:DIM_customTransactionId
Data Type: text

Data Source

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

Date

API Name: delivery_date
NinjaCat System ID: centro_basis:DIM_delivery_date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

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

Day Of Week

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

Delivery Source Id

API Name: delivery_source_id
NinjaCat System ID: centro_basis:DIM_deliverySourceId
Data Type: text

Device Type

API Name: device_type
NinjaCat System ID: centro_basis:DIM_deviceType
Data Type: text

DMA Code

API Name: dma_code
NinjaCat System ID: centro_basis:DIM_dmaCode
Data Type: text

DMA Name

API Name: dma_name
NinjaCat System ID: centro_basis:DIM_dmaName
Data Type: text

Domain / App Id

API Name: domain/app_id
NinjaCat System ID: centro_basis:DIM_domainAppId
Data Type: text

End Date

API Name: end_date
NinjaCat System ID: centro_basis:DIM_endDate
Data Type: text

Exchange Id

API Name: exchange_id
NinjaCat System ID: centro_basis:DIM_exchangeId
Data Type: text

Exchange Name

API Name: exchange_name
NinjaCat System ID: centro_basis:DIM_exchangeName
Data Type: text

External Ad Ref

API Name: external_ad_ref
NinjaCat System ID: centro_basis:DIM_externalAdRef
Data Type: text

External Id

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

External Source

API Name: external_source
NinjaCat System ID: centro_basis:DIM_externalSource
Data Type: text

Group Id

API Name: group_id
NinjaCat System ID: centro_basis:DIM_groupId
Data Type: text

Group Name

API Name: group_name
NinjaCat System ID: centro_basis:DIM_groupName
Data Type: text

Initiative Name

API Name: initiative_name
NinjaCat System ID: centro_basis:DIM_initiativeName
Data Type: text

Line Item End Date

API Name: line_item_end_date
NinjaCat System ID: centro_basis:DIM_lineItemEndDate
Data Type: date

Line Item Id

API Name: line_item_id
NinjaCat System ID: centro_basis:DIM_lineItemId
Data Type: text

Line Item Lineage

API Name: line_item_lineage
NinjaCat System ID: centro_basis:DIM_lineItemLineage
Data Type: text

Line Item Name

API Name: line_item_name
NinjaCat System ID: centro_basis:DIM_lineItemName
Data Type: text

Line Item Start Date

API Name: line_item_start_date
NinjaCat System ID: centro_basis:DIM_lineItemStartDate
Data Type: date

Line Item Type

API Name: line_item_type
NinjaCat System ID: centro_basis:DIM_lineItemType
Data Type: text

Make

API Name: make
NinjaCat System ID: centro_basis:DIM_make
Data Type: text

Media Plan Approval Version

API Name: media_plan_approval_version
NinjaCat System ID: centro_basis:DIM_mediaPlanApprovalVersion
Data Type: text

Media Plan Id

API Name: media_plan_id
NinjaCat System ID: centro_basis:DIM_mediaPlanId
Data Type: text

Media Plan Name

API Name: media_plan_name
NinjaCat System ID: centro_basis:DIM_mediaPlanName
Data Type: text

Media Type

Deprecated: 2024-11-07T01:28:37.866Z
API Name: media_type
NinjaCat System ID: centro_basis:DIM_mediaType
Data Type: text

Model

API Name: model
NinjaCat System ID: centro_basis:DIM_model
Data Type: text

Month Of Year

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

Name

API Name: name
NinjaCat System ID: centro_basis:DIM_name
Data Type: text

Network

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

Page Position

API Name: page_position
NinjaCat System ID: centro_basis:DIM_pagePosition
Data Type: text

Primary

API Name: primary
NinjaCat System ID: centro_basis:DIM_primary
Data Type: text

Property Id

API Name: property_id
NinjaCat System ID: centro_basis:DIM_propertyId
Data Type: text

Property Name

API Name: property_name
NinjaCat System ID: centro_basis:DIM_propertyName
Data Type: text

Property Type

API Name: property_type
NinjaCat System ID: centro_basis:DIM_propertyType
Data Type: text

Property Url

API Name: property_url
NinjaCat System ID: centro_basis:DIM_propertyUrl
Data Type: text
Display As: url

Quarter

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

Rate Type

API Name: rate_type
NinjaCat System ID: centro_basis:DIM_rateType
Data Type: text

Rate Type Unit

API Name: rate_type_unit
NinjaCat System ID: centro_basis:DIM_rateTypeUnit
Data Type: text

Region

API Name: region
NinjaCat System ID: centro_basis:DIM_region
Data Type: text

Row

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

Segment Name

API Name: segment_name
NinjaCat System ID: centro_basis:DIM_segmentName
Data Type: text

Size

API Name: size
NinjaCat System ID: centro_basis:DIM_size
Data Type: text

Start Date

API Name: start_date
NinjaCat System ID: centro_basis:DIM_startDate
Data Type: text

System Account ID

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

Tactic Id

API Name: tactic_id
NinjaCat System ID: centro_basis:DIM_tacticId
Data Type: text

Tactic Name

API Name: tactic_name
NinjaCat System ID: centro_basis:DIM_tacticName
Data Type: text

Vendor Id

API Name: vendor_id
NinjaCat System ID: centro_basis:DIM_vendorId
Data Type: text

Vendor Name

API Name: vendor_name
NinjaCat System ID: centro_basis:DIM_vendorName
Data Type: text

Week Of Year

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

Year

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

Zip / Postal Code

API Name: zip/postal_code
NinjaCat System ID: centro_basis:DIM_zipPostalCode
Data Type: text

Metrics (65)

100% Complete

API Name: 100%_complete
NinjaCat System ID: centro_basis:MET_100Complete
Data Type: integer

25% Complete

API Name: 25%_complete
NinjaCat System ID: centro_basis:MET_25Complete
Data Type: integer

50% Complete

API Name: 50%_complete
NinjaCat System ID: centro_basis:MET_50Complete
Data Type: integer

75% Complete

API Name: 75%_complete
NinjaCat System ID: centro_basis:MET_75Complete
Data Type: integer

Ad Serving Spend

API Name: ad_serving_spend
NinjaCat System ID: centro_basis:MET_adServingSpend
Data Type: integer

Audio / Video Starts

API Name: audio/video_starts
NinjaCat System ID: centro_basis:MET_audioVideoStarts
Data Type: integer

Click CVR

NinjaCat System ID: centro_basis:MET_clickCvr
Data Type: decimal
Display As: percent
Formula: 1000 * $row['centro_basis:MET_ctc / centro_basis:MET_clicks

Clicks

API Name: clicks
NinjaCat System ID: centro_basis:MET_clicks
Data Type: integer
Aggregates To: MET_CLICKS

Companion Clicks

API Name: companion_clicks
NinjaCat System ID: centro_basis:MET_companionClicks
Data Type: integer

Companion CTC

API Name: companion_ctc
NinjaCat System ID: centro_basis:MET_companionCtc
Data Type: integer

Companion CTC Revenue

API Name: companion_ctc_revenue
NinjaCat System ID: centro_basis:MET_companionCtcRevenue
Data Type: decimal
Display As: currency

Companion Impressions Won

API Name: companion_imps_won
NinjaCat System ID: centro_basis:MET_companionImpressionsWon
Data Type: integer

Completion Rate

NinjaCat System ID: centro_basis:MET_completionRate
Data Type: decimal
Display As: percent
Formula: 1000 * $row['centro_basis:MET_100Complete / centro_basis:MET_audioVideoStarts

Contract Ad Serving Rate

API Name: contract_ad_serving_rate
NinjaCat System ID: centro_basis:MET_contractAdServingRate
Data Type: integer

Contract Ad Serving Spend

API Name: contract_ad_serving_spend
NinjaCat System ID: centro_basis:MET_contractAdServingSpend
Data Type: decimal
Display As: currency

Contracted Actions

API Name: contracted_actions
NinjaCat System ID: centro_basis:MET_contractedActions
Data Type: integer

Contracted Clicks

API Name: contracted_clicks
NinjaCat System ID: centro_basis:MET_contactedClicks
Data Type: integer

Contracted Impressions

API Name: contracted_impressions
NinjaCat System ID: centro_basis:MET_contractedImpressions
Data Type: integer

Contracted Video Completions

Deprecated: 2024-11-07T01:28:37.866Z
API Name: contracted_video_completions
NinjaCat System ID: centro_basis:MET_contactedVideoCompletions
Data Type: integer

Contracted Video Views

API Name: contracted_video_views
NinjaCat System ID: centro_basis:MET_contractedVideoViews
Data Type: integer

Contracted Viewable Impressions

API Name: contracted_viewable_impressions
NinjaCat System ID: centro_basis:MET_contractedViewableImpressions
Data Type: integer

Contract Media Rate

API Name: contract_media_rate
NinjaCat System ID: centro_basis:MET_contractMediaRate
Data Type: decimal
Display As: percent

Contract Media Spend

API Name: contract_media_spend
NinjaCat System ID: centro_basis:MET_contractMediaSpend
Data Type: decimal
Display As: currency

Contract Total Rate

API Name: contract_total_rate
NinjaCat System ID: centro_basis:MET_contractTotalRate
Data Type: decimal
Display As: currency

Contract Total Spend

API Name: contract_total_spend
NinjaCat System ID: centro_basis:MET_contractTotalSpend
Data Type: decimal
Display As: currency

Contract Units

API Name: contract_units
NinjaCat System ID: centro_basis:MET_contractUnits
Data Type: integer

Conversion Count

NinjaCat System ID: centro_basis:MET_conversionCount
Data Type: integer
Formula: NUM_ROWS

Count (Unique Dimensions)

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

CTC

API Name: ctc
NinjaCat System ID: centro_basis:MET_ctc
Data Type: integer

CTC Revenue

API Name: ctc_revenue
NinjaCat System ID: centro_basis:MET_ctcRevenue
Data Type: decimal
Display As: currency

CTR

NinjaCat System ID: centro_basis:MET_ctr
Data Type: decimal
Display As: percent
Aggregates To: MET_CTR
Formula: (centro_basis:MET_clicks / centro_basis:MET_impressions)

Data Spend

API Name: data_spend
NinjaCat System ID: centro_basis:MET_dataSpend
Data Type: decimal
Display As: currency

Delivered Units

API Name: delivered_units
NinjaCat System ID: centro_basis:MET_deliveredUnits
Data Type: integer

Eligible Impressions

API Name: eligible_impressions
NinjaCat System ID: centro_basis:MET_eligibleImpressions
Data Type: integer

Impressions

API Name: impressions
NinjaCat System ID: centro_basis:MET_impressions
Data Type: integer
Aggregates To: MET_IMPRESSIONS

Impressions Won

API Name: imps_won
NinjaCat System ID: centro_basis:MET_impressionsWon
Data Type: integer

Interactions

API Name: interactions
NinjaCat System ID: centro_basis:MET_interactions
Data Type: integer

Inventory Spend

API Name: inventory_spend
NinjaCat System ID: centro_basis:MET_inventorySpend
Data Type: decimal
Display As: currency

Measurable Impressions

API Name: measurable_impressions
NinjaCat System ID: centro_basis:MET_measurableImpressions
Data Type: integer

Measured Rate

NinjaCat System ID: centro_basis:MET_measuredRate
Data Type: decimal
Display As: percent
Formula: 1000 * $row['centro_basis:MET_totalMeasuredImpressions / centro_basis:MET_totalEligibleImpressions

Media Spend

API Name: media_spend
NinjaCat System ID: centro_basis:MET_mediaSpend
Data Type: decimal
Display As: currency
Aggregates To: MET_MEDIA_SPEND

Net ECPA

API Name: net_ecpa
NinjaCat System ID: centro_basis:MET_netEcpa
Data Type: decimal
Display As: currency

Net ECPC

API Name: net_ecpc
NinjaCat System ID: centro_basis:MET_netEcpc
Data Type: decimal
Display As: currency

Net ECPM

API Name: net_ecpm
NinjaCat System ID: centro_basis:MET_netEcpm
Data Type: decimal
Display As: currency

Net Spend

API Name: net_spend
NinjaCat System ID: centro_basis:MET_netSpend
Data Type: decimal
Display As: currency

Pixel Size

Deprecated: 2024-11-07T01:28:37.866Z
API Name: pixel_size
NinjaCat System ID: centro_basis:MET_pixelSize
Data Type: integer

Total Click Conversions

API Name: total_click_conversions
NinjaCat System ID: centro_basis:MET_totalClickConversions
Data Type: integer

Total Conversions

API Name: total_conversions
NinjaCat System ID: centro_basis:MET_totalConversions
Data Type: integer
Aggregates To: MET_TOTAL_CONVERSIONS

Total CVRM

API Name: total_cvrm
NinjaCat System ID: centro_basis:MET_totalCvrm
Data Type: integer

Total ECPCV

API Name: total_ecpcv
NinjaCat System ID: centro_basis:MET_totalEcpcv
Data Type: decimal
Display As: currency

Total Eligible Impressions

API Name: total_eligible_imps
NinjaCat System ID: centro_basis:MET_totalEligibleImpressions
Data Type: integer

Total Measured Impressions

API Name: total_measured_imps
NinjaCat System ID: centro_basis:MET_totalMeasuredImpressions
Data Type: integer

Total Revenue

API Name: total_revenue
NinjaCat System ID: centro_basis:MET_totalRevenue
Data Type: decimal
Display As: currency

Total Spend

API Name: total_spend
NinjaCat System ID: centro_basis:MET_totalSpend
Data Type: integer
Aggregates To: MET_COST,MET_TOTAL_SPEND

Total Viewable Impressions

API Name: total_viewable_imps
NinjaCat System ID: centro_basis:MET_totalViewableImpressions
Data Type: integer

Total View Conversions

API Name: total_view_conversions
NinjaCat System ID: centro_basis:MET_totalViewConversions
Data Type: integer

Video Completions

API Name: video_completions
NinjaCat System ID: centro_basis:MET_videoCompletions
Data Type: integer
Aggregates To: MET_VIDEO_COMPLETIONS

Video Starts

API Name: video_starts
NinjaCat System ID: centro_basis:MET_videoStarts
Data Type: integer
Aggregates To: MET_VIDEO_STARTS

Video Views

API Name: video_views
NinjaCat System ID: centro_basis:MET_videoViews
Data Type: integer
Aggregates To: MET_VIDEO_VIEWS

Viewability Fee

API Name: viewability_fee
NinjaCat System ID: centro_basis:MET_viewabilityFee
Data Type: decimal
Display As: currency

Viewable Impressions

API Name: viewable_impressions
NinjaCat System ID: centro_basis:MET_viewableImpressions
Data Type: integer
Aggregates To: MET_VIEWABLE_IMPRESSIONS

Viewable Rate

NinjaCat System ID: centro_basis:MET_viewableRate
Data Type: decimal
Display As: percent
Formula: 1000 * $row['centro_basis:MET_totalViewableImpressions / centro_basis:MET_totalMeasuredImpressions

View CVR

NinjaCat System ID: centro_basis:MET_viewCvr
Data Type: decimal
Display As: percent
Formula: 1000 * $row['centro_basis:MET_vtc / centro_basis:MET_clicks

VTC

API Name: vtc
NinjaCat System ID: centro_basis:MET_vtc
Data Type: integer

VTC Revenue

API Name: vtc_revenue
NinjaCat System ID: centro_basis:MET_vtcRevenue
Data Type: decimal
Display As: currency

Updated 4 months ago