I ask this as we often have a very similar metric with varying conversion windows. For example: • Proportion of Active Users within 2 Days of Registration • Proportion of Active Users within 5 Days of Registration etc. This is obviously exactly the same underlying SQL and it would be nice to only have to maintain one version of this SQL and be able to express what the conversion window is when the Metric is used rather than when it is defined.

I also like the idea of a “fact table” approach where multiple metrics can share the same SQL query.

Another idea here. It’d be cool to be able to perform custom Windorizing at the Fact Table column level. For example, for order values we often want to cap at the 95th percentile to avoid taking into account very unusual orders but for other columns we might want to cap the bottom and top ends only at the 99th percentile.