Q: if i wanted to set up a conversion metric for checkout → book using fact tables, do i need both events to be in the same fact table? not seeing a good way of doing a % conversion metric with separate fact tables (e.g., checkout_fact_table, booking_fact_table)

You can pick a denominator from a different fact table when using a Ratio metric. Would that work?

i tried that but a couple of things: 1. the format is a decimal instead of a percent. not a dealbreaker but more of a UI preference thing 2. it's numerator / denominator instead of being tied to a user stream. for a metrics like "checkout for segment A of inventory → book any type of inventory" it doesn't work. when the denominator isn't a mandatory funnel step then the ratio can be more than 100%