This project is originally posted in Portuguese. You are viewing an auto-translated version.
Back

Service metrics dashboard

Management Dashboard, Advanced Excel, spreadsheets and reports, Sheets

  • Project status

    Open

  • Interested

    12

  • Posted at

  • Location

    The project can be completed remotely

  • Budget

    R$ 100 - R$ 500

  • Posted by

    Trampo

Job description

The creation of a dashboard in Google Sheets to monitor and track the progress of the customer service team. The goal is to consolidate relevant information for analyzing performance and customer satisfaction.

Dashboard Requirements:

Volume of Service:

Graph showing the total number of service calls per day/month.

NPS (Net Promoter Score):

Average NPS over time, with corresponding graph.

CSAT (Customer Satisfaction Score):

Average CSAT, showing comparative graphs.
Main Reasons for Contact:

Pie or bar chart showing the distribution of the main reasons for contact.
Customers Who Contact Us Most:

Table listing the main customers by number of service calls.
TMA (Average Service Time) and TME (Average Waiting Time):

Line graphs showing the evolution of TMA and TME over time.
Implementation:

The dashboard must be functional and accessible online on the company's server, allowing the team to view metrics in real time.

I thank you in advance for your attention and I am available to discuss further details about this project.

I am interested
Recommend someone Post on linkedin

Refer someone and get paid!

Do you know a someone who is a good fit for the project? Earn commission by referring freelancers! For every signup you get € 5 directly in your account and when the freelancer is hired through the platform you earn 2 % of the earnings of this freelancer!

Fill in the details of the pro you'd like to recommend:

When the freelancer accepts the invitation this freelancer will automatically be added to your network and you'll earn 2 % over all earnings by this freelancer through the platform. For more information see our Terms and conditions

Invitation Sent!

after_invite_popup_message

Interested freelancers

    {{ item.displayName }} {{ item.displayName }}

    {{ item.displayDisciplines }}

    • {{ item.hourlyRate || '-' }} per hour
    • {{ item.cityName }}
      {{ item.stateName }}, {{ item.countryName }}
    • {{ item.nrSharedConnections }} shared connections
    Premium
    Open chat Refused

No interested freelancers yet

Refuse

    {{item.displayName}}

    {{item.displayDisciplines}}

    • {{ item.hourlyRate || '-' }} per hour
    • {{ item.cityName }}, {{ item.stateName }}
    • {{item.nrSharedConnections}} shared connections
Cancel
Operation failed!
Please try again later. If the problem persists contact support.