local_services_lead

Help me build a query

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

Attributed resources
customer

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.category_id Field description Output only. Service category of the lead. For example: xcat:service_area_business_hvac, xcat:service_area_business_real_estate_agent, etc. For more details see: https://developers.google.com/google-ads/api/data/codes-formats#local_services_ids Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

local_services_lead.contact_details Field description Output only. Lead's contact details. Category ATTRIBUTE Data Type MESSAGE Type URL google.ads.googleads.v16.resources.ContactDetails Filterable False Selectable True Sortable False Repeated False

local_services_lead.creation_date_time Field description Output only. The date time at which lead 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.credit_details.credit_state Field description Output only. Credit state of the lead. Category ATTRIBUTE Data Type ENUM CREDITED PENDING UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.LocalServicesCreditStateEnum.CreditState Filterable True Selectable True Sortable True Repeated False

local_services_lead.credit_details.credit_state_last_update_date_time Field description Output only. The date time when the credit state of the lead was last updated. 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.id Field description Output only. ID of this Lead. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

local_services_lead.lead_charged Field description Output only. True if the advertiser was charged for the lead. Category ATTRIBUTE Data Type BOOLEAN Type URL N/A Filterable True Selectable True Sortable True Repeated False

local_services_lead.lead_status Field description Output only. Current status of lead. Category ATTRIBUTE Data Type ENUM ACTIVE BOOKED CONSUMER_DECLINED DECLINED DISABLED EXPIRED NEW UNKNOWN UNSPECIFIED WIPED_OUT Type URL google.ads.googleads.v16.enums.LocalServicesLeadStatusEnum.LeadStatus Filterable True Selectable True Sortable True Repeated False

local_services_lead.lead_type Field description Output only. Type of Local Services lead: phone, message, booking, etc. Category ATTRIBUTE Data Type ENUM BOOKING MESSAGE PHONE_CALL UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v16.enums.LocalServicesLeadTypeEnum.LeadType Filterable True Selectable True Sortable True Repeated False

local_services_lead.locale Field description Output only. Language used by the Local Services provider linked to lead. See https://developers.google.com/google-ads/api/data/codes-formats#locales Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

local_services_lead.note.description Field description Output only. Content of lead note. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

local_services_lead.note.edit_date_time Field description Output only. The date time when lead note was edited. 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.resource_name Field description Output only. The resource name of the local services lead data. Local Services Lead resource name have the form customers/{customer_id}/localServicesLead/{local_services_lead_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

local_services_lead.service_id Field description Output only. Service for the category. For example: buyer_agent, seller_agent for the category of xcat:service_area_business_real_estate_agent. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False