Customer Service Scorecard Creation

Job ID: 39705579

Budget: $10 – $30 USD

I'm seeking an experienced Google Sheets developer to create a comprehensive scorecard for my customer service agents. I want it to be a scorecard that looks very very professional but easy to read with BIGLY branded. I want something that is out of the box and not generic. Have fun with it but also easy to a novice agent to decipher. I want the owners on the company to use be able to read this at a high volume.

Requirements:
- Metrics to track:
- Call resolution time
- Number of calls handled
- Average Handle Time
- Emails closed
- Email responses
- Average First Response Time
- Number of sales saved
- Number of memberships saved
- Sales $$
- Returns processed
- Disputes submitted
- Manager feedback

- Layout:
- Combination of table and graphical formats
- Update Frequency:
- Daily

Ideal Skills and Experience:
- Proficiency in Google Sheets
- Experience creating scorecards or dashboards
- Ability to present data in a clear, visual format
- Attention to detail and accuracy