Shopify logo

Ecommerce integration

Shopify reporting & dashboards

Turn store orders, revenue, customers, and refunds into governed ecommerce reporting.

What you can do with Shopify in Maven

Maven connects Shopify and models orders, products, customers, refunds, and discounts into governed ecommerce metrics. Track orders, net revenue, AOV, units, and refunds, break revenue down by customer type or order status, and tie store performance back to the ads and email that drove it.

What you can measure

100 Shopify metrics you can use consistently

Maven keeps Shopify numbers consistent across dashboards, reports, and answers so the team is not debating which spreadsheet is right.

AOV

Average order value from orders

Cancelled Orders

Orders marked cancelled in the canonical order fact

Completed Orders

Orders not marked cancelled in the canonical order fact

Ecommerce Discounts

Discounts from orders

Gross Revenue

Gross revenue from orders

Net Revenue

Net revenue from orders

Ecommerce Refunds

Refunds from orders

Ecommerce Subtotal Revenue

Order subtotal before tax shipping discounts and refunds

Collected Order Revenue

Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.

Show all 100 metrics

Order Count

Orders represented by the order-level ecommerce fact

Order Gross Revenue

Gross revenue at order grain

Order Net Revenue

Net revenue at order grain

Outstanding Order Revenue

Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.

Order Refunds

Refund amount at order grain

Order Shipping

Shipping amount charged on order-level ecommerce rows.

Order Tax

Tax amount collected on order-level ecommerce rows.

Order Units

Units sold at order grain

Orders

Count of orders

Platform Discount

Platform-funded discounts on TikTok Shop orders

Seller Discount

Seller-funded discounts on TikTok Shop orders

Shopify Current Order Value

Shopify order value after returns, sourced from currentTotalPriceSet.

SKU Count

Distinct SKU counts reported on TikTok Shop orders

Subtotal Price

Order subtotal before tax shipping discounts and refunds

TikTok Shop Items

Items represented on TikTok Shop orders

TikTok Shop Revenue

Gross revenue on TikTok Shop orders

Total Line Items

Line items represented across canonical orders

Total Weight

Units Sold (Ecommerce)

Units sold from orders

Current Order Value

Order value after post-purchase edits and returns (Shopify currentTotalPriceSet). Only Shopify reports this value, so the formula is limited to Shopify orders; other platforms' order totals are in ecommerce_gross_revenue

Collected Order Revenue

Amount collected on source orders when the provider supplies a paid balance; currently populated by Keap.

Ecommerce Orders

Orders represented by the order-level ecommerce fact

Outstanding Order Revenue

Amount still due on source orders when the provider supplies an outstanding balance; currently populated by Keap.

Ecommerce Units Sold

Units sold at order grain

Ecommerce Product Discounts

Line-level product discounts.

Ecommerce Product Net Revenue

Net product revenue after line-level discounts.

Ecommerce Product Net Revenue After Refunds

Product revenue after discounts and line-linked refunds; group or filter by currency

Ecommerce Product Orders

Distinct orders containing this product.

Ecommerce Product Revenue

Gross product revenue across commerce and shopping product rows

Ecommerce Product Units Sold

Units sold for the product at daily grain.

Shopping Clicks

Product-listing clicks reported by Google Merchant Center

Shopping Conversions

Product-listing conversions reported by Google Merchant Center

Shopping Impressions

Product-listing impressions reported by Google Merchant Center

Shopping Revenue

Product-listing conversion revenue reported by Google Merchant Center

Cohort Active Customers

Distinct cohort customers who placed an order at this month offset. Summing across offsets yields customer-months, not distinct customers.

Cohort Cumulative Active Customers

Running sum of active_customers for the cohort from month 0 through this offset (customer-months; can exceed cohort_size). Level, not a flow — do not sum across offsets.

Cohort Cumulative Revenue

Running gross revenue for the cohort from month 0 through this offset. Level, not a flow — do not sum across offsets.

Cohort Gross Revenue

Gross revenue (order total price) from the cohort at this month offset.

Cohort Net Revenue

Net revenue (gross revenue minus refunds) from the cohort at this month offset.

Cohort Orders

Orders placed by the cohort at this month offset.

Cohort Size

Distinct customers acquired in the cohort month. Repeated on every offset row of the cohort — only valid within a single months_since_first_order slice.

Geo Ad Conversions

Platform-reported conversions from the region. For Facebook this is Meta Results for each ad set's optimization event under its attribution setting, not purchases.

Geo Ad Revenue

Platform-reported conversion value from regional paid-media rows. For Facebook this is the primary set's conversion_value, not purchase_value.

Regional Ad Spend

Paid media spend attributed to a geo region by the ad platform

Geo Clicks

Ad clicks from the region.

Geo Impressions

Ad impressions served in the region.

Regional Orders

Orders shipped to a geo region (Shopify)

Regional Revenue

Business revenue by geo region from one KPI source per workspace (Shopify when connected, else GA4)

Regional Sessions

Web sessions from a geo region (GA4)

Geo Users

Web users from the region (GA4 rows; null for Shopify).

Regional Weekly Attributed Conversions

Weekly platform-attributed conversions by region from the geo spend-response panel

