Spreadsheet: 684125d1593161405-dashboard-help-please-contact-centre-sales-dashboard
Sheet: Pivot

 |  |  |  |  |  |  | Row Labels | Sum of Contact Rate % |  | Row Labels | Sum of Speed to Response |  | Row Labels | Average of Weighted Average |  | Row Labels | Average of No Attempt |  | Campaign Web Leads
 |  |  |  |  |  |  | Australia | 0.9363817097415507 |  | Australia | 0.8290258449304175 |  | Australia | 1.6 |  | Australia | 0.0157
 |  |  |  |  |  |  | England | 0.9636803874092009 |  | England | 1.012106537530266 |  | England | 3.5 |  | England | 0.0052
 |  |  |  |  |  |  | India | 0.9476923076923077 |  | India | 1.052307692307692 |  | India | 3.4 |  | India | 0 |  | Campaign Inbound Calls
 |  |  |  |  |  |  | USA | 0.9161184210526315 |  | USA | 0.9950657894736842 |  | USA | 1.4 |  | USA | 0.02
 |  |  |  |  |  |  | Argentina | 0.9437229437229437 |  | Argentina | 1.043290043290043 |  | Argentina | 1 |  | Argentina | 0.0287
 |  |  |  |  |  |  | Canada | 0.9425087108013938 |  | Canada | 0.9773519163763066 |  | Canada | 1 |  | Canada | 0.0271
 |  |  |  |  |  |  | New Zealand | 0.950479233226837 |  | New Zealand | 1.003993610223642 |  | New Zealand | 2.1 |  | New Zealand | 0.0025
 |  |  |  |  |  |  | China | 0.9180018850141376 |  | China | 1.004712535344015 |  | China | 4 |  | China | 0.004
 |  |  |  |  |  |  | Japan |  |  | Japan |  |  | Japan |  |  | Japan
 |  |  |  |  |  |  | Spain |  |  | Spain |  |  | Spain |  |  | Spain
 |  |  |  |  |  |  | Italy | 0.9153952843273232 |  | Italy | 0.8233934350439205 |  | Italy | 0.6 |  | Italy | 0.0769
Date (Week ending) | 2020-05-24 00:00:00 |  |  |  |  |  | South Africa |  |  | South Africa |  |  | South Africa |  |  | South Africa
 |  |  |  |  |  |  | Grand Total | 0.9326527906668435 |  | Grand Total | 0.9420654911838791 |  | Grand Total | 2.066666666666667 |  | Grand Total | 0.02001111111111111
Row Labels | Count of Centre | Sum of VALID Web Leads | Average of Contact Rate | Average of Contact Rate Previous Week | Sum of Contact Rate Change
Australia | 1 | 503 | 0.9363817097415507 | 0 | 0 |  | Contact Rate |  |  | Speed to Response
England | 1 | 826 | 0.9636803874092009 | 0 | 0 |  |  |  |  |  |  |  | Weigthed Average |  |  | No Attempt %
India | 1 | 325 | 0.9476923076923077 | 0 | 0
USA | 1 | 608 | 0.9161184210526315 | 0 | 0
Argentina | 1 | 231 | 0.9437229437229437 | 0 | 0 |  | Row Labels | Average of Follow Up |  | Row Labels | Sum of VALID Web Leads |  | Row Labels | Sum of Abandoned |  | Row Labels | Sum of Inbound Calls
Canada | 1 | 574 | 0.9425087108013938 | 0 | 0 |  | Australia | 0.2581 |  | Australia | 503 |  | Australia | 0.1492764661081493 |  | Australia | 1313
New Zealand | 1 | 1252 | 0.950479233226837 | 0 | 0 |  | England | 0.2549 |  | England | 826 |  | England | 0.1077694235588972 |  | England | 1197
China | 1 | 1061 | 0.9180018850141376 | 0 | 0 |  | India | 0.3986 |  | India | 325 |  | India | 0.07565337001375516 |  | India | 727
Japan | 1 |  | 0 | 0 | 0 |  | USA | 0.228 |  | USA | 608 |  | USA | 0.0815450643776824 |  | USA | 932
Spain | 1 |  | 0 | 0 | 0 |  | Argentina | 0.2898 |  | Argentina | 231 |  | Argentina | 0.1049504950495049 |  | Argentina | 505
Italy | 1 | 2163 | 0.9153952843273232 | 0 | 0 |  | Canada | 0.3968 |  | Canada | 574 |  | Canada | 0.09450038729666925 |  | Canada | 1291
South Africa | 1 |  | 0 | 0 | 0 |  | New Zealand | 0.3133 |  | New Zealand | 1252 |  | New Zealand | 0.05600403632694248 |  | New Zealand | 1982
Grand Total | 12 | 7543 | 0.7028317402490272 | 0 | 0 |  | China | 0.2585 |  | China | 1061 |  | China | 0.08712363869314542 |  | China | 1561
 |  |  |  |  |  |  | Japan |  |  | Japan |  |  | Japan | 0.05908419497784342 |  | Japan | 1354
 |  |  |  |  |  |  | Spain |  |  | Spain |  |  | Spain | 0.05760494275849536 |  | Spain | 5503
 |  |  |  |  |  |  | Italy | 0.1229 |  | Italy | 2163 |  | Italy | 0.2272727272727273 |  | Italy | 616
 |  |  |  |  |  |  | South Africa |  |  | South Africa |  |  | South Africa | 0.1067064083457526 |  | South Africa | 3355
 |  |  |  |  |  |  | Grand Total | 0.2801 |  | Grand Total | 7543 |  | Grand Total | 0.0871852871754524 |  | Grand Total | 20336
 |  |  |  |  |  |  | Follow Up |  |  | Web Leads |  |  | Abandoned |  |  | Inbound Calls
 |  |  |  |  |  |  | Row Labels | Sum of Call Quality
 |  |  |  |  |  |  | Australia | 10
 |  |  |  |  |  |  | England | 5
 |  |  |  |  |  |  | India | 5
 |  |  |  |  |  |  | USA | 5
 |  |  |  |  |  |  | Argentina | 5
 |  |  |  |  |  |  | Canada | 23
 |  |  |  |  |  |  | New Zealand | 5
 |  |  |  |  |  |  | China | 5
 |  |  |  |  |  |  | Japan | 7
 |  |  |  |  |  |  | Spain | 5
 |  |  |  |  |  |  | Italy | 5
 |  |  |  |  |  |  | South Africa | 5
 |  |  |  |  |  |  | Grand Total | 85
 |  |  |  |  |  |  | Call Quality