Google Ads data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

Accountname_fromAW
Display name Account name
Field type dimension
Data type string.text.value
AdvertisingChannelSubType
Display name Advertising channel sub-type
Field type dimension
Data type string.text.value
AdvertisingChannelType
Display name Advertising channel type
Field type dimension
Data type string.text.value
Biddingstrategy
Display name Bidding strategy
Field type dimension
Data type string.text.value
BiddingstrategyID
Display name Bidding strategy ID
Description The ID of the BiddingStrategyConfiguration
Field type dimension
Data type string.text.value
BiddingstrategyType
Display name Bidding strategy type
Field type dimension
Data type string.text.value
CampaignID
Display name Campaign ID
Description The ID of the Campaign
Field type dimension
Data type string.text.value
campaignlabels
Display name Campaign labels
Field type dimension
Data type string.text.value
Campaignname
Display name Campaign name
Field type dimension
Data type string.text.value
Campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
Clicks
Display name Clicks
Field type metric
Data type int.number.value
Conversions
Display name Conversions
Description The number of conversions for all conversion actions that you have opted into optimization
Field type metric
Data type float.number.value
ConversionValue
Display name Total conversion value
Description The sum of conversion values for all conversions
Field type metric
Data type float.currency.value
Cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period
Field type metric
Data type float.currency.value
Cost_eur
Display name Cost (EUR)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to euros
Field type metric
Data type float.currency.value
Cost_gbp
Display name Cost (GBP)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to British pounds
Field type metric
Data type float.currency.value
Cost_usd
Display name Cost (USD)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to US dollars
Field type metric
Data type float.currency.value
Currencycode
Display name Currency code
Field type dimension
Data type string.currency.code
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Field type dimension
Data type string.time.date
engagements
Display name Engagements
Description The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics
Field type metric
Data type int.number.value
Impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
ImpressionShare
Display name Impression share
Description The impressions you've received divided by the total Available Impressions
Field type metric
Data type float.number.ratio
interactions
Display name Interactions
Description The number of interactions. An interaction is the main user action associated with an ad format--clicks for text and shopping ads, views for video ads, and so on
Field type metric
Data type int.number.value
profileID
Display name Account ID
Field type dimension
Data type string.text.value
SearchAbsoluteTopImpressionShare
Display name Search absolute top impression share
Field type metric
Data type float.number.ratio
SearchBudgetLostImpressionShare
Display name Search budget lost impression share
Description The estimated percent of times that your ad was eligible to show on the Search Network but didn't because your budget was too low
Field type metric
Data type float.number.ratio
SearchExactMatchImpressionShare
Display name Search exact match impression share
Description The impressions you've received divided by the estimated number of impressions you were eligible to receive on the Search Network for search terms that matched your keywords exactly (or were close variants of your keyword), regardless of your keyword match types
Field type metric
Data type float.number.ratio
SearchImpressionShare
Display name Search impression share
Description The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive
Field type metric
Data type float.number.ratio
SearchRankLostTopImpressionShare
Display name Search rank lost top impression share
Field type metric
Data type float.number.ratio
SearchTopImpressionShare
Display name Search top impression share
Field type metric
Data type float.number.ratio
TopImpressionPercentage
Display name Top impression percentage
Field type metric
Data type float.number.ratio
TotalAmount
Display name Total budget
Description The total budget amount, if you set a campaign's total budget in the Google Ads UI
Field type metric
Data type float.currency.value
TotalAvailableImpressions
Display name Available impressions
Description This is a complex calculation but in most basic for is Impressions + Lost Impressions = Available impressions
Field type metric
Data type int.number.value
videoimpressions
Display name Video impressions
Field type metric
Data type int.number.value
videoviews
Display name Video views
Description The number of times your video ads were viewed
Field type metric
Data type int.number.value
Viewthroughconversions
Display name View-through conversions
Description The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad
Field type metric
Data type float.number.value

Table: AD

