I'm trying to work out the best way of structuring...
# ask-questions
d
I'm trying to work out the best way of structuring my fact tables to work with the new product analytics dashboards. I generally tend to be interested in proportion metrics - e.g. conversion rates. Up until now I've had fact tables where one row represents each conversion event. When used in an experiment the metric value is then expressed as a % of the experiment audience, which is great. Is there a way I can reuse this metric to create a conversion rate in a product analytics dashboard? I can't work out how to do it as there doesn't seem to be a way to express what the total audience is. For example, I don't think I can specify the metric to show as a proportion of all site visitors - or other fact table values. So is there a way I can monitor an overall site conversion, without changing my existing fact table?
s
If you already have a conversion metric defined, you should be able to use that metric directly in the product analytics dashboard. Does that work for you?
d
@strong-mouse-55694 I've got to be honest - not working for me at the moment :D As an example - at the moment suppose I have a metric 'Purchase conversion rate' which is a 'proportion' metric in a fact table containing all my purchase events. This works fine as a conversion rate for experiments - where it'll show the % of units in the experiment that made a purchase. But if I add 'Purchase conversion rate' metric to a Product Analytics block, it'll always be at 100% - as all users in that fact table are making a purchase. What I'd like to be able to do is contextualise proportion metrics with an audience in the product analytics block configuration. E.g. 'Show metric as % of audience in fact table' <Select another fact table>. That way I could see the conversion rate as a % of all users visiting pages, or all users entering a funnel etc.
s
Sorry I didn't respond sooner. Were you able to figure this out?
d
Hi @strong-mouse-55694 no worries. I noticed the configuration panels have a few more options but haven't tried it out again since - hopefully have the time to soon!