Campaign Fact Consolidated
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Consolidated fact table storing campaign execution metrics including guest counts, delivery statuses, and engagement statistics per center.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| organization name | VARCHAR(512) | YES | Name of the organization. Sourced from DimOrganization.organization name. |
| organization account name | VARCHAR(256) | YES | Account name of the organization. Sourced from DimOrganization.organization account name. |
| center name | VARCHAR(128) | YES | Name of the center. Sourced from DimCenter.center name. |
| center company name | VARCHAR(200) | YES | Company name associated with the center. Sourced from DimCenter.center company name. |
| is center franchise | BOOLEAN | YES | Indicates whether the center is a franchise. Sourced from DimCenter.is center franchise. |
| center cst number | VARCHAR(80) | YES | CST tax registration number for the center. Sourced from DimCenter.center cst number. |
| center tin number | VARCHAR(80) | YES | TIN tax registration number for the center. Sourced from DimCenter.center tin number. |
| center tot number | VARCHAR(80) | YES | TOT tax registration number for the center. Sourced from DimCenter.center tot number. |
| center service tax number | VARCHAR(80) | YES | Service tax registration number for the center. Sourced from DimCenter.center service tax number. |
| center vat number | VARCHAR(80) | YES | VAT registration number for the center. Sourced from DimCenter.center vat number. |
| center luxary tax number | VARCHAR(80) | YES | Luxury tax registration number for the center. Sourced from DimCenter.center luxary tax number. |
| campaign name | VARCHAR(512) | YES | Name of the campaign. |
| campaign description | VARCHAR(4096) | YES | Description of the campaign. |
| campaign type | INTEGER | YES | Numeric code representing the type of campaign. |
| campaign start date | TIMESTAMP WITHOUT TIME ZONE | YES | Start date and time of the campaign. |
| campaign end date | TIMESTAMP WITHOUT TIME ZONE | YES | End date and time of the campaign. |
| campaign launch date | TIMESTAMP WITHOUT TIME ZONE | YES | Date the campaign was launched. |
| campaign validity days | INTEGER | YES | Number of days the campaign remains valid. |
| campaign expiry date | TIMESTAMP WITHOUT TIME ZONE | YES | Date when the campaign expires. |
| campaign send status | VARCHAR(50) | YES | Current send status of the campaign. |
| campaign sent by | VARCHAR(256) | YES | Name of the person who sent the campaign. |
| # of guests | INTEGER | YES | Total number of guests targeted by the campaign. |
| # of processed | INTEGER | YES | Number of campaign messages processed. |
| # of sent to | INTEGER | YES | Number of campaign messages sent. |
| # of mms failed | INTEGER | YES | Number of MMS messages that failed to deliver. |
| # of queued | INTEGER | YES | Number of campaign messages queued for sending. |
| # of delivered | INTEGER | YES | Number of campaign messages successfully delivered. |
| # of undelivered | INTEGER | YES | Number of campaign messages that were not delivered. |
| # of dnd | INTEGER | YES | Number of recipients on Do Not Disturb lists. |
| # of opened | INTEGER | YES | Number of campaign messages opened by recipients. |
| # of clicked | INTEGER | YES | Number of campaign messages that had link clicks. |
| minutes to add | INTEGER | YES | Minute offset to convert UTC to center local time. |
| campaign send date | TIMESTAMP WITHOUT TIME ZONE | YES | Date and time the campaign was sent. |
| Center Code | VARCHAR(40) | YES | Code assigned to the center. Sourced from DimCenter.Center Code. |
Primary Key
No explicit primary key is defined. Rows are uniquely identified by the combination of center name, campaign name, and campaign start date.
Foreign Keys
center namereferences DimCentergroupidreferences the tenant/data group
Enumerator Values
| Column Name | Known Values |
|---|---|
| campaign type | INTEGER |
| campaign send status | VARCHAR(50) |
Standard ETL metadata columns (EtlLastUpdatedOn, EtlLastUpdatedBy, podname, groupid) are present in the underlying table but omitted from this reference for brevity.
Was this article helpful?
Your feedback helps us improve our documentation.