The Ecomm Analyst

There’s a moment most operators hit somewhere around year two. You’ve graduated from staring at Shopify’s default analytics. You’ve outgrown Meta Ads Manager’s stock dashboards. You’ve built a few Looker Studio things that you mostly ignore. And you’re starting to ask the kind of questions that none of those tools were built to answer.

Stuff like:

• What’s my blended ROAS on customers who first touched email but converted on a Meta retargeting ad?
• Which products pull in new customers, versus the ones being repurchased by people who’d buy anyway?
• How does week-2 LTV look for customers acquired through TikTok versus Google Search?

Default reports don’t answer these questions. They show you what the platform wants to show you. Meta wants you to see Meta-attributed revenue. Klaviyo wants you to see flow-attributed revenue. Shopify wants you to see GMV. Nobody is incentivized to tell you the messy, cross-channel truth.

Custom reports are how you get there.

For years I tried to do this in Google Sheets. Every Monday morning I’d export CSVs from four platforms, paste them into a master tab, and run my pivots. It worked, sort of. The data was always a day stale, the formulas broke whenever something got nudged out of place, and I spent more time maintaining the report than reading it.

These days I do most of this inside ThoughtMetric. The custom report builder lets you pick the dimensions you actually care about (channel, campaign, product, attribution model, customer segment) and combine them into a single view. The recent addition of custom metrics is what really sold me on it. You can write your own KPI formulas directly inside a report, so something like “new customer revenue per dollar of paid spend” or “blended ROAS net of returns” becomes a saved metric you reference instead of a spreadsheet column you rebuild every month.

A few of the custom reports I actually use:

The Monday morning revenue mix. Channel-level revenue with multi-touch attribution, sorted by week-over-week change. This is the first thing I look at, and it tells me whether anything is quietly breaking before I open another tab.

New customer ROAS by campaign. Filtered to first-time buyers only. This is the report that consistently changes how we spend money. It surfaces campaigns that look mediocre on blended ROAS but are quietly pulling new customers in cheaply, and the inverse, campaigns that look great because they’re harvesting people email would’ve converted anyway.

Product-level acquisition cost. Which SKUs are doing the heavy lifting on bringing in new customers? This one has saved me from killing products that looked unprofitable on direct ROAS but were actually our best top-of-funnel converters.

The pattern across all three is that none of them can be pulled from a single platform. They require stitching data together and applying logic the source platform doesn’t have. That’s the whole point of custom reports. Default dashboards exist to make you feel informed. Custom reports exist to help you make actual decisions.

If you’re still living inside spreadsheet exports, I’d push you to find a tool, any tool, that lets you build this stuff in a system that updates itself. The hour you spend setting up a good custom report pays back roughly forever.