I noticed when I set the email frequency to once a week. The ‘scheduled date’ is calculated according to the time when the email is sent for the second time.
For example:
Send A mail on 2023-07-20
On 2023-07-24, send A emails again. At this time, they will enter the queue and set the next scheduled date (2023-08-01).
Is there a problem with this scheduled date? Shouldn’t he be number 2023-07-27?
Sorry, I don’t have a screenshot of the campaign. I have two segmentA, segmentB, corresponding to A email template and B email template respectively. They both have C email addresses.
Send A email template on 2023-07-20
On 2023-07-24, send B the email template again. At this time, C email address, will enter the queue and set the next scheduled date (2023-08-01).
I can provide their records in emai_stats and message_queue tables.
‘email_stats’:
±----------±---------±--------------------±— -----------------+
| id | lead_id | email_address | date_sent |
±----------±---------±--------------------±— -----------------+
| 368621865 | 21813251 | demo@demo.com | 2023-07-20 15:46:06 |
Yes, there is a difference of one week here, but I think it is wrong. We should calculate the time one week after the last successful sending (2023-07-20 15:46:06 → 2023-07-27 15:46:06), instead of calculating one week after sending the email Time (2023-07-25 01:54:21 → 2023-08-01)