Power BI Connector for Google Ads

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062