Power BI Connector for Google Ads

Build 24.0.9060

LocalServicesLeadConversation

Data from Local Services Lead Conversation. Contains details of Lead Conversation which is generated when user calls, messages or books service from advertiser. These are appended to a Lead. More info: https://ads.google.com/local-services-ads

Columns

Name Type Behavior Description
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
LocalServicesLeadConversationConversationChannel String ATTRIBUTE Output only. Type of GLS lead conversation, EMAIL, MESSAGE, PHONE_CALL, SMS, etc.

The allowed values are ADS_API, BOOKING, EMAIL, MESSAGE, PHONE_CALL, SMS, UNKNOWN, UNSPECIFIED, WHATSAPP.

LocalServicesLeadConversationEventDateTime Datetime ATTRIBUTE Output only. The date time at which lead conversation 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'
LocalServicesLeadConversationId Long ATTRIBUTE Output only. ID of this Lead Conversation.
LocalServicesLeadConversationLead String ATTRIBUTE Output only. Resource name of Lead associated to the Lead Conversation.
LocalServicesLeadConversationMessageDetailsAttachmentUrls String ATTRIBUTE Output only. URL to the SMS or email attachments. These URLs can be used to download the contents of the attachment by using the developer token.
LocalServicesLeadConversationMessageDetailsText String ATTRIBUTE Output only. Textual content of the message.
LocalServicesLeadConversationParticipantType String ATTRIBUTE Output only. Type of participant in the lead conversation, ADVERTISER or CONSUMER.

The allowed values are ADVERTISER, CONSUMER, UNKNOWN, UNSPECIFIED.

LocalServicesLeadConversationPhoneCallDetailsCallDurationMillis Long ATTRIBUTE Output only. The duration (in milliseconds) of the phone call (end to end).
LocalServicesLeadConversationPhoneCallDetailsCallRecordingUrl String ATTRIBUTE Output only. URL to the call recording audio file.
LocalServicesLeadConversationResourceName String ATTRIBUTE Output only. The resource name of the local services lead conversation data. Local Services Lead Conversation resource name have the form customers/{customer_id}/localServicesLeadConversation/{local_services_lead_conversation_id}

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