From our weekly CSAT data, only between six and ten percent of users from live chat follow up in the forum. Since a lot of chats are not yet resolved when the user is disconnected or closes the browser, the process of following up later should be made easier. Changes that need to be made: *Transcript e-mails should include links to the CSAT poll and for following up in the forum *Provide a link to follow up in the forum right after the chat ends *Include the chat ID in any forum reply, so we can collect stats about users who start in Live Chat and continue in the forum. (A future enhancement would be to allow the user to include the entire transcript) Additionally, bug 481539 will allow helpers to give a CSAT or forum followup link to the user at any time, via a canned response.
Created attachment 383979 [details] SQL for forum metadata table This is the SQL for the forum metadata table that will be used by live chat CSAT, to find posts that are continuations of a live chat. The table is generic, so it may also be used to store information such as plugins or user-agent.
Attachment #383979 - Flags: review?(smirkingsisyphus)
Created attachment 384045 [details] [diff] [review] Store live chat ID in forum metadata This adds a metadata feature to tiki_comments to store information about each thread for easy querying. The Live Chat session ID and agent name are stored in this table to track live chat->forum followups. The included tiki-forum_livechat_pings.php script produces an XML output of recent live chat followups, for Openfire and sumobot to query.
Created attachment 384141 [details] [diff] [review] Slightly improved patch This is a slightly improved patch that adds an <agent> element in tiki-forum_livechat_pings.php and deletes metadata when a thread is removed.
Attachment #383979 - Flags: review?(smirkingsisyphus) → review+
Attachment #384141 - Flags: review?(smirkingsisyphus) → review+
Since this adds a table to SUMO and introduces new functionality, Laura needs to look at this too.
Comment on attachment 383979 [details] SQL for forum metadata table Requesting review from Laura, per Eric's comment.
Attachment #383979 - Flags: review?(laura)
Attachment #383979 - Attachment mime type: text/x-sql → text/plain
Comment on attachment 383979 [details] SQL for forum metadata table Don't forget to add this to the push bug.
Attachment #383979 - Flags: review?(laura) → review+
You should also add sanitization of the User Agent. When that's done, please commit and file a bug to get SQl run on staging ASAP so QA can test.
(In reply to comment #7) > You should also add sanitization of the User Agent. When that's done, please > commit and file a bug to get SQl run on staging ASAP so QA can test. Sanitation is already being done by strip_tags in set_metadata, when $sanitize == 1. Should it be doing more here?
Also, I don't currently have commit permissions in /projects/sumo, so I will either need to get those permissions or have someone else check this in.
Created attachment 385195 [details] [diff] [review] Update to trunk Patch updated for changes to trunk
Component: Chat → Chat
Product: support.mozilla.org → support.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.