Accountname_fromAW
Display name Account name
Field type dimension
Data type string.text.value
ActiveViewImpressions
Display name Viewable impressions
Description How often your ad has become viewable on a Display Network site
Field type metric
Data type int.number.value
Adapprovalstatus
Display name Ad approval status
Field type dimension
Data type string.text.value
AdgroupID
Display name Ad group ID
Description The ID of the AdGroup
Field type dimension
Data type string.text.value
adgrouplabels
Display name Ad group labels
Field type dimension
Data type string.text.value
Adgroupname
Display name Ad group name
Description The name of the AdGroup
Field type dimension
Data type string.text.value
Adgroupstatus
Display name Ad group status
Field type dimension
Data type string.text.value
AdID
Display name Ad ID
Description The ID of the Ad. This field may contain IDs of ads that are not supported in the report request's API version
Field type dimension
Data type string.text.value
adlabels
Display name Ad labels
Field type dimension
Data type string.text.value
Adstatus
Display name Ad status
Field type dimension
Data type string.text.value
Adtype
Display name Ad type
Field type dimension
Data type string.text.value
CampaignID
Display name Campaign ID
Description The ID of the Campaign
Field type dimension
Data type string.text.value
campaignlabels
Display name Campaign labels
Field type dimension
Data type string.text.value
Campaignname
Display name Campaign name
Field type dimension
Data type string.text.value
Campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
Clicks
Display name Clicks
Field type metric
Data type int.number.value
Conversions
Display name Conversions
Description The number of conversions for all conversion actions that you have opted into optimization
Field type metric
Data type float.number.value
ConversionValue
Display name Total conversion value
Description The sum of conversion values for all conversions
Field type metric
Data type float.currency.value
Cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period
Field type metric
Data type float.currency.value
Cost_eur
Display name Cost (EUR)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to euros
Field type metric
Data type float.currency.value
Cost_gbp
Display name Cost (GBP)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to British pounds
Field type metric
Data type float.currency.value
Cost_usd
Display name Cost (USD)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to US dollars
Field type metric
Data type float.currency.value
Currencycode
Display name Currency code
Field type dimension
Data type string.currency.code
CustomUrlParameters
Display name Custom URL parameters
Field type dimension
Data type string.text.json
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Field type dimension
Data type string.time.date
Description
Display name Description
Description The descriptive text of an expanded text ad or responsive display ad
Field type dimension
Data type string.text.value
Description1
Display name Description 1
Description Line 1 description of the Ad
Field type dimension
Data type string.text.value
Description2
Display name Description 2
Description Line 2 description of the Ad
Field type dimension
Data type string.text.value
DestinationURL
Display name Destination URL
Description Destination URL of the ad. Please note that this field will be removed on 2020-10-29
Field type dimension
Data type string.text.url
DevicePreference
Display name Device preference
Field type dimension
Data type string.text.value
DisplayURL
Display name Display URL
Field type dimension
Data type string.text.url
engagements
Display name Engagements
Description The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics
Field type metric
Data type int.number.value
finalURL
Display name Final URL
Description Final URL of the impressions
Field type dimension
Data type string.text.url
GmailForwards
Display name Gmail forwards
Description The number of times your ad was forwarded to someone else as a message
Field type metric
Data type int.number.value
GmailSaves
Display name Gmail saves
Description The number of times someone has saved your Gmail ad to their inbox as a message
Field type metric
Data type int.number.value
GmailSecondaryClicks
Display name Gmail secondary clicks
Description The number of clicks to your landing page on the expanded state of Gmail ads
Field type metric
Data type int.number.value
Headline
Display name Headline
Field type dimension
Data type string.text.value
HeadlinePart1
Display name Headline part 1
Description The first part of an expanded text ad headline
Field type dimension
Data type string.text.value
HeadlinePart2
Display name Headline part 2
Description The second part of an expanded text ad headline
Field type dimension
Data type string.text.value
HeadlinePart3
Display name Headline part 3
Description The third part of an expanded text ad headline
Field type dimension
Data type string.text.value
Imageadname
Display name Image ad name
Field type dimension
Data type string.text.value
ImageadURL
Display name Image ad URL
Field type dimension
Data type string.text.url
ImageCreativeImageHeight
Display name Ad image height
Description The height of the image ad. For other ad types, this will have no values
Field type dimension
Data type int.number.value
ImageCreativeImageWidth
Display name Ad image width
Description The width of the image ad. For other ad types, this will have no values
Field type dimension
Data type int.number.value
Impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
interactions
Display name Interactions
Description The number of interactions. An interaction is the main user action associated with an ad format--clicks for text and shopping ads, views for video ads, and so on
Field type metric
Data type int.number.value
LongHeadline
Display name Long headline
Description The long format of the headline in a responsive display ad
Field type dimension
Data type string.text.value
Network
Display name Network
Field type dimension
Data type string.text.value
Networkwithsearchpartners
Display name Network (with search partners)
Field type dimension
Data type string.text.value
path1
Display name Path 1
Description The text that appears in the ad with the displayed URL for an expanded text ad
Field type dimension
Data type string.text.value
path2
Display name Path 2
Description In addition to "Path1", more text that appears in the ad with the displayed URL for an expanded text ad
Field type dimension
Data type string.text.value
profileID
Display name Account ID
Field type dimension
Data type string.text.value
ShortHeadline
Display name Short headline
Description The short format of the headline in a responsive display ad
Field type dimension
Data type string.text.value
TextAdDescription1
Display name Expanded text ad description 1
Description The description 1 of the expanded text ad
Field type dimension
Data type string.text.value
TextAdDescription2
Display name Expanded text ad description 2
Description The description 2 of the expanded text ad
Field type dimension
Data type string.text.value
TrackingUrlTemplate
Display name Tracking URL template
Description Tracking template of the main object of this row
Field type dimension
Data type string.text.value
videoimpressions
Display name Video impressions
Field type metric
Data type int.number.value
VideoQuartile100Views
Display name Watch 100% views
Field type metric
Data type int.number.value
videoviews
Display name Video views
Description The number of times your video ads were viewed
Field type metric
Data type int.number.value
Viewthroughconversions
Display name View-through conversions
Description The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad
Field type metric
Data type float.number.value

