Guides
Shape Help Center

Criteo Fields

Suggest Edits

Dimensions (39)

Account

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

Ad

API Name: Ad
NinjaCat System ID: criteo:DIM_Ad
Data Type: text

Ad Id

API Name: AdId
NinjaCat System ID: criteo:DIM_AdId
Data Type: text

Ad Set

API Name: Adset
NinjaCat System ID: criteo:DIM_Adset
Data Type: text

Ad Set Id

API Name: AdsetId
NinjaCat System ID: criteo:DIM_AdsetId
Data Type: text

Advertiser

API Name: Advertiser
NinjaCat System ID: criteo:DIM_Advertiser
Data Type: text

Advertiser Id

API Name: AdvertiserId
NinjaCat System ID: criteo:DIM_advertiser_id
Data Type: text
Aggregates To: DIM_ACCOUNT

Campaign Group

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

Campaign Id

API Name: CampaignId
NinjaCat System ID: criteo:DIM_campaign_id
Data Type: text
Aggregates To: DIM_CAMPAIGN_ID

Campaign Name

API Name: Campaign
NinjaCat System ID: criteo:DIM_campaign_name
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Category Id

API Name: CategoryId
NinjaCat System ID: criteo:DIM_category_id
Data Type: text

Category Set

API Name: Category
NinjaCat System ID: criteo:DIM_category
Data Type: text

Channel

API Name: Channel
NinjaCat System ID: criteo:DIM_Channel
Data Type: text

Channel Id

API Name: ChannelId
NinjaCat System ID: criteo:DIM_ChannelId
Data Type: text

Countries

API Name: countries
NinjaCat System ID: criteo:DIM_countries
Data Type: text

Coupon

API Name: Coupon
NinjaCat System ID: criteo:DIM_Coupon
Data Type: text

Coupon Id

API Name: CouponId
NinjaCat System ID: criteo:DIM_CouponId
Data Type: text

Currency

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

Data Source

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

Date

API Name: Day
NinjaCat System ID: criteo:DIM_date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

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

Day Of Week

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

Delivery Status

API Name: deliveryStatus
NinjaCat System ID: criteo:DIM_deliveryStatus
Data Type: text

Device

API Name: Device
NinjaCat System ID: criteo:DIM_Device
Data Type: text

External Id

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

Hour

API Name: Hour
NinjaCat System ID: criteo:DIM_Hour
Data Type: text

Marketing Objective

API Name: MarketingObjective
NinjaCat System ID: criteo:DIM_objective
Data Type: text

Marketing Objective Id

API Name: MarketingObjectiveId
NinjaCat System ID: criteo:DIM_objectiveId
Data Type: text

Media Type

API Name: mediaType
NinjaCat System ID: criteo:DIM_mediaType
Data Type: text

Month Of Year

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

Network

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

Os

API Name: Os
NinjaCat System ID: criteo:DIM_Os
Data Type: text

Quarter

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

Regions

API Name: subdivisions
NinjaCat System ID: criteo:DIM_subdivisions
Data Type: text

Row

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

System Account ID

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

Week Of Year

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

Year

NinjaCat System ID: criteo:DIM_Year
Data Type: text
Aggregates To: DIM_YEAR

Zip Codes

API Name: zipCodes
NinjaCat System ID: criteo:DIM_zipCodes
Data Type: text

Metrics (45)

All Click Through Conversions

API Name: SalesAllPc30d
NinjaCat System ID: criteo:MET_SalesAllPc
Data Type: integer

Audience

API Name: Audience
NinjaCat System ID: criteo:MET_Audience
Data Type: integer

Average Cart

NinjaCat System ID: criteo:MET_average_cart
Data Type: decimal
Display As: percent
Formula: criteo:MET_ExposedUsers / criteo:MET_Audience

Bounce Rate

API Name: BounceRate
NinjaCat System ID: criteo:MET_bouncerate
Data Type: decimal
Display As: percent
Aggregates To: MET_BOUNCE_RATE

Clicks

API Name: Clicks
NinjaCat System ID: criteo:MET_clicks
Data Type: integer
Aggregates To: MET_CLICKS

Click Through Conversion Rate

NinjaCat System ID: criteo:MET_click_conversion_rate
Data Type: decimal
Display As: percent
Formula: criteo:MET_SalesPc / criteo:MET_ActionLeadingToConv

Click Through Conversions (1d)

API Name: SalesPc1d
NinjaCat System ID: criteo:MET_SalesPc1d
Data Type: integer

Click Through Conversions (30d)

API Name: SalesPc30d
NinjaCat System ID: criteo:MET_SalesPc
Data Type: integer
Aggregates To: MET_CLICK_THROUGH_CONVERSIONS

Click Through Conversions (7d)

API Name: SalesPc7d
NinjaCat System ID: criteo:MET_SalesPc7d
Data Type: integer

Click Through Conversions - Same Device

Deprecated: 2024-11-07T01:28:37.866Z
API Name: SameSalesPc
NinjaCat System ID: criteo:MET_SameSalesPc
Data Type: integer

Click Through Revenue (1d)

API Name: RevenueGeneratedPc1d
NinjaCat System ID: criteo:MET_RevenueGeneratedPc1d
Data Type: decimal
Display As: currency

Click Through Revenue (30d)

API Name: RevenueGeneratedPc30d
NinjaCat System ID: criteo:MET_RevenueGeneratedPc
Data Type: decimal
Display As: currency

Click Through Revenue (7d)

API Name: RevenueGeneratedPc7d
NinjaCat System ID: criteo:MET_RevenueGeneratedPc7d
Data Type: decimal
Display As: currency

Conversions (pc30d pv24h)

