Seven-figure e-commerce brands reach a point where the standard reporting stack stops being useful. Meta says it drove $180,000 in sales. Google says it drove $140,000. Klaviyo attributes another $60,000. Add those up and the number is larger than actual Shopify revenue -- sometimes by a factor of two. In the meantime, the P&L shows margins tightening and the founder cannot tell whether ads are working, whether retention is improving, or whether the business is actually profitable at the marketing level.

TVG built its growth dashboard to solve this problem. It is a spreadsheet that functions as a hybrid P&L -- combining revenue, gross profit, and operational costs with the marketing KPIs that channel dashboards cannot provide. It took about a year of iteration across dozens of seven and eight-figure brands to land on the metrics that actually matter. The result is a single view that tells you whether your marketing is profitable, how efficiently you are acquiring new customers, and whether your LTV:CAC ratio supports the growth rate you are trying to run.

This article breaks down every section of the dashboard, explains how to calculate each metric, and walks through a real example with actual numbers. A free template is available for download at the link in the video description.

Watch the Full Breakdown on YouTube

Patrick builds the dashboard live, populates it with example data, and explains how to interpret each metric to guide monthly decisions

Why Platform ROAS Fails at Scale

Attribution overlap is the core problem. When a customer sees a Meta ad on Monday, a Google Shopping result on Thursday, and opens a Klaviyo promotional email on Friday before purchasing, each platform records a conversion. Meta claims it. Google claims it. Klaviyo claims it. The actual order happened once. Combined attributed revenue across these three channels can be 150 to 200 percent of actual Shopify revenue -- which makes every individual platform look effective while obscuring whether any of them are incrementally driving sales.

Google tends to be the most aggressive. Its broad match and Performance Max campaigns regularly capture brand search traffic that would have converted organically, attributing those sales to paid. When TVG pulls back Google spend by 20 or 30 percent and monitors whether MER holds, the result is often that overall efficiency either stays flat or improves -- a clear signal that significant Google spend was capturing conversions that would have happened anyway.

The conclusion is not that platform metrics are useless. ROAS and CPA at the campaign level still guide creative and bidding decisions within a channel. The problem is using those numbers as evidence of overall marketing health. That requires a metric with no attribution model, calculated above the level of any single platform.

Section 1: The Hybrid P&L -- Revenue Through Gross Profit

The top half of the dashboard is a stripped-down P&L for the Shopify channel. It is not a replacement for the company's full financial statements -- it is a focused view of the revenue and cost structure that marketing decisions operate against. For brands running Amazon, retail, or other channels alongside Shopify, this section covers only the Shopify business.

Section 2: Marketing Costs and the MER Calculation

Below gross profit, the dashboard layers in marketing and operational costs. This section transforms the gross profit calculation into a contribution margin view -- gross profit minus all the costs the marketing function is responsible for.

MER is the single most useful high-level marketing metric for multi-channel brands. It does not replace channel-level data -- understanding which campaigns and creative are working still requires platform dashboards. What MER provides is a system-level accountability metric that no channel can manipulate.

Section 3: The True Marketing KPIs

Below the P&L section, the dashboard tracks the acquisition metrics that determine whether marketing spend is building the business or recycling money through existing customers. These metrics come from Shopify, not from platform ad accounts.

Average Order Value

AOV is tracked month over month and year over year. For most brands, increasing AOV is one of the highest-leverage levers available because it improves front-end margins without requiring additional spend. The dashboard tracks both the current period AOV and a one-year rolling AOV so that a single month of promotional activity does not distort the baseline.

New Customers and New Customer Net Sales

New customer count comes from Shopify, not from any ad platform. This distinction matters because platforms count anyone who converts as an acquisition, including repeat purchasers. Shopify's new customer report counts only first-time buyers. New customer net sales shows what percentage of revenue came from acquisition versus repeat purchasing.

Net Acquisition MER

Net acquisition MER is calculated by dividing new customer net sales by total ad spend. This is a deliberately harsh metric. It assumes that all ad spend exists to acquire new customers -- which is the right assumption because retention should be handled primarily through email and SMS rather than paid media.

Section 4: LTV, LTV:CAC, and Lifetime Gross Profit to CAC

The bottom section of the dashboard connects acquisition costs to the long-term value of the customers being acquired. These metrics determine whether the CAC the brand is running is profitable over the full customer relationship.

Purchase Frequency and LTV

Purchase frequency is total orders divided by total customers over the chosen time horizon. Multiplied by average order value, it produces the LTV estimate for that period. The choice of time horizon should match typical repurchase cycles so the frequency calculation reflects realistic behavior.

LTV:CAC and LTGP:CAC

LTV:CAC measures the ratio of lifetime value to the cost of acquiring a customer. A 3:1 ratio is a healthy baseline for most scaling e-commerce brands. The more rigorous version is LTGP:CAC, which multiplies LTV by gross profit margin to remove product costs before comparing against acquisition cost. LTGP:CAC answers the question that actually matters: after paying for the product, how much economic value does each acquired customer return per dollar spent to get them?

Live Example: Running the Numbers on a Real Brand

The following example walks through the dashboard with actual numbers -- the same exercise TVG runs during onboarding and at the start of each monthly review.

The LTV:CAC of 0.83 and LTGP:CAC of 0.58 tell a clear story: this brand is currently acquiring customers at a loss on a lifetime basis. That does not mean the situation is unfixable. It means there are three levers to pull -- increase LTV through better retention, reduce CAC through creative improvement and prospecting reallocation, or improve gross margin through pricing or COGS work.

When the Numbers Look Bad, Let Data Guide the Response

Running this analysis for the first time often produces uncomfortable numbers. The right approach is to treat bad numbers as a baseline -- a starting point for a structured diagnosis -- rather than a verdict.

Build This Once, Use It Every Month

The growth dashboard does not replace channel-level reporting. A media buyer still needs campaign-level ROAS to optimize creative and bidding. An email strategist still needs Klaviyo flow analytics. What the dashboard replaces is the false confidence that comes from looking only at platform numbers and concluding that marketing is working because every channel shows positive returns.

The brands that scale consistently are the ones that build a measurement system above the level of any single channel, then use that system to make decisions monthly rather than quarterly. Getting this dashboard live and populated takes one focused session. Maintaining it takes about an hour a month.

Watch the Full Breakdown on YouTube

Patrick builds the dashboard live, populates it with example data, and explains how to interpret each metric to guide monthly decisions

About TVG

The Visionary Group (TVG) is a full-service e-commerce growth agency helping 7 and 8-figure Shopify brands scale profitably through paid media, creative strategy, email, and analytics. TVG spends and manages millions in Meta ad spend monthly across active brand partners.

Frequently Asked Questions