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.

Table Specific Information

Select

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.

Columns

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.

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