Grok 4.1 Fast· xai
Frontier Reasoning Traces
Create a KPI glossary with lineage and contracts.
- User
Create a KPI glossary with lineage and contracts.
- Assistant
KPI Glossary for E-Commerce Business
This KPI glossary provides a structured reference for key performance indicators (KPIs) used in an e-commerce platform. Each entry includes:
- Definition: Clear business meaning.
- Lineage: Data sources, transformations, and calculation logic (assuming a modern data stack with sources like Snowflake, dbt for transformations, and tools like Monte Carlo for monitoring).
- Contract: Formal agreement on data quality, schema, freshness, SLAs, and ownership (inspired by data contract standards like those from dbt or Great Expectations).
The glossary is presented in a table for easy reference. This is a sample for 8 core KPIs; it can be extended.
KPI Name Definition Lineage Contract Total Revenue Gross revenue from all completed orders in a given period (excludes refunds). SUM(order_total) FROM orders WHERE status = 'completed' AND order_date BETWEEN start_date AND end_dateSources:raw_orders(Stripe API) →stg_orders(dbt) →mart_orders(dbt agg). Upstream: Payments lineage from Stripe.- Type: Decimal(15,2)- Freshness: Daily (T+1)- SLA: 99.9% uptime, <1% nulls- Owner: Finance Team- Consumers: Executive Dashboard Conversion Rate Percentage of website sessions that result in a purchase. (SUM(orders) / COUNT_DISTINCT(sessions)) * 100 FROM sessions JOIN orders ON session_idSources:raw_sessions(Google Analytics) →stg_sessions(dbt) →funnel_metrics(dbt).- Type: Float (0-100)- Freshness: Hourly- SLA: 99.5% completeness, volume >1k sessions/day- Owner: Product Team- Consumers: Marketing Customer Acquisition Cost (CAC) Total marketing spend divided by new customers acquired in the period. marketing_spend / COUNT(new_customers) FROM campaigns JOIN customers WHERE first_order_date BETWEEN datesSources:raw_ads(Google Ads/FB) →stg_marketing→customer_acquisitionmart.- Type: Decimal(10,2)- Freshness: Daily- SLA: <5% variance from source, no negative values- Owner: Marketing- Consumers: CFO Dashboard Average Order Value (AOV) Average monetary value of orders placed. AVG(order_total) FROM orders WHERE status = 'completed'Sources: Same as Total Revenue.- Type: Decimal(10,2)- Freshness: Real-time (via streaming)- SLA: 99.99% accuracy, >$0 min- Owner: Ops Team- Consumers: Inventory Planning Churn Rate Percentage of customers who made no purchase in the last 30 days after prior activity. (COUNT(inactive_customers) / COUNT(active_customers_30d_ago)) * 100Sources:customer_events(Amplitude) →customer_retentionmodel (dbt).- Type: Float (0-100)- Freshness: Daily- SLA: Row count match upstream ±1%, freshness <24h- Owner: Customer Success- Consumers: Retention Reports Net Promoter Score (NPS) Average score from customer surveys (promoters - detractors). AVG(score) - (detractors_pct) FROM surveys WHERE response_date BETWEEN datesSources:raw_surveys(Typeform) →nps_metrics(dbt).- Type: Integer (-100 to 100)- Freshness: Weekly- SLA: Response volume >100/week, <2% invalid scores- Owner: CX Team- Consumers: Board Metrics Inventory Turnover Number of times inventory is sold and replaced over a period. COGS / AVG(inventory_value) FROM sales JOIN inventory_snapshotsSources:raw_inventory(ERP) →inventory_turnover(dbt).- Type: Float (>0)- Freshness: Monthly- SLA: 100% reconciliation with GL, no div-by-zero- Owner: Supply Chain- Consumers: Procurement Cart Abandonment Rate Percentage of shopping carts not completed as purchases. ((COUNT(carts) - COUNT(purchases)) / COUNT(carts)) * 100 FROM cart_eventsSources:raw_carts(web events) →funnel_dropoff(dbt).- Type: Float (0-100)- Freshness: Hourly- SLA: Event volume >10k/day, <1% duplicates- Owner: Product- Consumers: UX Optimization Usage Notes
- Lineage Tracking: Use tools like OpenLineage or dbt's metadata for full visualization (e.g., DAGs showing upstream dependencies).
- Contract Enforcement: Implement via dbt tests, Great Expectations, or Soda for automated validation. Contracts are versioned (v1.0 here).
- Extensibility: Add columns for tags (e.g., "finance", "growth") or thresholds (e.g., alert if CAC > $50).
- Governance: Reviewed quarterly by Data Governance Council.
If you need this for a specific industry, more KPIs, or export formats (CSV, YAML), let me know!
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.