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.