## PRE ORDER RETENTION 

RESTRICT TO USA

customer  Own_1st,  Own_2nd,  Own_3rd, FirstPlayed,  Attributable Purchase, Pre_Ordered

How many people listen to the itunes radio stream and (1) pre-ordreed  OR (2) downloaded
    ---   how many people who streamed the FIRSTPLAY later purchased.  Breakdown by pre-order vs download
          - it is likey that they will be lumped in the download bucket.   So make sure to setdiff them. 
        PURPOSE:  When iTunes Radio offers this, we can show what the value is here.   
        :: FOLLOW UP.   What is the time distance between FIRSTPLAY listen and purchase.   BONUS:  Breakdown by repeat listens in FIRSTPLAY

    ---   how many people pre-ordered as a result of the stream.   As opposed to having pre ordered for other reasons. 

    --- how many users purchased the previous album(s) 


NEEEDED
  -- DATE preorder date
  -- DATE street date
  -- DATE firstplay date
  PREORDER WILL BE A SUBSET OF 3

      who s listening to the full record and pre ordering
      how engaged are these fans who are converting to pre order



X 1.) How many customers who listened to the pre-stream pre-ordered or downloaded the record?
X 2.) How soon (days) after these customers listened to the pre-stream did they pre-order/download the record?
XXX  3.) What percentage of overall pre-orders/downloads were driven from the pre-stream?
4.) On average, how many tracks from the stream did customers who converted to pre-order/download listen to?