Table: KEYWORD

Accountname_fromAW
Display name Account name
Field type dimension
Data type string.text.value
AdgroupID
Display name Ad group ID
Description The ID of the AdGroup
Field type dimension
Data type string.text.value
Adgroupname
Display name Ad group name
Description The name of the AdGroup
Field type dimension
Data type string.text.value
Adgroupstatus
Display name Ad group status
Field type dimension
Data type string.text.value
Campaignname
Display name Campaign name
Field type dimension
Data type string.text.value
Campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
Clicks
Display name Clicks
Field type metric
Data type int.number.value
Conversions
Display name Conversions
Description The number of conversions for all conversion actions that you have opted into optimization
Field type metric
Data type float.number.value
ConversionValue
Display name Total conversion value
Description The sum of conversion values for all conversions
Field type metric
Data type float.currency.value
Cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period
Field type metric
Data type float.currency.value
Cost_eur
Display name Cost (EUR)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to euros
Field type metric
Data type float.currency.value
Cost_gbp
Display name Cost (GBP)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to British pounds
Field type metric
Data type float.currency.value
Cost_usd
Display name Cost (USD)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to US dollars
Field type metric
Data type float.currency.value
CreativeQualityScore
Display name Creative quality score
Field type dimension
Data type string.text.value
Currencycode
Display name Currency code
Field type dimension
Data type string.currency.code
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Field type dimension
Data type string.time.date
engagements
Display name Engagements
Description The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics
Field type metric
Data type int.number.value
Impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
interactions
Display name Interactions
Description The number of interactions. An interaction is the main user action associated with an ad format--clicks for text and shopping ads, views for video ads, and so on
Field type metric
Data type int.number.value
Keyword
Display name Keyword
Description Keyword that matched the query and triggered the ad
Field type dimension
Data type string.text.value
KeyworddestinationURL
Display name Keyword destination URL
Description Please note that this field will be removed on 2020-10-29
Field type dimension
Data type string.text.url
KeywordID
Display name Keyword ID
Description The ID of the Keyword that triggered the ad
Field type dimension
Data type string.text.value
keywordlabels
Display name Keyword labels
Field type dimension
Data type string.text.json
Keywordstatus
Display name Keyword status
Field type dimension
Data type string.text.value
Matchtype
Display name Match type
Field type dimension
Data type string.text.value
Network
Display name Network
Field type dimension
Data type string.text.value
Networkwithsearchpartners
Display name Network (with search partners)
Field type dimension
Data type string.text.value
PostClickQualityScore
Display name Post-click quality score
Field type dimension
Data type string.text.value
profileID
Display name Account ID
Field type dimension
Data type string.text.value
Qualityscore
Display name Quality score
Field type dimension
Data type int.number.value
Viewthroughconversions
Display name View-through conversions
Description The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad
Field type metric
Data type float.number.value

