JDBC Driver for Google Ads

Build 22.0.8462

Customer

A customer.

Table Specific Information

Select

Google Ads does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be 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. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword 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.
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, UNSPECIFIED.

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 Output only. 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. A subset of the currency codes from the ISO 4217 standard is supported.
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 Customer is not associated with the Partners program, this will be false. For more information, see https://support.google.com/partners/answer/3125774.
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
CustomerManager Bool ATTRIBUTE Output only. Whether the customer is a manager.
CustomerOptimizationScore Double ATTRIBUTE Output only. Optimization score of the customer. Optimization score is an estimate of how well a customer's campaigns are set to perform. It ranges from 0% (0.0) to 100% (1.0). This field is null for all manager customers, and for unscored non-manager customers. See 'About optimization score' at https://support.google.com/google-ads/answer/9061546. This field is read-only.
CustomerOptimizationScoreWeight Double ATTRIBUTE Output only. Optimization score weight of the customer. Optimization score weight can be used to compare/aggregate optimization scores across multiple non-manager customers. The aggregate optimization score of a manager is computed as the sum over all of their customers of Customer.optimization_score * Customer.optimization_score_weight. This field is 0 for all manager customers, and for unscored non-manager customers. This field is read-only.
CustomerPayPerConversionEligibilityFailureReasons String ATTRIBUTE Output only. Reasons why the customer is not eligible to use PaymentMode.CONVERSIONS. If the list is empty, the customer is eligible. This field is read-only.

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, UNSPECIFIED.

CustomerRemarketingSettingGoogleGlobalSiteTag String ATTRIBUTE Output only. The Google tag.
CustomerResourceName String ATTRIBUTE Immutable. The resource name of the customer. Customer resource names have the form: customers/{customer_id}
CustomerStatus String ATTRIBUTE Output only. The status of the customer.

The allowed values are CANCELED, CLOSED, ENABLED, SUSPENDED, UNKNOWN, UNSPECIFIED.

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.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462