Regional Weekly Orders

Weekly total business orders by region from the geo spend-response panel (single KPI source platform per workspace)

Regional Outcome Delta

Baseline-relative, cross-region demeaned weekly unattributed-orders difference. Analysis aid for region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation

Regional Weekly Spend

Weekly ad spend by region from the geo spend-response panel (summed across platforms and campaigns)

Regional Spend Delta

Baseline-relative, cross-region demeaned weekly spend difference. Analysis aid for region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation

Regional Spend Delta Prior Week

Prior week's spend delta for the same region (1-week lag). Analysis aid for lagged region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation

Regional Weekly Unattributed Orders

Weekly orders not attributed by ad platforms (total orders minus platform-attributed conversions) — descriptive correlation input; not a causal measure

Demeaned Spend Delta

Baseline-relative, cross-region demeaned weekly spend difference. Analysis aid for region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation

Demeaned Spend Delta (Prior Week)

Prior week's spend delta for the same region (1-week lag). Analysis aid for lagged region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation

Demeaned Unattributed Orders Delta

Baseline-relative, cross-region demeaned weekly unattributed-orders difference. Analysis aid for region-week scatter/correlation views — only meaningful at region x week grain or as an intentional rollup; correlation, not causation

Conversion Weight (First Touch)

Fractional conversion credit under the first-touch model by conversion touchpoint

Conversion Weight (Last Touch)

Fractional conversion credit under the last-touch model by conversion touchpoint

Conversion Weight (Linear)

Fractional conversion credit under the linear model by conversion touchpoint

Conversion Weight (Markov)

Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint

Conversion Weight (Position Based)

Fractional conversion credit under the position-based model by conversion touchpoint

Conversion Weight (Shapley)

Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint

Conversion Weight (Time Decay)

Fractional conversion credit under the time-decay model by conversion touchpoint

Conversion Events

Canonical conversion/lead events counted through normalized last-touch weights

GA4 Site Conversions by Geo

GA4 key events (site conversions) by geography and channel; GA4 rows only, never added to platform conversions

GA4 Key Event Days Covered

GA4 day-rows whose key events were fully reported; compare with geo_channel_ga4_days_expected

GA4 Key Event Days Expected

GA4 day-rows expected for key-event coverage

GA4 Revenue by Geo

GA4 revenue by geography and channel

GA4 Sessions by Geo

GA4 sessions by geography and channel

Platform Clicks by Geo

Ad platform clicks by geography and channel

Platform Conversions by Geo

Platform-reported conversions (each platform's own attribution) by geography and channel; NULL where the platform does not report them, never added to GA4 conversions

Platform Impressions by Geo

Ad platform impressions by geography and channel

Platform Conversion Value by Geo

Platform-reported conversion value by geography and channel; NULL where not reported

Platform Spend by Geo

Ad platform spend by geography and channel, including spend a geo level does not account for (__not_reported__ rows)

Platform Spend with Reported Conversions

Ad platform spend on rows whose conversions the platform reports at that geo level; the CPA numerator

GA4 Conversion Rate by Geo

GA4 site conversions divided by GA4 sessions

GA4 Conversion Share of Total

Each grouped row's share of all GA4 site conversions in the result

GA4 Conversion Share within Geo

Each grouped row's share of GA4 site conversions within its geography

Platform Conversion Share of Total

Each grouped row's share of all platform conversions in the result (for example a state's share of the total)

Platform Conversion Share within Geo

Each grouped row's share of platform conversions within its geography (for example a channel's share of a state)

Platform CPA by Geo

Spend with reported conversions divided by platform-reported conversions

Return Count

Returns at return grain across connected returns platforms

Return Exchange Value

Value of items exchanged rather than refunded.

Return Refund Amount

Amount refunded for the return.

Return Store Credit

Store credit issued for the return.

Returned Quantity

Quantity of returned items across connected return sources.

Returned Value

Total value of returned items.

Questions you can ask

Just ask Maven about Shopify

Maven’s agent answers in plain language with the right metric definitions applied automatically. These are real, verified questions it can run today.

How many ecommerce orders did we get per week over the last 12 weeks?

Show ecommerce refunds by platform

Show cancelled orders by financial status

Show order discounts by customer type

Compare linear attribution weights by channel

Report templates

Shopify reports for the next client review

Use Shopify reporting templates to see what needs attention, what can be trusted, and which optional fields need cleanup before the next review.

Maven report template

Geographic Performance

Map paid delivery and business outcomes by country, state, and region using the geographic sources available in the workspace.

Geo performanceRegional outcomesCoverage quality

Requires at least one governed geo-level paid-delivery or regional-outcome source. Cross-source comparisons appear only when compatible geography and date coverage overlap.

Maven report template

Regional Spend & Outcome Correlation

Compare regional paid-media movement with non-platform outcome movement over time without presenting correlation as causal lift.

Regional responseOutcome correlationLive data

Requires overlapping geo-level paid-media and governed outcome history. It is descriptive correlation, never an incrementality result.

Connection and sync

What Maven pulls from Shopify

