NOTE ON THESE NUMBERS: iTunes suffered from a reporting error, where the UPC was not being reported on several downloads. Those downloads were NOT attributed to any album. This data looks back from April 01, 2013 to March 19, 2014 ------- Total_Number_Of_Unique_Customers_Listening_To_GlitchMob_On_iTunes 407,933 Number of Customers who bought Love Death Immortality after first hearing the promo firstPlay 1,036 Number of Unique Customers who have purchased each release (or part of) via itunes release Unique_Customers FirstPlay Promo 33473 <~~~ The Orchard Promotion Drive It Like You Stole It - Single 2650 Drink The Sea 88698 We Can Make The World Stop - EP 50561 Love Death Immortality 30339 __________________________________________________________________ Combinations (owning more than one album, or tracks from an album) __________________________________________________________________ [ Drink The Sea ]` 88698 [ Drive It Like You Stole It - Single ]` 2650 [ FirstPlay Promo ]` 33473 [ Love Death Immortality ]` 30339 [ We Can Make The World Stop - EP ]` 50561 [ Drink The Sea ] AND [ Drive It Like You Stole It - Single ]` 1495 [ Drink The Sea ] AND [ We Can Make The World Stop - EP ]` 17018 [ Drive It Like You Stole It - Single ] AND [ We Can Make The World Stop - EP ]` 1262 [ FirstPlay Promo ] AND [ Love Death Immortality ]` 3020 [ Drink The Sea ] AND [ Drive It Like You Stole It - Single ] AND [ We Can Make The World Stop - EP ]` 981 LOOK AT THE STORE USER ID COLUMN.... I cannot actually count the number of users, because we are missing user ids ## This table are users who bought Love, Death & Immortality and also bought Drink The Sea releaseid artistid dayid labelid storeid genreid trackid countryid transactiontypeid zipid catalogid isrcid imprintid currencyid 1: 8.88004e+11 544747 5465 19020 1 2 13917125 1 19 0 2919620 13977657 11282 170 2: 8.88004e+11 544747 5465 19020 1 2 13917125 1 19 0 2919620 13977657 11282 170 3: 8.88004e+11 544747 5465 19020 1 2 13917125 8 19 26073 2919620 13977657 11282 8 4: 8.88004e+11 544747 5465 19020 1 2 13917125 3 19 2317606 2919620 13977657 11282 46 5: 8.88004e+11 544747 5465 19020 1 2 13917125 11 19 40443 2919620 13977657 11282 46 --- 5030992: 8.88004e+11 544747 5557 19020 1 2 13917122 1 19 0 2919620 13977654 11282 170 5030993: 8.88004e+11 544747 5557 19020 1 2 13917125 1 19 0 2919620 13977657 11282 170 5030994: 8.88004e+11 544747 5557 19020 1 2 13917127 1 19 0 2919620 13977659 11282 170 5030995: 8.88004e+11 544747 5557 19020 1 2 13927297 1 23 0 2919620 13987829 11282 170 5030996: 8.88004e+11 544747 5557 19020 1 2 13927297 1 23 11824 2919620 13987829 11282 170 storeuserid processeddaytime royalty royaltydollar units paidunits freeunits uuid subaccountid 1: 0 2014-01-17 18:58:23 0.70 0.700000 1 1 0 8919474f0e0f4dc2dce058496839a1f9 NA 2: 0 2014-01-17 18:58:23 0.70 0.700000 1 1 0 8919474f0e0f4dc2dce058496839a1f9 NA 3: 0 2014-01-17 18:58:23 0.99 0.909612 1 1 0 8919474f0e0f4dc2dce058496839a1f9 NA 4: 0 2014-01-17 18:58:23 0.71 0.908232 1 1 0 8919474f0e0f4dc2dce058496839a1f9 NA 5: 0 2014-01-17 18:58:23 0.71 0.908232 1 1 0 8919474f0e0f4dc2dce058496839a1f9 NA --- 5030992: 0 2014-03-20 09:00:21 0.70 0.700000 1 1 0 8a141df8f7f3a1f58ae7bc70c93ca97f NA 5030993: 0 2014-03-20 09:00:21 0.70 0.700000 1 1 0 8a141df8f7f3a1f58ae7bc70c93ca97f NA 5030994: 0 2014-03-20 09:00:21 0.70 0.700000 1 1 0 8a141df8f7f3a1f58ae7bc70c93ca97f NA 5030995: 0 2014-03-20 09:00:21 6.30 6.300000 1 1 0 8a141df8f7f3a1f58ae7bc70c93ca97f NA 5030996: 0 2014-03-20 09:00:21 6.30 6.300000 1 1 0 8a141df8f7f3a1f58ae7bc70c93ca97f NA > ids <- alsoBoughtLDI[storeuserid>100, unique(storeuserid)] > head(ids) numeric(0)