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