Ecommerce reporting comparison

Supermetrics vs a custom data warehouse: a data pipe or a finished model?

Supermetrics moves marketing and store data into Sheets, Looker Studio, or a warehouse. It does not model profit. Here is how it fits with a custom build.

Linus TseGreyfield DataFacts last checked November 3, 2026

Contents 10 sections

The short answer

Supermetrics and a custom warehouse are not really alternatives. Supermetrics moves data; a warehouse build models it. For marketing reports in Sheets or Looker Studio, Supermetrics alone is often enough and costs far less. When you need profit, refunds, and orders matched across channels, Supermetrics can be the ingestion layer and the modeling still has to happen somewhere.

How Supermetrics and a custom warehouse differ

01
Moving data vs modeling it
Supermetrics delivers data from hundreds of sources as standard tables per source. Matching orders across channels and calculating profit is left to you.
02
Sheets by default, warehouses on Enterprise
Self-serve plans deliver to Sheets, Excel, Looker Studio, Power BI, and AI chat. Snowflake, BigQuery, and its own Storage need the custom-priced Enterprise plan.
03
It can be part of a build
On Enterprise, Supermetrics can land data in your Snowflake. A custom build can use it, or another connector, to feed the models.

Pricing at a glance

Supermetrics

Independent, privately held (Helsinki, Finland; backed by Highland Europe, IVP and others). Acquired Relay42 (CDP) in June 2025.

A marketing data pipeline that moves data from ad, analytics and ecommerce platforms into spreadsheets, Looker Studio, Power BI, AI chat tools and, on the Enterprise plan, cloud warehouses or Supermetrics' own managed Storage. It now markets itself as a Marketing Intelligence Platform with AI dashboards and an MCP server.

Pricing model: Tiered subscription priced by destinations, data sources, accounts per source and users; Enterprise is custom quoted
Published starting price: $44/month billed yearly ($55 monthly) for Starter
Free tier: No - 14-day free trial, no credit card required
What drives cost: Starter: $44/mo yearly or $55 monthly; 1 destination, 3 data sources, 3 accounts per source, 1 user, 4,000 AI credits/month. Growth: $177/mo yearly or $222 monthly; 1 destination, 6 sources, 7 accounts per source, 2 users, 12,000 AI credits; paid extras such as an extra destination (+$149/mo yearly) or user (+$99/mo yearly). Enterprise: custom quote; adds data warehousing (Snowflake, BigQuery, Redshift and others), Supermetrics Storage, transformations, Data and Platform API, custom data import, SAML SSO and data residency. Cost is driven by the number of destinations, data sources, ad or store accounts per source, and users, plus Enterprise for any warehouse delivery. Row volume is not listed as a price driver on the public page. In 2026 Starter rose from $37 to $44/mo (yearly) and per-unit Extras were added (per PricingSaaS, third-party). The vendor does not publish setup time.

Pricing source, checked November 3, 2026

Custom warehouse (Greyfield)

A Snowflake warehouse with dbt models and a BI layer (usually Sigma), built around your sources and your definitions, that you own after handover.

Pricing model: Project-based build, optional ongoing support
Published starting price: Scoped after a free consultation
Free tier: No
What drives cost: Warehouse, connector, and BI licences are billed by those vendors directly to you.

Pricing source, checked November 3, 2026

Feature comparison

"Not verified" means we could not confirm it from public docs, not that the feature is missing. Each cell links to the page we checked.

Sales channels

Sales channels: Custom warehouse (Greyfield) and Supermetrics
Feature	Custom warehouse (Greyfield)	Supermetrics
Shopify Native Shopify connector.	Yes Through a managed connector such as Fivetran or Airbyte. source	Yes Native connector covering orders, returns, products, inventory and customers. source
Amazon Seller Central Native Amazon connector.	Yes Orders, settlements, and fee events. source	Yes Amazon Seller Central connector covering orders, sales and refunds. No fee or settlement fields are listed. source
TikTok Shop Native TikTok Shop connector.	Yes Modeled alongside Shopify and Amazon. source	Early access TikTok Shop connector added in early access in February 2026. source
Wholesale, retail, ERP, 3PL Native connectors for sources beyond the online store, such as NetSuite, Faire, retail POS, or a 3PL.	Yes Any source with a connector or export. source	Partly No native NetSuite or Faire connector was found. Shopware and Odoo CRM are in early access. Custom Data Import (SFTP, URL, email) and Connector Builder can fill gaps. source

Marketing

Marketing: Custom warehouse (Greyfield) and Supermetrics
Feature	Custom warehouse (Greyfield)	Supermetrics
Ad platform spend Meta, Google, and TikTok ad spend connectors.	Yes Ad spend modeled next to orders. source	Yes Meta, Google, TikTok Ads and many more. source
Tracking pixel + attribution Its own pixel and multi-touch attribution models.	No Attribution from a dedicated tool can be loaded in. source	No It moves platform-reported data. No proprietary tracking pixel or multi-touch attribution model is offered in the pricing or product pages reviewed. source
MMM / incrementality Marketing mix modeling or incrementality testing.	No Not part of a standard build.	Not verified Not found in the product pages reviewed. source

Profit and customers

Profit and customers: Custom warehouse (Greyfield) and Supermetrics
Feature	Custom warehouse (Greyfield)	Supermetrics
Profit with COGS and fees Contribution margin after product cost, shipping, and fees.	Yes Fees, refunds, and cost timing defined in dbt. source	Partly The Shopify connector exposes gross profit and COGS fields, but these use the current unit cost. There is no contribution-margin model with shipping or fees. source
LTV and cohorts Lifetime value, cohort, and retention analysis.	Yes Contribution-margin LTV by acquisition channel. source	Not verified No prebuilt LTV or cohort reports were found; raw customer and order data is available for downstream modeling. source
Subscription analytics Recharge or other subscription reporting.	Yes Recharge renewals and skips modeled as events. source	Partly A Recharge connector (31 metrics, 98 dimensions) delivers raw data. Prebuilt subscription analytics were not found. source
Custom metric definitions Define your own metric logic.	Yes Definitions live in dbt models you own. source	Yes Custom fields and data blending, also exposed through the Public API since June 2026. source

