ROW_NUMBER is absolutely the best, especially for marketing related customer data.