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

    11

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

You've taken the first step in growing your professional network. Expect your friends and colleagues to join soon. More connections mean more opportunities. Welcome aboard!

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.