Skip to content

Instantly share code, notes, and snippets.

@sbrissenden

sbrissenden/predictions_churn_french_users.sql

Created May 7, 2019 22:35
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.
Download ZIP

Revisions

  1. sbrissenden revised this gist May 7, 2019. No changes.
  2. sbrissenden created this gist May 7, 2019.
    10 changes: 10 additions & 0 deletions predictions_churn_french_users.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,10 @@
    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"