The more I use Growthbook and set up a library of ...
# ask-questions
d
The more I use Growthbook and set up a library of product metrics, the more I'd like to be able to reuse those other metrics in analytics reports elsewhere - e.g. the sort of thing I may use in Looker / Tableau / GA4 reports etc. I know there's the new SQL explorer work, but I'd really like to have the metrics available/shared with a platform where I can set up much more complex reports and graphs etc. Has anyone found a solution to this? E.g. are there any tools that could easily import Growthbook metrics, fact tables etc - to use them for reporting outside of experiments?
👀 1
h
Hey Ed! Curious what kinds of graphs and reports you'd like to create with your metrics. Care to share?
c
Hey @dry-ambulance-7044, in a more recent version of growthbook I added in the ability to query an experiments metric queries. So if you want to replicate those queries on another platform (like BQ or something) you could query growthbook's API and then store those queries somewhere to execute. Not sure if this is helpful?
d
Hi @helpful-application-7107 - As a example we have quite a few transactional flows on our site, and I want to have a way for stakeholders to visualise the key metrics for those over a longer period of time - e.g. 8 months. So for around 8 different types of transactions I've put together dashboards for each showing things like conversion rate, user volume, AOV, transactions/user, etc - effectively grouping views of these metrics by area. I did this in looker studio but had to redefine all the metric calculations to do it and it occurred to me that I also had those metrics defined in Growthbook for experiments, so it would have been nice if I could just easily query the same metric data to have a consistent view across experiments and Product KPI dashboards - but also be able to arrange them visually for stakeholders. It was also useful to be able to use all the looker studio configuration for timeseries graphs - e.g. breaking down by certain dimensions etc. I guess what would have been easiest would be if I could just go to looker studio and use Growthbook as a data source and get all my metrics query able from there. @cool-house-41256 that does sound quite interesting and like it enables a route for someone to make a tool that builds on the Growthbook metrics which is nice
c
@dry-ambulance-7044 Exactly. That's what we're doing. Saves us a lot of re-writing queries and let's us automate a lot of more detailed analyses!