The TradeDesk Fields

Suggest Edits

Dimensions (19)

Account

NinjaCat System ID: the_trade_desk:DIM_ACCOUNT

Data Type: text

Aggregates To: DIM_ACCOUNT

Ad Format

API Name: Ad Format

NinjaCat System ID: the_trade_desk:DIM_AD_FORMAT

Data Type: text

Ad Group Name

API Name: Ad Group Name

NinjaCat System ID: the_trade_desk:DIM_AD_GROUP

Data Type: text

Aggregates To: DIM_AD_GROUP_NAME

Campaign Group

NinjaCat System ID: the_trade_desk:DIM_CampaignGroup

Data Type: text

Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign Name

API Name: Campaign Name

NinjaCat System ID: the_trade_desk:DIM_CAMPAIGN

Data Type: text

Aggregates To: DIM_CAMPAIGN_NAME

Creative

API Name: Creative Name

NinjaCat System ID: the_trade_desk:DIM_CREATIVE

Data Type: text

Currency

NinjaCat System ID: the_trade_desk:DIM_CURRENCY

Data Type: text

Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: the_trade_desk:DIM_DATA_SOURCE

Data Type: text

Aggregates To: DIM_DATA_SOURCE

Date

API Name: Date

NinjaCat System ID: the_trade_desk:DIM_DATE

Data Type: date

Aggregates To: DIM_DATE

Day of Month

NinjaCat System ID: the_trade_desk:DIM_DAY_OF_MONTH

Data Type: integer

Aggregates To: DIM_DAY_OF_MONTH

Day of Week

NinjaCat System ID: the_trade_desk:DIM_DAY_OF_WEEK

Data Type: text

Display As: day_of_week

Aggregates To: DIM_DAY_OF_WEEK

External Id

NinjaCat System ID: the_trade_desk:DIM_EXTERNAL_ID

Data Type: text

Aggregates To: DIM_EXTERNAL_ID

Month of Year

NinjaCat System ID: the_trade_desk:DIM_MONTH_OF_YEAR

Data Type: text

Display As: date_month_of_year

Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: the_trade_desk:DIM_NETWORK

Data Type: text

Display As: title_case

Aggregates To: DIM_NETWORK

Quarter

NinjaCat System ID: the_trade_desk:DIM_QUARTER

Data Type: text

Display As: quarter

Aggregates To: DIM_QUARTER

Row

NinjaCat System ID: the_trade_desk:DIM_ROW

Data Type: text

Aggregates To: DIM_ROW

System Account ID

NinjaCat System ID: the_trade_desk:DIM_ACCOUNT_ID

Data Type: text

Aggregates To: DIM_ACCOUNT_ID

Week of Year

NinjaCat System ID: the_trade_desk:DIM_WEEK_OF_YEAR

Data Type: text

Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: the_trade_desk:DIM_YEAR

Data Type: text

Aggregates To: DIM_YEAR

Metrics (91)

Clicks

API Name: Clicks

NinjaCat System ID: the_trade_desk:MET_Clicks

Data Type: integer

Aggregates To: MET_CLICKS

Conversions

NinjaCat System ID: the_trade_desk:MET_Conversions

Data Type: integer

Aggregates To: MET_CONVERSIONS

Formula: the_trade_desk:MET_PC_1 + the_trade_desk:MET_PC_2 + the_trade_desk:MET_PC_3 + the_trade_desk:MET_PC_4 + the_trade_desk:MET_PC_5 + the_trade_desk:MET_PC_6 + the_trade_desk:MET_PI_1 + the_trade_desk:MET_PI_2 + the_trade_desk:MET_PI_3 + the_trade_desk:MET_PI_4 + the_trade_desk:MET_PI_5 + the_trade_desk:MET_PI_6

Conv. Rate

NinjaCat System ID: the_trade_desk:MET_ConversionRate

Data Type: decimal

Display As: percent

Aggregates To: MET_CONVERSION_RATE

Formula: the_trade_desk:MET_Conversions / the_trade_desk:MET_ActionLeadingToConv

