Data model

Understand data model for CRM with Email Campaigns.

31 tables · 69 relationships

Data model 28 of 31 tables drawn

Data model28 of 31 tables, within two hops of Campaigns

How the model is organised

Audiences and CRM contacts

Subscribers, Lists, ListMemberships, ListImports, ConsentEvents. Build relevant audiences from contacts you are permitted to reach.

Subscribers
Lists
ListMemberships
ListImports
ConsentEvents

Templates and content

EmailTemplates, TemplateBlocks, EmailFooterTemplates, SenderIdentities. Turn reusable content into an approved campaign message.

EmailTemplates
TemplateBlocks
EmailFooterTemplates
SenderIdentities

Campaign planning

Campaigns, Sends, SendRecipients, Lists. Plan delivery around a reviewed audience, message and purpose.

Campaigns
Sends
SendRecipients
Lists

Drip journeys

Journeys, JourneySteps, JourneyEnrollments, Sends. Follow up over time with clear stops and next steps.

Journeys
JourneySteps
JourneyEnrollments
Sends

Experiments and engagement

ABTests, ABTestVariants, OpenEvents, ClickEvents, Sends. Learn from observed engagement without overstating the result.

ABTests
ABTestVariants
OpenEvents
ClickEvents
Sends

Delivery and preferences

SenderDomains, SendRecipients, Bounces, SpamReports, Suppressions, SuppressionReviews, Unsubscribes. Keep delivery outcomes and subscriber preferences visible.

SenderDomains
SendRecipients
Bounces
SpamReports
Suppressions
SuppressionReviews
Unsubscribes

Keys and references

Preserve workspace-scoped identities, source references and current record revisions. Child records inherit parent scope. Retried commands and provider events resolve to their original occurrence.

Migration order

Configure workspace identities and role scopes.
Import reference records and resolve duplicates.
Import current customer work with its actual state and ownership.
Reconcile historical decisions and external references.
Test a complete handoff before enabling automated commands.

Tables

Find a table 31 tables

UsersApp users — Admin, Email Marketing Manager, Email Designer, Deliverability Manager, Marketing Operations, Viewer.master

Field	Type	Required	Details
`UserID`	text	yes
`FullName`	text	yes
`Email`	text	yes
`Role`	select	yes	Admin, Email Marketing Manager, Email Designer, Deliverability Manager, Marketing Operations, Campaign Approver, Viewer / Analyst
`Department`	text
`Active`	boolean	yes
`PrincipalId`	text	yes	Unique authenticated subject within WorkspaceKey; not inferred from Email.
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

SenderDomainsVerified sender domains used for outbound email. DKIM, SPF, and DMARC must be green before a domain can move from `Pending` to `Verified`. Reputation score is a rolling 30-day signal pulled from the ESP and the BlocklistChecks history.master

Field	Type	Required	Details
`Domain`	text	yes	e.g. mail.acme.com
`RootDomain`	text	yes	e.g. acme.com
`Status`	select	yes	Pending, Verified, Warming, Active, Paused, Disabled
`DKIMStatus`	select	yes	NotChecked, Failing, Passing
`SPFStatus`	select	yes	NotChecked, Failing, Passing
`DMARCStatus`	select	yes	NotChecked, None, Quarantine, Reject, Failing
`ReputationScore`	number		0–100, rolling 30-day, pulled from ESP
`WarmupPlanDays`	number		Total days of throttled ramp
`WarmupStartedAt`	date
`DailyVolumeCapToday`	number		Today's per-domain cap during warm-up
`Owner`	reference	yes	→ Users (Deliverability Manager)
`LastVerifiedAt`	date
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

SenderIdentitiesA verified From-Name + From-Email pair tied to a SenderDomain. A Campaign sends from one SenderIdentity. CAN-SPAM requires the From line to clearly identify the sender — this is enforced by making `FromName` required and verified per identity.master

