Statistics Web Portal

Statistics Web portals can be made to show any types of statistical results. To show something in comparison or percentage, using statistical measures is an excellent way to get an image of the current situation. This app arranges all of the emails that are sent or all of those images that were bounced in such a way that the user can easily check which emails were bounced.

Problem

Clients had the problem that they could not get much information and statistics in their hands about all the bounced emails that were sent to the recipient. There was no way of getting a statistical result of all of the emails that were bounced, opened and the emails that were sent correctly. A statistical measure that could measure any distortion caused in between the email medium, therefore, the need was to get a summary of emails that were sent and those, which were bounced.

Another need was to know that after receiving the email by the recipient, when did they first time open it? What was the last time the recipient opened the email? A folder where all of the bounced emails were shown was also needed. It needed to be shown in some statistical measures such as tables and charts. There was no certain software, which could use these statistical measures and generate a result. An excel file was needed for these statistical measures to make them of some use.

Need

So looking at all the problems the clients were having regarding emails, software needed to be developed in such a way that could cover statistical and quantitative measures of emails being bounced and the emails being opened.

First Window (Total Overview)

The first thing that includes the statistical web portal is the totals table. The outbound profile has the totals in number. We divided the emails according to the status of email in many categories. The emails that were having temporary delivery failure categorise as one section. Their numbers write in front of them. The second category is the emails with content failure. Emails with content failure are those mails which have some problem in their content; it may be the format of the content that these emails are bounced. Next category is the mails having a permanent delivery failure. Re sending these emails will not solve the problem. These emails always bounce. If the reason behind the delivery failure is unknown, they categorise as messages with unknown delivery failure. Those messages that have been replied by the recipient categorise to check the response rate of the recipients and to reply them back quickly. Those messages that have been clicked through or are opened come in another category. The last category in outbound profile is of the messages with out of office replies. After all these categories, the total number of messages sent include. Whether those messages are bounced or received by the recipient, the total of emails include.

This was the quantitative total of the messages. Now, these quantitative totals are also measured in statistical terms through a pie chart. All of the categories mentioned above are referred to in a pie chart, and it gives a total overview of the emails. Totals trend is also mention which tells about the frequency of messages according to the timeline.

Table showing the First open and Last open Timing of Message

After the totals overview and statistics, the statistical web portal for emails include reports on messages sent to individual customers. This window is made to find a particular recipient and check the progress of the emails sent to him. You can find the customer through Customer ID, and you can also filter on by the date on which the email was sent. This window opens the details of the specific recipient. You could check the date when the recipient opened the mail for the first time if he did. You can also check when was the last time that recipient opened the email. The next thing you can check here is that whether the email has been sent or not.

You can check the status of the email. The next category is the subject where you will find the subject name of the email you sent. It is just to confirm that the subject is correct. You will also find outbound profile there. The workflow stage will mention if there is any ongoing stage or activity. The next category is the history with the recipient. The last category is the view option that tells the quantity of times the report has been viewed.

Overview of Message in Workflow

Another window is for the overview of messages that are in the workflow. It shows the stage of workflow and also the checked out. It also shows the date of the last workflow as well. The next category is the use of a workflow. You can also view the messages here. History can also be checked for the specific recipient.

Microsofe Excell Format (.XLSX FILES)

All of the statistical and quantitative measures you can do on this software need to be transferred to a software where it can be further processed. The statistical web portal for bounced emails and sent emails is just an informational software. To further modify and use these measures, it was needed to export these files to excel. The software provides a link with excel and one can transfer these files in xlsx file format. You can find the specific details you need and export it to excel. The descriptions of the email is shown at the start, which tells the delivery status, and content, which was not deliverable. It also shows the size of the message.

Solution

This statistical web portal is made while keeping the requirements of the client as our priority. The client needed a software that could analyse all of the bounced emails at one place so that it could be dealt with. A total summary of all the emails was the solution. The statistical web portal includes all of the quantitative and statistical total measures. The pie chart can explain the percentage of undelivered or bounced messages. After the overall view, the client needed a software which could specifically target a recipient and check the status of email sent to him. The software includes a window which searches for customer ID and delivers all the information to you regarding first seen and last seen the timing of the email. The client can also export the files from the statistical web portal to excel in Xlsx file format for further actions.

Conclusion

Through statistical web portal for bounced emails and delivered emails, the client can track all of the emails that are bounced or delivered. He can also check whether the recipient has opened the email or not and when was the last time he opened it. Tracking bounced email for each SMTP provider is not possible. The statistical web portal includes such algorithms which run some threads and ensures the stage of certain email whether it is bounced or delivered.