Customer
A customer.
View-Specific Information
Select
Google Ads does not allow every column to be selected in a single query, as some data conflicts if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes are returned. In general, these defaults are the same fields that are exposed through the Ads console. To use the nondefault fields, explicitly select them in your query.
Filters can also be used in the WHERE clause using the following supported operators: =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, NOT IN . Note that all filters must be joined by AND, as OR is not supported by the Ads API.
Columns
| Name | Type | Behavior | Description |
| CustomerAutoTaggingEnabled | Bool | ATTRIBUTE | Whether auto-tagging is enabled for the customer. |
| CustomerCallReportingSettingCallConversionAction | String | ATTRIBUTE | Customer-level call conversion action to attribute a call conversion to. If not set a default conversion action is used. Only in effect when call_conversion_reporting_enabled is set to true. |
| CustomerCallReportingSettingCallConversionReportingEnabled | Bool | ATTRIBUTE | Whether to enable call conversion reporting. |
| CustomerCallReportingSettingCallReportingEnabled | Bool | ATTRIBUTE | Enable reporting of phone call events by redirecting them through Google System. |
| CustomerContainsEuPoliticalAdvertising | String | ATTRIBUTE | Output only. Returns the advertiser self-declaration status of whether this
The allowed values are CONTAINS_EU_POLITICAL_ADVERTISING, DOES_NOT_CONTAIN_EU_POLITICAL_ADVERTISING, UNKNOWN. |
| CustomerConversionTrackingSettingAcceptedCustomerDataTerms | Bool | ATTRIBUTE | Output only. Whether the customer has accepted customer data terms. If using cross-account conversion tracking, this value is inherited from the manager. This field is read-only. For more information, see https://support.google.com/adspolicy/answer/7475709. |
| CustomerConversionTrackingSettingConversionTrackingId | Long | ATTRIBUTE | Output only. The conversion tracking id used for this account. This id doesn't indicate whether the customer uses conversion tracking (conversion_tracking_status does). This field is read-only. |
| CustomerConversionTrackingSettingConversionTrackingStatus | String | ATTRIBUTE | Output only. Conversion tracking status. It indicates whether the customer is using conversion tracking, and who is the conversion tracking owner of this customer. If this customer is using cross-account conversion tracking, the value returned will differ based on the login-customer-id of the request.
The allowed values are CONVERSION_TRACKING_MANAGED_BY_ANOTHER_MANAGER, CONVERSION_TRACKING_MANAGED_BY_SELF, CONVERSION_TRACKING_MANAGED_BY_THIS_MANAGER, NOT_CONVERSION_TRACKED, UNKNOWN. |
| CustomerConversionTrackingSettingCrossAccountConversionTrackingId | Long | ATTRIBUTE | Output only. The conversion tracking id of the customer's manager. This is set when the customer is opted into cross account conversion tracking, and it overrides conversion_tracking_id. This field can only be managed through the Google Ads UI. This field is read-only. |
| CustomerConversionTrackingSettingEnhancedConversionsForLeadsEnabled | Bool | ATTRIBUTE | Output only. Whether the customer is opted-in for enhanced conversions for leads. If using cross-account conversion tracking, this value is inherited from the manager. This field is read-only. |
| CustomerConversionTrackingSettingGoogleAdsConversionCustomer | String | ATTRIBUTE | The resource name of the customer where conversions are created and managed. This field is read-only. |
| CustomerCurrencyCode | String | ATTRIBUTE | Immutable. The currency in which the account operates. |
| CustomerCustomerAgreementSettingAcceptedLeadFormTerms | Bool | ATTRIBUTE | Output only. Whether the customer has accepted lead form term of service. |
| CustomerDescriptiveName | String | ATTRIBUTE | Optional, non-unique descriptive name of the customer. |
| CustomerFinalUrlSuffix | String | ATTRIBUTE | The URL template for appending params to the final URL. |
| CustomerHasPartnersBadge | Bool | ATTRIBUTE | Output only. Whether the Customer has a Partners program badge. If the |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| CustomerImageAssetAutoMigrationDone | Bool | ATTRIBUTE | Output only. True if feed based image has been migrated to asset based |
| CustomerImageAssetAutoMigrationDoneDateTime | Datetime | ATTRIBUTE | Output only. Timestamp of migration from feed based image to asset base |
| CustomerLocalServicesSettingsGranularInsuranceStatuses | String | ATTRIBUTE | Output only. A read-only list of geo vertical level insurance statuses. |
| CustomerLocalServicesSettingsGranularLicenseStatuses | String | ATTRIBUTE | Output only. A read-only list of geo vertical level license statuses. |
| CustomerLocationAssetAutoMigrationDone | Bool | ATTRIBUTE | Output only. True if feed based location has been migrated to asset based |
| CustomerLocationAssetAutoMigrationDoneDateTime | Datetime | ATTRIBUTE | Output only. Timestamp of migration from feed based location to asset base |
| CustomerManager | Bool | ATTRIBUTE | Output only. Whether the customer is a manager. |
| CustomerOptimizationScore | Double | ATTRIBUTE | Output only. Optimization score of the customer. |
| CustomerOptimizationScoreWeight | Double | ATTRIBUTE | Output only. Optimization score weight of the customer. |
| CustomerPayPerConversionEligibilityFailureReasons | String | ATTRIBUTE | Output only. Reasons why the customer is not eligible to use
The allowed values are ANALYSIS_NOT_COMPLETE, AVERAGE_DAILY_SPEND_TOO_HIGH, CONVERSION_LAG_TOO_HIGH, HAS_CAMPAIGN_WITH_SHARED_BUDGET, HAS_UPLOAD_CLICKS_CONVERSION, NOT_ENOUGH_CONVERSIONS, OTHER, UNKNOWN. |
| CustomerRemarketingSettingGoogleGlobalSiteTag | String | ATTRIBUTE | Output only. The Google tag. |
| CustomerResourceName | String | ATTRIBUTE | Immutable. The resource name of the customer. |
| CustomerStatus | String | ATTRIBUTE | Output only. The status of the customer.
The allowed values are CANCELED, CLOSED, ENABLED, SUSPENDED, UNKNOWN. |
| CustomerTestAccount | Bool | ATTRIBUTE | Output only. Whether the customer is a test account. |
| CustomerTimeZone | String | ATTRIBUTE | Immutable. The local timezone ID of the customer. |
| CustomerTrackingUrlTemplate | String | ATTRIBUTE | The URL template for constructing a tracking URL out of parameters. |
| CustomerVideoBrandSafetySuitability | String | ATTRIBUTE | Brand Safety setting at the account level. Allows for selecting
The allowed values are EXPANDED_INVENTORY, LIMITED_INVENTORY, STANDARD_INVENTORY, UNKNOWN. |
| CustomerVideoCustomerThirdPartyIntegrationPartnersBrandLiftIntegrationPartners | String | ATTRIBUTE | Allowed third party integration partners for Brand Lift verification. |
| CustomerVideoCustomerThirdPartyIntegrationPartnersBrandSafetyIntegrationPartners | String | ATTRIBUTE | Allowed third party integration partners for brand safety verification. |
| CustomerVideoCustomerThirdPartyIntegrationPartnersReachIntegrationPartners | String | ATTRIBUTE | Allowed third party integration partners for reach verification. |
| CustomerVideoCustomerThirdPartyIntegrationPartnersViewabilityIntegrationPartners | String | ATTRIBUTE | Allowed third party integration partners for YouTube viewability verification. |
| AbsoluteTopImpressionPercentage | Double | METRIC | Search absolute top impression share is the percentage of your Search ad |
| ActiveViewAudibilityInvalidGivtMeasurableImpressionsRate | Double | METRIC | The number of impressions for which Active View could measure audibility, |
| ActiveViewAudibilityInvalidMeasurableImpressionsRate | Double | METRIC | The number of impressions for which Active View could measure audibility, |
| ActiveViewAudibilityMeasurableImpressions | Long | METRIC | The number of impressions for which Active View could measure if the ad was |
| ActiveViewAudibilityMeasurableImpressionsRate | Double | METRIC | The number of impressions for which Active View could measure if the ad was |
| ActiveViewAudibleImpressions | Long | METRIC | The number of impressions that were audible (volume > 0%) at any point |
| ActiveViewAudibleImpressionsRate | Double | METRIC | The number of impressions that were audible (volume > 0%) at any point |
| ActiveViewAudibleQuartileP100Rate | Double | METRIC | The number of impressions that were audible at the fourth quartile of the |
| ActiveViewAudibleQuartileP25Rate | Double | METRIC | The number of impressions that were audible at the first quartile of the |
| ActiveViewAudibleQuartileP50Rate | Double | METRIC | The number of impressions that were audible at the second quartile of the |
| ActiveViewAudibleQuartileP75Rate | Double | METRIC | The number of impressions that were audible at the third quartile of the |
| ActiveViewAudibleThirtySecondsImpressions | Long | METRIC | The number of impressions that were audible for at least 30 seconds |
| ActiveViewAudibleThirtySecondsImpressionsRate | Double | METRIC | The number of impressions that were audible for at least 30 seconds |
| ActiveViewAudibleTwoSecondsImpressions | Long | METRIC | The number of impressions that were audible for at least 2 seconds |
| ActiveViewAudibleTwoSecondsImpressionsRate | Double | METRIC | The number of impressions that were audible for at least 2 seconds |
| 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 |
| AllConversionsByConversionDate | 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) |
| AllConversionsFromLocationAssetClickToCall | Double | METRIC | Number of call button clicks on any location surface after a chargeable ad |
| AllConversionsFromLocationAssetDirections | Double | METRIC | Number of driving directions clicks on any location surface after a |
| AllConversionsFromLocationAssetMenu | Double | METRIC | Number of menu link clicks on any location surface after a chargeable ad |
| AllConversionsFromLocationAssetOrder | Double | METRIC | Number of order clicks on any location surface after a chargeable ad event |
| AllConversionsFromLocationAssetOtherEngagement | Double | METRIC | Number of other types of local action clicks on any location surface after |
| AllConversionsFromLocationAssetStoreVisits | Double | METRIC | Estimated number of visits to the business after a chargeable |
| AllConversionsFromLocationAssetWebsite | Double | METRIC | Number of website URL clicks on any location surface after a chargeable ad |
| AllConversionsValue | Double | METRIC | The value of all conversions. |
| AllConversionsValueByConversionDate | Double | METRIC | The value of all conversions. When this column is selected with date, the |
| AllNewCustomerLifetimeValue | Double | METRIC | All of new customers' lifetime conversion value. If you have set up |
| 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 |
| AverageVideoWatchTimeDurationMillis | Long | METRIC | Average video watch time duration in milliseconds for video impressions |
| BiddableIndirectInstallFirstInAppConversionMicros | Long | METRIC | The number of biddable first in app conversions where the app install was |
| Clicks | Long | METRIC | The number of clicks. |
| ClicksUniqueQueryClusters | Long | METRIC | Unique query intent cluster count for clicks. |
| ContentBudgetLostImpressionShare | Double | METRIC | The estimated percent of times that your ad was eligible to show |
| ContentImpressionShare | Double | METRIC | The impressions you've received on the Display Network divided |
| ContentRankLostImpressionShare | Double | METRIC | The estimated percentage of impressions on the Display Network |
| Conversions | Double | METRIC | The number of conversions. This only includes conversion actions which |
| ConversionsByConversionDate | 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 |
| ConversionsUniqueQueryClusters | Long | METRIC | Unique query intent cluster count for conversions. |
| ConversionsValue | Double | METRIC | The value of conversions. This only includes conversion actions which |
| ConversionsValueByConversionDate | Double | METRIC | The value of conversions. This only includes conversion actions which |
| CostConvertedCurrencyPerPlatformComparableConversion | Double | METRIC | The cost of the platform comparable conversion in the currency of the |
| 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 |
| CostPerPlatformComparableConversion | Double | METRIC | The cost of ad interactions divided by the number of platform comparable |
| CrossDeviceConversions | Double | METRIC | Conversions from when a customer clicks on a Google Ads ad on one device, |
| CrossDeviceConversionsByConversionDate | Double | METRIC | The number of cross-device conversions by conversion date. |
| CrossDeviceConversionsValueByConversionDate | Double | METRIC | The sum of cross-device conversions value by conversion date. |
| 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 |
| EligibleImpressionsFromLocationAssetStoreReach | Long | METRIC | Number of impressions in which the business location was shown or the |
| 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. |
| GeneralInvalidClickRate | Double | METRIC | The percentage of clicks that have been filtered out of your total number |
| GeneralInvalidClicks | Long | METRIC | Number of general invalid clicks. These are a subset of your invalid clicks |
| 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 |
| ImpressionsUniqueQueryClusters | Long | METRIC | Unique query intent cluster count for impressions. |
| 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. |
| InvalidClickRate | Double | METRIC | The percentage of clicks filtered out of your total number of clicks |
| InvalidClicks | Long | METRIC | Number of clicks Google considers illegitimate and doesn't charge you for. |
| 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 |
| NewCustomerLifetimeValue | Double | METRIC | New customers' lifetime conversion value. If you have set up |
| OptimizationScoreUplift | Double | METRIC | Total optimization score uplift of all recommendations. |
| OptimizationScoreUrl | String | METRIC | URL for the optimization score page in the Google Ads web interface. |
| Orders | Double | METRIC | Orders is the total number of purchase conversions you received attributed |
| PlatformComparableConversions | Double | METRIC | The number of platform comparable conversions. This only includes |
| PlatformComparableConversionsByConversionDate | Double | METRIC | The number of platform comparable conversions. When this metric is |
| PlatformComparableConversionsFromInteractionsRate | Double | METRIC | Platform comparable conversions from interactions divided by the number of |
| PlatformComparableConversionsFromInteractionsValuePerInteraction | Double | METRIC | The value of platform comparable conversions from interactions divided by |
| PlatformComparableConversionsValue | Double | METRIC | The value of platform comparable conversions. This only includes conversion |
| PlatformComparableConversionsValueByConversionDate | Double | METRIC | The value of platform comparable conversions. When this metric is segmented |
| PlatformComparableConversionsValuePerCost | Double | METRIC | The value of conversions divided by the cost of ad interactions. This only |
| RevenueMicros | Long | METRIC | Revenue is the total amount you made from orders attributed to your ads. |
| SearchBudgetLostImpressionShare | Double | METRIC | The estimated percent of times that your ad was eligible to show on the |
| 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 |
| SearchRankLostImpressionShare | Double | METRIC | The estimated percentage of impressions on the Search Network |
| SkAdNetworkInstalls | Long | METRIC | The number of iOS Store Kit Ad Network conversions. |
| SkAdNetworkTotalConversions | Long | METRIC | The total number of iOS Store Kit Ad Network conversions. |
| 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. |
| ValuePerAllConversionsByConversionDate | Double | METRIC | The value of all conversions divided by the number of all conversions. When |
| ValuePerConversion | Double | METRIC | The value of conversions divided by the number of conversions. This only |
| ValuePerConversionsByConversionDate | Double | METRIC | The value of conversions divided by the number of conversions. This only |
| ValuePerPlatformComparableConversion | Double | METRIC | The value of platform comparable conversions divided by the number of |
| ValuePerPlatformComparableConversionsByConversionDate | Double | METRIC | The value of platform comparable conversions divided by the number of |
| VideoTrueviewViewRate | Double | METRIC | The number of TrueView views your video ad receives divided by its number |
| VideoTrueviewViewRateInFeed | Double | METRIC | The number of TrueView views divided by number of impressions that can |
| VideoTrueviewViewRateInStream | Double | METRIC | The number of TrueView views divided by number of impressions that can |
| VideoTrueviewViewRateShorts | Double | METRIC | The number of TrueView views divided by number of impressions that can |
| VideoTrueviewViews | Long | METRIC | The number of TrueView views your video ads received. |
| VideoWatchTimeDurationMillis | Long | METRIC | Total watch time duration in milliseconds for video impressions that |
| ViewThroughConversions | Long | METRIC | The total number of view-through conversions. |
| ViewThroughConversionsFromLocationAssetClickToCall | Double | METRIC | Number of call button clicks on any location surface after an impression. |
| ViewThroughConversionsFromLocationAssetDirections | Double | METRIC | Number of driving directions clicks on any location surface after an |
| ViewThroughConversionsFromLocationAssetMenu | Double | METRIC | Number of menu link clicks on any location surface after an impression. |
| ViewThroughConversionsFromLocationAssetOrder | Double | METRIC | Number of order clicks on any location surface after an impression. This |
| ViewThroughConversionsFromLocationAssetOtherEngagement | Double | METRIC | Number of other types of local action clicks on any location surface after |
| ViewThroughConversionsFromLocationAssetStoreVisits | Double | METRIC | Estimated number of visits to the business after an impression. |
| ViewThroughConversionsFromLocationAssetWebsite | Double | METRIC | Number of website URL clicks on any location surface after an impression. |
| AdFormatType | String | SEGMENT | Ad Format type.
The allowed values are AUDIO, BUMPER, INFEED, INSTREAM_NON_SKIPPABLE, INSTREAM_SKIPPABLE, MASTHEAD, OTHER, OUTSTREAM, PAUSE, SHORTS, TEXT, UNKNOWN, UNSEGMENTED, VERTICAL_ADS_BOOKING_LINK, VERTICAL_ADS_PROMOTION. |
| 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. |
| AdSubNetworkType | String | SEGMENT | Ad sub network type. Currently only available for ads running as part of
The allowed values are UNKNOWN, UNSEGMENTED, YOUTUBE_INFEED, YOUTUBE_INSTREAM, YOUTUBE_SHORTS. |
| AdUsingProductData | Bool | SEGMENT | Indicates whether an ad is using product data from a Google Merchant |
| AdUsingVideo | Bool | SEGMENT | Indicates whether an ad is using a video asset. This segment is only |
| AuctionInsightDomain | String | SEGMENT | Domain (visible URL) of a participant in the Auction Insights report. |
| 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. |
| ConversionValueRulePrimaryDimension | String | SEGMENT | Primary dimension of applied conversion value rules.
The allowed values are AUDIENCE, DEVICE, GEO_LOCATION, ITINERARY, MULTIPLE, NEW_VS_RETURNING_USER, NO_RULE_APPLIED, ORIGINAL, UNKNOWN. |
| Date | Date | SEGMENT | Date to which metrics apply. |
| DayOfWeek | String | SEGMENT | Day of the week, for example, MONDAY.
The allowed values are FRIDAY, MONDAY, SATURDAY, SUNDAY, THURSDAY, TUESDAY, UNKNOWN, WEDNESDAY. |
| 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. |
| Hour | Int | SEGMENT | Hour of day as a number between 0 and 23, inclusive. |
| 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. |
| RecommendationType | String | SEGMENT | Recommendation type.
The allowed values are CALLOUT_ASSET, CALL_ASSET, CAMPAIGN_BUDGET, CUSTOM_AUDIENCE_OPT_IN, DISPLAY_EXPANSION_OPT_IN, DYNAMIC_IMAGE_EXTENSION_OPT_IN, ENHANCED_CPC_OPT_IN, FORECASTING_CAMPAIGN_BUDGET, FORECASTING_SET_TARGET_CPA, FORECASTING_SET_TARGET_ROAS, IMPROVE_DEMAND_GEN_AD_STRENGTH, IMPROVE_GOOGLE_TAG_COVERAGE, IMPROVE_PERFORMANCE_MAX_AD_STRENGTH, KEYWORD, KEYWORD_MATCH_TYPE, LEAD_FORM_ASSET, LOWER_TARGET_ROAS, MARGINAL_ROI_CAMPAIGN_BUDGET, MAXIMIZE_CLICKS_OPT_IN, MAXIMIZE_CONVERSIONS_OPT_IN, MAXIMIZE_CONVERSION_VALUE_OPT_IN, MIGRATE_DYNAMIC_SEARCH_ADS_CAMPAIGN_TO_PERFORMANCE_MAX, MOVE_UNUSED_BUDGET, OPTIMIZE_AD_ROTATION, PERFORMANCE_MAX_FINAL_URL_OPT_IN, PERFORMANCE_MAX_OPT_IN, RAISE_TARGET_CPA, RAISE_TARGET_CPA_BID_TOO_LOW, REFRESH_CUSTOMER_MATCH_LIST, RESPONSIVE_SEARCH_AD, RESPONSIVE_SEARCH_AD_ASSET, RESPONSIVE_SEARCH_AD_IMPROVE_AD_STRENGTH, SEARCH_PARTNERS_OPT_IN, SET_TARGET_CPA, SET_TARGET_ROAS, SHOPPING_ADD_AGE_GROUP, SHOPPING_ADD_COLOR, SHOPPING_ADD_GENDER, SHOPPING_ADD_GTIN, SHOPPING_ADD_MORE_IDENTIFIERS, SHOPPING_ADD_PRODUCTS_TO_CAMPAIGN, SHOPPING_ADD_SIZE, SHOPPING_FIX_DISAPPROVED_PRODUCTS, SHOPPING_FIX_MERCHANT_CENTER_ACCOUNT_SUSPENSION_WARNING, SHOPPING_FIX_SUSPENDED_MERCHANT_CENTER_ACCOUNT, SHOPPING_MIGRATE_REGULAR_SHOPPING_CAMPAIGN_OFFERS_TO_PERFORMANCE_MAX, SHOPPING_TARGET_ALL_OFFERS, SITELINK_ASSET, TARGET_CPA_OPT_IN, TARGET_ROAS_OPT_IN, TEXT_AD, UNKNOWN, UPGRADE_LOCAL_CAMPAIGN_TO_PERFORMANCE_MAX, UPGRADE_SMART_SHOPPING_CAMPAIGN_TO_PERFORMANCE_MAX, USE_BROAD_MATCH_KEYWORD. |
| SkAdNetworkAdEventType | String | SEGMENT | iOS Store Kit Ad Network ad event type.
The allowed values are INTERACTION, UNAVAILABLE, UNKNOWN, VIEW. |
| SkAdNetworkAttributionCredit | String | SEGMENT | iOS Store Kit Ad Network attribution credit
The allowed values are CONTRIBUTED, UNAVAILABLE, UNKNOWN, WON. |
| SkAdNetworkCoarseConversionValue | String | SEGMENT | iOS Store Kit Ad Network coarse conversion value.
The allowed values are HIGH, LOW, MEDIUM, NONE, UNAVAILABLE, UNKNOWN. |
| SkAdNetworkFineConversionValue | Long | SEGMENT | iOS Store Kit Ad Network conversion value. |
| SkAdNetworkPostbackSequenceIndex | Long | SEGMENT | iOS Store Kit Ad Network postback sequence index. |
| SkAdNetworkRedistributedFineConversionValue | Long | SEGMENT | iOS Store Kit Ad Network redistributed fine conversion value. |
| SkAdNetworkSourceAppSkAdNetworkSourceAppId | String | SEGMENT | App id where the ad that drove the iOS Store Kit Ad Network install was shown. |
| SkAdNetworkSourceDomain | String | SEGMENT | Website where the ad that drove the iOS Store Kit Ad Network install was |
| SkAdNetworkSourceType | String | SEGMENT | The source type where the ad that drove the iOS Store Kit Ad Network
The allowed values are MOBILE_APPLICATION, UNAVAILABLE, UNKNOWN, WEBSITE. |
| SkAdNetworkUserType | String | SEGMENT | iOS Store Kit Ad Network user type.
The allowed values are NEW_INSTALLER, REINSTALLER, UNAVAILABLE, UNKNOWN. |
| SkAdNetworkVersion | String | SEGMENT | The version of the SKAdNetwork API used. |
| 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. |
| VerticalAdsEventParticipantDisplayNames | String | SEGMENT | The display names of participants in an event listing, like performers, |
| VerticalAdsHotelClass | Long | SEGMENT | The class of the hotel. Generally in the range of 1 to 5 stars, but fully |
| VerticalAdsListing | String | SEGMENT | The listing associated with a listing impression, click or conversion. |
| VerticalAdsListingBrand | String | SEGMENT | The brand associated with a specific listing within a Vertical Ads |
| VerticalAdsListingCity | String | SEGMENT | The city where the vertical ads listing is located. |
| VerticalAdsListingCountry | String | SEGMENT | The country where the vertical ads listing is located. |
| VerticalAdsListingRegion | String | SEGMENT | The region where the vertical ads listing is located. |
| VerticalAdsPartnerAccount | Long | SEGMENT | A specific partner account within a Partner Center (for example, Hotel |
| VerticalAdsVertical | String | SEGMENT | Type of vertical ad, such as Vacation Rentals, Car Rentals, or
The allowed values are EVENTS, FLIGHTS, HOTELS, RENTAL_CARS, THINGS_TO_DO, UNKNOWN, VACATION_RENTALS. |
| Week | Date | SEGMENT | Week as defined as Monday through Sunday, and represented by the date of |
| 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. |