Chat related tables and views (beta version)
Notes
This function is currently in beta version, so the specifications may change in the future.
Please contact support if you wish to use it.
If you are using karte talk chat features, you will optionally be provided with the following tables and views: If you would like to use it, please contact support.
Overview
下記は、 karte_stream_{{api_key}}
データセットの配下に格納されます。
karte_webchat_conversation view
- A view that contains chat conversation information
- It is not possible to preview the content from the data set screen and a query must be executed
- We mainly use it for the following purposes
- Analysis of conversation information between end users and chat operators
- When a chat message is deleted, it will also be deleted after a few days from the karte_webchat_conversation view
chat_label table
- Table containing chat label information
- We mainly use it for the following purposes
- Summary by label
karte_webchat_conversation view schema
チャットの会話情報が格納されたkarte_webchat_conversation
ビューのカラムは、次の通りです。
Column name | Overview | sample | 備考 |
---|---|---|---|
id | ID for each remark | a1234567890b2345678901c3 | |
timestamp | Sent date | 2020-01-02T03:04:05.678Z | |
visitor_id | User visitor ID | a1234-b5678 | |
user_id | User ID | vis-a1234-b5678 | |
from_user | Whether it's a message from the user | true / false | ユーザーからのメッセージ送信ではない場合に、値がfalse ではなくnull になる場合があります。 |
text | text | こんにちは | |
thread_id | Thread ID | 1234567890123456789 | |
account_id | Operator ID (Assignment ID) | 9a1234567890b2345678901c | |
access_url | Page URL at the time of speaking | https://karte.io/ | |
access_title | Page title at the time of speaking | CX(顧客体験)プラットフォーム KARTE(カルテ) |
Updated over 1 year ago