Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH clicks AS (
- SELECT ir.*, service_page_viewed as clicked
- FROM `sandbox.ir_ranking_training_ds_apr17_18` ir
- INNER JOIN `instant_results.search_results` s ON CAST(ir.service_pk AS INT64) = s.service_pk AND CAST(ir.search_request_pk as INT64) = s.search_request_pk
- ),
- search_atleast_one_conv AS (
- SELECT search_request_pk, COUNTIF(one_plus_conversation IS TRUE) as num_conv
- FROM clicks
- GROUP BY 1
- HAVING num_conv > 0
- )
- SELECT COUNT(DISTINCT search_request_pk) FROM search_atleast_one_conv
Add Comment
Please, Sign In to add comment