Field	Type	Required	Details
`IdentityName`	text	yes	Internal label, e.g. "Acme Marketing"
`FromName`	text	yes	Display name shown in inbox
`FromEmail`	text	yes	[email protected]
`ReplyTo`	text		Optional reply-to address
`Domain`	reference	yes	→ SenderDomains
`PhysicalPostalAddress`	text	yes	CAN-SPAM physical address shown in footer
`Status`	select	yes	Pending, Verified, Active, Paused
`LastUsedAt`	date
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

EmailTemplatesA reusable email design. Composed of TemplateBlocks line items. Carries default subject line, preheader, sender, and footer binding. Each Campaign instantiates an EmailTemplate at send time — the rendered EmailContent body is snapshotted onto the Sends row and frozen.master

Field	Type	Required	Details
`TemplateNumber`	text	yes
`Name`	text	yes
`Category`	select	yes	Newsletter, Promotional, Announcement, Re-Engagement, EventInvite, Survey, Other
`SubjectLine`	text	yes	Default subject — overridable per Campaign
`PreheaderText`	text		Inbox preview text
`BodyHTML`	text	yes	Compiled HTML body — the actual rendered email markup
`BodyText`	text	yes	Plain-text alternative for accessibility + spam-score
`DefaultSenderIdentity`	reference		→ SenderIdentities
`DefaultFooter`	reference	yes	→ EmailFooterTemplates
`ThumbnailURL`	text
`Owner`	reference	yes	→ Users (Email Designer)
`Status`	select	yes	Draft, Submitted, Approved, Retired
`LastEditedAt`	date
`Active`	boolean	yes
`Version`	number	yes
`ApprovedBy`	reference		→ Users
`ApprovedAt`	datetime
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

TemplateBlocksModular content blocks composing an EmailTemplate. The Designer edits blocks individually; the Template's BodyHTML is recompiled from blocks on save. Each block carries its own block-level HTML slot.master

Field	Type	Required	Details
`Template`	reference	yes	→ EmailTemplates
`Sequence`	number	yes	Render order
`BlockType`	select	yes	Header, Hero, Body, Image, CTA, Divider, Spacer, Footer, Custom
`BlockHTML`	text	yes	The block's HTML slot
`Label`	text		Editor-side block label
`LinkURL`	text		Used for CTA / Image / Hero blocks
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

EmailFooterTemplatesCAN-SPAM-compliant footer templates. Every Campaign must bind to one. Carries the physical postal address (required by CAN-SPAM), the unsubscribe link slot, the preferences-center link slot, and optional company branding HTML.master

Field	Type	Required	Details
`Name`	text	yes
`FooterHTML`	text	yes	Full footer markup with merge slots for {unsubscribe}, {preferences}, {address}
`FooterText`	text	yes	Plain-text version
`PhysicalPostalAddress`	text	yes	CAN-SPAM physical address
`BoundPreferencesCenter`	reference		→ PreferencesCenters
`Active`	boolean	yes
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

PreferencesCentersBranded subscription preference page configuration. Subscribers land here from the {preferences} link in the footer; they can update topic preferences, change cadence, or fully unsubscribe. Each PreferencesCenter ties to a SenderDomain for the public URL.master

Field	Type	Required	Details
`Name`	text	yes
`PublicURL`	text	yes	e.g. https://prefs.acme.com/abc123
`Domain`	reference	yes	→ SenderDomains
`BrandingHTML`	text		Header / colors customization
`OfferedLists`	text		Newline-separated names of opt-in Lists exposed on the page
`AllowFullUnsubscribe`	boolean	yes	Single global unsubscribe button
`Active`	boolean	yes
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

ListsSubscriber lists. A Subscriber can be on many Lists via ListMemberships. A Campaign targets exactly one List (segmentation is via additional filter on Subscribers within the List at send time).master

Field	Type	Required	Details
`ListNumber`	text	yes
`Name`	text	yes
`Description`	text
`ListType`	select	yes	Newsletter, Product, Customer, Prospect, Event, ReEngagement, Other
`OptInRequired`	boolean	yes	True for marketing lists per CAN-SPAM best practice
`Owner`	reference	yes	→ Users (Marketing Ops)
`MemberCountActive`	number		Rollup, refreshed on membership change
`Active`	boolean	yes
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

