Koddi Fields

Suggest Edits

Dimensions (27)

Ad Group ID

API Name: ad_group_id

NinjaCat System ID: koddi:DIM_ad_group_id

Data Type: text

Ad Group Name

API Name: ad_group_name

NinjaCat System ID: koddi:DIM_ad_group_name

Data Type: text

Aggregates To: DIM_AD_GROUP_NAME

Ad Group Status

API Name: ad_group|status

NinjaCat System ID: koddi:DIM_ad_group_status

Data Type: text

Advertiser

API Name: advertiser_name

NinjaCat System ID: koddi:DIM_advertiser

Data Type: text

Aggregates To: DIM_ACCOUNT

Advertiser ID

API Name: advertiser_id

NinjaCat System ID: koddi:DIM_advertiser_id

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Budget End Date (Ad Group)

API Name: ad_group|budget_end_date

NinjaCat System ID: koddi:DIM_ad_group_budget_end_date

Data Type: text

Display As: date

Budget End Date (Campaign)

API Name: campaign_budget|budget_end_date

NinjaCat System ID: koddi:DIM_campaign_budget_end_date

Data Type: text

Display As: date

Budget Start Date (Ad Group)

API Name: ad_group|budget_start_date

NinjaCat System ID: koddi:DIM_ad_group_budget_start_date

Data Type: text

Display As: date

Budget Start Date (Campaign)

API Name: campaign_budget|budget_start_date

NinjaCat System ID: koddi:DIM_campaign_budget_start_date

Data Type: text

Display As: date

Campaign End Date

API Name: campaign|end_date

NinjaCat System ID: koddi:DIM_campaign_end_date

Data Type: text

Display As: date

Campaign ID

API Name: campaign_id

NinjaCat System ID: koddi:DIM_campaign_id

Data Type: text

Campaign Name

API Name: campaign_name

NinjaCat System ID: koddi:DIM_campaign_Name

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Campaign Start Date

API Name: campaign|start_date

NinjaCat System ID: koddi:DIM_campaign_start_date

Data Type: text

Display As: date

Campaign Status

API Name: campaign|status

NinjaCat System ID: koddi:DIM_campaign_status

Data Type: text

Conversion Source

API Name: conversion_source

NinjaCat System ID: koddi:DIM_conversion_source

Data Type: text

Data Source

NinjaCat System ID: koddi:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: daily_date

NinjaCat System ID: koddi:DIM_date

Data Type: date

Aggregates To: DIM_DATE

Device Type

API Name: device_type

NinjaCat System ID: koddi:DIM_device_type

Data Type: text

Aggregates To: DIM_DEVICE_TYPE

Entity ID

API Name: entity_id

NinjaCat System ID: koddi:DIM_entity_id

Data Type: text

Entity Name

API Name: entity_name

NinjaCat System ID: koddi:DIM_entity_name

Data Type: text

Internal Entity ID

API Name: internal_entity_id

NinjaCat System ID: koddi:DIM_internal_entity_id

Data Type: text

Make

API Name: MAKE

NinjaCat System ID: koddi:DIM_MAKE

Data Type: text

Model

API Name: MODEL

NinjaCat System ID: koddi:DIM_MODEL

Data Type: text

Rank

API Name: rank

NinjaCat System ID: koddi:DIM_rank

Data Type: text

Row

NinjaCat System ID: koddi:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

Site ID

API Name: site_id

NinjaCat System ID: koddi:DIM_site_id

Data Type: text

Stock Type

API Name: STOCK_TYPE

NinjaCat System ID: koddi:DIM_STOCK_TYPE

Data Type: text

Metrics (25)

Average Basket Size

API Name: average_basket_size

NinjaCat System ID: koddi:MET_average_basket_size

Data Type: decimal

Is Unique: True

Display As: float

Average Rank

API Name: average_rank

NinjaCat System ID: koddi:MET_average_rank

Data Type: decimal

Is Unique: True

Display As: float

Clicks

API Name: clicks

NinjaCat System ID: koddi:MET_clicks

Data Type: decimal

Display As: integer

Aggregates To: MET_CLICKS

Conversions

API Name: transactions

NinjaCat System ID: koddi:MET_conversions

Data Type: decimal

Display As: integer

Aggregates To: MET_CONVERSIONS

Cost

API Name: cost

NinjaCat System ID: koddi:MET_cost

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

Cost Per Conversion

NinjaCat System ID: koddi:MET_cost_per_conversion

Data Type: decimal

Display As: currency

Aggregates To: MET_COST_PER_CONVERSION

Formula: (koddi:MET_cost / koddi:MET_conversions)

CPC

NinjaCat System ID: koddi:MET_CPC

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: (koddi:MET_cost / koddi:MET_clicks)

CTR

NinjaCat System ID: koddi:MET_CTR

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: (koddi:MET_clicks / koddi:MET_impressions)

Exposed Revenue

API Name: exposed_revenue

NinjaCat System ID: koddi:MET_exposed_revenue

Data Type: decimal

Display As: currency

Exposed ROAS

API Name: exposed_roas

NinjaCat System ID: koddi:MET_exposed_roas

Data Type: decimal

Display As: float

Exposed Transactions

API Name: exposed_transactions

NinjaCat System ID: koddi:MET_exposed_transactions

Data Type: integer

Exposed Units

API Name: exposed_units

NinjaCat System ID: koddi:MET_exposed_units

Data Type: integer

Halo Exposed Transactions

API Name: halo_exposed_transactions

NinjaCat System ID: koddi:MET_halo_exposed_transactions

Data Type: integer

Halo Exposed Units

API Name: halo_exposed_units

NinjaCat System ID: koddi:MET_halo_exposed_units

Data Type: integer

Halo Revenue

API Name: halo_exposed_revenue

NinjaCat System ID: koddi:MET_halo_exposed_revenue

Data Type: decimal

Display As: currency

Halo Revenue

API Name: halo_revenue

NinjaCat System ID: koddi:MET_halo_revenue

Data Type: decimal

Display As: currency

Halo ROAS

API Name: halo_roas

NinjaCat System ID: koddi:MET_halo_exposed_roas

Data Type: decimal

Display As: float

Halo ROAS

API Name: halo_roas

NinjaCat System ID: koddi:MET_halo_roas

Data Type: decimal

Display As: float

Halo Transactions

API Name: halo_transactions

NinjaCat System ID: koddi:MET_halo_transactions

Data Type: integer

Halo Units

API Name: halo_units

NinjaCat System ID: koddi:MET_halo_units

Data Type: integer

Impressions

API Name: impressions

NinjaCat System ID: koddi:MET_impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

Revenue

API Name: revenue

NinjaCat System ID: koddi:MET_revenue

Data Type: decimal

Display As: currency

ROAS

NinjaCat System ID: koddi:MET_return_on_ad_spend

Data Type: decimal

Display As: float

Formula: (koddi:MET_revenue / koddi:MET_cost)

Transactions

API Name: transactions

NinjaCat System ID: koddi:MET_transactions

Data Type: integer

Units

API Name: units

NinjaCat System ID: koddi:MET_units

Data Type: integer

Updated 4 months ago