Help me build a query
A call view that includes data for call tracking of call-only ads or call extensions.
Fields from the above resources may be selected along with this
resource in your SELECT and WHERE clauses. These fields will not segment
metrics in your SELECT clause.
call_view.call_duration_seconds
Field description Output only. The advertiser-provided call duration in seconds. Category ATTRIBUTEData Type INT64Type URL N/AFilterable True Selectable True Sortable True Repeated False
call_view.call_status
Field description Output only. The status of the call. Category ATTRIBUTEData Type
ENUM
MISSED
RECEIVED
UNKNOWN
UNSPECIFIED
Type URL google.ads.googleads.v17.enums.GoogleVoiceCallStatusEnum.GoogleVoiceCallStatusFilterable True Selectable True Sortable True Repeated False
call_view.call_tracking_display_location
Field description Output only. The call tracking display location. Category ATTRIBUTEData Type
ENUM
AD
LANDING_PAGE
UNKNOWN
UNSPECIFIED
Type URL google.ads.googleads.v17.enums.CallTrackingDisplayLocationEnum.CallTrackingDisplayLocationFilterable True Selectable True Sortable True Repeated False
call_view.caller_area_code
Field description Output only. Area code of the caller. Null if the call duration is shorter than 15 seconds. Category ATTRIBUTEData Type STRINGType URL N/AFilterable True Selectable True Sortable True Repeated False
call_view.caller_country_code
Field description Output only. Country code of the caller. Category ATTRIBUTEData Type STRINGType URL N/AFilterable True Selectable True Sortable True Repeated False
call_view.end_call_date_time
Field description Output only. The advertiser-provided call end date time. Category ATTRIBUTEData Type DATEType URL N/AFilterable True Selectable True Sortable True Repeated False
call_view.resource_name
Field description Output only. The resource name of the call view. Call view resource names have the form: customers/{customer_id}/callViews/{call_detail_id} Category ATTRIBUTEData Type RESOURCE_NAMEType URL N/AFilterable False Selectable True Sortable False Repeated False
call_view.start_call_date_time
Field description Output only. The advertiser-provided call start date time. Category ATTRIBUTEData Type DATEType URL N/AFilterable True Selectable True Sortable True Repeated False
call_view.type
Field description Output only. The type of the call. Category ATTRIBUTEData Type
ENUM
HIGH_END_MOBILE_SEARCH
MANUALLY_DIALED
UNKNOWN
UNSPECIFIED
Type URL google.ads.googleads.v17.enums.CallTypeEnum.CallTypeFilterable True Selectable True Sortable True Repeated False
