JDBC Driver for Google Ads

Build 26.0.9655

LocalServicesLead

Data from Local Services Lead.

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:
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.
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.
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 Immutable. The resource name of the local services lead data.
LocalServicesLeadServiceId String ATTRIBUTE Output only. Service for the category. For example: buyer_agent,

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655