Guides
Shape Help Center

Yahoo Gemini Fields

Suggest Edits

Dimensions (43)

Account

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

Ad

API Name: Ad Title
NinjaCat System ID: yahoo_gemini:DIM_Ad
Data Type: text
Aggregates To: DIM_AD_NAME,DIM_AD

Ad Final Url

API Name: Ad Final URL
NinjaCat System ID: yahoo_gemini:DIM_AdFinalUrl
Data Type: text
Display As: url

AdGroup

API Name: Ad Group Name
NinjaCat System ID: yahoo_gemini:DIM_AdGroup
Data Type: text
Aggregates To: DIM_AD_GROUP_NAME

Ad Id

API Name: Ad ID
NinjaCat System ID: yahoo_gemini:DIM_AdId
Data Type: text
Aggregates To: DIM_AD_ID

Ad Landing Url

API Name: Ad Landing URL
NinjaCat System ID: yahoo_gemini:DIM_AdLandingUrl
Data Type: text
Display As: url

Ad Mobile Final Url

API Name: Ad Mobile Final URL
NinjaCat System ID: yahoo_gemini:DIM_AdMobileFinalUrl
Data Type: text
Display As: url

Advertiser Id

API Name: Advertiser ID
NinjaCat System ID: yahoo_gemini:DIM_AdvertiserId
Data Type: text
Aggregates To: DIM_ADVERTISER_ID

Age

API Name: Age
NinjaCat System ID: yahoo_gemini:DIM_Age
Data Type: text

Average Bid

API Name: Average Bid
NinjaCat System ID: yahoo_gemini:DIM_Average_Bid
Data Type: decimal
Display As: currency

Bid Modifier

API Name: Bid Modifier
NinjaCat System ID: yahoo_gemini:DIM_Bid_Modifier
Data Type: text

Campaign

API Name: Campaign Name
NinjaCat System ID: yahoo_gemini:DIM_Campaign
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Campaign Group

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

Category Name

API Name: Category Name
NinjaCat System ID: yahoo_gemini:DIM_Category_Name
Data Type: text

City

API Name: City
NinjaCat System ID: yahoo_gemini:DIM_City
Data Type: text
Aggregates To: DIM_CITY

Conversion Device

API Name: Conversion Device
NinjaCat System ID: yahoo_gemini:DIM_Conversion_Device
Data Type: text

Country

API Name: Country
NinjaCat System ID: yahoo_gemini:DIM_Country
Data Type: text
Display As: country
Aggregates To: DIM_COUNTRIES,DIM_COUNTRY

Currency

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

Data Source

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

Date

API Name: Day
NinjaCat System ID: yahoo_gemini:DIM_Date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

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

Day Of Week

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

Delivered Match Type

API Name: Delivered Match Type
NinjaCat System ID: yahoo_gemini:DIM_Delivered_Match_Type
Data Type: text

Destination URL

API Name: Destination URL
NinjaCat System ID: yahoo_gemini:DIM_Destination_URL
Data Type: text
Display As: url

Device

API Name: Device Type
NinjaCat System ID: yahoo_gemini:DIM_Device
Data Type: text
Aggregates To: DIM_DEVICE_TYPE

External Id

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

Gender

API Name: Gender
NinjaCat System ID: yahoo_gemini:DIM_Gender
Data Type: text
Aggregates To: DIM_GENDER

Keyword

API Name: Keyword Value
NinjaCat System ID: yahoo_gemini:DIM_Keyword
Data Type: text
Aggregates To: DIM_KEYWORDS

Modified Bid

API Name: Modified Bid
NinjaCat System ID: yahoo_gemini:DIM_Modified_Bid
Data Type: text

Month Of Year

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

Price Type

API Name: Price Type
NinjaCat System ID: yahoo_gemini:DIM_Price_Type
Data Type: text

Quarter

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

Row

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

Rule ID

API Name: Rule ID
NinjaCat System ID: yahoo_gemini:DIM_RuleId
Data Type: text

Rule Name

API Name: Rule Name
NinjaCat System ID: yahoo_gemini:DIM_Rule_Name
Data Type: text

Search Term

API Name: Search Term
NinjaCat System ID: yahoo_gemini:DIM_Search_Term
Data Type: text

Site Name

API Name: External Site Name
NinjaCat System ID: yahoo_gemini:DIM_Site_Name
Data Type: text

Source

API Name: Source
NinjaCat System ID: yahoo_gemini:DIM_Source
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK,DIM_SOURCE

State

API Name: State
NinjaCat System ID: yahoo_gemini:DIM_State
Data Type: text
Aggregates To: DIM_STATE

System Account ID

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

Week Of Year

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

Year

NinjaCat System ID: yahoo_gemini:DIM_YEAR
Data Type: text
Aggregates To: DIM_YEAR

Zip Code

API Name: Zip
NinjaCat System ID: yahoo_gemini:DIM_ZipCode
Data Type: text

Metrics (32)

Ad Extn Clicks

API Name: Ad Extn Clicks
NinjaCat System ID: yahoo_gemini:MET_Ad_Extn_Clicks
Data Type: decimal
Display As: currency

Ad Extn Conversions

API Name: Ad Extn Conversions
NinjaCat System ID: yahoo_gemini:MET_Ad_Extn_Conversions
Data Type: integer

Ad Extn Impressions

API Name: Ad Extn Impressions
NinjaCat System ID: yahoo_gemini:MET_Ad_Extn_Impressions
Data Type: integer

Ad Extn Spend