Table: PLACEMENT

Accountname_fromAW
Display name Account name
Field type dimension
Data type string.text.value
ActiveViewImpressions
Display name Viewable impressions
Description How often your ad has become viewable on a Display Network site
Field type metric
Data type int.number.value
CampaignID
Display name Campaign ID
Description The ID of the Campaign
Field type dimension
Data type string.text.value
Campaignname
Display name Campaign name
Field type dimension
Data type string.text.value
Campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
Clicks
Display name Clicks
Field type metric
Data type int.number.value
Conversions
Display name Conversions
Description The number of conversions for all conversion actions that you have opted into optimization
Field type metric
Data type float.number.value
ConversionValue
Display name Total conversion value
Description The sum of conversion values for all conversions
Field type metric
Data type float.currency.value
Cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period
Field type metric
Data type float.currency.value
Cost_eur
Display name Cost (EUR)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to euros
Field type metric
Data type float.currency.value
Cost_gbp
Display name Cost (GBP)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to British pounds
Field type metric
Data type float.currency.value
Cost_usd
Display name Cost (USD)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to US dollars
Field type metric
Data type float.currency.value
CustomUrlParameters
Display name Custom URL parameters
Field type dimension
Data type string.text.json
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Field type dimension
Data type string.time.date
Domain
Display name Domain
Description The domain of the URL (placement) where the impression was shown
Field type dimension
Data type string.text.value
engagements
Display name Engagements
Description The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics
Field type metric
Data type int.number.value
Impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
interactions
Display name Interactions
Description The number of interactions. An interaction is the main user action associated with an ad format--clicks for text and shopping ads, views for video ads, and so on
Field type metric
Data type int.number.value
Network
Display name Network
Field type dimension
Data type string.text.value
PlacementdestinationURL
Display name Placement destination URL
Description Please note that this field will be removed on 2020-10-29
Field type dimension
Data type string.text.url
Placementstatus
Display name Placement status
Field type dimension
Data type string.text.value
profileID
Display name Account ID
Field type dimension
Data type string.text.value
videoviews
Display name Video views
Description The number of times your video ads were viewed
Field type metric
Data type int.number.value

Table: CONVERSION

