Unanswered

Custom PVA Analytics - Data Fields

Like (0) Share

Report

Posted on 18 Aug 2022 13:29:59 by Matthew5

Hi there,

I have recently followed the brilliant write up to build customer analytics in Power BI (Custom Analytics solution for Power Virtual Agents | Microsoft Power Virtual Agents)

I have been reviewing the trace data that PVA emits (Understand conversation transcripts - Power Virtual Agents | Microsoft Docs)

Would anyone know what field would provide the users name? For context we use PVA for teams and users are all employees, we're hoping to identify who is using the bot and how often. It would be great to see how many sessions per user and even what topics they've used.

Thank you for taking the time to read this post.

I have the same question (0)

All responses (2)

Answers (0)

AlinaMartin on 05 Oct 2023 at 15:01:19

Like (0)

Report

Re: Custom PVA Analytics - Data Fields

I created a Power Automate flow that will record the user and the topics used.

Just use the create flow from PVA to go to PA and then use the add a row to a table. It is helpful to create the table in excel before beginning. Let me know if you need some additional details and I will be happy to share them with you.

Was this reply helpful? Yes No
Expiscornovus 32,292 Most Valuable Professional on 25 Aug 2022 at 11:16:40

Like (0)

Report

Re: Custom PVA Analytics - Data Fields

Hi @Matthew5,

As far as I am aware the Content field stores the user id:

https://docs.microsoft.com/en-us/power-virtual-agents/analytics-sessions-transcripts#content-field

Unfortunately, I don't think you can use it to identify users because it is hashed.

The ID is hashed before being written to the transcript for security and privacy considerations.

Was this reply helpful? Yes No