Chat bot Analytics - Power Bi and report insights
# 🤝help
r
Hello everyone !! I m a Power BI user used to connect to databases to extract meaningful data and create custom reports for my clients. I started using Botpress as part of a customer service project and would like to create my own cutom-made reports . My goal is : - Get number of conversations , id,s , contact channels , A.I. tokens and cost-related information - Get most commonly asked questions as well as non - answered questions - Get the client´s node journey inside the bot And with this information create metrics , dahsborads, etc . Is there any way to connect to botpress server to acces this information ? Is there also anyway to connect to the tables on the bot ? Thanks in advance for your cooperation community !!
f
I think @wide-oyster-38514 does this, right? I would also love to learn about this.
c
Following
@refined-actor-91340 Sly or someone else I can't remember who said that there will be some access via API to tables and knowledge "coming soon" Right now I am storing all that data in the tables in preparation of that, and currently just exporting it as a CSV.
f
The tables API is already out there
c
@fresh-fireman-491 oh shoot I didn't see that!? I'll go re-scan the docs now
f
c
Well snap! It sure is! Thanks @fresh-fireman-491 !!!!!
f

https://youtu.be/NRXwNdSUlz0?si=t-w6RLgjHb0rjnk5

You are very welcome 🙂
c
Could always use the https://botpress.com/docs/api-documentation/#get-bot-logs to grab the rest of the info
f
What information would you grab from that?
c
token usage mainly
cost related info
f
Ah okay. That would actually be nice to have
r
I appreciate your feedback .... Yes i know we can pull CSV file and store...maybe create a procedural sweep through Make every 2 weeks to store them automatically , however , the less hand work the merrier.... (important for me since i want to provide my customer with stats and help me track client behavior to improve bots) I´ve already tried to connect Power Bi to Botpress through the http + Personal access tokens but haven t been able to reach the tables or the inner server.... Will defintley toy with the documentation and see where it goes ...will keep you posted if i manage to solve this for the rest of the community . I ve also read you can do reporting with Mixer .......might be another solution , thou i would rather prefer to user Power Bi since i can mix and match all kind of info there...
h
Yes besides Power BI you can also use Mixpanel. You can setting it upeasily using the code given in the docs: https://botpress.com/docs/cloud/exporting-bot-data/exporting-analytics/from-the-bot/#setting-up-mixpanel You will be able to export all conversation data and metadata plus you can easily create dashboards and see your metrics in nice views
a
If you are successful, will you be able to write an instruction of how to make it right? For somebody as non-dev? 😄
r
Sure!! but im stuck with other nuisances .....so had to pause.....but yes, i will provide feedback once i do it