I am trying so hard to find out how I can solve these 2 questions :
How many emails I send for each user per day.
What is the average of emails I send to my users (global) per day.
For information, I push daily notifications by email to my users. Some of them receive 0 email per day, others can receive more than 50 emails per day.
Here’s a screenshot that could halp to understand :
In Sent emails , i can see what users receive X ads.
user_id = the user
ad_id = the ad
created_at = when i send the ad by email
you can see in the image above there are 3 users
User 1 = 3549 has received 13 ads by email (the ad_id = 1 is just a special email, not an ad)
User 2 = 3548 has received 2 ads by email
User 3 = 3547 has received 2 ads by email
Any help ? That would be a really nice gift for Chirstmas