You connect Shopify by signing in to it and approving access, so nobody shares a password. Each Shopify sync takes a fresh copy of the current records, so the workspace always reflects what is in Shopify now.

Shop

Fields: shop gid, name, myshopify domain, primary domain, currency, iana timezone, timezone abbreviation, updated at, account name, city, and 7 more

Orders

Fields: order gid, checkout token, order number, created at, updated at, processed at, closed at, cancelled at, cancel reason, financial status, and 70 more

Order line items

Fields: title, variant title, sku, vendor, quantity, price, total discount, fulfillment status, requires shipping, taxable, and 6 more

Products

Fields: title, vendor, product type, status, tags, created at, updated at, published at, variants count, min price, and 5 more

Product variants

Fields: variant gid, product gid, title, sku, price, inventory quantity, inventory item gid, tracked, updated at, account name

Collections

Product-to-collection memberships.

Fields: collection gid, product gid, title, handle, updated at, account name

Customers

Fields: email, first name, last name, orders count, total spent, currency, created at, updated at, tags, state, and 7 more

Transactions

Order payment/refund transactions.

Fields: kind, status, gateway, amount, currency, account name, created at, order gid, receipt json, transaction gid

Refunds

Order refunds.

Fields: total refunded, currency, account name, created at, note, order gid, refund gid, updated at

Refund line items

Refund amounts and quantities linked to original Shopify order line items.

Fields: quantity, restock type, subtotal refunded, tax refunded, total refunded, currency, account name, line item gid, order gid, refund gid, and 1 more

Returns

Order returns.

Fields: name, status, created at, closed at, request approved at, updated at, account name, order gid, return gid

Return line items

Returned item quantity, value, reason, and original product hierarchy at one row per return line item.

Fields: return line item gid, return gid, order gid, line item gid, product gid, variant gid, quantity, return reason, return reason name, return reason note, and 5 more

Fulfillments

Order fulfillments and tracking.

Fields: status, tracking numbers, account name, created at, fulfillment gid, order gid, tracking company, tracking URLs, updated at

Fulfillment orders

Fulfillment order workflow state by order/location.

Fields: order name, status, request status, assigned location name, account name, created at, destination city, destination country, destination province, fulfill at, and 5 more

Inventory items

Inventory item master records.

Fields: sku, tracked, unit cost, account name, currency, inventory item gid, updated at

Inventory levels

Current inventory levels by item and location.

Fields: available, on hand, committed, reserved, incoming, account name, inventory item gid, inventory level gid, location gid, location name, and 1 more

Locations

Shop locations used by inventory and fulfillment.

Fields: location gid, name, is active, city, province, country, updated at, account name

Discounts

Shop discount definitions and lifecycle state.

Fields: discount gid, discount type, title, status, starts at, ends at, created at, updated at, account name

How it works

Connect Shopify to a client’s workspace

No SQL or warehouse setup. Connect the source, then build the client’s report by asking Claude or ChatGPT.

Step 1

Connect Shopify

In the client’s workspace, open Sources, add Shopify and choose the account to sync. If you don’t have access to the account, send the client a connect link where the platform supports one.

Step 2

Maven syncs and models the data

Maven pulls the client’s Shopify data (11 objects) and models it into documented tables. No SQL, warehouse or pipeline setup.

Step 3

Report, ask and automate

Build the client’s report or deck by asking Claude or ChatGPT through the MCP, set alerts on what matters, and publish to the client’s portal once you approve it.

Works well with

Report Shopify alongside the rest of your stack

FAQ

Shopify reporting questions

What Shopify metrics can I report on in Maven?

Maven exposes 100 governed Shopify metrics, including AOV, Cancelled Orders, Completed Orders, Ecommerce Discounts, Gross Revenue and Net Revenue — each defined once so it means the same thing in every report.

What can I break Shopify performance down by?

You can break Shopify metrics down by Order Number, Source Timezone, Cancel Reason, Financial status, Fulfillment status, Is Test, Taxes Included and Payment Gateway Names, and more.

Can I combine Shopify with other data sources?

Yes. Shopify sits in the same client workspace as sources like Facebook Ads, Google Ads, Klaviyo and Google Analytics 4, so one report or question can use them together.

How often does Shopify data sync to Maven?

Maven syncs Shopify automatically: a fast first source pull after connecting, then scheduled refreshes that keep reports current. The last successful sync time is always visible, so you know the source data is fresh before it feeds a trusted reporting workflow.

Can Maven attribute Shopify revenue to marketing channels?

Yes. Because Shopify orders sit in the same governed layer as your ad spend and email sends, you can compare revenue against channel spend and report blended ROAS and customer acquisition cost.

Is my Shopify data secure with Maven?

Yes. Maven connects to Shopify over its official OAuth flow — no password sharing — stores access tokens encrypted, and pulls read-only reporting data into a governed warehouse you control.

Start your 14-day trial

Set up your first client, build their report by asking Claude or ChatGPT, and publish it to their portal.

  • Free for 14 days, no credit card
  • Your first client workspace and portal
  • Every report template, ready to clone
Start a 14-day trial

Nothing is charged unless you subscribe.

Prefer a walkthrough? Book a demo on one of your own clients.