Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-01-01 2015-01-01 U AD EUR 12640 1088 8.61 55 13.00 13 0 63.8560 63.8560 3.2640 3.2640 3.6854 2015-01-01 2015-01-01 FAM2 AD EUR 4338 255 5.88 55 2.00 2 0 29.5020 29.5020 0.7650 0.7650 0.8638 2015-01-01 2015-01-01 FAM3 AD EUR 1351 81 6.00 55 0.94 1 0 18.3990 18.3990 0.2430 0.2430 0.2744 2015-01-01 2015-01-01 A AD EUR 707234 64893 9.18 55 15227.68 3216 0 0.0000 0.0000 194.6790 194.6790 219.8121 2015-01-01 2015-01-01 P AD EUR 263127 20712 7.87 55 366.87 352 0 3274.9830 3274.9830 62.1360 62.1360 70.1578 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/old_files/spotify-revshare-for-theorchard-20151.txt -------------- Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-02-01 2015-02-01 U AD EUR 11318 1200 10.60 55 13.00 13 0 61.6440 61.6440 3.6000 3.6000 4.0309 2015-02-01 2015-02-01 FAM2 AD EUR 3675 165 4.49 55 2.00 2 0 28.4790 28.4790 0.4950 0.4950 0.5543 2015-02-01 2015-02-01 FAM3 AD EUR 1157 57 4.93 55 1.00 1 0 18.9860 18.9860 0.1710 0.1710 0.1915 2015-02-01 2015-02-01 A AD EUR 665126 56372 8.48 55 15858.79 3256 0 0.0000 0.0000 169.1160 169.1160 189.3592 2015-02-01 2015-02-01 P AD EUR 252124 19816 7.86 55 379.61 371 0 3339.9600 3316.5800 59.4480 59.4480 66.5639 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20152.txt -------------- Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-03-01 2015-03-01 U AD EUR 11572 1028 8.88 55 14.00 13 0 71.6130 71.6130 3.0840 3.0840 3.3107 2015-03-01 2015-03-01 FAM2 AD EUR 4407 152 3.45 55 1.94 2 0 29.7310 29.7310 0.4560 0.4560 0.4895 2015-03-01 2015-03-01 FAM3 AD EUR 1185 208 17.55 55 1.00 1 0 20.4810 20.4810 0.6240 0.6240 0.6699 2015-03-01 2015-03-01 A AD EUR 758559 67606 8.91 55 16486.58 3482 0 0.0000 0.0000 202.8180 202.8180 217.7251 2015-03-01 2015-03-01 P AD EUR 278594 21292 7.64 55 385.55 374 0 3798.3940 3741.9540 63.8760 63.8760 68.5709 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20153.txt -------------- Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-04-01 2015-04-01 U AD EUR 11654 1220 10.47 55 14.00 13 0 66.6020 66.6020 3.6600 3.6600 4.1076 2015-04-01 2015-04-01 FAM2 AD EUR 2173 117 5.38 55 2.67 2 0 38.0960 38.0960 0.3510 0.3510 0.3939 2015-04-01 2015-04-01 FAM3 AD EUR 1320 237 17.95 55 1.17 2 0 22.2230 22.2230 0.7110 0.7110 0.7980 2015-04-01 2015-04-01 A AD EUR 695525 62324 8.96 55 17202.80 3568 0 0.0000 0.0000 186.9720 186.9720 209.8387 2015-04-01 2015-04-01 P AD EUR 254108 20880 8.22 55 380.90 371 0 3667.0490 3599.5700 62.6400 62.6400 70.3009 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20154.txt -------------- Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-05-01 2015-05-01 U AD EUR 10869 1082 9.95 55 14.00 13 0 69.2090 69.2090 3.2460 3.2460 3.6352 2015-05-01 2015-05-01 FAM2 AD EUR 1301 116 8.92 55 2.00 2 0 29.6910 29.6910 0.3480 0.3480 0.3897 2015-05-01 2015-05-01 FAM3 AD EUR 2378 189 7.95 55 2.00 2 0 39.5880 39.5880 0.5670 0.5670 0.6350 2015-05-01 2015-05-01 A AD EUR 703467 59878 8.51 55 17766.29 3526 0 0.0000 0.0000 179.6340 179.6340 201.1721 2015-05-01 2015-05-01 P AD EUR 267436 22008 8.23 55 406.58 409 0 4077.9930 3980.5430 66.0240 66.0240 73.9403 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20155.txt -------------- Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-06-01 2015-06-01 U AD EUR 11129 964 8.66 55 14.00 12 0 67.7910 67.7910 2.8920 2.8920 3.2220 2015-06-01 2015-06-01 FAM2 AD EUR 1066 50 4.69 55 2.00 2 0 29.0820 29.0820 0.1500 0.1500 0.1671 2015-06-01 2015-06-01 FAM3 AD EUR 2094 122 5.83 55 2.00 2 0 38.7770 38.7770 0.3660 0.3660 0.4078 2015-06-01 2015-06-01 A AD EUR 725051 53821 7.42 55 18263.83 3484 0 1.0000 1.0000 161.4630 161.4630 179.8859 2015-06-01 2015-06-01 P AD EUR 274482 22384 8.15 55 435.57 440 0 4206.9000 4093.7820 67.1520 67.1520 74.8140 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20156.txt -------------- Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-07-01 2015-07-01 U AD EUR 12269 951 7.75 55 14.00 12 0 68.4780 68.4780 2.8530 2.8530 3.1337 2015-07-01 2015-07-01 FAM2 AD EUR 2544 134 5.27 55 2.00 2 0 29.3770 29.3770 0.4020 0.4020 0.4416 2015-07-01 2015-07-01 FAM3 AD EUR 1952 138 7.07 55 2.00 2 0 39.1700 39.1700 0.4140 0.4140 0.4547 2015-07-01 2015-07-01 A AD EUR 695070 55261 7.95 55 18703.87 3438 0 0.0000 0.0000 165.7830 165.7830 182.0960 2015-07-01 2015-07-01 P AD EUR 296286 22519 7.60 55 483.77 464 0 4273.5240 4178.5940 67.5570 67.5570 74.2046 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20157.txt -------------- Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-08-01 2015-08-01 U AD EUR 11696 1144 9.78 55 13.74 13 0 65.9500 65.9500 3.4320 3.4320 3.8480 2015-08-01 2015-08-01 FAM2 AD EUR 4331 363 8.38 55 2.90 3 0 41.8410 41.8410 1.0890 1.0890 1.2210 2015-08-01 2015-08-01 FAM3 AD EUR 2062 92 4.46 55 2.00 2 0 38.4320 38.4320 0.2760 0.2760 0.3095 2015-08-01 2015-08-01 A AD EUR 680049 57079 8.39 55 19225.26 3412 0 0.0000 0.0000 171.2370 171.2370 191.9909 2015-08-01 2015-08-01 P AD EUR 327346 22969 7.02 55 486.26 459 0 4552.8270 4420.0770 68.9070 68.9070 77.2585 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20158.txt -------------- Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-09-01 2015-09-01 U AD EUR 8805 902 10.24 55 12.33 11 0 59.2180 59.2180 2.7060 2.7060 3.0248 2015-09-01 2015-09-01 FAM2 AD EUR 3255 180 5.53 55 3.00 3 0 43.2560 43.2560 0.5400 0.5400 0.6036 2015-09-01 2015-09-01 FAM3 AD EUR 2476 149 6.02 55 2.00 2 0 38.4500 38.4500 0.4470 0.4470 0.4997 2015-09-01 2015-09-01 A AD EUR 720376 58882 8.17 55 19687.43 3478 0 0.0100 0.0100 176.6460 176.6460 197.4549 2015-09-01 2015-09-01 P AD EUR 327032 23376 7.15 55 496.13 491 0 4795.6760 4678.7860 70.1280 70.1280 78.3891 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20159.txt -------------- 3 2015-10-01 2015-10-31 The Orchard Confidential Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-10-01 2015-10-01 U AD EUR 9182 1048 11.41 55 12.00 10 0 59.6850 59.6850 3.1440 3.1440 3.4606 2015-10-01 2015-10-01 FAM2 AD EUR 3570 235 6.58 55 3.55 4 0 52.9990 52.9990 0.7050 0.7050 0.7760 2015-10-01 2015-10-01 FAM3 AD EUR 3177 215 6.77 55 2.06 3 0 41.1150 41.1150 0.6450 0.6450 0.7100 2015-10-01 2015-10-01 A AD EUR 818644 65044 7.95 55 20110.06 3592 0 2.5370 2.5370 195.1320 195.1320 214.7818 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-201510.txt -------------- 3 2015-11-01 2015-11-30 The Orchard Confidential Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-11-01 2015-11-01 U AD EUR 8048 759 9.43 55 11.20 10 0 54.3790 54.3790 2.2770 2.2770 2.4057 2015-11-01 2015-11-01 FAM2 AD EUR 4893 293 5.99 55 5.00 7 0 72.9020 72.9020 0.8790 0.8790 0.9287 2015-11-01 2015-11-01 FAM3 AD EUR 4829 239 4.95 55 3.00 3 0 58.3210 58.3210 0.7170 0.7170 0.7575 2015-11-01 2015-11-01 A AD EUR 812040 60089 7.40 55 20556.87 3638 0 2.0450 2.0450 180.2670 180.2670 190.4521 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-201511.txt -------------- 3 2015-12-01 2015-12-31 The Orchard Confidential Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2015-12-01 2015-12-01 U AD EUR 10926 1220 11.17 55 11.00 10 0 54.7630 54.7630 3.6600 3.6600 3.9751 2015-12-01 2015-12-01 FAM2 AD EUR 7204 518 7.19 55 8.90 9 0 133.1070 133.1070 1.5540 1.5540 1.6878 2015-12-01 2015-12-01 FAM3 AD EUR 6111 161 2.63 55 2.29 2 0 45.6550 45.6550 0.4830 0.4830 0.5246 2015-12-01 2015-12-01 FAMH15 AD EUR 2562 85 3.32 55 2.48 6 0 24.7560 24.7560 0.2550 0.2550 0.2770 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-201512.txt -------------- 3 2016-01-01 2016-01-31 The Orchard Confidential Report start date Report end date Product Country Currency Total tracks Rightholder's tracks Pro rata share Revenue share Registered users Active users New product users Gross revenue Net revenue Payable Payable EUR Payable USD 2016-01-01 2016-01-01 U AD EUR 10733 1582 14.74 55 10.71 10 0 52.6720 52.6720 4.7460 4.7460 5.1413 2016-01-01 2016-01-01 FAM2 AD EUR 9907 780 7.87 55 10.68 12 0 157.6980 157.6980 2.3400 2.3400 2.5349 2016-01-01 2016-01-01 FAM3 AD EUR 3215 312 9.70 55 2.00 2 0 39.3850 39.3850 0.9360 0.9360 1.0140 2016-01-01 2016-01-01 FAM4 AD EUR 2403 215 8.95 55 0.71 1 0 17.4690 17.4690 0.6450 0.6450 0.6987 ====================== /home/rsaporta/git/orch/data/Spotify_Accounting_ETL/ftp_sync/spotify-revshare-for-theorchard-20161.txt --------------