Skip to content
TheChatArchiveThe Chat Archive
Grok 4.1 Fast· xaiHugging Face Frontier Reasoning Traces

Create a KPI glossary with lineage and contracts.

  1. User

    Create a KPI glossary with lineage and contracts.

  2. 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 NameDefinitionLineageContract
    Total RevenueGross 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 RatePercentage 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_acquisition mart.- 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 RatePercentage 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_retention model (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 TurnoverNumber 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 RatePercentage 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!

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.