WITH

/*New Customers for selected date range*/
 newCustomers as (
   SELECT
    userID,
    RAND() random
   FROM
    `uptimerobot-001.ur.payments`
  WHERE
    paymentPeriod IN (1,12)
    AND paymentStatus = 1
    AND paymentNewUpgradeRenewal = 1

    /*Set the date range for desired reporting period*/
    AND paymentDateTime BETWEEN "2022-01-01 00:00:01" AND "2022-01-31 23:59:59"

  ORDER BY
    random
 ),

/*New users for selected date range with YT as reported source of acguisition*/
 reportedSourceOfAcquisition as (
   SELECT
    userID,
    userRegisterDateTime,
    userReportedOrigin,
    RAND() random
  FROM
    `uptimerobot-001.ur.users`

  WHERE
    /*Set the date range for desired reporting period*/
    userRegisterDateTime BETWEEN "2022-01-01 00:00:01" AND "2022-01-31 23:59:59"
    AND userReportedOrigin = "youtube"
  ORDER BY
    random
 )

SELECT
  *

FROM
  reportedSourceOfAcquisition

WHERE
  userID NOT IN (SELECT userID FROM newCustomers)

limit 500