Accountname_fromAW
Display name Account name
Field type dimension
Data type string.text.value
AdvertisingChannelSubType
Display name Advertising channel sub-type
Field type dimension
Data type string.text.value
AdvertisingChannelType
Display name Advertising channel type
Field type dimension
Data type string.text.value
Biddingstrategy
Display name Bidding strategy
Field type dimension
Data type string.text.value
BiddingstrategyID
Display name Bidding strategy ID
Description The ID of the BiddingStrategyConfiguration
Field type dimension
Data type string.text.value
BiddingstrategyType
Display name Bidding strategy type
Field type dimension
Data type string.text.value
CampaignID
Display name Campaign ID
Description The ID of the Campaign
Field type dimension
Data type string.text.value
campaignlabels
Display name Campaign labels
Field type dimension
Data type string.text.value
Campaignname
Display name Campaign name
Field type dimension
Data type string.text.value
Campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
ConversionCategory
Display name Conversion category
Description A category that describes the action the user will take to complete a conversion. Prevents zero-conversion rows from being returned
Field type dimension
Data type string.text.value
Conversions
Display name Conversions
Description The number of conversions for all conversion actions that you have opted into optimization
Field type metric
Data type float.number.value
ConversionTrackerId
Display name Conversion tracker ID
Description ID of the conversion tracker
Field type dimension
Data type string.text.value
ConversionTypeName
Display name Conversion type name
Description The name of the conversion type. Prevents zero-conversion rows from being returned
Field type dimension
Data type string.text.value
ConversionValue
Display name Total conversion value
Description The sum of conversion values for all conversions
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Field type dimension
Data type string.time.date
EstimatedCrossDeviceConversions
Display name Cross-device conversions
Description Conversions from when a customer clicks on an Google Ads ad on one device, then converts on a different device or browser. Cross-device conversions are already included in your AllConversions column
Field type metric
Data type float.number.value
EstimatedTotalConversions
Display name All conversions
Description Best estimate of the total number of conversions that Google Ads drives. Includes website, cross-device, and phone call conversions
Field type metric
Data type float.number.value
EstimatedTotalConversionValue
Display name All conversion value
Description The total value of all of your conversions, including those that are estimated
Field type metric
Data type float.currency.value
ExternalConversionSource
Display name External conversion source
Field type dimension
Data type string.text.value
Network
Display name Network
Field type dimension
Data type string.text.value
profileID
Display name Account ID
Field type dimension
Data type string.text.value
Viewthroughconversions
Display name View-through conversions
Description The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad
Field type metric
Data type float.number.value

Table: SEARCH_QUERY

Accountname_fromAW
Display name Account name
Field type dimension
Data type string.text.value
CampaignID
Display name Campaign ID
Description The ID of the Campaign
Field type dimension
Data type string.text.value
Campaignname
Display name Campaign name
Field type dimension
Data type string.text.value
Campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
Clicks
Display name Clicks
Field type metric
Data type int.number.value
Conversions
Display name Conversions
Description The number of conversions for all conversion actions that you have opted into optimization
Field type metric
Data type float.number.value
ConversionValue
Display name Total conversion value
Description The sum of conversion values for all conversions
Field type metric
Data type float.currency.value
Cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period
Field type metric
Data type float.currency.value
Cost_eur
Display name Cost (EUR)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to euros
Field type metric
Data type float.currency.value
Cost_gbp
Display name Cost (GBP)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to British pounds
Field type metric
Data type float.currency.value
Cost_usd
Display name Cost (USD)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to US dollars
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Field type dimension
Data type string.time.date
engagements
Display name Engagements
Description The number of engagements. An engagement occurs when a viewer expands your Lightbox ad. Also, in the future, other ad types may support engagement metrics
Field type metric
Data type int.number.value
Impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
interactions
Display name Interactions
Description The number of interactions. An interaction is the main user action associated with an ad format--clicks for text and shopping ads, views for video ads, and so on
Field type metric
Data type int.number.value
Keyword
Display name Keyword
Description Keyword that matched the query and triggered the ad
Field type dimension
Data type string.text.value
KeywordID
Display name Keyword ID
Description The ID of the Keyword that triggered the ad
Field type dimension
Data type string.text.value
profileID
Display name Account ID
Field type dimension
Data type string.text.value
QueryTargetingStatus
Display name Query targeting status
Description Indicates whether the search term is currently one of your targeted or excluded keywords
Field type dimension
Data type string.text.value
Searchterm
Display name Matched search term
Field type dimension
Data type string.text.value
Viewthroughconversions
Display name View-through conversions
Description The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad
Field type metric
Data type float.number.value

Table: SHOPPING

