ZenotiHelp

Campaign Summary Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Stores summary-level metrics for marketing campaign sends, including delivery, open, and click statistics.

Columns

Column Name Data Type Nullable Description
factcampaignwid BIGINT IDENTITY NOT NULL Surrogate key and primary key for the campaign summary record.
factcampaignid VARCHAR(36) YES GUID identifier for the campaign fact record.
centerwid BIGINT YES Foreign key to the center dimension (Bi_DimCenter.centerwid).
campaignwid BIGINT YES Foreign key to the campaign dimension.
campaignstartdate TIMESTAMP YES Start date/time of the campaign.
campaignenddate TIMESTAMP YES End date/time of the campaign.
campaignsendid VARCHAR(36) YES GUID of the specific campaign send event.
campaignsendtype VARCHAR(10) YES Type of campaign send (e.g., SMS, Email).
campaignsendstatus VARCHAR(50) YES Status of the campaign send.
campaignsenddate TIMESTAMP YES Date/time the campaign was sent.
campaignsentby VARCHAR(256) YES Name or identifier of the user who sent the campaign.
numguests BIGINT YES Total number of guests targeted by the campaign.
processed BIGINT YES Number of campaign messages processed.
sentto BIGINT YES Number of campaign messages sent.
mmsfailed BIGINT YES Number of MMS messages that failed to send.
queued BIGINT YES Number of campaign messages queued for delivery.
delivered BIGINT YES Number of campaign messages successfully delivered.
undelivered BIGINT YES Number of campaign messages that were undelivered.
dnd BIGINT YES Number of recipients on Do Not Disturb list.
opened BIGINT YES Number of campaign messages opened by recipients.
clicked BIGINT YES Number of campaign messages where recipients clicked a link.
podid INTEGER YES Identifier for the pod (database partition).
void BOOLEAN YES Soft-delete flag indicating the record is logically deleted.

Note: All fact tables also include standard ETL metadata columns (podname, organizationid, groupid, etlCreatedDate) which are omitted from this reference for brevity.

Primary Key

factcampaignwid

Foreign Keys

Column References
centerwid Bi_DimCenter.centerwid

Enumerator Values

Column Values
campaignsendtype SMS
Email
campaignsendstatus Sent
Scheduled
Failed
Draft
InProgress
void TRUE if the record is soft-deleted; FALSE otherwise.
Was this article helpful?
Your feedback helps us improve our documentation.