Why a store would even consider Metabase
Metabase is a general BI tool with no ecommerce opinions. That is a weakness on day one, because there are no prebuilt dashboards for marketing ROI or customer lifetime value, and an advantage later, because the same tool can report on inventory, support tickets, finance, and product usage. The open-source edition is free to self-host, which suits brands watching every line of spend.
The catch is data. Metabase reads from a database or warehouse; it doesn't pull from Shopify, Meta, or Google Ads on its own. Someone has to set up and pay for a pipeline that lands that data, then write the SQL or build the questions that turn it into store reporting.