Tableau • Ecommerce

Tableau Semantic Layer Template for Ecommerce

Turn webshop dashboards into MetricFlow YAML with baked-in revenue, orders, and retention measures.

Launch the ecommerce template Learn MetricFlow YAML basics

Recommended metrics

Start with foundations, then extend the YAML with your warehouse-specific dimensions.

Revenue by channel
Repeat purchase rate
Average order value
Fulfillment SLA adherence

MetricFlow YAML starter

Paste this into your repo, then extend entities, dimensions, and measures to match your grain.

semantic_models:
  - name: ecommerce_orders
    model: ref('stg_orders')
    defaults:
      agg_time_dimension: order_date
    dimensions:
      - name: order_date
        type: time
        type_params:
          time_granularity: day
      - name: channel
        type: categorical
    measures:
      - name: total_revenue
        agg: sum
        expr: revenue
      - name: order_count
        agg: count_distinct
        expr: order_id
      - name: repeat_orders
        agg: sum
        expr: is_repeat