ListMembershipsPer-Subscriber membership in a List with subscribed-at date and membership status.master

Field	Type	Required	Details
`List`	reference	yes	→ Lists
`Subscriber`	reference	yes	→ Subscribers
`SubscribedAt`	date	yes
`Source`	select	yes	WebForm, Import, API, Manual, Migration
`Status`	select	yes	Active, Unsubscribed, Bounced, Complained
`UnsubscribedAt`	date
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

ListImportsBulk subscriber import jobs. Marketing Ops uploads a CSV; the import job validates each row (email syntax, MX lookup, role-based filter), creates or updates Subscribers, and stitches ListMemberships to the target List.transaction

Field	Type	Required	Details
`ImportNumber`	text	yes
`TargetList`	reference	yes	→ Lists
`FileURL`	text	yes	Uploaded CSV location
`Submitter`	reference	yes	→ Users
`RowsTotal`	number
`RowsImported`	number
`RowsRejected`	number
`RowsSkippedSuppressed`	number		Rejected because email is on Suppressions
`Status`	select	yes	Queued, Validating, Importing, Completed, Failed, Cancelled
`StartedAt`	date
`CompletedAt`	date
`ErrorSummary`	text
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

SubscribersThe recipient master. One row per unique email. Carries engagement score, status, and CCPA do-not-sell flag.master

Field	Type	Required	Details
`Email`	text	yes	Natural key
`FirstName`	text
`LastName`	text
`Status`	select	yes	Active, Bounced, Unsubscribed, Complained, Suppressed
`EngagementScore`	number		0–100, rolling, updated by engagement-score-update workflow
`LastOpenedAt`	date
`LastClickedAt`	date
`FirstSubscribedAt`	date	yes
`Source`	select	yes	WebForm, Import, API, Manual, Migration
`StateUS`	text		Two-letter US state code, used for CCPA scoping
`CCPADoNotSell`	boolean		Honored on send filtering
`TimeZone`	text		IANA TZ for send-time optimization
`ConfirmedOptInAt`	date		If double opt-in flow used
`OptInConfirmationSentAt`	date		When the confirmation email was sent (used for the 7-day expiry default)
`SubscriberNumber`	text	yes
`ContactPolicy`	select	yes	Unknown, Permitted, Restricted, Withdrawn
`PolicyPurpose`	text	yes
`CRMExternalReference`	text		Configured source CRM contact identifier; no implicit cross-system access.
`OptInTokenHash`	text		Store a one-way token digest; never persist the raw confirmation token.
`OptInTokenExpiresAt`	datetime
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

CampaignsEmail-specific Campaign instance — distinct from the broader multi-channel `crm-campaigns` Campaign object. Binds a Template, a List, a SenderIdentity, a Footer, and a schedule. May carry an ABTest reference. Spawns one or more Sends rows (one for the main audience, one per A/B variant if applicable).transaction

Field	Type	Required	Details
`CampaignNumber`	text	yes
`Name`	text	yes
`Template`	reference	yes	→ EmailTemplates
`TargetList`	reference	yes	→ Lists
`AdditionalFilter`	text		Optional segment filter expression on Subscribers within the List
`SenderIdentity`	reference	yes	→ SenderIdentities
`Footer`	reference	yes	→ EmailFooterTemplates
`PreferencesCenter`	reference		→ PreferencesCenters
`SubjectLineOverride`	text		Overrides Template.SubjectLine if set
`ScheduledAt`	date	yes
`SendTimeOptimization`	boolean		Per-recipient TZ-aware send
`ABTest`	reference		→ ABTests
`Owner`	reference	yes	→ Users (Email Marketing Manager)
`Status`	select	yes	Draft, Submitted, Approved, Scheduled, Sending, Completed, Paused, Cancelled
`Notes`	text
`PreparedBy`	reference	yes	→ Users
`ApprovedBy`	reference		→ Users
`ApprovalRevision`	number
`ApprovedAt`	datetime
`StartTime`	datetime	yes	Scheduled campaign window start in UTC.
`EndTime`	datetime	yes	Campaign window end after StartTime.
`Purpose`	text	yes
`AudienceRevision`	text	yes	Frozen audience rule and policy revision at approval.
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

