One row per email this automation actually sent, newest first, with the body the brand wrote and what the recipient did with it — opened_at, clicked_at, replied_at, plus boolean shorthands.

Unlike the metrics block on the automation, this is NOT limited to a trailing window: it pages through every email on record. Bear in mind that open tracking began in May 2026 and click tracking later still, so a row sent before then reads as un-opened because nothing was watching, not because the recipient ignored it. sent_at is null on older rows; date_sent is always present.