Yahoo Gemini
The table below gives information about all the data fields that you can import from Yahoo Gemini.
|
Field UI name |
Field API name |
Data Type |
Description |
Use in Adverity |
Docs |
|---|---|---|---|---|---|
|
|
Ad Description (string) |
string |
The description of the ad that will be shown to the user. This field supports keyword insertion. Max length is 150 characters. |
dimension |
|
|
|
Ad Display URL (string) |
string |
The user.friendly URL that is displayed to the user. |
dimension |
|
|
|
Ad Extn Clicks (Fact) |
long |
Total clicks an ad extension link (rather than the ad landing URL). |
metric |
|
|
|
Ad Extn Conversions (Fact) |
long |
Total conversions which were attributed back to an ad extension link click. |
metric |
|
|
|
Ad Extn ID (Dimension) |
string |
The ID of the ad extension. |
dimension |
|
|
|
Ad Extn Impressions (Fact) |
long |
Total impressions for which an ad extension was displayed. |
metric |
|
|
|
Ad Extn Parent Type (enum) |
string |
The parent type of the ad extension. |
dimension |
|
|
|
Ad Extn Phone Number (string) |
string |
The phone number associated with the ad extension. Applies to call extensions. |
dimension |
|
|
|
Ad Extn Spend (Fact) |
currency |
The spend resulting from clicking an ad extension link. |
metric |
|
|
|
Ad Extn Title (string) |
string |
The title of the ad extension. Populated only for sitelinks. |
dimension |
|
|
|
Ad Extn Type (enum) |
string |
The type of the ad extension. |
dimension |
|
|
|
Ad Format Name (Dimension) |
string |
Category of Ad like Single Image- Mail Ad- Video- etc. |
dimension |
|
|
|
Ad Group ID (Dim) |
string |
The ID of the ad group. |
dimension |
|
|
|
Ad Group ID (Dimension) |
string |
The ID of the ad group. |
dimension |
|
|
|
Ad Group Name (string) |
string |
The name of the ad group. |
dimension |
|
|
|
Ad Group Status (enum) |
string |
The status of the ad group (ACTIVE- PAUSED). |
dimension |
|
|
|
Ad ID (Dimension) |
string |
The ID of the ad. |
dimension |
|
|
|
Ad Image URL (string) |
string |
The URL of the (uploaded thumbnail) image. |
dimension |
|
|
|
Ad Landing URL (string) |
string |
The URL where the user was redirected to upon clicking the ad. |
dimension |
|
|
|
Ad SponsoredBy (string) |
string |
The string shown against the sponsored by label in the ad. |
dimension |
|
|
|
Ad Title (string) |
string |
The title of the ad that will be shown to the user. Limited to 50 characters. |
dimension |
|
|
|
Ad Title 2 (string) |
string |
The second line title of the ad that will be shown to the user. The limit is 30 characters of text. When used with Ad Title- then the Ad Title attribute is also limited to 30 characters of text. Supported for both v1 and v2 API calls. |
dimension |
|
|
|
Adjustment Type (Dim) |
string |
The adjustment type. |
dimension |
|
|
|
Advertiser Currency (string) |
string |
Advertiser currency- e.g.- USD |
dimension |
|
|
|
Advertiser ID (Dim) |
string |
The ID of the advertiser. |
dimension |
|
|
|
Advertiser ID (Dimension) |
string |
The ID of the advertiser. |
dimension |
|
|
|
Advertiser Name (string) |
string |
The name of the advertiser account. |
dimension |
|
|
|
Advertiser Timezone (enum) |
string |
The advertiser account timezone- e.g.- America/New_York. |
dimension |
|
|
|
Age (Dimension) |
string |
Age group of the user: 18.24- 25.34- 35.44- 45.54- 55.64. |
dimension |
|
|
|
Audience ID (Dimension) |
string |
ID of the Audience that received Impressions. |
dimension |
|
|
|
Audience Name (Dimension) |
string |
Name of the Audience that received Impressions. |
dimension |
|
|
|
Audience Status (Dimension) |
string |
Status of the Audience that received Impressions (ON- OFF). |
dimension |
|
|
|
Audience Type (Dimension) |
string |
Type of the Audience that received Impressions [General Interest Category/Custom Audience/Custom Segment]. |
dimension |
|
|
|
Average Bid (Dimension) |
string |
The average bid for the ad. |
dimension |
|
|
|
Average CPC (Derived Fact) |
currency |
The average CPC bid value. |
metric |
|
|
|
Average CPC (Fact) |
currency |
The average CPC bid value. |
metric |
|
|
|
Average CPM (Derived Fact) |
currency |
The average CPM bid value. |
metric |
|
|
|
Average CPM (Fact) |
currency |
The average CPM bid value. |
metric |
|
|
|
Average Call Duration (Derived Fact) |
float |
The average call duration. |
metric |
|
|
|
Average Cost-per-action (Fact) |
currency |
The average cost per action. |
metric |
|
|
|
Average Cost-per-install (Derived Fact) |
currency |
The average cost per install. |
metric |
|
|
|
Average Cost-per-install (Fact) |
currency |
The average cost per install. |
metric |
|
|
|
Average Position (Fact) |
float |
Impression weighted average position. |
metric |
|
|
|
Bid Modifier (Dimension) |
string |
The bid modifier used for the ad. |
dimension |
|
|
|
Brand (Dim) |
string |
Brand of the offer- same value as the “brand” field in the product feed. |
dimension |
|
|
|
Budget (BigDecimal) |
currency |
The lifetime budget at the campaign level. |
BigDecimal |
|
|
|
Budget Type (enum) |
string |
The type of budget. |
dimension |
|
|
|
CTR (Derived Fact) |
percentage |
The clickthrough rate. |
metric |
|
|
|
CTR (Fact) |
percentage |
The clickthrough rate. |
metric |
|
|
|
Call Conversion (Fact) |
long |
The total number of calls received. |
metric |
|
|
|
Call Duration (Dimension) |
string |
Duration of the call in seconds. |
dimension |
|
|
|
Call End Time (Dimension) |
string |
Call End Time in UTC. |
dimension |
|
|
|
Call Start Time (Dimension) |
string |
Call Start Time in UTC. |
dimension |
|
|
|
Call Status (Dimension) |
string |
Status of the Call Received- ANSWER/NOANSWER. |
dimension |
|
|
|
Caller Area Code (Dimension) |
string |
Caller Area Code. |
dimension |
|
|
|
Caller Name (Dimension) |
string |
Name of the Caller. |
dimension |
|
|
|
Caller Number (Dimension) |
string |
Caller number. |
dimension |
|
|
|
Campaign End Date (yyyy-mm-dd format) |
date |
The end date of the campaign. |
dimension |
|
|
|
Campaign ID (Dim) |
string |
The ID of the campaign. |
dimension |
|
|
|
Campaign ID (Dimension) |
string |
The ID of the campaign. |
dimension |
|
|
|
Campaign Name (string) |
string |
The name of the campaign. |
dimension |
|
|
|
Campaign Objective (string) |
string |
The objective of the campaign as defined in the campaign settings. |
dimension |
|
|
|
Campaign Start Date (yyyy-mm-dd format) |
date |
The start date of the campaign. |
dimension |
|
|
|
Campaign Status (enum) |
string |
The status of the campaign (ACTIVE- PAUSED). |
dimension |
|
|
|
Card ID (Dimension) |
string |
Ad slot asset Id. |
dimension |
|
|
|
Card Position (Dimension) |
string |
Ad slot Horizontal Index. |
dimension |
|
|
|
Category ID (Dim) |
string |
ID of the product category- foreign key to the product_categories dimension. |
dimension |
|
|
|
Category Name (Dim) |
string |
The name associated with the Category ID. |
dimension |
|
|
|
Category Name (Dimension) |
string |
The name associated with the Category ID. |
dimension |
|
|
|
Category Name (string) |
string |
The name associated with the Category ID. |
dimension |
|
|
|
Category Path (string) |
string |
The full category path |
dimension |
|
|
|
City (Dimension) |
string |
Name of the user’s City. |
dimension |
|
|
|
City WOEID (Dimension) |
string |
The Where Earth ID associated with the City. |
dimension |
|
|
|
Click Outs (Fact) |
long |
Number of users to clicked out to advertiser landing page. |
metric |
|
|
|
Click Outs Rate (Fact) |
percentage |
Rate of clickouts (over opens). |
metric |
|
|
|
Click Share (Fact) |
percentage |
Share of Clicks that the Advertiser or Campaign received a given Keyword- after factoring in Targeting. For example- if Campaign X had 10 Clicks to the keyword ‘basketball-’ and a total of 100 Clicks occurred ‘basketball’ during the time period selected- then Campaign X has a Click Share of 10% for the term ‘basketball’ |
metric |
|
|
|
Clicks (Fact) |
long |
The number of clicks. |
metric |
|
|
|
Conversion Device (Dimension) |
string |
SmartPhone- Tablet or Desktop. This is the device the conversion event occurred- and it can be different from the device associated with the impression or click. Device other reports is the device associated with the impression- click events. |
dimension |
|
|
|
Conversion Share (Fact) |
percentage |
Share of Conversions that the Advertiser or Campaign received a given Keyword- after factoring in Targeting. For example- if Campaign X had 10 Conversions to the keyword ‘basketball-’ and a total of 100 Conversions occurred ‘basketball’ during the time period selected- then Campaign X has a Conversion Share of 10% for the term ‘basketball’. |
metric |
|
|
|
Conversion Value (Fact) |
float |
The actual value associated with the conversion event. |
metric |
|
|
|
Conversions (Fact) |
long |
The total number of conversions- includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post.click and 1 day post view. For website conversions the default windows are 30 days post.click and 2 days post.view. |
metric |
|
|
|
Cost (Fact) |
currency |
The cost. |
metric |
|
|
|
Cost Per Video View (Fact) |
currency |
Average cost per video view. |
metric |
|
|
|
Country (Dimension) |
string |
Name of the user’s country. |
dimension |
|
|
|
Country WOEID (Dimension) |
string |
The Where Earth ID associated with the Country. |
dimension |
|
|
|
Custom Label 0 (Dim) |
string |
One of 5 different custom labels that can be applied to a Product. |
dimension |
|
|
|
Custom Label 1 (Dim) |
string |
One of 5 different custom labels that can be applied to a Product. |
dimension |
|
|
|
Custom Label 2 (Dim) |
string |
One of 5 different custom labels that can be applied to a Product. |
dimension |
|
|
|
Custom Label 3 (Dim) |
string |
One of 5 different custom labels that can be applied to a Product. |
dimension |
|
|
|
Custom Label 4 (Dim) |
string |
One of 5 different custom labels that can be applied to a Product. |
dimension |
|
|
|
DMA WOEID (Dimension) |
string |
The Where Earth ID associated with the DMA. |
dimension |
|
|
|
Day (Dim) |
date |
The date in YYYY.MM.DD format. Either Day- Week or Month must be queried. |
dimension |
|
|
|
Day (Dimension) |
date |
The date in YYYY.MM.DD format. Either Day- Week or Month must be queried. |
dimension |
|
|
|
Delivered Match Type (Dimension) |
string |
Match type set the keyword delivered. |
dimension |
|
|
|
Destination URL (Dimension) |
string |
The actual served URL post macro.expansion. Canly be requested if both Ad ID and Keyword ID are requested. Note that requesting Destination URL granularity will result in considerably longer report generation times .ly request this data if you really need it. |
dimension |
|
|
|
Device (Dimension) |
string |
SmartPhone- Tablet or Desktop. |
dimension |
|
|
|
Device Type (Dim) |
string |
Device type of the user: Desktop- Tablet- Phone- Unknown. Note that Device Type data isly available after the field is launched. If you run it for a previous date- it will return NONE in the Device Type column. |
dimension |
|
|
|
Device Type (Dimension) |
string |
Device type of the user: Desktop- Tablet- Phone- Unknown. Note that Device Type data isly available after the field is launched. If you run it for a previous date- it will return NONE in the Device Type column. |
dimension |
|
|
|
Engagement Rate (Derived Fact) |
percentage |
The rate of total Tumblr Engagements (over Impressions). |
metric |
|
|
|
Engagements (Derived Fact) |
long |
The count of total Tumblr Engagements. |
metric |
|
|
|
External Site Name (Dimension) |
string |
The site name where the ad was displayed. |
dimension |
|
|
|
Follow Rate (Derived Fact) |
percentage |
The rate of Tumblr Follows (over Impressions). |
metric |
|
|
|
Follows (Derived Fact) |
long |
The count of Tumblr Follows. |
metric |
|
|
|
Forward Rate (Fact) |
percentage |
Rate of forwards (over opens). |
metric |
|
|
|
Forwards (Fact) |
long |
Number of email addresses the email was forwarded to. |
metric |
|
|
|
Gender (Dimension) |
string |
The gender of the user: F- M- or U. |
dimension |
|
|
|
Group (Dimension) |
string |
The native supply group- i.e.- GROUP_1A- GROUP_1B- GROUP_2A- GROUP_2B- GROUP_3A- GROUP_3B. |
dimension |
|
|
|
Group or Site (Dimension) |
string |
The section group value. Site is no longer available. |
dimension |
|
|
|
Hour (Dimension) |
string |
The hour in integer format. For example- 1 means reporting stats between 1am and 2am. |
dimension |
|
|
|
Impression Share (Fact) |
percentage |
Share of Impressions that the Advertiser or Campaign served to a given Keyword- after factoring in Targeting. For example- if Campaign X served 10 impressions to the keyword ‘basketball-’ and a total of 100 bidded searches occurred ‘basketball’ during the time period selected- then Campaign X has an Impression Share of 10% for the term ‘basketball’. |
metric |
|
|
|
Impressions (Fact) |
long |
The number of impressions. |
metric |
|
|
|
In App Post Click Conversions (Fact) |
long |
In-app post click conversions. |
metric |
|
|
|
In App Post Install Conversions (Fact) |
long |
In-app install conversions. |
metric |
|
|
|
In App Post View Conversions (Fact) |
long |
In-app post view conversions. |
metric |
|
|
|
Is Adjustment (Dim) |
string |
Whether it is an adjustment. |
dimension |
|
|
|
Keyword ID (Dimension) |
string |
The id of the keyword. |
dimension |
|
|
|
Keyword Landing URL (string) |
string |
The keyword landing URL. |
dimension |
|
|
|
Keyword Match Type (string) |
string |
The keyword match type. |
dimension |
|
|
|
Keyword Param 1 (string) |
string |
The param1 value for the keyword. |
dimension |
|
|
|
Keyword Status (string) |
string |
The keyword status. |
dimension |
|
|
|
Keyword Value (Dimension) |
string |
The actual keyword. |
dimension |
|
|
|
Keyword Value (string) |
string |
The actual keyword. |
dimension |
|
|
|
Landing Page Type (Dimension) |
string |
The landing page type. |
dimension |
|
|
|
Like Rate (Derived Fact) |
percentage |
Rate of Tumblr Likes (over Impressions). |
metric |
|
|
|
Likes (Derived Fact) |
long |
The count of Tumblr Likes. |
metric |
|
|
|
Location Type (Dimension) |
string |
Flags whether the location listed in the report indicates the physical location of the user or the location of their intent (for Search). |
dimension |
|
|
|
Max Bid (Fact) |
float |
The maximum bid value. |
metric |
|
|
|
Modified Bid (Dimension) |
string |
The average bid multiplied by the bid modifier. |
dimension |
|
|
|
Month (Dim) |
string |
Month will be represented as the first day of the month in YYYY.MM.DD’ format. Either Day- Week or Month must be queried. |
dimension |
|
|
|
Month (Dimension) |
string |
Month will be represented as the first day of the month in YYYY.MM.DD’ format. Either Day- Week or Month must be queried. |
dimension |
|
|
|
Offer Group ID (Dim) |
string |
The id of the leaf product group node that won the auction. |
dimension |
|
|
|
Offer ID (Dim) |
string |
ID of the offer- same value as the id field in the product feed. This is the merchant.side ID of the product. |
dimension |
|
|
|
Opens (Fact) |
long |
Number of impressions of the Mail Ad asset. |
metric |
|
|
|
Paid Engagement Rate (Derived Fact) |
percentage |
The rate of revenue.bearing Engagements (over Impressions).” |
metric |
|
|
|
Paid Engagements (Derived Fact) |
long |
Total of revenue.bearing Impressions. |
metric |
|
|
|
Parent Category ID (long) |
string |
ID of the parent product category |
dimension |
|
|
|
Post Click Conversion Value (Fact) |
float |
The Conversion Value attributed to Post Click Conversions. |
metric |
|
|
|
Post Click Conversions (Fact) |
long |
The total number of post click conversions. |
metric |
|
|
|
Post Impression Conversion Value (Fact) |
float |
The Conversion Value attributed to post view conversions. |
metric |
|
|
|
Post Impression Conversions (Fact) |
long |
The total number of post view conversions. |
metric |
|
|
|
Post View Conversions (Fact) |
long |
The total number of post view conversions. |
metric |
|
|
|
Price Type (Dimension) |
string |
The price type. |
dimension |
|
|
|
Pricing Type (Dimension) |
string |
CPC- CPM |
dimension |
|
|
|
Product Ad ID (Dimension) |
string |
The id of the product ad. |
dimension |
|
|
|
Product ID (Dim) |
string |
The id of the product. This is the Yahoo.side ID given to the product. |
dimension |
|
|
|
Product Name (Dim) |
string |
The Name of the product. |
dimension |
|
|
|
Product Type (Dim) |
string |
The merchant’s own product category string- same value as the “product type” field in the product feed. |
dimension |
|
|
|
Reblog Rate (Derived Fact) |
percentage |
The rate of Tumblr Reblogs (over Impressions). |
metric |
|
|
|
Reblogs (Derived Fact) |
long |
The count of Tumblr Reblogs. |
metric |
|
|
|
Rendered Type (Dimension) |
string |
Ad got rendered as Standard (e.g. Text) or Multiple (e.g. Carousel). |
dimension |
|
|
|
Rule ID (Dimension) |
string |
The id associated with the conversion rule. |
dimension |
|
|
|
Rule Name (Dimension) |
string |
The name associated with the conversion. |
dimension |
|
|
|
Save Rate (Fact) |
percentage |
Rate of saves (over opens). |
metric |
|
|
|
Saves (Fact) |
long |
Number of users who clicked save. |
metric |
|
|
|
Search Term (Dimension) |
string |
The phrase canon user search query. |
dimension |
|
|
|
Section ID (Dimension) |
string |
The ID of the section. |
dimension |
|
|
|
Source (Dim) |
string |
Integer value corresponding to various Source types. |
dimension |
|
|
|
Source (Dimension) |
string |
Integer value corresponding to various Source types. |
dimension |
|
|
|
Source Name (Dimension) |
string |
Native- Search or Other. |
dimension |
|
|
|
Spend (Fact) |
currency |
The unadjusted spend amount. Please note that adjustments . meaning any corrections due to issues like overcharging . can be queried using the adjustment_stats cube. |
metric |
|
|
|
State (Dimension) |
string |
Name of the user’s state. |
dimension |
|
|
|
State WOEID (Dimension) |
string |
The Where Earth ID associated with the State. |
dimension |
|
|
|
Structured Snippet Extn ID (Dimension) |
string |
The ID of the Structured Snippet extension. This is the primary key for this dimension and should be included in the report in order for other dimension attributes to be queried. |
dimension |
|
|
|
Structured Snippet Text (Dimension) |
string |
The text of the structured snippet text. |
dimension |
|
|
|
Supply Type (Dimension) |
string |
The supply type is SECTION_GROUP. |
dimension |
|
|
|
Total Conversions (Fact) |
long |
A synonym for the Conversions field (is kept for backwards compatibility). |
metric |
|
|
|
Video 100% Complete (Fact) |
long |
Number of times the video played to 100% of its length. |
metric |
|
|
|
Video 25% Complete (Fact) |
long |
Number of times the video played to 25% of its length. |
metric |
|
|
|
Video 50% Complete (Fact) |
long |
Number of times the video played to 50% of its length. |
metric |
|
|
|
Video 75% Complete (Fact) |
long |
Number of times the video played to 75% of its length. |
metric |
|
|
|
Video Closed (Fact) |
long |
The number of times the video was closed. |
metric |
|
|
|
Video Skipped (Fact) |
long |
The number of times the video was skipped. |
metric |
|
|
|
Video Starts (Fact) |
long |
The number of video starts. |
metric |
|
|
|
Video Views (Fact) |
long |
The number of video views. |
metric |
|
|
|
Video after 30 seconds view (Fact) |
long |
The number of times the video played longer than 30 seconds. |
metric |
|
|
|
Week (Dim) |
string |
Week will be represented as the first day of the week in YYYY.MM.DD’ format. This will always be Monday. Either Day- Week or Month must be queried. |
dimension |
|
|
|
Week (Dimension) |
string |
Week will be represented as the first day of the week in YYYY.MM.DD’ format. This will always be Monday. Either Day- Week or Month must be queried. |
dimension |
|
|
|
Zip (Dimension) |
string |
Zip code of the user. |
dimension |
|
|
|
Zip WOEID (Dimension) |
string |
The Where Earth ID associated with the Zip Code. |
dimension |
|