Hello,
The best way to see what columns you need/want in your selectedColumns would be to request the export of the report from the Genesys Desktop UI - in Performance views.
And check via your Browser tools what request is sent over the network (e.g. with Chrome Developer Tools - Network tab - checking the body/payload of your POST /api/v2/analytics/reporting/exports).
Four comments:
- I think that if you do not specify/include the selectedColumns in your request body, all available fields will be exported in the report.
- the columnOrder starts at 1 (not 0).
- I don't think you have to specify the Agent ID in the selectedColumns. You can but it is included by default in the export.
- There is no status in the export for the Agent Performance Summary View.
I just triggered an export of the Agent Performance Summary View with all available columns as of today (Role and Media Types are not supported in the export).
Here's the list:
[
{
"columnOrder": 1,
"columnName": "agent_performance_view_agent_name"
},
{
"columnOrder": 2,
"columnName": "agent_performance_view_division_name"
},
{
"columnOrder": 3,
"columnName": "agent_performance_view_skills"
},
{
"columnOrder": 4,
"columnName": "agent_performance_view_agent_id"
},
{
"columnOrder": 5,
"columnName": "agent_performance_view_agent_email"
},
{
"columnOrder": 6,
"columnName": "agent_performance_view_group"
},
{
"columnOrder": 7,
"columnName": "agent_performance_view_reports_to"
},
{
"columnOrder": 8,
"columnName": "agent_performance_view_location"
},
{
"columnOrder": 9,
"columnName": "agent_performance_view_answered"
},
{
"columnOrder": 10,
"columnName": "agent_performance_view_handle"
},
{
"columnOrder": 11,
"columnName": "agent_performance_view_average_handle"
},
{
"columnOrder": 12,
"columnName": "agent_performance_view_average_talk"
},
{
"columnOrder": 13,
"columnName": "agent_performance_view_average_hold"
},
{
"columnOrder": 14,
"columnName": "agent_performance_view_average_acw"
},
{
"columnOrder": 15,
"columnName": "agent_performance_view_average_dialing"
},
{
"columnOrder": 16,
"columnName": "agent_performance_view_average_contacting"
},
{
"columnOrder": 17,
"columnName": "agent_performance_view_total_handle"
},
{
"columnOrder": 18,
"columnName": "agent_performance_view_total_talk"
},
{
"columnOrder": 19,
"columnName": "agent_performance_view_total_hold"
},
{
"columnOrder": 20,
"columnName": "agent_performance_view_total_acw"
},
{
"columnOrder": 21,
"columnName": "agent_performance_view_total_dialing"
},
{
"columnOrder": 22,
"columnName": "agent_performance_view_total_contacting"
},
{
"columnOrder": 23,
"columnName": "agent_performance_view_held"
},
{
"columnOrder": 24,
"columnName": "agent_performance_view_transferred"
},
{
"columnOrder": 25,
"columnName": "agent_performance_view_outbound"
},
{
"columnOrder": 26,
"columnName": "agent_performance_view_not_responding"
},
{
"columnOrder": 27,
"columnName": "agent_performance_view_total_not_responding"
},
{
"columnOrder": 28,
"columnName": "agent_performance_view_alert"
},
{
"columnOrder": 29,
"columnName": "agent_performance_view_total_alert"
},
{
"columnOrder": 30,
"columnName": "agent_performance_view_transfer_percent"
},
{
"columnOrder": 31,
"columnName": "agent_performance_view_total_monitor"
},
{
"columnOrder": 32,
"columnName": "agent_performance_view_avg_monitor"
},
{
"columnOrder": 33,
"columnName": "agent_performance_view_max_monitor"
},
{
"columnOrder": 34,
"columnName": "agent_performance_view_min_monitor"
},
{
"columnOrder": 35,
"columnName": "agent_performance_view_monitor"
},
{
"columnOrder": 36,
"columnName": "agent_performance_view_min_alert"
},
{
"columnOrder": 37,
"columnName": "agent_performance_view_max_alert"
},
{
"columnOrder": 38,
"columnName": "agent_performance_view_min_not_responding"
},
{
"columnOrder": 39,
"columnName": "agent_performance_view_max_not_responding"
},
{
"columnOrder": 40,
"columnName": "agent_performance_view_min_handle"
},
{
"columnOrder": 41,
"columnName": "agent_performance_view_max_handle"
},
{
"columnOrder": 42,
"columnName": "agent_performance_view_min_talk"
},
{
"columnOrder": 43,
"columnName": "agent_performance_view_max_talk"
},
{
"columnOrder": 44,
"columnName": "agent_performance_view_min_hold"
},
{
"columnOrder": 45,
"columnName": "agent_performance_view_max_hold"
},
{
"columnOrder": 46,
"columnName": "agent_performance_view_min_answer"
},
{
"columnOrder": 47,
"columnName": "agent_performance_view_max_answer"
},
{
"columnOrder": 48,
"columnName": "agent_performance_view_min_acw"
},
{
"columnOrder": 49,
"columnName": "agent_performance_view_max_acw"
},
{
"columnOrder": 50,
"columnName": "agent_performance_view_blind_transfer"
},
{
"columnOrder": 51,
"columnName": "agent_performance_view_blind_transfer_percent"
},
{
"columnOrder": 52,
"columnName": "agent_performance_view_consult_transfer"
},
{
"columnOrder": 53,
"columnName": "agent_performance_view_consult_transfer_percent"
},
{
"columnOrder": 54,
"columnName": "agent_performance_view_title"
},
{
"columnOrder": 55,
"columnName": "agent_performance_view_department"
},
{
"columnOrder": 56,
"columnName": "agent_performance_view_primary_phone"
},
{
"columnOrder": 57,
"columnName": "agent_performance_view_standard_requested_count"
},
{
"columnOrder": 58,
"columnName": "agent_performance_view_standard_requested_rate"
},
{
"columnOrder": 59,
"columnName": "agent_performance_view_standard_used_count"
},
{
"columnOrder": 60,
"columnName": "agent_performance_view_standard_used_rate"
},
{
"columnOrder": 61,
"columnName": "agent_performance_view_bullseye_requested_count"
},
{
"columnOrder": 62,
"columnName": "agent_performance_view_bullseye_requested_rate"
},
{
"columnOrder": 63,
"columnName": "agent_performance_view_bullseye_used_count"
},
{
"columnOrder": 64,
"columnName": "agent_performance_view_bullseye_used_rate"
},
{
"columnOrder": 65,
"columnName": "agent_performance_view_preferred_requested_count"
},
{
"columnOrder": 66,
"columnName": "agent_performance_view_preferred_requested_rate"
},
{
"columnOrder": 67,
"columnName": "agent_performance_view_preferred_used_count"
},
{
"columnOrder": 68,
"columnName": "agent_performance_view_preferred_used_rate"
},
{
"columnOrder": 69,
"columnName": "agent_performance_view_last_requested_count"
},
{
"columnOrder": 70,
"columnName": "agent_performance_view_last_requested_rate"
},
{
"columnOrder": 71,
"columnName": "agent_performance_view_last_used_count"
},
{
"columnOrder": 72,
"columnName": "agent_performance_view_last_used_rate"
},
{
"columnOrder": 73,
"columnName": "agent_performance_view_manual_used_count"
},
{
"columnOrder": 74,
"columnName": "agent_performance_view_manual_used_rate"
},
{
"columnOrder": 75,
"columnName": "agent_performance_view_predictive_requested_count"
},
{
"columnOrder": 76,
"columnName": "agent_performance_view_predictive_requested_rate"
},
{
"columnOrder": 77,
"columnName": "agent_performance_view_predictive_used_count"
},
{
"columnOrder": 78,
"columnName": "agent_performance_view_predictive_used_rate"
},
{
"columnOrder": 79,
"columnName": "agent_performance_view_sentiment_instances_total"
},
{
"columnOrder": 80,
"columnName": "agent_performance_view_sentiment_instances_positive"
},
{
"columnOrder": 81,
"columnName": "agent_performance_view_sentiment_instances_negative"
},
{
"columnOrder": 82,
"columnName": "agent_performance_view_sentiment_avg"
}
]
Regards,