ABTestsCampaign experiment with disjoint recipient variants, a declared supported engagement metric and a defined observation window. The system proposes a result from recorded evidence. An independent Campaign Approver authorizes a supported winner; insufficient evidence remains Inconclusive. Only the untouched eligible audience can receive the approved follow-on.transaction

Field	Type	Required	Details
`TestNumber`	text	yes
`Name`	text	yes
`Campaign`	reference	yes	→ Campaigns
`TestType`	select	yes	SubjectLine, FromName, Content, SendTime
`VariantCount`	number	yes	2–4
`AudiencePercentPerVariant`	number	yes	e.g. 10 → 10% of List per variant, remainder gets winner
`WinningMetric`	select	yes	OpenRate, ClickRate, ClickToOpenRate; calculated from deduplicated events with explicit signal quality; conversion attribution is outside this experiment model.
`SignificanceWindowHours`	number	yes	e.g. 24, 48, 72
`MinimumSampleSize`	number		Minimum recipients per variant before winner can be declared
`SignificanceThreshold`	number		e.g. 0.95 confidence
`WinnerVariant`	reference		→ ABTestVariants; Populated only when Status IN ('WinnerApproved', 'Completed'); set by a supported independent approval for this same test.
`WinnerDeclaredAt`	date		Populated only when Status IN ('WinnerApproved', 'Completed'); timestamp of the supported independent winner approval.
`Status`	select	yes	Draft, Running, WinnerPending, WinnerApproved, Inconclusive, Completed, Cancelled
`Owner`	reference	yes	→ Users
`DecisionBy`	reference		→ Users
`DecisionAt`	datetime
`AudienceSnapshot`	text	yes
`DecisionReason`	longtext
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

ABTestVariantsThe variant cells of an ABTest. Each variant carries the variant content (subject / from-name / content body / send-time) and the post-test results captured by the winner-detection workflow.master

Field	Type	Required	Details
`Test`	reference	yes	→ ABTests
`VariantLabel`	text	yes	A, B, C, D
`SubjectLineVariant`	text		Used when TestType = SubjectLine
`FromNameVariant`	text		Used when TestType = FromName
`ContentBodyHTMLVariant`	text		Used when TestType = Content
`SendTimeVariant`	date		Used when TestType = SendTime
`Recipients`	number		Captured at send
`Delivered`	number		Captured rolling
`Opens`	number
`UniqueOpens`	number
`Clicks`	number
`UniqueClicks`	number
`OpenRate`	decimal		Server-derived; fx: UniqueOpens / Delivered
`ClickRate`	decimal		Server-derived; fx: UniqueClicks / Delivered
`IsWinner`	boolean
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

SendsA single send batch. One Campaign produces one Sends row for a straight blast, or N+1 rows for an N-variant A/B (one per variant plus a follow-on winner send). Snapshots the rendered EmailContent body so the historical record is frozen against later template edits.transaction

Field	Type	Required	Details
`SendNumber`	text	yes
`Campaign`	reference	yes	→ Campaigns
`ABTest`	reference		→ ABTests
`Variant`	reference		→ ABTestVariants (set when this Send is one variant cell)
`SendKind`	select	yes	Blast, ABVariant, ABWinnerFollowOn
`RenderedSubjectLine`	text	yes	Snapshot at send
`RenderedFromName`	text	yes	Snapshot at send
`RenderedFromEmail`	text	yes	Snapshot at send
`RenderedBodyHTML`	text	yes	Frozen snapshot of the email body that went out
`RenderedBodyText`	text	yes	Plain-text alternative snapshot
`ScheduledAt`	date	yes
`StartedAt`	date
`CompletedAt`	date
`RecipientCountIntended`	number		After suppression filter
`RecipientCountSent`	number
`RecipientCountFailed`	number
`Status`	select	yes	Scheduled, Filtering, Sending, Sent, Completed, Paused, Failed, Unknown, Cancelled
`ESPMessageBatchID`	text		Returned by ESP for trace
`JourneyEnrollment`	reference		→ JourneyEnrollments
`JourneyStep`	reference		→ JourneySteps
`DispatchKey`	text	yes	Unique campaign/version/audience or journey step intent.
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