Cost

API Name: Advertiser Total Cost

NinjaCat System ID: the_trade_desk:MET_Cost

Data Type: decimal

Display As: currency

Aggregates To: MET_COST

Cost / Conv.

NinjaCat System ID: the_trade_desk:MET_CostPerConversion

Data Type: decimal

Display As: currency

Aggregates To: MET_CPA

Formula: the_trade_desk:MET_Cost / the_trade_desk:MET_Conversions

Cost / PC Conversion

NinjaCat System ID: the_trade_desk:MET_CostPerPC

Data Type: decimal

Display As: currency

Formula: the_trade_desk:MET_Cost / the_trade_desk:MET_PCConversions

Cost / PI Conversion

NinjaCat System ID: the_trade_desk:MET_CostPerPI

Data Type: decimal

Display As: currency

Formula: the_trade_desk:MET_Cost / the_trade_desk:MET_PIConversions

Count (Unique Dimensions)

NinjaCat System ID: the_trade_desk:MET_COUNT_NC

Data Type: integer

Aggregates To: MET_COUNT_NC

CPC

NinjaCat System ID: the_trade_desk:MET_Cpc

Data Type: decimal

Display As: currency

Aggregates To: MET_CPC

Formula: the_trade_desk:MET_Cost / the_trade_desk:MET_Clicks

CPM

NinjaCat System ID: the_trade_desk:MET_Cpm

Data Type: decimal

Display As: currency

Aggregates To: MET_CPM

Formula: 1000 * the_trade_desk:MET_Cost / the_trade_desk:MET_Impressions

Creative Is Trackable

API Name: CreativeIsTrackable

NinjaCat System ID: the_trade_desk:MET_CreativeIsTrackable

Data Type: integer

Creative was Viewable

API Name: CreativeWasViewable

NinjaCat System ID: the_trade_desk:MET_CreativeWasViewable

Data Type: integer

CTA 1

API Name: CTA 1

NinjaCat System ID: the_trade_desk:MET_CTA_1

Data Type: integer

CTA 1 Revenue

API Name: CTA 1 Rev

NinjaCat System ID: the_trade_desk:MET_CTA_1_Rev

Data Type: decimal

Display As: currency

CTA 2

API Name: CTA 2

NinjaCat System ID: the_trade_desk:MET_CTA_2

Data Type: integer

CTA 2 Revenue

API Name: CTA 2 Rev

NinjaCat System ID: the_trade_desk:MET_CTA_2_Rev

Data Type: decimal

Display As: currency

CTA 3

API Name: CTA 3

NinjaCat System ID: the_trade_desk:MET_CTA_3

Data Type: integer

CTA 3 Revenue

API Name: CTA 3 Rev

NinjaCat System ID: the_trade_desk:MET_CTA_3_Rev

Data Type: decimal

Display As: currency

CTA 4

API Name: CTA 4

NinjaCat System ID: the_trade_desk:MET_CTA_4

Data Type: integer

CTA 4 Revenue

API Name: CTA 4 Rev

NinjaCat System ID: the_trade_desk:MET_CTA_4_Rev

Data Type: decimal

Display As: currency

CTA 5

API Name: CTA 5

NinjaCat System ID: the_trade_desk:MET_CTA_5

Data Type: integer

CTA 5 Revenue

API Name: CTA 5 Rev

NinjaCat System ID: the_trade_desk:MET_CTA_5_Rev

Data Type: decimal

Display As: currency

CTA 6

API Name: CTA 6

NinjaCat System ID: the_trade_desk:MET_CTA_6

Data Type: integer

CTA 6 Revenue

API Name: CTA 6 Rev

NinjaCat System ID: the_trade_desk:MET_CTA_6_Rev

Data Type: decimal

Display As: currency

CTR

NinjaCat System ID: the_trade_desk:MET_Ctr

Data Type: decimal

Display As: percent

Aggregates To: MET_CTR

Formula: the_trade_desk:MET_Clicks / the_trade_desk:MET_Impressions

Impressions

API Name: Imps

