ZenotiHelp

Adoption Fact Consolidated

ZTZenoti Docs Team Updated June 29, 2026 7 min readGuide

Consolidated fact table capturing daily feature adoption metrics per center, tracking usage of services, products, campaigns, integrations, and operational flags.

Columns

Column Name Data Type Nullable Description
run date TIMESTAMP WITHOUT TIME ZONE YES Date the adoption metrics were captured.
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(128) YES Company name associated with the center. Sourced from DimCenter.center company name.
product sales BIGINT YES Count of product sales transactions.
membership sales BIGINT YES Count of membership sales transactions.
package sales BIGINT YES Count of package sales transactions.
gift card sales BIGINT YES Count of gift card sales transactions.
recurring membership sales BIGINT YES Count of recurring membership sales.
price adjustment flag BOOLEAN YES Indicates whether price adjustment is enabled.
price increase flag BOOLEAN YES Indicates whether price increase is enabled.
invoice lock flag BOOLEAN YES Indicates whether invoice locking is enabled.
discount adjustment flag BOOLEAN YES Indicates whether discount adjustments are enabled.
authentication need for discount flag BOOLEAN YES Indicates whether authentication is required for applying discounts.
restrict txns if register not closed flag BOOLEAN YES Indicates whether transactions are restricted if the register is not closed.
otp flag BOOLEAN YES Indicates whether OTP verification is enabled.
# of packages associated BIGINT YES Number of packages associated with the center.
# of memberships associated BIGINT YES Number of memberships associated with the center.
biometric flag BOOLEAN YES Indicates whether biometric verification is enabled.
# of services associated BIGINT YES Number of services associated with the center.
# of services booked BIGINT YES Total number of services booked.
# of servicesbooked_webstore BIGINT YES Number of services booked via the webstore.
# of servicesbooked_cma BIGINT YES Number of services booked via the CMA (Customer Mobile App) (client mobile app).
# of nonservices_sold BIGINT YES Number of non-service items sold.
# of nonservices_webstore BIGINT YES Number of non-service items sold via the webstore.
# of nonservices_cma BIGINT YES Number of non-service items sold via the CMA.
# of transactional sms_apptcreate BIGINT YES Count of transactional SMS sent for appointment creation.
# of transactional sms_apptrem BIGINT YES Count of transactional SMS sent as appointment reminders.
# of transactional sms_thankyou BIGINT YES Count of transactional SMS sent as thank-you messages.
# of transactional sms_others BIGINT YES Count of other transactional SMS sent.
# of transactional email_apptcreate BIGINT YES Count of transactional emails sent for appointment creation.
# of transactional email_apptrem BIGINT YES Count of transactional emails sent as appointment reminders.
# of transactional email_thankyou BIGINT YES Count of transactional emails sent as thank-you messages.
# of transactional email_others BIGINT YES Count of other transactional emails sent.
# of campaigns BIGINT YES Total number of campaigns.
# of campaigns alwayson active BIGINT YES Number of always-on campaigns that are active.
app confirmation tempenabled_sms flag BIGINT YES Flag indicating if appointment confirmation SMS template is enabled (1=enabled).
appreminder temp enabled_sms flag BIGINT YES Flag indicating if appointment reminder SMS template is enabled.
membership balance temp enabled_sms flag BIGINT YES Flag indicating if membership balance SMS template is enabled.
thankyou temp enabled_sms flag BIGINT YES Flag indicating if thank-you SMS template is enabled.
paymentmade temp enabled_sms flag BIGINT YES Flag indicating if payment-made SMS template is enabled.
appconfirmation temp enabled_email flag BIGINT YES Flag indicating if appointment confirmation email template is enabled.
appreminder temp enabled_email flag BIGINT YES Flag indicating if appointment reminder email template is enabled.
membership balance tempenabled_email flag BIGINT YES Flag indicating if membership balance email template is enabled.
thank you temp enabled_email flag BIGINT YES Flag indicating if thank-you email template is enabled.
payment made temp enabled_email flag BIGINT YES Flag indicating if payment-made email template is enabled.
retail pos delivered BIGINT YES Count of retail POS (Point of Sale) items delivered.
consumable pos delivered BIGINT YES Count of consumable POS items delivered.
# of email receipts BIGINT YES Number of email receipts sent.
email packageexpiry flag BOOLEAN YES Indicates whether package expiry email notification is enabled.
email membership expiry flag BOOLEAN YES Indicates whether membership expiry email notification is enabled.
# of daily reports to owneremp_email BIGINT YES Number of daily report emails sent to owner/employees.
# of servicesbom defined BIGINT YES Number of services with bill of materials defined.
retail reconcilations submitted BIGINT YES Count of retail inventory reconciliations submitted.
consummable reconcilations submitted BIGINT YES Count of consumable inventory reconciliations submitted.
facebook integration flag BIGINT YES Flag indicating whether Facebook integration is enabled (1=enabled).
twitter integration flag BIGINT YES Flag indicating whether Twitter integration is enabled.
social posts flag BIGINT YES Flag indicating whether social media posting is enabled.
payments enabled Webstore BIGINT YES Flag indicating whether Webstore payments are enabled.
invoices deleted in a day BIGINT YES Number of invoices deleted in a day.
product consqty_negative BIGINT YES Count of consumable products with negative quantity.
product retailqty_negative BIGINT YES Count of retail products with negative quantity.
product order level alert BIGINT YES Count of products at or below order-level alert threshold.
appointments missing product consumption BIGINT YES Count of appointments missing product consumption records.
tally enabled at org BOOLEAN YES Indicates whether Tally integration is enabled at the organization level.
tally enabled at center BIGINT YES Flag indicating whether Tally integration is enabled at the center level.
enable navision at org BOOLEAN YES Indicates whether Navision integration is enabled at the organization level.
quick books enabled flag BIGINT YES Flag indicating whether QuickBooks integration is enabled.
quick books enable dat VARCHAR(4000) YES Date/details of QuickBooks enablement.
xerosenabled flag BIGINT YES Flag indicating whether Xero integration is enabled.
xeroenabled at VARCHAR(4000) YES Date/details of Xero enablement.
guest categories enabled BIGINT YES Flag indicating whether guest categories are enabled.
lp program enabled BIGINT YES Flag indicating whether the loyalty program is enabled.
# offeedbacks_created BIGINT YES Number of feedback entries created.
# of issues created BIGINT YES Number of issues created.
# of payrolls run BIGINT YES Number of payroll runs executed.
# of pos_retail products BIGINT YES Number of retail POS products defined.
# of opportunities_created BIGINT YES Number of sales opportunities created.
# of opportunities_updated BIGINT YES Number of sales opportunities updated.
# of pos_consumable products BIGINT YES Number of consumable POS products defined.
# of employees scheduled BIGINT YES Number of employees scheduled.
# of check in checkouts BIGINT YES Number of employee check-in/check-out events.
# petty cash transactions BIGINT YES Number of petty cash transactions.
# of zenoti payments BIGINT YES Number of Zenoti payment transactions.
# of email campaigns BIGINT YES Number of email campaigns executed.
invoice total BIGINT YES Total number of invoices.
# of forms filled BIGINT YES Number of forms filled by guests.
# of performance targets BIGINT YES Number of performance targets defined.
# of audit_consummable BIGINT YES Number of consumable inventory audits.
# of audit_retail BIGINT YES Number of retail inventory audits.
# of appts closed one hour after booking time BIGINT YES Number of appointments closed within one hour after booking time.
# of appts closed one hour after bookingtime_campapied BIGINT YES Number of appointments closed within one hour after booking time with campaign applied.
# of transactional sms BIGINT YES Total count of transactional SMS sent.
# of transactional email BIGINT YES Total count of transactional emails sent.
# of sms campaign BIGINT YES Number of SMS campaigns executed.
# of future appts BIGINT YES Number of future appointments booked.
# of reg closures BIGINT YES Number of register closures.
# of target segments BIGINT YES Number of target segments defined.
is center franchise BOOLEAN YES Indicates whether the center is a franchise. Sourced from DimCenter.is center franchise.
center cstn number VARCHAR(80) YES CST tax registration number for the center. Sourced from DimCenter.center cstn 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.
minutes to add INTEGER YES Minute offset to convert UTC to center local time.
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 and run date.

Foreign Keys

  • center name references DimCenter
  • groupid references the tenant/data group

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.