You want to improve your abandoned cart program, and have it sent more than once per day.
You can load abandon data into a relational table with a time stamp, and then query the information that shows time in the last few hours of their abandonment.
If you need to be able to query the time such as the hour portion of the data, you cannot use the time stamp field. You must create different fields. One field dedicated to store the date and another field to store the hour as a numeric value. You can then query that hour field by using both query and classic query.
Date | Hour |
---|---|
11/22/2020 | 21 |
11/22/2020 | 14 |