gistfile1.txt

SELECT
  COUNTIF(customer_interaction_count_3d >= 2 AND hired_time IS NOT NULL)/COUNTIF(customer_interaction_count_3d >= 2) AS hire_given_twoplus_interactions
  , COUNTIF(customer_interaction_count_after_pro_response_to_first_contact_3d >= 1 AND hired_time IS NOT NULL)/COUNTIF(customer_interaction_count_after_pro_response_to_first_contact_3d >= 1) AS hire_given_oneplus_conversation
FROM a.contacts
WHERE TIMESTAMP_TRUNC(first_customer_contact_time, MONTH) = '2018-01-01 00:00:00'