120-Day Engaged Audience
Create an explainable engaged-audience dataset from recent opens/clicks while protecting the final grain.
Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.
One-row-per-contact engagement flags and last-event dates suitable for segmentation or reporting.
Choose the identity key used by the audience.
Decide whether opens alone count as engagement for your business case.
Build the eligible base
Start from the audience grain you actually want to preserve.
Aggregate opens and clicks separately
Avoid raw many-to-many joins between event views.
Calculate engagement flags
Join reduced event sets back to the base and derive recent-engagement flags.
Check status / deliverability context
Engagement and sendability are different dimensions.
Turn the Recipe into checkable work.
Progress, notes and history stay in this browser.