Hi,
I need to run a script on events table to check the frequency of user logging in.
Where the count of successful login attempts over the last 30 calendar days is greater than or equal to10, then the user is returned as a "Frequent" user.
Where the count of login attempts retrieved from the events table over the last 30 calendar days is lesser than 10, then the user is returned as a "Infrequent" user.
For the frequent users will have property set to "Opted out" i.e., for the newly introduced notification, the notification preference will be set as "Opted out".
For the infrequent users will have property set to "Opted in" i.e., for the newly introduced notification, the notification preference will be set as "Opted in".
Kindly help me how to achieve this logic.
