ZenotiHelp

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 name references DimCenter
  • groupid references 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.