1. Granularity

The d_agents table has information about an agent on agent level, which means there's one row for each agent.

You will be able to find the following data for each agent:

• agent_id
• name
• email
• current_manager
• category
• first_tracked_time
• avg_agent_qa_score
• agent_failure_rate
• client_list
• lifetime_delegation_count
• trailing_3_months_delegation_count
• trailing_2_weeks_delegation_count
• lifetime_time_tracked
• trailing_3_months_time_tracked
• trailing_2_weeks_time_tracked
• lifetime_complaint_count
• trailing_3_months_complaint_count