API Name: Ad Extn Spend
NinjaCat System ID: yahoo_gemini:MET_Ad_Extn_Spend
Data Type: decimal
Display As: currency

Average Position

API Name: Average Position
NinjaCat System ID: yahoo_gemini:MET_Average_Position
Data Type: decimal
Display As: float

Call Conversion

API Name: Call Conversion
NinjaCat System ID: yahoo_gemini:MET_Call_Conversion
Data Type: integer

Click CVR

NinjaCat System ID: yahoo_gemini:MET_ClickCVR
Data Type: decimal
Display As: percent
Formula: (1000 * yahoo_gemini:MET_Post_Click_Conversions / yahoo_gemini:MET_Clicks)

Clicks

API Name: Clicks
NinjaCat System ID: yahoo_gemini:MET_Clicks
Data Type: integer
Aggregates To: MET_CLICKS

Conversions

API Name: Conversions
NinjaCat System ID: yahoo_gemini:MET_Conversions
Data Type: integer
Aggregates To: MET_CONVERSIONS

Conversion Value

API Name: Conversion Value
NinjaCat System ID: yahoo_gemini:MET_Conversion_Value
Data Type: integer
Aggregates To: MET_CONVERSION_VALUE

Conv. Rate

NinjaCat System ID: yahoo_gemini:MET_ConversionRate
Data Type: decimal
Display As: percent
Aggregates To: MET_CONVERSION_RATE
Formula: (yahoo_gemini:MET_Conversions / yahoo_gemini:MET_ActionLeadingToConv)

Cost / Conv.

NinjaCat System ID: yahoo_gemini:MET_AverageCPA
Data Type: decimal
Display As: currency
Aggregates To: MET_CPA
Formula: (yahoo_gemini:MET_Spend / yahoo_gemini:MET_Conversions)

Count (Unique Dimensions)

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

CPC

NinjaCat System ID: yahoo_gemini:MET_AverageCpc
Data Type: decimal
Display As: currency
Aggregates To: MET_CPC
Formula: (yahoo_gemini:MET_Spend / yahoo_gemini:MET_Clicks)

CPM

NinjaCat System ID: yahoo_gemini:MET_AverageCpm
Data Type: decimal
Display As: currency
Aggregates To: MET_CPM
Formula: (1000 * yahoo_gemini:MET_Spend / yahoo_gemini:MET_Impressions)

CTR

NinjaCat System ID: yahoo_gemini:MET_Ctr
Data Type: decimal
Display As: percent
Aggregates To: MET_CTR
Formula: (yahoo_gemini:MET_Clicks / yahoo_gemini:MET_Impressions)

Impressions

API Name: Impressions
NinjaCat System ID: yahoo_gemini:MET_Impressions
Data Type: integer
Aggregates To: MET_IMPRESSIONS

Impression Share

API Name: Impression Share
NinjaCat System ID: yahoo_gemini:MET_Impression_Share
Data Type: decimal
Display As: percent

Post Click Conversions

API Name: Post Click Conversions
NinjaCat System ID: yahoo_gemini:MET_Post_Click_Conversions
Data Type: integer
Aggregates To: MET_POST_CLICK_CONVERSIONS

Post Impression Conversions

API Name: Post Impression Conversions
NinjaCat System ID: yahoo_gemini:MET_Post_Impression_Conversions
Data Type: integer

Post View Conversions

API Name: Post View Conversions
NinjaCat System ID: yahoo_gemini:MET_Post_View_Conversions
Data Type: integer
Aggregates To: MET_POST_VIEW_CONVERSIONS

Spend

API Name: Spend
NinjaCat System ID: yahoo_gemini:MET_Spend
Data Type: decimal
Display As: currency
Aggregates To: MET_COST

Total CVRM

NinjaCat System ID: yahoo_gemini:MET_CVRM
Data Type: decimal
Display As: percent
Formula: (1000 * yahoo_gemini:MET_Conversions / yahoo_gemini:MET_Impressions)

Video 100% Complete

API Name: Video 100% Complete
NinjaCat System ID: yahoo_gemini:MET_Complete100
Data Type: integer

Video 25% Complete

API Name: Video 25% Complete
NinjaCat System ID: yahoo_gemini:MET_Complete25
Data Type: integer

Video 50% Complete

API Name: Video 50% Complete
NinjaCat System ID: yahoo_gemini:MET_Complete50
Data Type: integer

Video 75% Complete

API Name: Video 75% Complete
NinjaCat System ID: yahoo_gemini:MET_Complete75
Data Type: integer

Video CPC

NinjaCat System ID: yahoo_gemini:MET_CPCV
Data Type: decimal
Display As: currency
Formula: (yahoo_gemini:MET_Spend / yahoo_gemini:MET_Complete100)

Video Starts

API Name: Video Starts
NinjaCat System ID: yahoo_gemini:MET_VideoStarts
Data Type: integer
Aggregates To: MET_VIDEO_STARTS

Video Views

API Name: Video Views
NinjaCat System ID: yahoo_gemini:MET_Video_Views
Data Type: integer
Aggregates To: MET_VIDEO_VIEWS

View CVR

NinjaCat System ID: yahoo_gemini:MET_ViewCVR
Data Type: decimal
Display As: percent
Formula: (1000 * yahoo_gemini:MET_Post_Impression_Conversions / yahoo_gemini:MET_Clicks)

VTC Revenue

API Name: Max Bid
NinjaCat System ID: yahoo_gemini:MET_Max_Bid
Data Type: decimal
Display As: currency
Aggregates To: MET_VTC_REVENUE

Updated 6 months ago