TargetingExpansionView
A targeting expansion view with metrics.
Columns
| Name | Type | Behavior | Description |
| AdGroupId | Long | SEGMENT | Output only. The ID of the ad group. |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| TargetingExpansionViewResourceName | String | ATTRIBUTE | Output only. The resource name of the targeting expansion view. |
| AbsoluteTopImpressionPercentage | Double | METRIC | Search absolute top impression share is the percentage of your Search ad |
| ActiveViewCpm | Double | METRIC | Average cost of viewable impressions (active_view_impressions). |
| ActiveViewCtr | Double | METRIC | Active view measurable clicks divided by active view viewable impressions. |
| ActiveViewImpressions | Long | METRIC | A measurement of how often your ad has become viewable on a Display |
| ActiveViewMeasurability | Double | METRIC | The ratio of impressions that could be measured by Active View over the |
| ActiveViewMeasurableCostMicros | Long | METRIC | The cost of the impressions you received that were measurable by Active |
| ActiveViewMeasurableImpressions | Long | METRIC | The number of times your ads are appearing on placements in positions |
| ActiveViewViewability | Double | METRIC | The percentage of time when your ad appeared on an Active View enabled site |
| AllConversions | Double | METRIC | The total number of conversions. This includes all conversions regardless |
| AllConversionsFromInteractionsRate | Double | METRIC | All conversions from interactions (as oppose to view through conversions) |
| AllConversionsFromInteractionsValuePerInteraction | Double | METRIC | The value of all conversions from interactions divided by the total number |
| AllConversionsValue | Double | METRIC | The value of all conversions. |
| AllConversionsValuePerCost | Double | METRIC | The value of all conversions divided by the total cost of ad interactions |
| AverageCartSize | Double | METRIC | Average cart size is the average number of products in each order |
| AverageCost | Double | METRIC | The average amount you pay per interaction. This amount is the total cost |
| AverageCpc | Double | METRIC | The total cost of all clicks divided by the total number of clicks |
| AverageCpe | Double | METRIC | The average amount that you've been charged for an ad engagement. This |
| AverageCpm | Double | METRIC | Average cost-per-thousand impressions (CPM). |
| AverageOrderValueMicros | Long | METRIC | Average order value is the average revenue you made per order attributed to |
| AveragePageViews | Double | METRIC | Average number of pages viewed per session. |
| AverageTimeOnSite | Double | METRIC | Total duration of all sessions (in seconds) / number of sessions. Imported |
| BounceRate | Double | METRIC | Percentage of clicks where the user only visited a single page on your |
| Clicks | Long | METRIC | The number of clicks. |
| Conversions | Double | METRIC | The number of conversions. This only includes conversion actions which |
| ConversionsFromInteractionsRate | Double | METRIC | Conversions from interactions divided by the number of ad interactions |
| ConversionsValue | Double | METRIC | The value of conversions. This only includes conversion actions which |
| ConversionsValuePerCost | Double | METRIC | The value of conversions divided by the cost of ad interactions. This only |
| CostMicros | Long | METRIC | The sum of your cost-per-click (CPC) and cost-per-thousand impressions |
| CostOfGoodsSoldMicros | Long | METRIC | Cost of goods sold (COGS) is the total cost of the products you sold in |
| CostPerAllConversions | Double | METRIC | The cost of ad interactions divided by all conversions. |
| CostPerConversion | Double | METRIC | The cost of ad interactions divided by conversions. This only includes |
| CostPerCurrentModelAttributedConversion | Double | METRIC | The cost of ad interactions divided by current model attributed |
| CrossDeviceConversions | Double | METRIC | Conversions from when a customer clicks on a Google Ads ad on one device, |
| CrossDeviceConversionsValueMicros | Long | METRIC | The sum of the value of cross-device conversions, in micros. |
| CrossSellCostOfGoodsSoldMicros | Long | METRIC | Cross-sell cost of goods sold (COGS) is the total cost of products sold as |
| CrossSellGrossProfitMicros | Long | METRIC | Cross-sell gross profit is the profit you made from products sold as a |
| CrossSellRevenueMicros | Long | METRIC | Cross-sell revenue is the total amount you made from products sold as a |
| CrossSellUnitsSold | Double | METRIC | Cross-sell units sold is the total number of products sold as a result of |
| Ctr | Double | METRIC | The number of clicks your ad receives (Clicks) divided by the number |
| CurrentModelAttributedConversions | Double | METRIC | Shows how your historic conversions data would look under the attribution |
| CurrentModelAttributedConversionsValue | Double | METRIC | The value of current model attributed conversions. This only includes |
| EngagementRate | Double | METRIC | How often people engage with your ad after it's shown to them. This is the |
| Engagements | Long | METRIC | The number of engagements. |
| GmailForwards | Long | METRIC | The number of times the ad was forwarded to someone else as a message. |
| GmailSaves | Long | METRIC | The number of times someone has saved your Gmail ad to their inbox as a |
| GmailSecondaryClicks | Long | METRIC | The number of clicks to the landing page on the expanded state of Gmail |
| GrossProfitMargin | Double | METRIC | Gross profit margin is the percentage gross profit you made from orders |
| GrossProfitMicros | Long | METRIC | Gross profit is the profit you made from orders attributed to your ads |
| Impressions | Long | METRIC | Count of how often your ad has appeared on a search results page or |
| InteractionEventTypes | String | METRIC | The types of payable and free interactions.
The allowed values are CLICK, ENGAGEMENT, NONE, UNKNOWN, VIDEO_VIEW. |
| InteractionRate | Double | METRIC | How often people interact with your ad after it is shown to them. |
| Interactions | Long | METRIC | The number of interactions. |
| LeadCostOfGoodsSoldMicros | Long | METRIC | Lead cost of goods sold (COGS) is the total cost of products sold as a |
| LeadGrossProfitMicros | Long | METRIC | Lead gross profit is the profit you made from products sold as a result of |
| LeadRevenueMicros | Long | METRIC | Lead revenue is the total amount you made from products sold as a result of |
| LeadUnitsSold | Double | METRIC | Lead units sold is the total number of products sold as a result of |
| Orders | Double | METRIC | Orders is the total number of purchase conversions you received attributed |
| PercentNewVisitors | Double | METRIC | Percentage of first-time sessions (from people who had never visited your |
| PhoneCalls | Long | METRIC | Number of offline phone calls. |
| RevenueMicros | Long | METRIC | Revenue is the total amount you made from orders attributed to your ads. |
| SearchAbsoluteTopImpressionShare | Double | METRIC | The percentage of the customer's Shopping or Search ad impressions that are |
| SearchBudgetLostAbsoluteTopImpressionShare | Double | METRIC | The number estimating how often your ad wasn't the very first ad among the |
| SearchBudgetLostTopImpressionShare | Double | METRIC | The number estimating how often your ad didn't show adjacent to the top |
| SearchClickShare | Double | METRIC | The number of clicks you've received on the Search Network |
| SearchExactMatchImpressionShare | Double | METRIC | The impressions you've received divided by the estimated number of |
| SearchImpressionShare | Double | METRIC | The impressions you've received on the Search Network divided |
| SearchRankLostAbsoluteTopImpressionShare | Double | METRIC | The number estimating how often your ad wasn't the very first ad among the |
| SearchRankLostImpressionShare | Double | METRIC | The estimated percentage of impressions on the Search Network |
| SearchRankLostTopImpressionShare | Double | METRIC | The number estimating how often your ad didn't show adjacent to the top |
| SearchTopImpressionShare | Double | METRIC | The impressions you've received among the top ads compared to the estimated |
| TopImpressionPercentage | Double | METRIC | The percent of your ad impressions that are shown adjacent to the top |
| TrueviewAverageCpv | Double | METRIC | The average amount you pay each time someone views your ad. |
| UnitsSold | Double | METRIC | Units sold is the total number of products sold from orders attributed to |
| ValuePerAllConversions | Double | METRIC | The value of all conversions divided by the number of all conversions. |
| ValuePerConversion | Double | METRIC | The value of conversions divided by the number of conversions. This only |
| ValuePerCurrentModelAttributedConversion | Double | METRIC | The value of current model attributed conversions divided by the number of |
| ViewThroughConversions | Long | METRIC | The total number of view-through conversions. |
| AdNetworkType | String | SEGMENT | Ad network type.
The allowed values are CONTENT, DISCOVER, GMAIL, GOOGLE_OWNED_CHANNELS, GOOGLE_TV, MAPS, MIXED, SEARCH, SEARCH_PARTNERS, UNKNOWN, YOUTUBE. |
| ClickType | String | SEGMENT | Click type.
The allowed values are AD_IMAGE, APP_DEEPLINK, BREADCRUMBS, BROADBAND_PLAN, CALLS, CALL_TRACKING, CLICK_ON_ENGAGEMENT_AD, CLICK_TO_MESSAGE_LANDING_PAGE_CLICK, CLICK_TO_MESSAGE_THIRD_PARTY_CLICK, CROSS_NETWORK, GET_DIRECTIONS, HOTEL_BOOK_ON_GOOGLE_ROOM_SELECTION, HOTEL_PRICE, LOCATION_EXPANSION, LOCATION_FORMAT_CALL, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_IMAGE, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_MAP, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_TEXT, MOBILE_CALL_TRACKING, OFFER_PRINTS, OTHER, PRICE_EXTENSION, PRODUCT_AD_APP_DEEPLINK, PRODUCT_ASSETS, PRODUCT_EXTENSION_CLICKS, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_CLICKS, PRODUCT_LISTING_AD_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_AD_TRANSACTABLE, PROMOTION_EXTENSION, SHOPPING_COMPARISON_LISTING, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SITELINKS, STORE_LOCATOR, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SWIPES, TRAVEL_ASSETS, UNKNOWN, URL_CLICKS, VEHICLE_ASSETS, VIDEO_APP_STORE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_CHANNEL_CLICK, VIDEO_END_CAP_CLICKS, VIDEO_RELATED_VIDEOS_CLICK, VIDEO_WEBSITE_CLICKS, VISUAL_SITELINKS, WIRELESS_PLAN. |
| ConversionAction | String | SEGMENT | Resource name of the conversion action. |
| ConversionActionCategory | String | SEGMENT | Conversion action category.
The allowed values are ADD_TO_CART, BEGIN_CHECKOUT, BOOK_APPOINTMENT, CONTACT, CONVERTED_LEAD, DEFAULT, DOWNLOAD, ENGAGEMENT, GET_DIRECTIONS, IMPORTED_LEAD, OUTBOUND_CLICK, PAGE_VIEW, PHONE_CALL_LEAD, PURCHASE, QUALIFIED_LEAD, REQUEST_QUOTE, SIGNUP, STORE_SALE, STORE_VISIT, SUBMIT_LEAD_FORM, SUBSCRIBE_PAID, UNKNOWN, YOUTUBE_FOLLOW_ON_VIEWS. |
| ConversionActionName | String | SEGMENT | Conversion action name. |
| ConversionAdjustment | Bool | SEGMENT | This segments your conversion columns by the original conversion and |
| ConversionLagBucket | String | SEGMENT | An enum value representing the number of days between the impression and
The allowed values are EIGHT_TO_NINE_DAYS, ELEVEN_TO_TWELVE_DAYS, FIVE_TO_SIX_DAYS, FORTY_FIVE_TO_SIXTY_DAYS, FOURTEEN_TO_TWENTY_ONE_DAYS, FOUR_TO_FIVE_DAYS, LESS_THAN_ONE_DAY, NINE_TO_TEN_DAYS, ONE_TO_TWO_DAYS, SEVEN_TO_EIGHT_DAYS, SIXTY_TO_NINETY_DAYS, SIX_TO_SEVEN_DAYS, TEN_TO_ELEVEN_DAYS, THIRTEEN_TO_FOURTEEN_DAYS, THIRTY_TO_FORTY_FIVE_DAYS, THREE_TO_FOUR_DAYS, TWELVE_TO_THIRTEEN_DAYS, TWENTY_ONE_TO_THIRTY_DAYS, TWO_TO_THREE_DAYS, UNKNOWN. |
| ConversionOrAdjustmentLagBucket | String | SEGMENT | An enum value representing the number of days between the impression and
The allowed values are ADJUSTMENT_EIGHT_TO_NINE_DAYS, ADJUSTMENT_ELEVEN_TO_TWELVE_DAYS, ADJUSTMENT_FIVE_TO_SIX_DAYS, ADJUSTMENT_FORTY_FIVE_TO_SIXTY_DAYS, ADJUSTMENT_FOURTEEN_TO_TWENTY_ONE_DAYS, ADJUSTMENT_FOUR_TO_FIVE_DAYS, ADJUSTMENT_LESS_THAN_ONE_DAY, ADJUSTMENT_NINETY_TO_ONE_HUNDRED_AND_FORTY_FIVE_DAYS, ADJUSTMENT_NINE_TO_TEN_DAYS, ADJUSTMENT_ONE_TO_TWO_DAYS, ADJUSTMENT_SEVEN_TO_EIGHT_DAYS, ADJUSTMENT_SIXTY_TO_NINETY_DAYS, ADJUSTMENT_SIX_TO_SEVEN_DAYS, ADJUSTMENT_TEN_TO_ELEVEN_DAYS, ADJUSTMENT_THIRTEEN_TO_FOURTEEN_DAYS, ADJUSTMENT_THIRTY_TO_FORTY_FIVE_DAYS, ADJUSTMENT_THREE_TO_FOUR_DAYS, ADJUSTMENT_TWELVE_TO_THIRTEEN_DAYS, ADJUSTMENT_TWENTY_ONE_TO_THIRTY_DAYS, ADJUSTMENT_TWO_TO_THREE_DAYS, ADJUSTMENT_UNKNOWN, CONVERSION_EIGHT_TO_NINE_DAYS, CONVERSION_ELEVEN_TO_TWELVE_DAYS, CONVERSION_FIVE_TO_SIX_DAYS, CONVERSION_FORTY_FIVE_TO_SIXTY_DAYS, CONVERSION_FOURTEEN_TO_TWENTY_ONE_DAYS, CONVERSION_FOUR_TO_FIVE_DAYS, CONVERSION_LESS_THAN_ONE_DAY, CONVERSION_NINE_TO_TEN_DAYS, CONVERSION_ONE_TO_TWO_DAYS, CONVERSION_SEVEN_TO_EIGHT_DAYS, CONVERSION_SIXTY_TO_NINETY_DAYS, CONVERSION_SIX_TO_SEVEN_DAYS, CONVERSION_TEN_TO_ELEVEN_DAYS, CONVERSION_THIRTEEN_TO_FOURTEEN_DAYS, CONVERSION_THIRTY_TO_FORTY_FIVE_DAYS, CONVERSION_THREE_TO_FOUR_DAYS, CONVERSION_TWELVE_TO_THIRTEEN_DAYS, CONVERSION_TWENTY_ONE_TO_THIRTY_DAYS, CONVERSION_TWO_TO_THREE_DAYS, CONVERSION_UNKNOWN, UNKNOWN. |
| Date | Date | SEGMENT | Date to which metrics apply. |
| Device | String | SEGMENT | Device to which metrics apply.
The allowed values are CONNECTED_TV, DESKTOP, MOBILE, OTHER, TABLET, UNKNOWN. |
| ExternalConversionSource | String | SEGMENT | External conversion source.
The allowed values are AD_CALL_METRICS, ANALYTICS, ANALYTICS_SEARCH_ADS_360, ANDROID_FIRST_OPEN, ANDROID_IN_APP, APP_UNSPECIFIED, CLICK_TO_CALL, DISPLAY_AND_VIDEO_360_FLOODLIGHT, FIREBASE, FIREBASE_SEARCH_ADS_360, FLOODLIGHT, GOOGLE_ATTRIBUTION, GOOGLE_HOSTED, GOOGLE_PLAY, IOS_FIRST_OPEN, IOS_IN_APP, SALESFORCE, SEARCH_ADS_360, STORE_SALES, STORE_SALES_CRM, STORE_SALES_DIRECT_UPLOAD, STORE_SALES_PAYMENT_NETWORK, STORE_VISITS, THIRD_PARTY_APP_ANALYTICS, UNKNOWN, UPLOAD, UPLOAD_CALLS, WEBPAGE, WEBSITE_CALL_METRICS. |
| Month | Date | SEGMENT | Month as represented by the date of the first day of a month. Formatted as |
| MonthOfYear | String | SEGMENT | Month of the year, for example, January.
The allowed values are APRIL, AUGUST, DECEMBER, FEBRUARY, JANUARY, JULY, JUNE, MARCH, MAY, NOVEMBER, OCTOBER, SEPTEMBER, UNKNOWN. |
| NewVersusReturningCustomers | String | SEGMENT | This is for segmenting conversions by whether the user is a new customer
The allowed values are NEW, NEW_AND_HIGH_LTV, RETURNING, UNKNOWN. |
| Period | String | SEGMENT | Predefined date range.
The allowed values are TODAY, YESTERDAY, LAST_7_DAYS, LAST_BUSINESS_WEEK, THIS_MONTH, LAST_MONTH, LAST_14_DAYS, LAST_30_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK_SUN_SAT, LAST_WEEK_MON_SUN. |
| Quarter | Date | SEGMENT | Quarter as represented by the date of the first day of a quarter. |
| Slot | String | SEGMENT | Position of the ad.
The allowed values are CONTENT, MIXED, SEARCH_OTHER, SEARCH_PARTNER_OTHER, SEARCH_PARTNER_TOP, SEARCH_SIDE, SEARCH_TOP, UNKNOWN. |
| Year | Int | SEGMENT | Year, formatted as yyyy. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |