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