Skip to content

Instantly share code, notes, and snippets.

@sbrissenden

sbrissenden/predictions_churn.sql

Created May 7, 2019 22:39
Show Gist options
  • Save sbrissenden/f93ff83d254fc99ce4c4457d3e696554 to your computer and use it in GitHub Desktop.
Save sbrissenden/f93ff83d254fc99ce4c4457d3e696554 to your computer and use it in GitHub Desktop.
Download ZIP
[BigQuery + Firebase Predictions] Number of Users Predicted to Churn
Raw
predictions_churn.sql
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