What proportion of 'ghost' users were previously subscribed to alerts?

[crowbot]

Q: Do ex-alert subscribers make up a significant proportion of this group?

We could add a column to track the total number of alerts a user has ever subscribed to.

[garethrees]

Idea for trying to track this retrospectively https://gist.github.com/garethrees/3ab66642aa653115a58a8044294a2f18

[garethrees]

Can't be done 👎

The user's last_daily_track_email always gets updated when the alert tracks process is run.

The user's who were getting found by the script in the gist either:

• Didn't confirm their email
• Had an email bounce
• Had email alerts turned off

The only insight I think we can get is whether ghost users specifically unsubscribed from all alerts:

attrs = {
  :info_requests_count => 0,
  :track_things_count => 0,
  :comments_count => 0,
  :request_classifications_count => 0,
  :public_body_change_requests_count => 0,
  :info_request_batches_count => 0
}

# Total number of ghosts
User.where(attrs).count
# => 39134

# Number of ghosts who've explicitly set receive_email_alerts to false
User.where(attrs.merge(:receive_email_alerts => false)).count
# => 318

[garethrees]

Closed because I don't think this is really worth writing up, given that we can't really prove anything.