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