ProductGroupView

A product group view.

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

ProductGroupViewResourceName

String

Attribute

ResourceName column for table ProductGroupView

CustomerId

Long

Attribute

ClientCustomerId column for table ProductGroupView

AllConversions

Double

Metric

AllConversions column for table Metrics

AllConversionsFromInteractionsRate

Double

Metric

AllConversionsFromInteractionsRate column for table Metrics

AllConversionsValue

Double

Metric

AllConversionsValue column for table Metrics

AverageCpc

Double

Metric

AverageCpc column for table Metrics

AverageCpm

Double

Metric

AverageCpm column for table Metrics

BenchmarkAverageMaxCpc

Double

Metric

BenchmarkAverageMaxCpc column for table Metrics

BenchmarkCtr

Double

Metric

BenchmarkCtr column for table Metrics

Clicks

Long

Metric

Clicks column for table Metrics

Conversions

Double

Metric

Conversions column for table Metrics

ConversionsFromInteractionsRate

Double

Metric

ConversionsFromInteractionsRate column for table Metrics

ConversionsValue

Double

Metric

ConversionsValue 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

Impressions

Long

Metric

Impressions column for table Metrics

SearchAbsoluteTopImpressionShare

Double

Metric

SearchAbsoluteTopImpressionShare column for table Metrics

SearchClickShare

Double

Metric

SearchClickShare column for table Metrics

SearchImpressionShare

Double

Metric

SearchImpressionShare column for table Metrics

ValuePerAllConversions

Double

Metric

ValuePerAllConversions column for table Metrics

ValuePerConversion

Double

Metric

ValuePerConversion 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

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

Month

Date

Segment

Month column for table Segments

MonthOfYear

String

Segment

MonthOfYear column for table Segments

Quarter

Date

Segment

Quarter 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