The Question
SQLCRM Consecutive Engagement Analysis
Identify high-intent customers from CRM and marketing logs. Specifically, extract the unique email addresses of contacts who have shown sustained engagement—defined as having at least one marketing interaction per week for a minimum of three consecutive weeks—and who have also specifically requested a product trial ('trial_request') at any point in their interaction history.
Snowflake
CTE
Window Func
Gaps and Islands
DATEADD
TRUNC
QUALIFY
March 13, 2026