Power BI Connector for Google Ads

Build 24.0.9062

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.

使用できる値は次のとおりです。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.

使用できる値は次のとおりです。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

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