CallMetricsCallDetails

The Call Metrics Call Details report includes call details for your call extension including call duration and the caller's area code.

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

AccountDescriptiveName

String

Attribute

Account

Account for the CallMetricsCallDetails report.

AccountTimeZone

String

Attribute

Time Zone

Time Zone for the CallMetricsCallDetails report.

AdGroupId

Long

Attribute

Ad Group ID

Ad Group ID for the CallMetricsCallDetails report.

AdGroupName

String

Attribute

Ad Group

Ad Group for the CallMetricsCallDetails report.

AdGroupStatus

String

Attribute

Ad Group State

Ad Group State for the CallMetricsCallDetails report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

CallDuration

Long

Attribute

Duration (seconds)

Duration (seconds) for the CallMetricsCallDetails report.

CallEndTime

Long

Attribute

End Time

End Time for the CallMetricsCallDetails report.

CallerCountryCallingCode

String

Attribute

Caller Country Code

Caller Country Code for the CallMetricsCallDetails report.

CallerNationalDesignatedCode

String

Attribute

Caller Area Code

Caller Area Code for the CallMetricsCallDetails report.

CallStartTime

Long

Attribute

Start Time

Start Time for the CallMetricsCallDetails report.

CallStatus

String

Attribute

Status

Status for the CallMetricsCallDetails report.

The allowed values are RECEIVED, MISSED, UNKNOWN.

CallTrackingDisplayLocation

String

Attribute

Call Source

Call Source for the CallMetricsCallDetails report.

The allowed values are UNKNOWN, AD, LANDING_PAGE.

CallType

String

Attribute

Call Type

Call Type for the CallMetricsCallDetails report.

The allowed values are GOOGLE_SEARCH, HIGH_END_MOBILE_SEARCH, UNKNOWN.

CampaignId

Long

Attribute

Campaign ID

Campaign ID for the CallMetricsCallDetails report.

CampaignName

String

Attribute

Campaign

Campaign for the CallMetricsCallDetails report.

CampaignStatus

String

Attribute

Campaign State

Campaign State for the CallMetricsCallDetails report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

CustomerDescriptiveName

String

Attribute

Client Name

Client Name for the CallMetricsCallDetails report.

Date

Date

Attribute

Day

Day for the CallMetricsCallDetails report.

DayOfWeek

String

Attribute

Day Of Week

Day Of Week for the CallMetricsCallDetails report.

The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.

ExternalCustomerId

Long

Attribute

Customer ID

Customer ID for the CallMetricsCallDetails report.

HourOfDay

Integer

Attribute

Hour Of Day

Hour Of Day for the CallMetricsCallDetails report.

Month

String

Attribute

Month

Month for the CallMetricsCallDetails report.

MonthOfYear

String

Attribute

Month Of Year

Month Of Year for the CallMetricsCallDetails report.

The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.

Quarter

String

Attribute

Quarter

Quarter for the CallMetricsCallDetails report.

Week

String

Attribute

Week

Week for the CallMetricsCallDetails report.

Year

Integer

Attribute

Year

Year for the CallMetricsCallDetails 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