NinjaCat System ID: the_trade_desk:MET_Impressions

Data Type: integer

Aggregates To: MET_IMPRESSIONS

PC 1

API Name: PC 1

NinjaCat System ID: the_trade_desk:MET_PC_1

Data Type: integer

PC 1 Revenue

API Name: PC 1 Rev

NinjaCat System ID: the_trade_desk:MET_PC_1_Rev

Data Type: decimal

Display As: currency

PC 2

API Name: PC 2

NinjaCat System ID: the_trade_desk:MET_PC_2

Data Type: integer

PC 2 Revenue

API Name: PC 2 Rev

NinjaCat System ID: the_trade_desk:MET_PC_2_Rev

Data Type: decimal

Display As: currency

PC 3

API Name: PC 3

NinjaCat System ID: the_trade_desk:MET_PC_3

Data Type: integer

PC 3 Revenue

API Name: PC 3 Rev

NinjaCat System ID: the_trade_desk:MET_PC_3_Rev

Data Type: decimal

Display As: currency

PC 4

API Name: PC 4

NinjaCat System ID: the_trade_desk:MET_PC_4

Data Type: integer

PC 4 Revenue

API Name: PC 4 Rev

NinjaCat System ID: the_trade_desk:MET_PC_4_Rev

Data Type: decimal

Display As: currency

PC 5

API Name: PC 5

NinjaCat System ID: the_trade_desk:MET_PC_5

Data Type: integer

PC 5 Revenue

API Name: PC 5 Rev

NinjaCat System ID: the_trade_desk:MET_PC_5_Rev

Data Type: decimal

Display As: currency

PC 6

API Name: PC 6

NinjaCat System ID: the_trade_desk:MET_PC_6

Data Type: integer

PC 6 Revenue

API Name: PC 6 Rev

NinjaCat System ID: the_trade_desk:MET_PC_6_Rev

Data Type: decimal

Display As: currency

PC Conversions

NinjaCat System ID: the_trade_desk:MET_PCConversions

Data Type: integer

Formula: the_trade_desk:MET_PC_1 + the_trade_desk:MET_PC_2 + the_trade_desk:MET_PC_3 + the_trade_desk:MET_PC_4 + the_trade_desk:MET_PC_5 + the_trade_desk:MET_PC_6

PC Revenue

NinjaCat System ID: the_trade_desk:MET_PCRevenue

Data Type: decimal

Display As: currency

Formula: the_trade_desk:MET_PC_1_Rev + the_trade_desk:MET_PC_2_Rev + the_trade_desk:MET_PC_3_Rev + the_trade_desk:MET_PC_4_Rev + the_trade_desk:MET_PC_5_Rev + the_trade_desk:MET_PC_6_Rev

PC Revenue / PC Conversion

NinjaCat System ID: the_trade_desk:MET_PCRevenuePerConversion

Data Type: decimal

Display As: currency

Formula: the_trade_desk:MET_PCRevenue / the_trade_desk:MET_PCConversions

PI 1

API Name: PI 1

NinjaCat System ID: the_trade_desk:MET_PI_1

Data Type: integer

PI 1 Revenue

API Name: PI 1 Rev

NinjaCat System ID: the_trade_desk:MET_PI_1_Rev

Data Type: decimal

Display As: currency

PI 2

API Name: PI 2

NinjaCat System ID: the_trade_desk:MET_PI_2

Data Type: integer

PI 2 Revenue

API Name: PI 2 Rev

NinjaCat System ID: the_trade_desk:MET_PI_2_Rev

Data Type: decimal

Display As: currency

PI 3

API Name: PI 3

NinjaCat System ID: the_trade_desk:MET_PI_3

Data Type: integer

PI 3 Revenue

API Name: PI 3 Rev

NinjaCat System ID: the_trade_desk:MET_PI_3_Rev

Data Type: decimal

Display As: currency

PI 4

API Name: PI 4

NinjaCat System ID: the_trade_desk:MET_PI_4

Data Type: integer

PI 4 Revenue

API Name: PI 4 Rev

