LocalServicesLead
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
Columns
| Name | Type | Behavior | Description |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| LocalServicesLeadCategoryId | String | ATTRIBUTE | 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 |
| LocalServicesLeadContactDetails | String | ATTRIBUTE | Output only. Lead's contact details. |
| LocalServicesLeadCreationDateTime | Datetime | ATTRIBUTE | 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' |
| LocalServicesLeadCreditDetailsCreditState | String | ATTRIBUTE | Output only. Credit state of the lead.
使用できる値は次のとおりです。CREDITED, PENDING, UNKNOWN |
| LocalServicesLeadCreditDetailsCreditStateLastUpdateDateTime | Datetime | ATTRIBUTE | 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' |
| LocalServicesLeadId | Long | ATTRIBUTE | Output only. ID of this Lead. |
| LocalServicesLeadLeadCharged | Bool | ATTRIBUTE | Output only. True if the advertiser was charged for the lead. |
| LocalServicesLeadLeadFeedbackSubmitted | Bool | ATTRIBUTE | Output only. True if the advertiser submitted feedback for the lead. |
| LocalServicesLeadLeadStatus | String | ATTRIBUTE | Output only. Current status of lead.
使用できる値は次のとおりです。ACTIVE, BOOKED, CONSUMER_DECLINED, DECLINED, DISABLED, EXPIRED, NEW, UNKNOWN, WIPED_OUT |
| LocalServicesLeadLeadType | String | ATTRIBUTE | Output only. Type of Local Services lead: phone, message, booking, etc.
使用できる値は次のとおりです。BOOKING, MESSAGE, PHONE_CALL, UNKNOWN |
| LocalServicesLeadLocale | String | ATTRIBUTE | Output only. Language used by the Local Services provider linked to lead. See https://developers.google.com/google-ads/api/data/codes-formats#locales |
| LocalServicesLeadNoteDescription | String | ATTRIBUTE | Output only. Content of lead note. |
| LocalServicesLeadNoteEditDateTime | Datetime | ATTRIBUTE | 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' |
| LocalServicesLeadResourceName | String | ATTRIBUTE | 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} |
| LocalServicesLeadServiceId | String | ATTRIBUTE | Output only. Service for the category. For example: buyer_agent, seller_agent for the category of xcat:service_area_business_real_estate_agent. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |