How to report on Virtual Agent topic usage by device
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2023 01:48 AM - edited 10-03-2023 01:49 AM
Hi everyone.
I seem to be getting strange results when trying to report on topic usage by device type.
My report is on the sys_cs_conversation_task table where I then dot walk to sys_cs_conversation to get the device type.
I'm reporting on where topic = "My topic name". But for some mobile entries I cannot see it listed even though I know they have clicked on it.
- Labels:
-
Mobile
-
Reporting
-
Virtual Agent
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2023 08:04 AM
When I need to see the topics by Device Type, I start with this table va_view_conversation_interaction_task.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 03:07 AM
Thanks for replying.
I can't seem to actually find that table in our instance?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 08:41 AM
The only way I can get to that is by using create a report. If I try to get to the actual table, the system yells at me.
Since I have some time, I will see if I can get what you are looking for using the two tables you mentioned. I just learned those two are rather limited so I cheated?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 05:16 AM - edited 10-10-2023 05:18 AM
Still cannot find that table even in the reporting module. It must be part of a plugin?
I did noticed that when using Virtual Agent an interaction is created each time, which is useful to see the state and reason but not useful in the fact you cannot seem to track it back to the topic.