Outlook Email Statistics

[TimmK]

A customer sends an email with an order request. This request needs to be clarified as the product is complex and needs to be tailored to the customer's need. Thus, emails are sent back and forth between the customer and our customer agent.

Now we want to see how fast a customer agent replies to each email from the customer. Is this generally possible with Power BI? If yes, how? Or is it easier to use an Outlook add-on or software for email statistics? Can you recommend one?

[agustinamar]

Hi, I hope you can answer this question. I am working with an outlook database, and to know the days elapsed since an email with a case to be resolved is received until its resolution, but I would not know how to put together the formula (I have the dates of sent and received), since there would be many mails (different cases per client) I thought of doing it by subject: when it starts, put region_customername_test1 and when region_customername_resolved_test1 is resolved. Would you have any suggestion? Is this possible to do? Thank you in advance

[v-shex-msft · Accepted solution]

HI @TimmK,

I'd like to suggest you connect to the Microsoft Exchange service to analyze your email records.
Notice: these records are not such readable so you may need to do some additional steps to shape/transform these data first.

Analyzing your Microsoft Exchange Account Data with Power Query | Microsoft Power BI Blog | Microsof...

Regards,

Xiaoxin Sheng