local_services_lead_conversation

Help me build a query

Data from Local Services Lead Conversation. Contains details of Lead Conversation which is generated when user calls, messages or books service from advertiser. These are appended to a Lead. More info: https://ads.google.com/local-services-ads

Attributed resources
customer
local_services_lead

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.

local_services_lead_conversation.conversation_channel Field description Output only. Type of GLS lead conversation, EMAIL, MESSAGE, PHONE_CALL, SMS, etc. Category ATTRIBUTE Data Type ENUM BOOKING EMAIL MESSAGE PHONE_CALL SMS UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v15.enums.LocalServicesLeadConversationTypeEnum.ConversationType Filterable True Selectable True Sortable True Repeated False

local_services_lead_conversation.event_date_time Field description Output only. The date time at which lead conversation was created by Local Services Ads. The format is "YYYY-MM-DD HH:MM:SS" in the Google Ads account's timezone. Examples: "2018-03-05 09:15:00" or "2018-02-01 14:34:30" Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

local_services_lead_conversation.id Field description Output only. ID of this Lead Conversation. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

local_services_lead_conversation.lead Field description Output only. Resource name of Lead associated to the Lead Conversation. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

local_services_lead_conversation.message_details.text Field description Output only. Textual content of the message. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated False

local_services_lead_conversation.participant_type Field description Output only. Type of participant in the lead conversation, ADVERTISER or CONSUMER. Category ATTRIBUTE Data Type ENUM ADVERTISER CONSUMER UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v15.enums.LocalServicesParticipantTypeEnum.ParticipantType Filterable True Selectable True Sortable True Repeated False

local_services_lead_conversation.phone_call_details.call_duration_millis Field description Output only. The duration (in milliseconds) of the phone call (end to end). Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

local_services_lead_conversation.phone_call_details.call_recording_url Field description Output only. URL to the call recording audio file. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated False

local_services_lead_conversation.resource_name Field description Output only. The resource name of the local services lead conversation data. Local Services Lead Conversation resource name have the form customers/{customer_id}/localServicesLeadConversation/{local_services_lead_conversation_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False