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 |
| 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.