Appendix A3 Data tables for figures Table A3.1: Proportion of EPF expenditure spent on reverse marketing of job seekers (per cent) -/ High performing sites Mid performing sites Low performing sites total Proportion of EPF expenditure (%) 10.39 7.55 6.11 7.65 Table A3.2: Reverse Marketing expenditure, transaction count and job seeker count Month Name Abbreviation Amount (Sum) Transaction Count Unique JSKR Count Jul-09 $317,556.40 3,722 2,746 Aug-09 12,678 8,166 Sep-09 22,068 14,452 Oct-09 24,152 15,836 Nov-09 24,988 16,407 Dec-09 25,328 16,925 Jan-10 21,602 14,679 Feb-10 27,178 18,544 Mar-10 34,274 22,453 Apr-10 25,262 17,298 May-10 32,947 21,816 Jun-10 33,554 21,533 Jul-10 31,795 20,328 0 7
Jan-10 1919878.21 8.9% Feb-10 2433195.61 8.6% Mar-10 3157771.13 8.8% Apr-10 2329522.07 7.7% May-10 3043493.3 8.4% Jun-10 2964789.12 7.6% Jul-10 2624073.37 7.2% Aug-10 2736384.13 7.4% Sep-10 2689818 7.0% Oct-10 2550772.11 7.0% Nov-10 2608500.83 6.9% Dec-10 2115307.18 6.3% Jan-11 1778738.91 7.0% Feb-11 2416499.02 7.0% Mar-11 3055090.34 7.1% Apr-11 2314994.34 7.1% May-11 2812709.98 7.1% Jun-11 2782315.95 6.1% Jul-11 2807721.06 7.3% Aug-11 3016374.4 6.4% View Figure 3.4 A3.4: Total Reverse Marketing job seeker count, transaction count and dollars committed against each Stream Service July 2009 to August 2011 Stream Sum of RM Amount Count of JSID Count of Trans Id S1 2404172 10672 23367 S2 27195927 115709 324159 S3 18291396 66800 224992 S4 13748833 48432 171562 Table A3.5: Total and commenced caseload per JSCI score March 2010 JSCI Commenced Job Seeker Count Active Caseload Job Seeker Count JSCI Commenced Job Seeker Count Active Caseload Job Seeker 12498 17947 41 4072 6273 1 333 430 42 3572 5555
2 608 807 43 2963 4645 3 1010 1304 44 2683 4209 4 2145 2774 45 2286 3539 5 5292 6669 46 1948 3035 9502 47 1718 2646 14302 48 1380 2209 25038 49 1191 1850 9 25610 50 1164 1724 10 29249 36139 51 876 1334 11 30970 38669 52 768 1153 12 38689 53 603 888 13 29752 37596 54 515 798 14 27785 35534 55 446 652 15 25375 56 349 531 16 23284 31267 57 295 446 17 21269 29306 58 255 368 18 19537 27967 59 178 268 19 27545 60 131 214 20 30098 61 133 203 21 19097 62 96 150 22 18591 28548 63 81 134 23 18147 28284 64 54 80 24 27502 65 46 76 25 18059 27948 66 39 63 26 26591 67 28 42 27 16078 24826 68 31 49 28 14749 22946 69 15 29 29 14027 70 13 25 30 12776 19783 71 7 16 31 11646 18003 72 5 13 32 10700 16656 73 6 11 33 9750 15112 74 3 6 34 8554 13553 75 2 3 35 7654 12000 76 2 5 36 7132 77 1 1 37 6381 9941 79 1 1 38 5708 8902 81 1 1
29 1104776.92 108404.12 66 1325.74 / 30 950858.08 91600.07 67 90.37 / 31 882798.34 93640.38 68 611.96 / 32 723427.78 67686.39 69 123.44 / 33 648831.29 58213.35 70 172.21 / 34 584032.23 52045.07 71 695.15 / 35 522939.61 72 25.99 / 36 491816.7 38224.71 73 179.3 / Table A3.7: Job seeker count for reverse marketing and all other EPF use by JSCI score, March 2010 JSCI JSKR Count All Other EPF JSKR Count RM Only JSCI JSKR Count All Other EPF JSKR Count RM Only 0 1858 486 37 1493 213 1 39 13 38 1290 201 2 51 14 39 1217 205 3 111 34 40 997 129 4 212 63 41 862 122 5 468 128 42 745 90 6 897 233 43 559 64 7 1323 359 44 540 55 8 1862 490 45 470 47 9 2476 639 46 386 41 10 2772 714 47 330 37 11 3111 743 48 286 27 12 3089 712 49 232 21 13 3105 675 50 215 16 14 3014 651 51 155 10 15 2848 626 52 153 5 16 2760 577 53 113 7 17 2628 539 54 91 5 18 2588 550 55 79 2 19 2558 524 56 59 2 20 4432 1023 57 42 4 21 4213 956 58 44 0 22 4027 866 59 29 1 23 4026 867 60 32 0
24 3909 875 61 29 1 25 3976 833 62 14 / 26 3857 818 63 14 / 27 3598 756 64 12 / 28 3411 676 65 9 / 29 3518 729 66 7 / 30 3095 642 67 1 / 31 2802 599 68 8 / 32 2550 477 69 3 / 33 2298 424 70 2 / 34 2014 345 71 1 / 35 1815 317 72 1 / 36 1642 274 73 1 / Table A3.8: Transaction count for reverse marketing and all other EPF use by JSCI score, March 2010 JSCI Transaction Count All Other EPF Transaction Count RM JSCI Transaction Count All Other EPF Transaction RM 0 3138 740 37 2678 333 1 70 18 38 2335 332 2 79 22 39 2259 322 3 165 57 40 1913 212 4 340 104 41 1726 175 5 745 193 42 1397 130 6 1407 352 43 1064 103 7 2156 574 44 1048 80 8 2846 748 45 937 54 9 3884 965 46 730 50 10 4350 1111 47 660 55 11 4971 1153 48 568 38 12 4829 1086 49 406 23 13 4865 1017 50 422 18 14 4673 988 51 368 17 15 4567 1006 52 414 5 16 4316 840 53 273 7 17 4312 860 54 200 5
18 4263 895 55 209 2 19 4187 787 56 150 2 20 7310 1493 57 91 6 21 7080 1462 58 98 0 22 6594 1313 59 46 1 23 6634 1380 60 61 0 24 6487 1324 61 61 1 25 6754 1275 62 29 / 26 6447 1240 63 60 / 27 6146 1206 64 28 / 28 5902 1025 65 17 / 29 6203 1150 66 16 / 30 5406 1009 67 1 / 31 4998 945 68 18 / 32 4386 717 69 10 / 33 4005 627 70 7 / 34 3445 542 71 2 / 35 3235 509 72 3 / 36 3009 418 73 1 / Table A3.9: Reverse Marketing expenditure, job seeker count and transaction count per Stream Service March 2010 / JSKR Count RM Expenditure Transaction Count S1 603 815 S2 10505 1326832.85 S3 6551 949275.51 10233 S4 3848 667359 6232 Table A3.10: Distribution of job seekers who received reverse marketing by JSCI score and Stream, March 2010 JSCI Score S1 S2 S3 S4 JSCI Score S1 S2 S3 S4 0 3 73 43 30 30 2 27 457 168 1 0 13 0 0 31 0 29 426 153
2 1 13 0 1 32 2 15 351 119 3 2 32 0 0 33 2 13 310 108 4 1 60 3 2 34 0 11 244 102 5 5 116 6 5 35 0 10 217 97 6 11 210 15 6 36 0 6 191 84 7 16 313 24 9 37 1 6 152 60 8 28 422 28 11 38 1 4 140 60 9 41 534 39 23 39 0 6 138 61 10 47 587 67 19 40 0 2 82 45 11 55 579 79 37 41 0 1 82 46 12 54 523 98 41 42 0 4 52 32 13 62 481 85 48 43 0 1 40 23 14 48 441 102 64 44 0 0 38 18 15 50 381 113 91 45 0 1 31 15 16 44 332 114 98 46 1 1 26 13 17 38 258 135 107 47 0 0 17 21 18 21 273 119 123 48 0 2 14 11 19 30 228 129 138 49 0 0 14 7 20 4 762 142 151 50 0 0 8 8 21 5 646 157 176 51 0 0 2 8 22 3 576 156 164 52 0 0 4 1 23 5 553 144 175 53 0 0 5 2 24 5 518 162 199 54 0 0 5 0 25 3 408 247 183 55 0 0 2 0 26 3 366 273 188 56 0 0 1 1 27 3 337 236 189 57 0 0 2 2 28 0 301 228 155 59 1 0 0 0 29 5 30 556 149 61 0 0 0 1 Table A3.11: Distribution of job seekers with a status of ‘Commenced’ in Stream Services March 2010 JSCI Score S1 S2 S3 S4 JSCI Score S1 S2 S3 S4 0 874 1352 1022 636 41 28 76 2759 1591 1 192 155 1 1 42 30 67 2401 1404 2 341 311 3 2 43 23 45 2026 1159