NinjaCat System ID: the_trade_desk:MET_PI_4_Rev

Data Type: decimal

Display As: currency

PI 5

API Name: PI 5

NinjaCat System ID: the_trade_desk:MET_PI_5

Data Type: integer

PI 5 Revenue

API Name: PI 5 Rev

NinjaCat System ID: the_trade_desk:MET_PI_5_Rev

Data Type: decimal

Display As: currency

PI 6

API Name: PI 6

NinjaCat System ID: the_trade_desk:MET_PI_6

Data Type: integer

PI 6 Revenue

API Name: PI 6 Rev

NinjaCat System ID: the_trade_desk:MET_PI_6_Rev

Data Type: decimal

Display As: currency

PI Conversions

NinjaCat System ID: the_trade_desk:MET_PIConversions

Data Type: integer

Formula: the_trade_desk:MET_PI_1 + the_trade_desk:MET_PI_2 + the_trade_desk:MET_PI_3 + the_trade_desk:MET_PI_4 + the_trade_desk:MET_PI_5 + the_trade_desk:MET_PI_6

PI Revenue

NinjaCat System ID: the_trade_desk:MET_PIRevenue

Data Type: decimal

Display As: currency

Formula: the_trade_desk:MET_PI_1_Rev + the_trade_desk:MET_PI_2_Rev + the_trade_desk:MET_PI_3_Rev + the_trade_desk:MET_PI_4_Rev + the_trade_desk:MET_PI_5_Rev + the_trade_desk:MET_PI_6_Rev

PI Revenue / PI Conversion

NinjaCat System ID: the_trade_desk:MET_PIRevenuePerConversion

Data Type: decimal

Display As: currency

Formula: the_trade_desk:MET_PIRevenue / the_trade_desk:MET_PIConversions

Revenue

NinjaCat System ID: the_trade_desk:MET_Revenue

Data Type: decimal

Display As: currency

Formula: the_trade_desk:MET_PC_1_Rev + the_trade_desk:MET_PC_2_Rev + the_trade_desk:MET_PC_3_Rev + the_trade_desk:MET_PC_4_Rev + the_trade_desk:MET_PC_5_Rev + the_trade_desk:MET_PC_6_Rev + the_trade_desk:MET_PI_1_Rev + the_trade_desk:MET_PI_2_Rev + the_trade_desk:MET_PI_3_Rev + the_trade_desk:MET_PI_4_Rev + the_trade_desk:MET_PI_5_Rev + the_trade_desk:MET_PI_6_Rev

Revenue / Conversion

NinjaCat System ID: the_trade_desk:MET_RevenuePerConversion

Data Type: decimal

Display As: currency

Formula: the_trade_desk:MET_Revenue / the_trade_desk:MET_Conversions

TWD 1

API Name: TWD 1

NinjaCat System ID: the_trade_desk:MET_TWD_1

Data Type: integer

TWD 1 Revenue

API Name: TWD 1 Rev

NinjaCat System ID: the_trade_desk:MET_TWD_1_Rev

Data Type: decimal

Display As: currency

TWD 2

API Name: TWD_2

NinjaCat System ID: the_trade_desk:MET_TWD_2

Data Type: integer

TWD 2 Revenue

API Name: TWD 2 Rev

NinjaCat System ID: the_trade_desk:MET_TWD_2_Rev

Data Type: decimal

Display As: currency

TWD 3

API Name: TWD 3

NinjaCat System ID: the_trade_desk:MET_TWD_3

Data Type: integer

TWD 3 Revenue

API Name: TWD 3 Rev

NinjaCat System ID: the_trade_desk:MET_TWD_3_Rev

Data Type: decimal

Display As: currency

TWD 4

API Name: TWD 4

NinjaCat System ID: the_trade_desk:MET_TWD_4

Data Type: integer

TWD 4 Revenue

API Name: TWD 4 Rev

NinjaCat System ID: the_trade_desk:MET_TWD_4_Rev

Data Type: decimal

Display As: currency

TWD 5

API Name: TWD_5