API Name: SalesPc30dPv24h
NinjaCat System ID: criteo:MET_SalesPcPv
Data Type: integer
Aggregates To: MET_CONVERSIONS

Conv. Rate

NinjaCat System ID: criteo:MET_conversion_rate
Data Type: decimal
Display As: percent
Aggregates To: MET_CONVERSION_RATE
Formula: criteo:MET_SalesAllPc / criteo:MET_ActionLeadingToConv

COS

NinjaCat System ID: criteo:MET_cos
Data Type: decimal
Display As: currency
Formula: criteo:MET_RevenueGeneratedPcPv / criteo:MET_advertiser_cost

Cost

API Name: AdvertiserCost
NinjaCat System ID: criteo:MET_advertiser_cost
Data Type: decimal
Display As: currency
Aggregates To: MET_COST

Cost / Conv.

NinjaCat System ID: criteo:MET_cpa
Data Type: decimal
Display As: currency
Aggregates To: MET_CPA
Formula: criteo:MET_advertiser_cost / criteo:MET_SalesAllPc

Count (Unique Dimensions)

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

CPC

NinjaCat System ID: criteo:MET_cpc
Data Type: decimal
Display As: currency
Aggregates To: MET_CPC
Formula: criteo:MET_advertiser_cost / criteo:MET_clicks

CPM

NinjaCat System ID: criteo:MET_cpm
Data Type: decimal
Display As: currency
Aggregates To: MET_CPM
Formula: 1000 * criteo:MET_advertiser_cost / criteo:MET_impressions

CTR

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

Exposed Users

API Name: ExposedUsers
NinjaCat System ID: criteo:MET_ExposedUsers
Data Type: integer

Frequency

NinjaCat System ID: criteo:MET_frequency
Data Type: decimal
Display As: percent
Formula: criteo:MET_impressions / criteo:MET_ExposedUsers

Impressions

API Name: Displays
NinjaCat System ID: criteo:MET_impressions
Data Type: integer
Aggregates To: MET_IMPRESSIONS

Non Viewable Displays

API Name: NonViewableDisplays
NinjaCat System ID: criteo:MET_nonviewabledisplays
Data Type: integer

Overall Competition Win

NinjaCat System ID: criteo:MET_OverallCompetitionWin
Data Type: decimal
Display As: percent
Formula: criteo:MET_impressions / criteo:MET_potentialdisplays

Potential Displays

API Name: PotentialDisplays
NinjaCat System ID: criteo:MET_potentialdisplays
Data Type: integer

Qualified Visits

API Name: QualifiedVisits
NinjaCat System ID: criteo:MET_qualifiedvisits
Data Type: integer

Reach

NinjaCat System ID: criteo:MET_reach
Data Type: decimal
Display As: percent
Formula: criteo:MET_RevenueGeneratedPcPv / criteo:MET_SalesPcPv

Reach

API Name: Reach
NinjaCat System ID: criteo:MET_Reach
Data Type: integer

Revenue Generated Client Attribution

API Name: RevenueGeneratedClientAttribution
NinjaCat System ID: criteo:MET_RevenueGeneratedClientAttribution
Data Type: decimal
Display As: currency

Revenue (pc30d pv24h)

API Name: RevenueGeneratedPc30dPv24h
NinjaCat System ID: criteo:MET_RevenueGeneratedPcPv
Data Type: decimal
Display As: currency
Aggregates To: MET_REVENUE

ROAS

NinjaCat System ID: criteo:MET_roas
Data Type: decimal
Display As: currency
Formula: criteo:MET_RevenueGeneratedPcPv / criteo:MET_advertiser_cost

Sales Client Attribution

API Name: SalesClientAttribution
NinjaCat System ID: criteo:MET_SalesClientAttribution
Data Type: integer

Unique Click Through Conversions

Deprecated: 2024-11-07T01:28:37.866Z
API Name: SalesPcNd
NinjaCat System ID: criteo:MET_SalesPcNd
Data Type: integer
Is Unique: True

Unique Click Through Revenue

Deprecated: 2024-11-07T01:28:37.866Z
API Name: RevenueGeneratedPcNd
NinjaCat System ID: criteo:MET_RevenueGeneratedPcNd
Data Type: decimal
Is Unique: True
Display As: currency

Unique View Through Conversions

Deprecated: 2024-11-07T01:28:37.866Z
API Name: SalesPvNd
NinjaCat System ID: criteo:MET_SalesPvNd
Data Type: integer
Is Unique: True

Unique View Through Revenue

Deprecated: 2024-11-07T01:28:37.866Z
API Name: RevenueGeneratedPvNd
NinjaCat System ID: criteo:MET_RevenueGeneratedPvNd
Data Type: decimal
Is Unique: True
Display As: currency

Untracked Displays

API Name: UntrackableDisplays
NinjaCat System ID: criteo:MET_untrackeddisplays
Data Type: integer

Viewable Displays

API Name: ViewableDisplays
NinjaCat System ID: criteo:MET_viewabledisplays
Data Type: integer

View Through Conversion Rate

NinjaCat System ID: criteo:MET_view_conversion_rate
Data Type: decimal
Display As: percent
Formula: criteo:MET_SalesPv / criteo:MET_ActionLeadingToConv

View Through Conversions (24h)

API Name: SalesPv24h
NinjaCat System ID: criteo:MET_SalesPv
Data Type: integer
Aggregates To: MET_VIEW_THROUGH_CONVERSIONS

View Through Revenue (24h)

API Name: RevenueGeneratedPv24h
NinjaCat System ID: criteo:MET_RevenueGeneratedPv
Data Type: decimal
Display As: currency

Visits

API Name: Visits
NinjaCat System ID: criteo:MET_visits
Data Type: integer
Aggregates To: MET_VISITS

Updated 4 months ago