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