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