SendRecipientsPer-recipient send result on a Sends batch. Created by the send pipeline after pre-send filtering. Captures whether the ESP accepted the message and the eventual delivery state.master

Field	Type	Required	Details
`Send`	reference	yes	→ Sends
`Subscriber`	reference	yes	→ Subscribers
`EmailAtSend`	text	yes	Snapshot — Subscriber email may change later
`Status`	select	yes	Queued, Sent, Delivered, Bounced, Failed, Suppressed, Unknown
`ESPMessageID`	text		Per-recipient ESP message ID for webhook correlation
`QueuedAt`	date
`SentAt`	date
`DeliveredAt`	date
`FailureReason`	text
`DispatchKey`	text	yes	Unique per send and subscriber; provider idempotency correlation.
`ProviderAcceptedAt`	datetime
`LeaseUntil`	datetime
`SuppressionCheckedAt`	datetime
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

OpenEventsOpen events captured by the tracking pixel. Webhook-fed by the ESP. Multiple opens per recipient possible — UniqueOpens at the Send level dedupes by Subscriber.transaction

Field	Type	Required	Details
`Send`	reference	yes	→ Sends
`SendRecipient`	reference	yes	→ SendRecipients
`Subscriber`	reference	yes	→ Subscribers
`OpenedAt`	date	yes
`UserAgent`	text
`IPAddress`	text
`ESPMessageID`	text
`ProviderEventId`	text		Deduplicate each distinct provider event, not all events sharing a message ID.
`SignalQuality`	select	yes	HumanCandidate, Proxy, Bot, Unknown
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.
`RecordNumber`	text	yes
`Status`	select	yes	Recorded, Superseded

ClickEventsLink click events captured by ESP click-tracking. Carries the clicked URL.transaction

Field	Type	Required	Details
`Send`	reference	yes	→ Sends
`SendRecipient`	reference	yes	→ SendRecipients
`Subscriber`	reference	yes	→ Subscribers
`ClickedURL`	text	yes
`ClickedAt`	date	yes
`UserAgent`	text
`IPAddress`	text
`ESPMessageID`	text
`ProviderEventId`	text		Deduplicate each distinct provider event, not all events sharing a message ID.
`SignalQuality`	select	yes	HumanCandidate, Proxy, Bot, Unknown
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.
`RecordNumber`	text	yes
`Status`	select	yes	Recorded, Superseded

BouncesBounce events fed from the ESP. Type drives downstream automation: hard bounces add the recipient to Suppressions; soft bounces are counted and only suppress after a threshold of consecutive softs.transaction

Field	Type	Required	Details
`Send`	reference	yes	→ Sends
`SendRecipient`	reference	yes	→ SendRecipients
`Subscriber`	reference	yes	→ Subscribers
`BounceType`	select	yes	Soft, Hard, Block
`BounceReason`	text		ESP-provided category, e.g. mailbox-full, no-such-user
`SMTPResponseCode`	text
`BouncedAt`	date	yes
`AddedToSuppressions`	boolean		True after bounce-list-management workflow runs
`ProviderEventId`	text		Deduplicate each distinct provider event, not all events sharing a message ID.
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.
`RecordNumber`	text	yes
`Status`	select	yes	Recorded, Superseded

UnsubscribesUnsubscribe events. Source distinguishes the action — link click, preferences-page submission, list-unsubscribe header, or a manual ops add.transaction

Field	Type	Required	Details
`Send`	reference		→ Sends (null when sourced from preferences page off-send)
`Subscriber`	reference	yes	→ Subscribers
`Source`	select	yes	FooterLink, PreferencesPage, ListUnsubscribeHeader, ReplyParser, Manual
`ScopeKind`	select	yes	Global, ListSpecific
`ScopeList`	reference		→ Lists (set when ScopeKind = ListSpecific)
`UnsubscribedAt`	date	yes
`ReasonGiven`	text		Optional free-text from preferences page
`ProviderEventId`	text		Deduplicate each distinct provider event, not all events sharing a message ID.
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.
`RecordNumber`	text	yes
`Status`	select	yes	Recorded, Superseded

