Dimensions (30)

Account

NinjaCat System ID: steelhouse:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Ad Group Name

API Name: CreativeGroup_Name

NinjaCat System ID: steelhouse:DIM_CreativeGroup_Name

Data Type: text

Aggregates To: DIM_AD_GROUP_NAME

Advertiser Id

API Name: Advertiser_ID

NinjaCat System ID: steelhouse:DIM_Advertiser_ID

Data Type: text

Aggregates To: DIM_ADVERTISER_ID

Advertiser Name

API Name: Advertiser_Name

NinjaCat System ID: steelhouse:DIM_Advertiser_Name

Data Type: text

Campaign Id

API Name: Campaign_ID

NinjaCat System ID: steelhouse:DIM_Campaign_ID

Data Type: text

Aggregates To: DIM_CAMPAIGN_ID

Campaign Name

API Name: Campaign_Name

NinjaCat System ID: steelhouse:DIM_Campaign_Name

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Channel Id

API Name: Channel_ID

NinjaCat System ID: steelhouse:DIM_Channel_ID

Data Type: text

Channel Name

API Name: Channel_Name

NinjaCat System ID: steelhouse:DIM_Channel_Name

Data Type: text

Conversions: Click Through

API Name: Conversions_Click_Through

NinjaCat System ID: steelhouse:DIM_Conversions_Click_Through

Data Type: text

Conversions: Currency

API Name: Currency

NinjaCat System ID: steelhouse:DIM_Conversions_Currency

Data Type: text

Conversions: Domain

API Name: Domain

NinjaCat System ID: steelhouse:DIM_Conversions_Domain

Data Type: text

Conversions: Order ID

API Name: Order_ID

NinjaCat System ID: steelhouse:DIM_Conversions_OrderId

Data Type: text

Conversions: Time

API Name: Conversion_Time

NinjaCat System ID: steelhouse:DIM_Conversions_Time

Data Type: datetime

Display As: date_time

Conversions: Type

API Name: Type

NinjaCat System ID: steelhouse:DIM_Conversions_Type

Data Type: text

Creative Group Id

API Name: CreativeGroup_ID

NinjaCat System ID: steelhouse:DIM_CreativeGroup_ID

Data Type: text

Creative Id

API Name: Creative_ID

NinjaCat System ID: steelhouse:DIM_Creative_ID

Data Type: text

Aggregates To: DIM_CREATIVE_ID

Creative Name

API Name: Creative_Name

NinjaCat System ID: steelhouse:DIM_Creative_Name

Data Type: text

Currency

NinjaCat System ID: steelhouse:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: steelhouse:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: date

NinjaCat System ID: steelhouse:DIM_Date

Data Type: date

Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: steelhouse:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: steelhouse:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: steelhouse:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Month Of Year

NinjaCat System ID: steelhouse:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: steelhouse:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Quarter

NinjaCat System ID: steelhouse:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: steelhouse:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: steelhouse:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Week Of Year

NinjaCat System ID: steelhouse:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: steelhouse:DIM_Year

Data Type: text

Aggregates To: DIM_YEAR

Metrics (39)

Click Average Order Value

API Name: Click_Average_Order_Value

NinjaCat System ID: steelhouse:MET_Click_Average_Order_Value

Data Type: decimal

Display As: currency

Click Conversion Rate

API Name: Click_Conversion_Rate

NinjaCat System ID: steelhouse:MET_Click_Conversion_Rate

Data Type: decimal

Display As: percent

Click Conversions

API Name: Click_Conversions

NinjaCat System ID: steelhouse:MET_Click_Conversions

Data Type: integer

Aggregates To: MET_CLICK_CONVERSIONS

Click ECPA

API Name: Click_ECPA

NinjaCat System ID: steelhouse:MET_Click_ECPA

Data Type: decimal

Display As: currency

Click Rate

API Name: Click_Rate

NinjaCat System ID: steelhouse:MET_Click_Rate

Data Type: decimal

Display As: percent

Click ROAS

API Name: Click_ROAS

NinjaCat System ID: steelhouse:MET_Click_ROAS

Data Type: decimal

Display As: float

Clicks

API Name: Clicks

NinjaCat System ID: steelhouse:MET_Clicks

Data Type: integer

Aggregates To: MET_CLICKS

Click To Conversion Rate

API Name: Click_To_Conversion_Rate

NinjaCat System ID: steelhouse:MET_Click_To_Conversion_Rate

Data Type: decimal

Display As: percent

Click Total Order Value

API Name: Click_Total_Order_Value

NinjaCat System ID: steelhouse:MET_Click_Total_Order_Value

Data Type: decimal

Display As: percent

Conversion Rate

API Name: Conversion_Rate

NinjaCat System ID: steelhouse:MET_Conversion_Rate

