Dimensions (34)

Account

NinjaCat System ID: spotify:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Ad Id

API Name: entity_id

NinjaCat System ID: spotify:DIM_ad_id

Data Type: text

Ad Name

API Name: entity_name

NinjaCat System ID: spotify:DIM_ad_name

Data Type: text

Aggregates To: DIM_AD_NAME

Ad Set Id

API Name: entity_id

NinjaCat System ID: spotify:DIM_ad_set_id

Data Type: text

Ad Set Id ( Audience )

API Name: id

NinjaCat System ID: spotify:DIM_ad_set_id_audience

Data Type: text

Ad Set Name

API Name: entity_name

NinjaCat System ID: spotify:DIM_ad_set_name

Data Type: text

Ad Set Name ( Audience )

API Name: name

NinjaCat System ID: spotify:DIM_ad_set_name_audience

Data Type: text

Ad Set Status

API Name: entity_status

NinjaCat System ID: spotify:DIM_ad_set_status

Data Type: text

Ad Set Status ( Audience )

API Name: status

NinjaCat System ID: spotify:DIM_ad_set_status_audience

Data Type: text

Ad Status

API Name: entity_status

NinjaCat System ID: spotify:DIM_ad_status

Data Type: text

Campaign Id

API Name: entity_id

NinjaCat System ID: spotify:DIM_campaign_id

Data Type: text

Campaign Name

API Name: entity_name

NinjaCat System ID: spotify:DIM_campaign_name

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Campaign Status

API Name: entity_status

NinjaCat System ID: spotify:DIM_campaign_status

Data Type: text

Currency

NinjaCat System ID: spotify:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: spotify:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: date

NinjaCat System ID: spotify:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: spotify:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: spotify:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

Entity Type

API Name: entity_type

NinjaCat System ID: spotify:DIM_entity_type

Data Type: text

External Id

NinjaCat System ID: spotify:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Genre

API Name: insight_value

NinjaCat System ID: spotify:DIM_insight_value_genre

Data Type: text

Listener Age Range

API Name: insight_value

NinjaCat System ID: spotify:DIM_insight_value_age

Data Type: text

Listener Country

API Name: insight_value

NinjaCat System ID: spotify:DIM_insight_value_country

Data Type: text

Listener Gender

API Name: insight_value

NinjaCat System ID: spotify:DIM_insight_value_gender

Data Type: text

Month Of Year

NinjaCat System ID: spotify:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: spotify:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Parent Entity Name

API Name: parent_entity|name

NinjaCat System ID: spotify:DIM_parent_entity_name

Data Type: text

Parent Entity Status

API Name: parent_entity|status

NinjaCat System ID: spotify:DIM_parent_entity_status

Data Type: text

Platform

API Name: insight_value

NinjaCat System ID: spotify:DIM_insight_value_platform

Data Type: text

Quarter

NinjaCat System ID: spotify:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: spotify:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: spotify:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Week Of Year

NinjaCat System ID: spotify:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: spotify:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (30)

Bid Micro Amount

API Name: bid_micro_amount

NinjaCat System ID: spotify:MET_bid_micro_amount

Data Type: integer

Clicks

API Name: CLICKS

NinjaCat System ID: spotify:MET_clicks

Data Type: integer

Aggregates To: MET_CLICKS

Completes

API Name: COMPLETES

NinjaCat System ID: spotify:MET_completes

Data Type: integer

Count (Unique Dimensions)

NinjaCat System ID: spotify:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

CPC

NinjaCat System ID: spotify:MET_cpc

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: spotify:MET_spend / spotify:MET_clicks

CPCL

API Name: E_CPCL

NinjaCat System ID: spotify:MET_E_cpcl

Data Type: decimal

Display As: currency

CPM

NinjaCat System ID: spotify:MET_e_cpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Formula: spotify:MET_spend * 1000 / spotify:MET_impressions

CTR

NinjaCat System ID: spotify:MET_ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: spotify:MET_clicks / spotify:MET_impressions

First Quartiles

API Name: FIRST_QUARTILES

NinjaCat System ID: spotify:MET_first_quartiles

Data Type: integer

Frequency

API Name: FREQUENCY

NinjaCat System ID: spotify:MET_frequency

Data Type: decimal

Is Unique: True

Display As: float

Impressions

API Name: IMPRESSIONS

NinjaCat System ID: spotify:MET_impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

Intent Rate

API Name: INTENT_RATE

NinjaCat System ID: spotify:MET_intent_rate

Data Type: decimal

Is Unique: True

Display As: percent

Listeners

API Name: LISTENERS

NinjaCat System ID: spotify:MET_listeners

Data Type: integer

Midpoints

API Name: MIDPOINTS

NinjaCat System ID: spotify:MET_midpoints

Data Type: integer

New Listener Conversion Rate

API Name: NEW_LISTENER_CONVERSION_RATE

NinjaCat System ID: spotify:MET_new_listener_conversion_rate

Data Type: decimal

Is Unique: True

Display As: percent

New Listeners

API Name: NEW_LISTENERS

NinjaCat System ID: spotify:MET_new_listeners

Data Type: integer

New Listener Streams

API Name: NEW_LISTENER_STREAMS

NinjaCat System ID: spotify:MET_new_listener_streams

Data Type: integer

Off Spotify Impressions

API Name: OFF_SPOTIFY_IMPRESSIONS

NinjaCat System ID: spotify:MET_off_spotify_impressions

Data Type: integer

Paid Listens

API Name: PAID_LISTENS

NinjaCat System ID: spotify:MET_paid_listens

Data Type: integer

Paid Listens Frequency

API Name: PAID_LISTENS_FREQUENCY

NinjaCat System ID: spotify:MET_paid_listens_frequency

Data Type: decimal

Is Unique: True

Display As: float

Paid Listens Reach

API Name: PAID_LISTENS_REACH

NinjaCat System ID: spotify:MET_paid_listens_reach

Data Type: integer

Is Unique: True

Reach

API Name: REACH

NinjaCat System ID: spotify:MET_reach

Data Type: integer

Is Unique: True

Skips

API Name: SKIPS

NinjaCat System ID: spotify:MET_skips

Data Type: integer

Spend

API Name: SPEND

NinjaCat System ID: spotify:MET_spend

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

Starts

API Name: STARTS

NinjaCat System ID: spotify:MET_starts

Data Type: integer

Streams

API Name: STREAMS

NinjaCat System ID: spotify:MET_streams

Data Type: integer

Streams Per New Listener

NinjaCat System ID: spotify:MET_streams_per_new_listener

Data Type: decimal

Display As: float

Formula: spotify:MET_new_listener_streams / spotify:MET_new_listeners

Streams Per User

NinjaCat System ID: spotify:MET_streams_per_user

Data Type: decimal

Display As: float

Formula: spotify:MET_streams / spotify:MET_listeners

Third Quartiles

API Name: THIRD_QUARTILES

NinjaCat System ID: spotify:MET_third_quartiles

Data Type: integer

Video Views

API Name: VIDEO_VIEWS

NinjaCat System ID: spotify:MET_video_views

Data Type: integer