Power BI Connector for Google Ads

Build 24.0.9060

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.

The allowed values are 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.

The allowed values are 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.

The allowed values are 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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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.9060