Automated Weekly Yield Report Emails

[edehvictor]

📝 Description

To increase user retention, we want to send an automated "Weekly Digest" email to subscribed users, summarizing their yield earned over the past 7 days and highlighting the top-performing vaults.

🎯 Acceptance Criteria

• Build a Cron job that runs every Sunday at 00:00 UTC.
• Query the database for the weekly PnL of all subscribed users.
• Use react-email to design a beautiful, responsive HTML email template.
• Integrate with Resend or SendGrid to batch-send the emails.
• Include an unsubscribe link that interacts with a secure backend endpoint.

🛠 Technical Details

• Stack: Node.js, React Email, PostgreSQL, Resend.
• Location: /backend/jobs/weekly_digest.ts
• Security: Strictly enforce unsubscribe compliance (CAN-SPAM/GDPR).

⏱ Complexity & Scope

• Estimated Time: 2-3 weeks.
• Drips Complexity: High (200 points) - Email templating, batch processing, and DB aggregation.

📋 Guidelines for Submission

• Minimum 90 percent test coverage required.
• Clear NatSpec-style documentation must be added to public contract functions.
• Timeframe for completion: 2 Wave cycles.

[shogun444]

@shogun444 has applied to work on this issue as part of the Stellar Wave Program's 3rd wave.

Can i please be assigned here?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @shogun444 to this issue.