Accountname_fromAW
Display name Account name
Field type dimension
Data type string.text.value
Brand
Display name Brand
Description The ProductBrand value of the product
Field type dimension
Data type string.text.value
CampaignID
Display name Campaign ID
Description The ID of the Campaign
Field type dimension
Data type string.text.value
Campaignname
Display name Campaign name
Field type dimension
Data type string.text.value
Campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
CategoryL1
Display name CategoryL1
Field type dimension
Data type string.text.value
CategoryL2
Display name CategoryL2
Field type dimension
Data type string.text.value
CategoryL3
Display name CategoryL3
Field type dimension
Data type string.text.value
CategoryL4
Display name CategoryL4
Field type dimension
Data type string.text.value
CategoryL5
Display name CategoryL5
Field type dimension
Data type string.text.value
Clicks
Display name Clicks
Field type metric
Data type int.number.value
Cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period
Field type metric
Data type float.currency.value
CustomAttribute0
Display name CustomAttribute0
Description The ProductCustomAttribute level 0 value of the product
Field type dimension
Data type string.text.value
CustomAttribute1
Display name CustomAttribute1
Description The ProductCustomAttribute level 1 value of the product
Field type dimension
Data type string.text.value
CustomAttribute2
Display name CustomAttribute2
Description The ProductCustomAttribute level 2 value of the product
Field type dimension
Data type string.text.value
CustomAttribute3
Display name CustomAttribute3
Description The ProductCustomAttribute level 3 value of the product
Field type dimension
Data type string.text.value
CustomAttribute4
Display name CustomAttribute4
Description The ProductCustomAttribute level 4 value of the product
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Field type dimension
Data type string.time.date
Impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
Language
Display name Language
Field type dimension
Data type int.number.value
MerchantId
Display name Merchant ID
Description ID of the Google Merchant Center account associated with the products being advertised
Field type dimension
Data type string.text.value
OfferId
Display name Offer ID
Description Offer/item ID of the product
Field type dimension
Data type string.text.value
ProductCondition
Display name Product condition
Field type dimension
Data type string.text.value
ProductTitle
Display name Product Title
Field type dimension
Data type string.text.value
ProductTypeL1
Display name Product Type L1
Field type dimension
Data type string.text.value
ProductTypeL2
Display name Product Type L2
Field type dimension
Data type string.text.value
ProductTypeL3
Display name Product Type L3
Field type dimension
Data type string.text.value
ProductTypeL4
Display name Product Type L4
Field type dimension
Data type string.text.value
ProductTypeL5
Display name Product Type L5
Field type dimension
Data type string.text.value
profileID
Display name Account ID
Field type dimension
Data type string.text.value
StoreId
Display name Store ID
Description Store ID of the product
Field type dimension
Data type string.text.value

Table: GEO

Accountname_fromAW
Display name Account name
Field type dimension
Data type string.text.value
AdgroupID
Display name Ad group ID
Description The ID of the AdGroup
Field type dimension
Data type string.text.value
Adgroupname
Display name Ad group name
Description The name of the AdGroup
Field type dimension
Data type string.text.value
CampaignID
Display name Campaign ID
Description The ID of the Campaign
Field type dimension
Data type string.text.value
Campaignname
Display name Campaign name
Field type dimension
Data type string.text.value
Campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
City
Display name City
Field type dimension
Data type string.geo.city
Clicks
Display name Clicks
Field type metric
Data type int.number.value
Conversions
Display name Conversions
Description The number of conversions for all conversion actions that you have opted into optimization
Field type metric
Data type float.number.value
ConversionValue
Display name Total conversion value
Description The sum of conversion values for all conversions
Field type metric
Data type float.currency.value
Cost
Display name Cost
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period
Field type metric
Data type float.currency.value
Cost_eur
Display name Cost (EUR)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to euros
Field type metric
Data type float.currency.value
Cost_gbp
Display name Cost (GBP)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to British pounds
Field type metric
Data type float.currency.value
Cost_usd
Display name Cost (USD)
Description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period, converted to US dollars
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Field type dimension
Data type string.time.date
Impressions
Display name Impressions
Description Count of how often your ad has appeared on a search results page or website on the Google Network
Field type metric
Data type int.number.value
LocationType
Display name Location type
Field type dimension
Data type string.text.value
Metroarea
Display name Metro area
Field type dimension
Data type string.geo.metro
profileID
Display name Account ID
Field type dimension
Data type string.text.value
Region
Display name Region
Field type dimension
Data type string.geo.region
videoviews
Display name Video views
Description The number of times your video ads were viewed
Field type metric
Data type int.number.value
Viewthroughconversions
Display name View-through conversions
Description The total number of view-through conversions. These happen when a customer sees a Display network ad, then later completes a conversion on your site without interacting with (e.g. clicking on) another ad
Field type metric
Data type float.number.value