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 nameOverviewsample備考
idID for each remarka1234567890b2345678901c3
timestampSent date2020-01-02T03:04:05.678Z
visitor_idUser visitor IDa1234-b5678
user_idUser IDvis-a1234-b5678
from_userWhether it's a message from the usertrue / falseユーザーからのメッセージ送信ではない場合に、値がfalseではなくnullになる場合があります。
texttextこんにちは
thread_idThread ID1234567890123456789
account_idOperator ID (Assignment ID)9a1234567890b2345678901c
access_urlPage URL at the time of speakinghttps://karte.io/
access_titlePage title at the time of speakingCX(顧客体験)プラットフォーム KARTE(カルテ)

日本語
English
Translated by AI