Data & Analytics Glossary

A

Ad Hoc Analysis

A type of data analysis performed on the fly to answer a specific business question, rather than relying on pre-built reports. Ad hoc analysis empowers business users to explore data independently without waiting for a data team to build a custom report.

API (Application Programming Interface)

A set of protocols that allows different software systems to communicate and exchange data. In analytics, APIs are used to pull data from platforms like Google Ads, Shopify, or Zenoti into a central data warehouse.

AskCorral

CorralData's conversational AI assistant that lets business users ask questions about their data in plain English and receive instant answers, visualizations, and recommendations — no SQL or technical skills required.

Attribution Modeling

A framework for assigning credit to marketing touchpoints along the customer journey. Attribution models help businesses understand which channels, campaigns, and content drive conversions and revenue.

Automated Reporting

The process of using software to generate, format, and distribute business reports on a recurring schedule without manual intervention. Automated reporting eliminates hours of repetitive work and ensures stakeholders receive timely, consistent data.

B

BAA (Business Associate Agreement)

A legally binding contract required under HIPAA between a covered entity (like a healthcare provider) and a business associate (like a data platform) that handles protected health information (PHI). CorralData signs BAAs with all healthcare customers. Learn about CorralData security.

Blended ROAS

A metric that measures total revenue generated divided by total marketing spend across all channels. Unlike channel-specific ROAS, blended ROAS gives a holistic view of overall marketing efficiency.

Business Intelligence (BI)

The technologies, practices, and strategies used to collect, integrate, analyze, and present business data. BI tools help organizations make informed decisions by transforming raw data into meaningful insights through dashboards, reports, and visualizations.

C

Cloud Data Warehouse

A managed, cloud-hosted database optimized for analytical queries and reporting. Unlike traditional databases designed for transactions, cloud data warehouses are built to process large volumes of data quickly for business intelligence and analytics.

Cohort Analysis

A method of analyzing user behavior by grouping customers into cohorts based on shared characteristics or time-based events (e.g., signup month, first purchase date). Cohort analysis helps identify trends in retention, revenue, and engagement over time.

Conversational Analytics

An approach to data analysis that allows users to interact with data through natural language questions and answers, similar to chatting with a knowledgeable colleague. Instead of writing SQL queries or building reports, users simply ask questions in plain English.

Customer Acquisition Cost (CAC)

The total cost of acquiring a new customer, calculated by dividing total sales and marketing expenses by the number of new customers acquired in a given period. CAC is a critical metric for evaluating marketing efficiency and business sustainability.

Customer Lifetime Value (CLV/LTV)

A prediction of the total revenue a business can expect from a single customer over the entire duration of their relationship. CLV helps businesses understand how much to invest in acquiring and retaining customers.

D

Dashboard

A visual interface that displays key business metrics and data points in real time. Dashboards consolidate data from multiple sources into a single view, making it easy for stakeholders to monitor performance and identify trends at a glance.

Data Connector

A pre-built integration that pulls data from a specific source (like Shopify, Google Ads, or Zenoti) into a data platform or warehouse. Data connectors automate data ingestion, eliminating manual exports and ensuring data stays fresh.

Data Integration

The process of combining data from multiple sources into a unified view. Data integration involves extracting data from different systems, transforming it into a consistent format, and loading it into a central repository for analysis.

Data Pipeline

An automated sequence of steps that moves data from source systems through transformation processes into a destination like a data warehouse. Data pipelines ensure data flows reliably and consistently without manual intervention.

Data Warehouse

A centralized repository that stores structured data from multiple sources, optimized for analytical queries and reporting. Data warehouses enable organizations to run complex queries across all their business data without impacting operational systems.

E

ELT (Extract, Load, Transform)

A modern data integration approach where raw data is extracted from sources and loaded directly into a data warehouse before being transformed. ELT takes advantage of the processing power of cloud data warehouses to handle transformations.

EMR (Electronic Medical Record)

A digital version of a patient's medical chart used by healthcare providers to store clinical data. EMR systems like Zenoti, NexTech, and ModMed are critical data sources for healthcare analytics.

ETL (Extract, Transform, Load)

A traditional data integration process that extracts data from source systems, transforms it into a usable format, and loads it into a destination system like a data warehouse. ETL is fundamental to building a reliable analytics infrastructure.

H

HIPAA (Health Insurance Portability and Accountability Act)

A US federal law that establishes standards for protecting sensitive patient health information. Any organization handling protected health information (PHI) must ensure HIPAA-compliant security controls including encryption, access controls, and audit logging. Learn about CorralData's HIPAA compliance.

K

KPI (Key Performance Indicator)

A measurable value that demonstrates how effectively an organization is achieving its key business objectives. KPIs vary by industry and department — examples include revenue growth rate, patient retention rate, and customer acquisition cost.

L

Looker

A business intelligence platform owned by Google that uses a proprietary modeling language called LookML. Looker requires significant technical expertise to set up and maintain, making it better suited for organizations with dedicated data teams.

