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

AutoTaggingEnabled column for table Customer

CustomerCallReportingSettingCallConversionAction

String

Attribute

CallReportingSettingCallConversionAction column for table Customer

CustomerCallReportingSettingCallConversionReportingEnabled

Bool

Attribute

CallReportingSettingCallConversionReportingEnabled column for table Customer

CustomerCallReportingSettingCallReportingEnabled

Bool

Attribute

CallReportingSettingCallReportingEnabled column for table Customer

CustomerConversionTrackingSettingConversionTrackingId

Long

Attribute

ConversionTrackingSettingConversionTrackingId column for table Customer

CustomerConversionTrackingSettingCrossAccountConversionTrackingId

Long

Attribute

ConversionTrackingSettingCrossAccountConversionTrackingId column for table Customer

CustomerCurrencyCode

String

Attribute

CurrencyCode column for table Customer

CustomerDescriptiveName

String

Attribute

DescriptiveName column for table Customer

CustomerFinalUrlSuffix

String

Attribute

FinalUrlSuffix column for table Customer

CustomerHasPartnersBadge

Bool

Attribute

HasPartnersBadge column for table Customer

CustomerId

Long

Attribute

Id column for table Customer

CustomerManager

Bool

Attribute

Manager column for table Customer

CustomerOptimizationScore

Double

Attribute

OptimizationScore column for table Customer

CustomerOptimizationScoreWeight

Double

Attribute

OptimizationScoreWeight column for table Customer

CustomerPayPerConversionEligibilityFailureReasons

String

Attribute

PayPerConversionEligibilityFailureReasons column for table Customer

CustomerRemarketingSettingGoogleGlobalSiteTag

String

Attribute

RemarketingSettingGoogleGlobalSiteTag column for table Customer

CustomerResourceName

String

Attribute

ResourceName column for table Customer

CustomerTestAccount

Bool

Attribute

TestAccount column for table Customer

CustomerTimeZone

String

Attribute

TimeZone column for table Customer

CustomerTrackingUrlTemplate

String

Attribute

TrackingUrlTemplate column for table Customer

CustomerId

Long

Attribute

ClientCustomerId column for table Customer

ActiveViewCpm

Double

Metric

ActiveViewCpm column for table Metrics

ActiveViewCtr

Double

Metric

ActiveViewCtr column for table Metrics

ActiveViewImpressions

Long

Metric

ActiveViewImpressions column for table Metrics

ActiveViewMeasurability

Double

Metric

ActiveViewMeasurability column for table Metrics

ActiveViewMeasurableCostMicros

Long

Metric

ActiveViewMeasurableCostMicros column for table Metrics

ActiveViewMeasurableImpressions

Long

Metric

ActiveViewMeasurableImpressions column for table Metrics

ActiveViewViewability

Double

Metric

ActiveViewViewability column for table Metrics

AllConversions

Double

Metric

AllConversions column for table Metrics

AllConversionsByConversionDate

Double

Metric

AllConversionsByConversionDate column for table Metrics

AllConversionsFromInteractionsRate

Double

Metric

AllConversionsFromInteractionsRate column for table Metrics

AllConversionsValue

Double

Metric

AllConversionsValue column for table Metrics

AllConversionsValueByConversionDate

Double

Metric

AllConversionsValueByConversionDate column for table Metrics

AverageCost

Double

Metric

AverageCost column for table Metrics

AverageCpc

Double

Metric

AverageCpc column for table Metrics

AverageCpe

Double

Metric

AverageCpe column for table Metrics

AverageCpm

Double

Metric

AverageCpm column for table Metrics

AverageCpv

Double

Metric

AverageCpv column for table Metrics

Clicks

Long

Metric

Clicks column for table Metrics

ContentBudgetLostImpressionShare

Double

Metric

ContentBudgetLostImpressionShare column for table Metrics

ContentImpressionShare

Double

Metric

ContentImpressionShare column for table Metrics

ContentRankLostImpressionShare

Double

Metric

ContentRankLostImpressionShare column for table Metrics

Conversions

Double

Metric

Conversions column for table Metrics

ConversionsByConversionDate

Double

Metric

