Ranking customer touchpoints to be used in attribution modelling

cazoo_attrb_modelling_rank_touchpoints.sql

SELECT
    customer_id
    , touchpoint_id
    , lead_id
    , order_id
    , touchpoint_channel
    , touchpoint_campaign
    , touchpoint_datetime
    , RANK() OVER (PARTITION BY customer_id ORDER BY touchpoint_datetime ASC, rand() ) AS touchpoints_customer_rank_asc /* touchpoint -> customer */
    , RANK() OVER (PARTITION BY customer_id ORDER BY touchpoint_datetime DESC, rand() ) AS touchpoints_customer_rank_des /* touchpoint -> customer */    
    , RANK() OVER (PARTITION BY customer_id, lead_id ORDER BY touchpoint_datetime ASC, rand() ) AS touchpoints_customer_lead_rank_asc /* touchpoint -> customer, lead */
    , RANK() OVER (PARTITION BY customer_id, lead_id ORDER BY touchpoint_datetime DESC, rand() ) AS touchpoints_customer_lead_rank_desc/* touchpoint -> customer, lead */
    , RANK() OVER (PARTITION BY customer_id, order_id ORDER BY touchpoint_datetime ASC, rand() ) AS touchpoints_customer_order_rank_asc /* touchpoint -> customer, order */
    , RANK() OVER (PARTITION BY customer_id, order_id ORDER BY touchpoint_datetime DESC, rand() ) AS touchpoints_customer_order_rank_desc /* touchpoint -> customer, order */
FROM
  master_customer_tocuhpoints