Data access

Data access: Custom warehouse (Greyfield) and Supermetrics
Feature	Custom warehouse (Greyfield)	Supermetrics
Data in a warehouse you can query Your modeled data lands in Snowflake, BigQuery, or a hosted warehouse you can query with SQL.	Yes Your own Snowflake account. source	Enterprise plan Enterprise plan: Snowflake, BigQuery, Redshift, Databricks, Fabric and others, plus a managed Supermetrics Storage option. source
SQL in the product Write SQL inside the product.	Yes Full SQL in Snowflake and in Sigma. source	Not verified No in-product SQL editor was found. SQL access to Supermetrics Storage is not documented. source
AI assistant Natural-language questions about your data.	Partly Depends on the BI tool; we have built text-to-SQL access for a client. source	Yes Studio AI dashboards, an MCP server, and ChatGPT, Claude, Gemini and Copilot integrations. MCP requires a plan that includes the API. source
Mobile app A native mobile app.	Partly Depends on the BI tool you choose.	Not verified No mobile app was found. source

What Supermetrics does well

It maintains hundreds of connectors for ad platforms, analytics, email, CRM, and ecommerce, including Shopify, Amazon Seller Central, Recharge, and TikTok Shop in early access. API pipelines are usually the most fragile part of a custom stack, and Supermetrics takes that off your hands.

Entry plans are self-serve with published prices, and it has added natural-language dashboards, an MCP server, and integrations with ChatGPT, Claude, Gemini, and Copilot.

What still needs modeling

Its own docs list the gaps. The Shopify connector uses the product’s current unit cost rather than the cost at the time of sale, and treats a missing cost as 100% margin. Refunds are dated when processed, canceled refunds are not reported, and edited orders can create duplicates. The Amazon field list covers orders, sales, and refunds but no fee or settlement fields.

Those are exactly the problems a warehouse model exists to solve: refund date vs order date, Amazon fees that arrive after the sale, and orders counted twice across channels.

Where Supermetrics is better

Hundreds of maintained connectors (ads, analytics, ecommerce, email, CRM) replace hand-built API ingestion, which is usually the most fragile part of a custom stack
Native connectors for Shopify, Amazon Seller Central, Recharge, and TikTok Shop (early access since Feb 2026)
Can land data directly in Snowflake, BigQuery, Redshift, Databricks, Microsoft Fabric and others, so it can serve as the ingestion layer of a custom build rather than a replacement for it
Supermetrics Storage offers a centrally managed data store for teams that do not want to run a warehouse
Self-serve entry plans with published prices, starting at $44/month billed yearly
AI features include natural-language dashboards (Studio), an MCP server, and official integrations with ChatGPT, Claude, Gemini and Copilot
A low-code Connector Builder (by request) and Custom Data Import via SFTP, URL or email for sources it does not cover

Who should pick which

Pick Supermetrics if

Your marketing team wants ad and store data in Sheets or Looker Studio this week.
Your questions are about spend, ROAS, and campaign performance, not profit.
You want a managed feed into a warehouse you already run.

Pick a custom warehouse if

You need contribution margin with dated costs, fees, and refunds.
Orders must be matched across Shopify, Amazon, and TikTok Shop.
You want the business rules written, tested, and owned in dbt.

Recommendations by team

If you are	Pick	Why
Marketing team reporting in Looker Studio	Supermetrics	Published self-serve plans and no engineering needed.
Agency reporting across many client ad accounts	Supermetrics	Connector coverage and account limits built for that.
Finance team that needs profit by channel	A custom warehouse	COGS, fees, and refunds modeled correctly over time.
Brand already paying for Supermetrics Enterprise	Both	Use it to load Snowflake and build the models on top.

Recent changes to Supermetrics

2025-06 Acquired Relay42, a Dutch real-time customer data platform, to add audience activation.source
2025-11 Launched Supermetrics AI: Dashboard, Insights and Connector agents, an MCP server and expanded Enterprise APIs.source
2026-02 Data API opened to all plans. TikTok Shop, Shopware and Odoo CRM connectors entered early access. Databricks and Microsoft Fabric were added as warehouse destinations (early access). Official ChatGPT, Claude, Gemini and Copilot integrations launched.source
2026-05 Starter price rose from $37 to $44/mo (yearly), and per-unit Extras were added for destinations, users, sources and accounts (third-party pricing tracker).source
2026-06 Added a ChatGPT Ads connector (early access). Custom fields and data blending became available through the Public API.source

Questions people ask

Does a custom warehouse replace Supermetrics?

It can, by using a different connector tool, but it does not have to. If you already use Supermetrics Enterprise, it can feed the warehouse, and the build focuses on modeling.

Can Supermetrics send Shopify data to Snowflake?

Yes, on the Enterprise plan, which is quoted by sales. Self-serve plans deliver to spreadsheets, Looker Studio, Power BI, and AI chat tools.

Does Supermetrics calculate profit?

Not as a modeled metric. Its Shopify connector exposes cost fields, but its documentation notes it uses the current unit cost, so historical margin needs modeling downstream.

Sources and corrections

We checked these pages on the dates shown. Products change quickly. If you work at Supermetrics and something here is wrong or out of date, email linus@greyfielddata.com and we will fix it.