Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save sbrissenden/d3f74f7e97436da627ac7305631c6ddf to your computer and use it in GitHub Desktop.
Save sbrissenden/d3f74f7e97436da627ac7305631c6ddf to your computer and use it in GitHub Desktop.
[BigQuery + Firebase Predictions] Number of Users Predicted to Churn - French Users
SELECT COUNT(distinct p.user_id)
FROM `friendly--pix.projectId.firebase_predictions.YOUR_PACKAGE_NAME_ANDROID` p CROSS JOIN UNNEST (predictions)
INNER JOIN `projectId.analytics_YOUR_TABLE.events_*`` a on p.user_id = a.user_id
WHERE
prediction_name = "churn"
AND score > 0.7
AND TIMESTAMP_TRUNC(p.prediction_time, DAY) = TIMESTAMP('2018-10-04')
AND a.geo.country = "France"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment