What "custom analytics reports" actually means
Most guides on this keyword walk you through the click path in Google Analytics 4 and stop there. That is the shallow version of the topic, and it is where nearly every top-ranking page lives.
A custom report is simply a report where you choose the metrics, dimensions, filters, and layout — instead of accepting a pre-built view. In GA4 you can add up to twelve metrics to a detail report, and each property holds up to a hundred and fifty custom reports (Google Analytics Help). Matomo lets you build from over two hundred dimensions and metrics (Matomo).
That flexibility is the point and the trap. Flexibility without a question just produces prettier noise. So this article is organized around the questions a small store owner should build reports to answer — in order — not around which buttons to click.
Why the default reports fail store owners
Your platform's built-in analytics are the system of record for what happened: revenue, orders, refunds. That is genuinely valuable, and it is trustworthy because it comes straight from your own order records.
But the defaults have a structural blind spot. Independent analytics guides consistently name the same gap: native Shopify reporting shows revenue and, on higher plans with cost of goods entered, gross margin — but not net profit after ad spend, shipping, transaction fees, and returns (Luca). You see what sold. You do not see what you kept.
That is the whole reason custom reports matter for ecommerce. The number that runs your business — profit per order — is never sitting in a default card. You have to construct it. If you want the full map of how these tools fit together, our guide to ecommerce business intelligence lays out the landscape.
The report that beats every competitor: contribution margin
Here is the report the GA4 tutorials never build, and the one that changes how you run a store. It is a per-product contribution margin report — revenue minus every variable cost of selling that unit.
First, define two terms so the report makes sense. Gross margin is revenue minus cost of goods sold, as a percentage; typical direct-to-consumer brands land around sixty to eighty percent. Contribution margin subtracts everything else that varies per sale — shipping, fees, attributed ad spend, returns — and on the same product often lands at just fifteen to thirty percent (Saras Analytics).
A worked example — one product, one order
Say you sell a mug for $50. Walk the costs down in layers:
| Line | Amount |
|---|---|
| Selling price | $50.00 |
| − Cost of goods (product + packaging + freight) | −$15.00 |
| = Gross profit | $35.00 (70%) |
| − Outbound shipping and fulfillment | −$8.00 |
| − Payment and platform fees (~3%) | −$1.50 |
| = After fulfillment | $25.50 (51%) |
| − Attributed ad spend to win the order | −$12.00 |
| − Returns reserve spread across orders | −$3.00 |
| = True contribution | $10.50 (21%) |
The arithmetic is the lesson: $50 − $15 − $8 − $1.50 − $12 − $3 = $10.50. A product that looked like a seventy-percent margin winner is really a twenty-one-percent product once you sell it online.
Now build that same calculation across your whole catalog and sort it. Suddenly you can see your real winners to scale, and the "zombie" products whose contribution is near zero or negative — the ones to reprice, bundle, or drop. No revenue report can show you that. Our deep dive on ecommerce dashboards and analytics shows how this rolls up into a daily view.
The four ways to build custom reports (and what each costs you)
There is no single right tool. There are four honest options, each answering a different need.
Spreadsheets. Google Sheets or Excel fed by CSV exports or a connector. Maximum control, near-zero cost, and still the most common small-business "BI stack" in practice — but manual, error-prone, and never real-time.
GA4 and native platform reports. Free and built in. GA4 is strong on traffic sources and pre-purchase behavior; Shopify's own reports are authoritative on money. Neither computes net profit across ad platforms on its own.
Ecommerce BI and dashboard platforms. Tools that unify orders, ads, and marketplaces into cohorts, lifetime value, and blended metrics on a pre-built semantic layer of defined metrics. Polar, for one, advertises a commerce semantic layer with over four hundred pre-built metrics (Polar Analytics).
Attribution tools. These reconcile which ad dollar produced which sale despite cookie and tracking loss. They are generally aimed at stores spending meaningful money on ads — often five thousand dollars a month or more (Cometly).
Most stores start in spreadsheets, add a profit view when margins get tight, and layer on attribution as ad spend grows. Do not buy the whole stack on day one.
The order to build reports in
Custom reporting fails at small scale when people track forty metrics and act on none. Build your reports to answer these questions in sequence — each one earns the next:
- Am I profitable, and on what? Net profit, then contribution margin per product. Revenue vanity dies here.
- Where do sales come from? Channel mix, new versus returning split.
- Is my marketing paying for itself? Cost to acquire a customer measured against contribution margin — not return on ad spend alone.
- Do customers come back? Repeat-purchase rate and retention by cohort, which is where durable growth lives.
- Where is the funnel leaking? Conversion rate step by step.
A focused stack of roughly seven numbers watched weekly beats a forty-metric dashboard nobody reads.
Watch out for the ROAS trap
Return on ad spend is the most-watched and most-misleading small-business metric. A campaign with a great return can still lose money if it sells low-margin, high-return products, because that ratio ignores product margin entirely (Luca). Judge campaigns on contribution margin after ad spend instead. That single upgrade is worth more than any new dashboard.
The retention report most small stores skip
Group customers by the month they first bought — their cohort — then track what share come back the next month, and the month after. The output is a retention table you read as a heatmap.
Commonly quoted direct-to-consumer benchmarks put average repeat behavior around thirty-five to forty percent, with the mid-forties considered strong (useProactiveAI). Treat those as rough, category-dependent rules of thumb — consumables retain very differently from furniture.
A rising first-month column across cohorts means recent changes are producing stickier customers, a signal to double down. A flat or falling column is the classic leaky bucket: you are filling it as fast as it drains. If you want to segment those customers by value and frequency, RFM analysis for customer segmentation is the natural next report, and RFM analysis software covers the tools that automate it.
Where an AI operator fits
An emerging category lets you ask a question in plain English instead of building a report by hand — conversational analytics. Gartner has estimated that by the end of this year, more than half of enterprise analytics queries will be generated through natural language, search, or voice rather than built manually (per 2026 BI-trend roundups).
This is where PodVector fits, and it is worth being precise about what it is. PodVector connects your Shopify, Meta Ads, Google Ads, Printify, and Printful accounts and computes true per-order profit — the twenty-one-percent number from the table above, calculated automatically across your catalog against a live data warehouse. It is not a dashboard you have to build and stare at.
Victor is the AI operator inside it. He reads your connected data, surfaces where margin is leaking, and proposes moves — and the actions he executes are Shopify-side, taken only with your approval. He reads your ad data to explain what is working, but Victor does not touch your ad account. If you have been building the contribution-margin report by hand in a spreadsheet, this is the version that stays current on its own. Connect your store and see your real per-order profit.
FAQs
What is a custom analytics report?
It is a report you configure yourself — choosing the metrics, dimensions, filters, and layout — rather than reading a fixed, pre-built view. The value is that you can build it around the exact question you need answered, like profit per product, instead of settling for whatever the default dashboard shows.
How do I build a custom report in Google Analytics 4?
In GA4 you open Explore or edit a detail report, then add the dimensions and metrics you want; you can add up to twelve metrics per detail report and save many custom reports per property (Google Analytics Help). The bigger question is what to build — start with traffic-source and behavior reports, since GA4 is strongest there and weakest on cross-platform cost.
Can Shopify's built-in reports show my profit?
Not fully. Native Shopify analytics shows revenue and, on higher plans with cost of goods entered, gross margin — but not net profit after ad spend, shipping, fees, and returns (Luca). To see what you actually keep, you either build that math in a spreadsheet or use a tool that pulls cost and ad data together.
Which custom report should a small store build first?
Build a contribution-margin report by product before anything else. It answers whether each item makes money after all variable costs, which reframes every other decision — what to advertise, what to bundle, what to drop. Revenue reports feel productive but hide the products quietly losing you money.
Do I need expensive software to make custom reports?
No. Most small stores run their first real custom reporting on a spreadsheet plus native platform reports. Paid tools earn their place later, when the manual work or the blind spots start costing you more than the subscription — usually once ad spend and product count grow past what you can track by hand.
What's the difference between gross margin and contribution margin?
Gross margin is revenue minus cost of goods, as a percentage — it ignores shipping, ads, and fees. Contribution margin subtracts all the variable costs of selling a unit, so it is the realistic "what you keep" number (Saras Analytics). A product can look healthy on gross margin and lose money on contribution margin once ad spend and returns are counted.