SpamReportsSpam / abuse complaint events fed from the ESP (FBL / ARF). Treated severely — every spam report adds the subscriber to Suppressions immediately and dings the SenderDomains.ReputationScore.transaction

Field	Type	Required	Details
`Send`	reference	yes	→ Sends
`SendRecipient`	reference	yes	→ SendRecipients
`Subscriber`	reference	yes	→ Subscribers
`ReportedAt`	date	yes
`ESPProvider`	select		SendGrid, SES, Mailgun, Other
`Mailbox`	select		Gmail, Outlook, Yahoo, AOL, ProtonMail, Other
`AddedToSuppressions`	boolean		Always true — set immediately on event ingest
`ProviderEventId`	text		Deduplicate each distinct provider event, not all events sharing a message ID.
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.
`RecordNumber`	text	yes
`Status`	select	yes	Recorded, Superseded

SuppressionsWorkspace-global delivery blocks for hard bounces, configured bounce thresholds, complaints, global unsubscribe and independently reviewed manual causes. A ListSpecific unsubscribe affects only its named membership and purpose; it never creates a global suppression. Global blocks are deduplicated by normalized email and reason, retain their cause, and require independent review for removal. Removal cannot restore separate withdrawn consent.transaction

Field	Type	Required	Details
`Email`	text	yes	Suppressed email — natural key
`Subscriber`	reference		→ Subscribers (null if suppression added before subscriber existed)
`Reason`	select	yes	HardBounce, SoftBounceThreshold, Unsubscribe, SpamReport, ManualAdd, ImportRejection
`Source`	select	yes	Bounces, Unsubscribes, SpamReports, ListImports, Manual
`AddedAt`	date	yes
`AddedBy`	reference		→ Users (null when automated)
`RemovedAt`	date
`RemovedBy`	reference		→ Users
`RemovalRationale`	text		Required when RemovedBy is set
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.
`RecordNumber`	text	yes
`Status`	select	yes	Recorded, Superseded

BlocklistChecksPeriodic checks of SenderDomains and sending IPs against major real-time blocklists (Spamhaus, SORBS, Barracuda, etc.). Run on a daily schedule; flagged listings page the Deliverability Manager.transaction

Field	Type	Required	Details
`Domain`	reference	yes	→ SenderDomains
`BlocklistName`	select	yes	Spamhaus, SORBS, Barracuda, SpamCop, Other
`Listed`	boolean	yes
`ListingDetail`	text		URL or rationale from blocklist
`CheckedAt`	date	yes
`ResolvedAt`	date
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.
`RecordNumber`	text	yes
`Status`	select	yes	Recorded, Superseded

JourneysVersioned drip campaigns with reviewed audience and exit behavior.master

Field	Type	Required	Details
`JourneyNumber`	text	yes
`Name`	text	yes
`Version`	number	yes
`Owner`	reference	yes	→ Users
`ApprovedBy`	reference		→ Users
`Status`	select	yes	Draft, Submitted, Approved, Paused, Retired
`AdmissionPolicy`	longtext	yes
`ExitPolicy`	longtext	yes
`StartTime`	datetime	yes
`EndTime`	datetime	yes
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

JourneyStepsOrdered campaign messages and delays in one journey version.line

Field	Type	Required	Details
`Journey`	reference	yes	→ Journeys
`Sequence`	number	yes
`Campaign`	reference	yes	→ Campaigns
`DelayHours`	number	yes
`ExitOnReply`	boolean	yes
`ExitOnConversion`	boolean	yes
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

JourneyEnrollmentsPer-subscriber progress through a fixed journey version.transaction

