CreativeConversion
Free clicks are interactions that take place before a clickthrough for video ads, display ads, product extensions and location extensions, interactions like a Video play or a Get directions.
Last updated
Free clicks are interactions that take place before a clickthrough for video ads, display ads, product extensions and location extensions, interactions like a Video play or a Get directions.
Last updated
Google AdWords 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 AdWords 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 AdWords API.
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
Behavior
DisplayName
Description
AccountCurrencyCode
String
Attribute
Currency
Currency for the CreativeConversion report.
AccountDescriptiveName
String
Attribute
Account
Account for the CreativeConversion report.
AccountTimeZone
String
Attribute
Time Zone
Time Zone for the CreativeConversion report.
AdGroupId
Long
Attribute
Ad Group ID
Ad Group ID for the CreativeConversion report.
AdGroupName
String
Attribute
Ad Group
Ad Group for the CreativeConversion report.
AdGroupStatus
String
Attribute
Ad Group State
Ad Group State for the CreativeConversion report.
The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CampaignId
Long
Attribute
Campaign ID
Campaign ID for the CreativeConversion report.
CampaignName
String
Attribute
Campaign
Campaign for the CreativeConversion report.
CampaignStatus
String
Attribute
Campaign State
Campaign State for the CreativeConversion report.
The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.
CreativeId
Long
Attribute
Ad ID
Ad ID for the CreativeConversion report.
CriteriaParameters
String
Attribute
Keyword Per Placement
Keyword Per Placement for the CreativeConversion report.
CriteriaTypeName
String
Attribute
Match Type
Match Type for the CreativeConversion report.
CriterionId
Long
Attribute
Keyword ID
Keyword ID for the CreativeConversion report.
CustomerDescriptiveName
String
Attribute
Client Name
Client Name for the CreativeConversion report.
ExternalCustomerId
Long
Attribute
Customer ID
Customer ID for the CreativeConversion report.
AdNetworkType1
String
Segment
Network
Network for the CreativeConversion report.
The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
AdNetworkType2
String
Segment
Network (with Search Partners)
Network (with Search Partners) for the CreativeConversion report.
The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.
ConversionTrackerId
Long
Segment
Free Click Type
Free Click Type for the CreativeConversion report.
Date
Date
Segment
Day
Day for the CreativeConversion report.
DayOfWeek
String
Segment
Day Of Week
Day Of Week for the CreativeConversion report.
The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.
Month
String
Segment
Month
Month for the CreativeConversion report.
Quarter
String
Segment
Quarter
Quarter for the CreativeConversion report.
Week
String
Segment
Week
Week for the CreativeConversion report.
Year
Integer
Segment
Year
Year for the CreativeConversion report.
CreativeConversionRate
Double
Metric
Free Click Rate
Free Click Rate for the CreativeConversion report.
CreativeConversions
Long
Metric
Free Clicks
Free Clicks for the CreativeConversion report.
Impressions
Long
Metric
Impressions
Impressions for the CreativeConversion report.
Name
Type
Description
StartDate
String
Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.
EndDate
String
End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.