Looker • B2B SaaS

Looker to MetricFlow Template for B2B SaaS

Map ARR dashboards into MetricFlow semantics and catch fan-out joins before finance does.

Spin up SaaS coverage Learn MetricFlow YAML basics

Recommended metrics

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

ARR growth
Logo churn
Expansion vs contraction
Pipeline to revenue leak

MetricFlow YAML starter

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

semantic_models:
  - name: saas_subscriptions
    model: ref('fct_subscriptions')
    defaults:
      agg_time_dimension: effective_date
    dimensions:
      - name: effective_date
        type: time
        type_params:
          time_granularity: month
      - name: segment
        type: categorical
    measures:
      - name: arr
        agg: sum
        expr: arr_amount
      - name: churned_arr
        agg: sum
        expr: churned_arr
      - name: expansion_arr
        agg: sum
        expr: expansion_arr
    entities:
      - name: account
        type: primary