LTV:CAC Ratio

A metric that compares Customer Lifetime Value to Customer Acquisition Cost. The LTV:CAC ratio indicates the return on investment for acquiring customers — a ratio of 3:1 or higher is generally considered healthy for sustainable growth.

M

Marketing Mix Modeling (MMM)

A statistical analysis technique that measures the impact of various marketing tactics on sales and other business outcomes. MMM helps allocate marketing budgets by quantifying the ROI of each channel in the marketing mix.

MedSpa Analytics

Specialized data analysis for medical spas and aesthetic practices, covering metrics like treatment profitability, provider performance, patient retention, and marketing ROI across systems like Zenoti, NexTech, and ModMed. Learn about MedSpa reporting.

N

Natural Language Processing (NLP)

A branch of artificial intelligence that enables computers to understand, interpret, and respond to human language. In analytics, NLP powers conversational interfaces that let users ask data questions in plain English instead of writing SQL.

No-Code Analytics

Analytics platforms and tools that allow business users to build reports, dashboards, and data analyses without writing code. No-code analytics democratizes data access by removing technical barriers to insight.

O

OAuth

An open standard authorization protocol that allows third-party services to access user data without exposing passwords. OAuth is the secure authentication method used by most modern data connectors to link platforms like Google Ads, Shopify, and HubSpot.

Operational Analytics

The practice of using data analysis to monitor and improve day-to-day business operations in real time. Operational analytics focuses on actionable metrics that drive immediate decisions, like staffing levels, inventory, and appointment scheduling.

P

Patient Acquisition Cost

The total marketing and operational cost of acquiring a new patient, calculated by dividing total acquisition spend by the number of new patients in a given period. This is a critical metric for MedSpas and healthcare practices evaluating marketing ROI.

PHI (Protected Health Information)

Any individually identifiable health information held or transmitted by a covered entity or business associate. PHI includes names, dates, medical records, and billing information — all of which require HIPAA-compliant handling.

Predictive Analytics

The use of statistical algorithms, machine learning, and historical data to forecast future outcomes. Predictive analytics helps businesses anticipate trends like customer churn, demand fluctuations, and revenue projections.

Provider Performance Metrics

Key measurements used to evaluate individual service providers (doctors, aestheticians, therapists) based on revenue generated, patient satisfaction, retention rates, rebooking rates, and average treatment value.

R

RBAC (Role-Based Access Control)

A security approach that restricts data and system access based on a user's role within an organization. RBAC ensures that team members only see the data relevant to their responsibilities — essential for compliance and data governance. Learn about CorralData security.

Reverse ETL

The process of syncing transformed data from a data warehouse back into operational tools like CRMs, email platforms, and ad networks. Reverse ETL activates analytical insights by pushing segments, scores, and metrics into the systems where teams work. Learn about CorralData's Reverse ETL.

ROAS (Return on Ad Spend)

A marketing metric that measures revenue generated for every dollar spent on advertising. ROAS is calculated by dividing revenue attributed to ads by the cost of those ads. A ROAS of 4:1 means $4 in revenue for every $1 spent.

S

Schema on Read

A data architecture approach where raw data is stored as-is and structure is applied only when the data is queried. This contrasts with schema on write, where data must be structured before storage. Schema on read offers flexibility for exploratory analytics.

Self-Service Analytics

An approach to business intelligence that empowers non-technical users to access, analyze, and visualize data independently without relying on IT or data teams. Self-service analytics tools prioritize ease of use and guided exploration.

Single Source of Truth (SSOT)

A centralized data repository where all business data from various sources is unified, deduplicated, and standardized. An SSOT ensures everyone in the organization is making decisions based on the same consistent, accurate data.

SOC 2 Compliance

A security framework developed by the American Institute of CPAs (AICPA) that verifies a service provider securely manages data to protect the interests and privacy of its clients. SOC 2 audits evaluate controls related to security, availability, processing integrity, confidentiality, and privacy. Learn about CorralData's SOC 2 compliance.

SQL (Structured Query Language)

A programming language used to manage and query relational databases. While SQL is powerful for data analysis, it creates a bottleneck when only technical team members can write queries — conversational analytics tools like AskCorral eliminate this barrier.

Star Schema

A data modeling pattern used in data warehouses that organizes data into fact tables (containing measurements) surrounded by dimension tables (containing descriptive attributes). Star schemas optimize query performance for analytical workloads.

T

Tableau

A widely-used business intelligence platform known for its data visualization capabilities. While powerful, Tableau typically requires technical expertise for data preparation and modeling, and does not include built-in data integration or warehousing.

Treatment Profitability

A healthcare analytics metric that calculates the net profit margin for specific medical treatments or services by factoring in revenue, supply costs, labor time, and overhead. Treatment profitability analysis helps practices optimize their service mix.

Z

Zenoti

A cloud-based practice management and EMR platform designed for MedSpas, salons, and wellness businesses. Zenoti manages appointments, billing, inventory, and patient records — making it a critical data source for MedSpa analytics and reporting.