Understand newsletter database records
Know which campaign, recipient, delivery and open metadata is retained.
Exact navigationCode-backed reference → Email Marketing & Newsletter installation schema
Before you begin
- Use an authorised account and confirm the source CRM record or setting is correct.
- Follow the exact route shown above; do not force database values to imitate a completed action.
What this guide covers
Know which campaign, recipient, delivery and open metadata is retained. These instructions follow the supplied module’s live hooks, controller, model, view and validation flow.
Exact step-by-step process
- Review a campaign in Newsletter History.
- Open Details to inspect recipient records.
- Use database access only for authorised diagnostics or retention work.
Fields, choices and supported possibilities
Campaign recordSubject, HTML body, total/sent/failed counts, status, creator and timestamps.
Recipient recordSource key/type/ID, recipient name/email, pending/processing/sent/failed state, error and sent time.
Tracking evidenceUnique tracking token, open count, first/last open, IP, source and user agent.
Code-backed validations and workflow rules
- Campaign and recipient rows are related by campaign ID.
- Open evidence is updated by the public pixel endpoint.
Expected result and verification
- The requested record, output or setting is created or updated through the supported module flow.
- Any related status, count, email, audit/event, PDF/file or queue evidence agrees with the source action.
- An error message is investigated rather than bypassed.
Security, privacy and operational checks
- Apply least privilege and verify the correct customer, lead, sales document or recipient before processing.
- Protect public tokens, recipient data, IP/browser evidence, templates and exported files according to organisational policy.
- Test configuration changes with controlled records before production-wide use.
- Retain or delete evidence only under an authorised retention process.