NinjaCat System ID: the_trade_desk:MET_TWD_5

Data Type: integer

TWD 5 Revenue

API Name: TWD 5 Rev

NinjaCat System ID: the_trade_desk:MET_TWD_5_Rev

Data Type: decimal

Display As: currency

TWD 6

API Name: TWD 6

NinjaCat System ID: the_trade_desk:MET_TWD_6

Data Type: integer

TWD 6 Revenue

API Name: TWD 6 Rev

NinjaCat System ID: the_trade_desk:MET_TWD_6_Rev

Data Type: decimal

Display As: currency

Video Closes

API Name: VideoEventClose

NinjaCat System ID: the_trade_desk:MET_VideoEventClose

Data Type: integer

Video Collapses

API Name: VideoEventCollapse

NinjaCat System ID: the_trade_desk:MET_VideoEventCollapse

Data Type: integer

Video Completion Rate

NinjaCat System ID: the_trade_desk:MET_VideoCompRate

Data Type: decimal

Display As: percent

Formula: the_trade_desk:MET_Cost / the_trade_desk:MET_PCConversions

Video Errors

API Name: VideoEventError

NinjaCat System ID: the_trade_desk:MET_VideoEventError

Data Type: integer

Video Expands

API Name: VideoEventExpand

NinjaCat System ID: the_trade_desk:MET_VideoEventExpand

Data Type: integer

Video Full Screens

API Name: VideoEventFullscreen

NinjaCat System ID: the_trade_desk:MET_VideoEventFullscreen

Data Type: integer

Video Invite Accepts

API Name: VideoEventAcceptInvitation

NinjaCat System ID: the_trade_desk:MET_VideoEventAcceptInvitation

Data Type: integer

Video Mutes

API Name: VideoEventMute

NinjaCat System ID: the_trade_desk:MET_VideoEventMute

Data Type: integer

Video Pauses

API Name: VideoEventPause

NinjaCat System ID: the_trade_desk:MET_VideoEventPause

Data Type: integer

Video Resumes

API Name: VideoEventResume

NinjaCat System ID: the_trade_desk:MET_VideoEventResume

Data Type: integer

Video Rewinds

API Name: VideoEventRewind

NinjaCat System ID: the_trade_desk:MET_VideoEventRewind

Data Type: integer

Video Skips

API Name: VideoEventSkip

NinjaCat System ID: the_trade_desk:MET_VideoEventSkip

Data Type: integer

Video Starts

API Name: VideoEventStart

NinjaCat System ID: the_trade_desk:MET_VideoEventStart

Data Type: integer

Aggregates To: MET_VIDEO_STARTS

Video Unmutes

API Name: VideoEventUnmute

NinjaCat System ID: the_trade_desk:MET_VideoEventUnmute

Data Type: integer

Video Views

API Name: VideoEventCreativeView

NinjaCat System ID: the_trade_desk:MET_VideoEventCreativeView

Data Type: integer

Aggregates To: MET_VIDEO_VIEWS

Video Views 100%

API Name: VideoEventComplete

NinjaCat System ID: the_trade_desk:MET_VideoEventComplete

Data Type: integer

Video Views 25%

API Name: VideoEventFirstQuarter

NinjaCat System ID: the_trade_desk:MET_VideoEventFirstQuarter

Data Type: integer

Video Views 50%

API Name: VideoEventMidpoint

NinjaCat System ID: the_trade_desk:MET_VideoEventMidpoint

Data Type: integer

Video Views 75%

API Name: VideoEventThirdQuarter

NinjaCat System ID: the_trade_desk:MET_VideoEventThirdQuarter

Data Type: integer

Video Views Engaged

API Name: VideoEventEngagedView

NinjaCat System ID: the_trade_desk:MET_VideoEventEngagedView

Data Type: integer

Viewability

NinjaCat System ID: the_trade_desk:MET_Viewability

Data Type: decimal

Display As: percent

Formula: the_trade_desk:MET_CreativeWasViewable / the_trade_desk:MET_CreativeIsTrackable

Updated 6 months ago