ETL SendGrid data to ClickHouse

Enables sending transactional and marketing emails by specifying recipients, content, and advanced email parameters. Contains data such as sender and recipient addresses, subject lines, message bodies, and personalization options.

Manages recipient lists and contact details, including email addresses, custom fields, and subscription status. Essential for segmentation and targeted email campaigns.

Organizes contacts into logical groups for efficient audience management and campaign targeting. Stores metadata about each list and its associated contacts.

Facilitates the creation, scheduling, and management of email marketing campaigns. Includes campaign content, scheduling information, and recipient lists.

Provides detailed analytics on email performance, such as delivery rates, opens, clicks, bounces, and spam reports. Useful for monitoring and optimizing campaign effectiveness.

Manages lists of email addresses that should not receive emails, including bounces, unsubscribes, and spam complaints. Helps maintain compliance and deliverability.

Stores and manages reusable email templates for consistent branding and efficient campaign creation. Contains template content, versions, and metadata.