Skip to content

Instantly share code, notes, and snippets.

@seyhunak
Forked from sbrissenden/predictions_churn.sql
Created August 31, 2021 19:23
Show Gist options
  • Save seyhunak/b6ce5128b85c2cb71a1d18197a7e2b55 to your computer and use it in GitHub Desktop.
Save seyhunak/b6ce5128b85c2cb71a1d18197a7e2b55 to your computer and use it in GitHub Desktop.
[BigQuery + Firebase Predictions] Number of Users Predicted to Churn
SELECT COUNT(distinct p.user_id)
FROM `friendly--pix.projectId.firebase_predictions.YOUR_PACKAGE_NAME_ANDROID` p CROSS JOIN UNNEST (predictions)
WHERE
prediction_name = "churn"
AND score > 0.7
AND TIMESTAMP_TRUNC(p.prediction_time, DAY) = TIMESTAMP('2018-10-04')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment