.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Strong indicator of customer loyalty and retention.
Formula
(Number of Returning Customers ÷ Total Unique Customers) × 100
Insights and Actions
- Loyalty Tracking — Indicates brand stickiness and satisfaction.
- Revenue Stability — Repeat customers often contribute to consistent income.
- Retention Strategy — Evaluate loyalty programs and engagement tactics.
- Customer Segmentation — Identify repeat vs. one-time buyers.
- Growth Forecasting — High returning rate supports sustainable growth.
Detailed Breakdown
- Number Of Returning Customers
- Total Unique Customers
- 100
Suggested Dimensions
RegionCampaignCustomer TypeChannel
Related Metrics
Example Use
Prompt
What’s our returning customer rate this quarter?
Response
Returning Customer Rate — 29.4%
Query
SELECT ROUND(COUNT(DISTINCT CASE WHEN user_type = 'returning_customer' THEN customer_email END) * 100.0 / NULLIF(COUNT(DISTINCT customer_email),0),4) AS returning_customer_rate FROM orders WHERE orders_date BETWEEN :start AND :end;