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, UNSPECIFIED |
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. |
LocalServicesLeadLeadStatus | String | ATTRIBUTE | Output only. Current status of lead.
使用できる値は次のとおりです。ACTIVE, BOOKED, CONSUMER_DECLINED, DECLINED, DISABLED, EXPIRED, NEW, UNKNOWN, UNSPECIFIED, WIPED_OUT |
LocalServicesLeadLeadType | String | ATTRIBUTE | Output only. Type of Local Services lead: phone, message, booking, etc.
使用できる値は次のとおりです。BOOKING, MESSAGE, PHONE_CALL, UNKNOWN, UNSPECIFIED |
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. |