Recently Modified/Viewed Vs. Unpublished Content

Good morning, all!

We’re utilizing SQL to identify last-modified and last-viewed dates (AO_92296B_AORECENTLY_VIEWED), but there are some unusual discrepancies. For example, we see some spaces where the last modified date may have been as recently as this week, but the last viewed date is more than three months ago. Could this be due to unpublished content triggering the modification date but not the view date? Does anyone have any insight into the relationship between these paramaters and published/unpublished content? Thank you!