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 ADS_API BOOKING EMAIL MESSAGE PHONE_CALL SMS UNKNOWN UNSPECIFIED WHATSAPP Type URL google.ads.googleads.v18.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.attachment_urls Field description Output only. URL to the SMS or email attachments. These URLs can be used to download the contents of the attachment by using the developer token. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated True

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.v18.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