ConversionsByConversionDate column for table Metrics

ConversionsFromInteractionsRate

Double

Metric

ConversionsFromInteractionsRate column for table Metrics

ConversionsValue

Double

Metric

ConversionsValue column for table Metrics

ConversionsValueByConversionDate

Double

Metric

ConversionsValueByConversionDate column for table Metrics

CostMicros

Long

Metric

CostMicros column for table Metrics

CostPerAllConversions

Double

Metric

CostPerAllConversions column for table Metrics

CostPerConversion

Double

Metric

CostPerConversion column for table Metrics

CrossDeviceConversions

Double

Metric

CrossDeviceConversions column for table Metrics

Ctr

Double

Metric

Ctr column for table Metrics

EngagementRate

Double

Metric

EngagementRate column for table Metrics

Engagements

Long

Metric

Engagements column for table Metrics

Impressions

Long

Metric

Impressions column for table Metrics

InteractionEventTypes

String

Metric

InteractionEventTypes column for table Metrics

InteractionRate

Double

Metric

InteractionRate column for table Metrics

Interactions

Long

Metric

Interactions column for table Metrics

InvalidClickRate

Double

Metric

InvalidClickRate column for table Metrics

InvalidClicks

Long

Metric

InvalidClicks column for table Metrics

OptimizationScoreUplift

Double

Metric

OptimizationScoreUplift column for table Metrics

OptimizationScoreUrl

String

Metric

OptimizationScoreUrl column for table Metrics

SearchBudgetLostImpressionShare

Double

Metric

SearchBudgetLostImpressionShare column for table Metrics

SearchExactMatchImpressionShare

Double

Metric

SearchExactMatchImpressionShare column for table Metrics

SearchImpressionShare

Double

Metric

SearchImpressionShare column for table Metrics

SearchRankLostImpressionShare

Double

Metric

SearchRankLostImpressionShare column for table Metrics

SkAdNetworkConversions

Long

Metric

SkAdNetworkConversions column for table Metrics

ValuePerAllConversions

Double

Metric

ValuePerAllConversions column for table Metrics

ValuePerAllConversionsByConversionDate

Double

Metric

ValuePerAllConversionsByConversionDate column for table Metrics

ValuePerConversion

Double

Metric

ValuePerConversion column for table Metrics

ValuePerConversionsByConversionDate

Double

Metric

ValuePerConversionsByConversionDate column for table Metrics

VideoViewRate

Double

Metric

VideoViewRate column for table Metrics

VideoViews

Long

Metric

VideoViews column for table Metrics

ViewThroughConversions

Long

Metric

ViewThroughConversions column for table Metrics

AdNetworkType

String

Segment

AdNetworkType column for table Segments

ClickType

String

Segment

ClickType column for table Segments

ConversionAction

String

Segment

ConversionAction column for table Segments

ConversionActionCategory

String

Segment

ConversionActionCategory column for table Segments

ConversionActionName

String

Segment

ConversionActionName column for table Segments

ConversionAdjustment

Bool

Segment

ConversionAdjustment column for table Segments

ConversionLagBucket

String

Segment

ConversionLagBucket column for table Segments

ConversionOrAdjustmentLagBucket

String

Segment

ConversionOrAdjustmentLagBucket column for table Segments

ConversionValueRulePrimaryDimension

String

Segment

ConversionValueRulePrimaryDimension column for table Segments

Date

Date

Segment

Date column for table Segments

DayOfWeek

String

Segment

DayOfWeek column for table Segments

Device

String

Segment

Device column for table Segments

ExternalConversionSource

String

Segment

ExternalConversionSource column for table Segments

Hour

Int

Segment

Hour column for table Segments

Month

Date

Segment

Month column for table Segments

MonthOfYear

String

Segment

MonthOfYear column for table Segments

Quarter

Date

Segment

Quarter column for table Segments

RecommendationType

String

Segment

RecommendationType column for table Segments

SkAdNetworkConversionValue

Long

Segment

SkAdNetworkConversionValue column for table Segments

Slot

String

Segment

Slot column for table Segments

Week

Date

Segment

Week column for table Segments

Year

Int

Segment

Year column for table Segments

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.

Last updated