Field	Type	Required	Details
`EnrollmentNumber`	text	yes
`Journey`	reference	yes	→ Journeys
`Subscriber`	reference	yes	→ Subscribers
`NextStep`	reference		→ JourneySteps
`AdmissionKey`	text	yes	Unique journey version/subscriber/admission occurrence.
`Status`	select	yes	Pending, Active, Paused, Completed, Exited
`EnrolledAt`	datetime	yes
`NextDueAt`	datetime
`ExitedAt`	datetime
`ExitReason`	text
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

ConsentEventsScoped acquisition and preference evidence for subscriber contact policy.transaction

Field	Type	Required	Details
`ConsentNumber`	text	yes
`Subscriber`	reference	yes	→ Subscribers
`Purpose`	text	yes
`Decision`	select	yes	Permitted, Restricted, Withdrawn
`List`	reference		→ Lists
`OccurredAt`	datetime	yes
`Evidence`	attachment
`Status`	select	yes	Recorded, Superseded
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

SuppressionReviewsIndependent review of an exceptional suppression removal request.transaction

Field	Type	Required	Details
`RequestNumber`	text	yes
`Suppression`	reference	yes	→ Suppressions
`RequestedBy`	reference	yes	→ Users
`DecisionBy`	reference		→ Users
`Reason`	longtext	yes
`ReplacementPolicyEvidence`	attachment
`Status`	select	yes	Draft, Submitted, Approved, Rejected
`SubmittedAt`	datetime	yes
`DecisionAt`	datetime
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

AuditEventsAppend-only evidence of commands and independent decisions.transaction

Field	Type	Required	Details
`EventNumber`	text	yes
`CommandKey`	text	yes	Unique workspace/action replay key.
`RecordType`	text	yes
`RecordId`	text	yes
`Action`	text	yes
`Actor`	reference	yes	→ Users
`OccurredAt`	datetime	yes
`BeforeState`	longtext	yes
`AfterState`	longtext	yes
`Status`	select	yes	Recorded, Superseded
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

IntegrationConnectionsExplicitly configured connector boundaries and credential references.master

Field	Type	Required	Details
`ConnectionNumber`	text	yes
`Name`	text	yes
`Provider`	text	yes
`SecretReference`	text	yes
`Status`	select	yes	Disabled, Configured, Paused
`Owner`	reference	yes	→ Users
`LastCheckedAt`	datetime
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

IntegrationEventsIdempotent external delivery and reconciliation evidence.transaction

Field	Type	Required	Details
`EventNumber`	text	yes
`Connection`	reference	yes	→ IntegrationConnections
`ProviderEventId`	text	yes	Unique per connection when supplied.
`CommandKey`	text	yes
`RecordType`	text	yes
`RecordId`	text	yes
`ExternalReference`	text
`Status`	select	yes	Pending, Accepted, Confirmed, Failed, Unknown
`OccurredAt`	datetime	yes
`FailureReason`	longtext
`WorkspaceKey`	text	yes	Server-enforced workspace scope.
`Revision`	number	yes	Compare-and-swap version; never client incremented.
`CreatedAt`	datetime	yes	Server creation timestamp.

ERP•AI workspace

Start now CRM with Email Campaigns

Create your ERP.AI account and get started with Proto.

Start now Download agent

Previous · reference 2 of 6Reports and analytics Next · reference 4 of 6Integrations

CRM with Email Campaigns

Modules

CRM with Email Campaigns

Processes

CRM with Email Campaigns

Industries

CRM with Email Campaigns

Reference

CRM with Email Campaigns

Data model

How the model is organised

Audiences and CRM contacts

Templates and content

Campaign planning

Drip journeys

Experiments and engagement

Delivery and preferences

Keys and references

Migration order

Tables

Start now CRM with Email Campaigns

CRM with Email Campaigns

Modules

CRM with Email Campaigns

Processes

CRM with Email Campaigns

Industries

CRM with Email Campaigns

Reference

Data model

How the model is organised

Audiences and CRM contacts

Templates and content

Campaign planning

Drip journeys

Experiments and engagement

Delivery and preferences

Keys and references

Migration order

Tables

Start now CRM with Email Campaigns

Your Privacy, Your Choice

Manage Your Cookie Preferences