Data Type: decimal

Display As: percent

Conversions

API Name: Conversions

NinjaCat System ID: steelhouse:MET_Conversions

Data Type: integer

Aggregates To: MET_CONVERSIONS

Conversions: Order Amount

API Name: Conversions_Order_Amount

NinjaCat System ID: steelhouse:MET_Conversions_Order_Amount

Data Type: integer

Cost Per Conversion

API Name: Cost_Per_Conversion

NinjaCat System ID: steelhouse:MET_Cost_Per_Conversion

Data Type: decimal

Display As: currency

Aggregates To: MET_CPA

Count (Unique Dimensions)

NinjaCat System ID: steelhouse:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

Estimated CPA

API Name: eCPA

NinjaCat System ID: steelhouse:MET_eCPA

Data Type: decimal

Display As: currency

Estimated CPM

API Name: eCPM

NinjaCat System ID: steelhouse:MET_eCPM

Data Type: decimal

Display As: currency

Impressions

API Name: Impressions

NinjaCat System ID: steelhouse:MET_Impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

Media Spend

API Name: Media_Spend

NinjaCat System ID: steelhouse:MET_Media_Spend

Data Type: decimal

Display As: currency

Aggregates To: MET_MEDIA_SPEND

Non PBC Spend

API Name: Non_Pbc_Spend

NinjaCat System ID: steelhouse:MET_Non_Pbc_Spend

Data Type: decimal

Display As: currency

Platform Spend

API Name: Platform_Spend

NinjaCat System ID: steelhouse:MET_Platform_Spend

Data Type: decimal

Display As: currency

Revenue Per Click

API Name: Revenue_Per_Click

NinjaCat System ID: steelhouse:MET_Revenue_Per_Click

Data Type: decimal

Display As: currency

Revenue Per User

API Name: Revenue_Per_User

NinjaCat System ID: steelhouse:MET_Revenue_Per_User

Data Type: decimal

Display As: currency

ROAS

API Name: ROAS

NinjaCat System ID: steelhouse:MET_ROAS

Data Type: decimal

Display As: float

Aggregates To: MET_ROAS

ROI

API Name: ROI

NinjaCat System ID: steelhouse:MET_ROI

Data Type: decimal

Display As: float

Spend

API Name: Spend

NinjaCat System ID: steelhouse:MET_Spend

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

Total Order Value

API Name: Total_Order_Value

NinjaCat System ID: steelhouse:MET_Total_Order_Value

Data Type: decimal

Display As: currency

Total Revenue

API Name: Total_Revenue

NinjaCat System ID: steelhouse:MET_Total_Revenue

Data Type: decimal

Display As: currency

Aggregates To: MET_TOTAL_REVENUE

Total Spend

API Name: Total_Spend

NinjaCat System ID: steelhouse:MET_Total_Spend

Data Type: integer

Aggregates To: MET_TOTAL_SPEND

User Conversion Rate

API Name: User_Conversion_Rate

NinjaCat System ID: steelhouse:MET_User_Conversion_Rate

Data Type: decimal

Display As: currency

View Average Order Value

API Name: View_Average_Order_Value

NinjaCat System ID: steelhouse:MET_View_Average_Order_Value

Data Type: decimal

Display As: currency

View Conversion Rate

API Name: View_Conversion_Rate

NinjaCat System ID: steelhouse:MET_View_Conversion_Rate

Data Type: decimal

Display As: percent

View Conversions

API Name: View_Conversions

NinjaCat System ID: steelhouse:MET_View_Conversions

Data Type: integer

Aggregates To: MET_VIEW_CONVERSIONS

View Cost Per Conversion

API Name: View_Cost_Per_Conversion

NinjaCat System ID: steelhouse:MET_View_Cost_Per_Conversion

Data Type: decimal

Display As: currency

View ECPA

API Name: View_ECPA

NinjaCat System ID: steelhouse:MET_View_ECPA

Data Type: decimal

Display As: currency

View Rate

API Name: View_Rate

NinjaCat System ID: steelhouse:MET_View_Rate

Data Type: decimal

Display As: percent

View Revenue Per User

API Name: View_Revenue_Per_User

NinjaCat System ID: steelhouse:MET_View_Revenue_Per_User

Data Type: decimal

Display As: currency

View ROAS

API Name: View_ROAS

NinjaCat System ID: steelhouse:MET_View_ROAS

Data Type: decimal

Display As: float

View ROI

API Name: View_ROI

NinjaCat System ID: steelhouse:MET_View_ROI

Data Type: decimal

Display As: float

View Total Order Value

API Name: View_Total_Order_Value

NinjaCat System ID: steelhouse:MET_View_Total_Order_Value

Data Type: decimal

Display As: currency