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 !!

I think @wide-oyster-38514 does this, right? I would also love to learn about this.

Following

The tables API is already out there

@fresh-fireman-491 oh shoot I didn't see that!? I'll go re-scan the docs now

Well snap! It sure is! Thanks @fresh-fireman-491 !!!!!

Could always use the https://botpress.com/docs/api-documentation/#get-bot-logs to grab the rest of the info

What information would you grab from that?

token usage mainly

Ah okay. That would actually be nice to have

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...

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

If you are successful, will you be able to write an instruction of how to make it right? For somebody as non-dev? 😄

Sure!! but im stuck with other nuisances .....so had to pause.....but yes, i will provide feedback once i do it