The CPG Data Analysis Playbook: From Raw Shopify Exports to Board-Ready Insights

You’ve got the data. Shopify exports, ad platform reports, email analytics, maybe a few spreadsheets that someone started and never finished. It’s all sitting there, waiting to tell you something useful.

But when it’s time to present to your board, your investors, or your leadership team, the gap between “we have data” and “we have answers” becomes painfully obvious. Raw exports don’t impress anyone. Dashboards full of vanity metrics don’t either. What boards want is clarity: a clear picture of what’s happening, why it matters, and what you’re doing about it.

This playbook walks through the process of turning raw Shopify data into the kind of analysis that earns trust, drives decisions, and makes you look like you know what you’re doing (because you will).

Start With the Questions, Not the Data

The biggest mistake in data analysis is opening a spreadsheet without knowing what you’re looking for. You’ll spend hours pivoting tables, creating charts, and finding patterns that don’t matter. Then you’ll scramble to figure out what story to tell.

Flip it around. Before you touch any data, write down the questions your audience cares about. For a board or investor update, those questions usually include:

Is the business growing, and is that growth sustainable?

Are we acquiring customers profitably, and are they sticking around?

Which products are driving results, and which are dragging us down?

Are we on track against our plan, and if not, why?

What are the biggest risks, and what are we doing about them?

These questions should guide every analysis you build. If a chart or metric doesn’t help answer one of them, it probably doesn’t belong in your presentation.

The Metrics That Actually Matter

CPG brands often drown in metrics. Platform dashboards show dozens of numbers, and it’s tempting to report all of them to look thorough. That’s a mistake. Boards don’t want comprehensive. They want clear.

Here’s a framework for organizing your metrics into tiers.

Tier one: The vital signs. These are the numbers that tell you whether the business is fundamentally healthy. For most CPG brands, that means:

Revenue (total and by channel if you’re selling DTC and wholesale)

Gross margin (after COGS, before operating expenses)

Customer acquisition cost and customer lifetime value (and the ratio between them)

Repeat purchase rate (percentage of first-time buyers who return)

Cash position and burn rate (if you’re pre-profit)

These should appear in every board update. They’re the equivalent of checking pulse and blood pressure. If something is off here, everything else is secondary.

Tier two: The diagnostic metrics. These help explain why the vital signs look the way they do. You don’t always need to present them, but you should know them cold in case someone asks.

Average order value and how it’s trending

Customer cohort performance (are newer customers behaving differently than older ones?)

Retention curves (how quickly are customers dropping off after first purchase?)

Return and refund rates

Channel mix and contribution margin by channel

Email and SMS performance (revenue, list growth, engagement)

Ad platform performance (spend, ROAS, CAC by platform and campaign type)

Tier three: The operational details. These matter for running the business day to day but rarely belong in a board presentation unless there’s a specific issue.

Inventory levels by SKU

Shipping times and fulfillment costs

Individual campaign performance

Product page conversion rates

These are useful for internal management, but boards don’t need this level of granularity. Know when to zoom in and when to stay at altitude.

Extracting and Cleaning Your Data

Shopify’s native exports are functional but messy. If you’ve ever opened an orders export and stared at dozens of columns, you know the feeling. Here’s how to make it manageable.

Start with the right export. For most CPG analysis, you’ll need:

Orders export (the core of your sales data)

Customers export (for cohort and retention analysis)

Products export (to match SKUs to categories and margins)

If you’re analyzing specific periods, filter by date before exporting to keep file sizes reasonable.

Clean the data before you analyze. Remove test orders and internal purchases. Standardize how you handle refunds and returns (do they show as negative line items or separate transactions?). Make sure customer IDs match across exports if you’re joining data. Remove duplicate rows that sometimes appear in exports.

Enrich with data Shopify doesn’t provide. Shopify tells you what was sold and for how much. It doesn’t tell you your product costs, your true shipping expenses, or your ad spend. You’ll need to bring in COGS data (often from a spreadsheet or your inventory system), shipping costs (from your 3PL or fulfillment reports), and marketing spend (from ad platforms and invoices).

Building a clean, joined data set takes time the first time. But once you’ve done it, updating becomes much faster. Create a template that you can refresh each month or quarter.

Structuring Your Analysis

With clean data in hand, you can start building the analysis. Here’s a structure that works for most CPG board presentations.

Section one: The headline. Start with the single most important thing leadership needs to know. Are we ahead of plan or behind? Growing faster or slower? More profitable or less? One or two sentences, supported by one or two key numbers.

Don’t bury the lead. Boards appreciate executives who get to the point.

Section two: Revenue and growth. Show revenue for the period versus prior period and versus plan. Break out by channel if relevant (DTC versus wholesale versus marketplace). Show growth rate and whether it’s accelerating or decelerating.

If there’s a significant variance from plan, explain it. Was it a specific product? A marketing channel? A seasonal effect? Don’t just show the miss; show that you understand why.

Section three: Unit economics. This is where you prove (or reveal) whether your growth is profitable. Show CAC, LTV, and the ratio. Show gross margin. If you can, show contribution margin after marketing and fulfillment.

Trends matter here as much as absolute numbers. A CAC of $40 might be fine if it’s stable. It’s concerning if it was $25 a year ago. Show the direction, not just the snapshot.

Section four: Customer health. Retention is everything for CPG. Show repeat purchase rate and how it’s trending. Show cohort analysis: are customers acquired six months ago behaving better or worse than customers acquired a year ago?

If you have subscription data, show subscriber count, churn rate, and average subscription duration. For consumables, this is often more important than one-time purchase metrics.

Section five: Product performance. Not every board needs SKU-level detail, but they should understand which products are working and which aren’t. Show your top products by revenue and by margin (they’re often not the same). Flag any products with concerning return rates or declining sales.

If you’re launching new products, show early performance indicators. If you’re sunsetting products, explain the rationale.

Section six: Risks and opportunities. End with what you’re watching and what you’re doing about it. Is CAC rising? What’s the plan? Is a key product underperforming? Are you testing something new? Is a competitor gaining share? How are you responding?

Boards respect leaders who acknowledge risks openly rather than hiding them in the data.

Visualizing for Clarity

Charts should make your point obvious, not require interpretation. A few principles:

One chart, one message. Don’t cram multiple stories into a single visual. If you want to show revenue growth and margin trend, use two charts.

Use consistent formatting. Same colors for the same metrics across slides. Same axis scales when comparing periods. Consistency reduces cognitive load.

Annotate key points. If something unusual happened in March, put a note on the chart explaining it. Don’t make your audience wonder.

Avoid 3D charts, pie charts with too many slices, and anything that looks like it was designed to impress rather than inform. Simple bar charts, line charts, and tables are usually enough.

Less is more. If a chart isn’t essential to your story, cut it. Every additional visual is another thing competing for attention.

Presenting With Confidence

Having the right analysis is only half the battle. Presenting it well is the other half.

Know your numbers cold. You should be able to answer questions about any metric without looking at your notes. If someone asks why CAC spiked in April, you should know the answer immediately.

Lead with insights, not data. Don’t walk through slides saying “this chart shows revenue by month.” Say “revenue grew 15% quarter over quarter, driven primarily by strong performance in our new protein bar line.” The chart supports the insight, not the other way around.

Anticipate questions and prepare answers. Boards often ask about context: how do we compare to benchmarks, what are peers doing, what’s the industry trend? Have those answers ready even if you don’t include them in the main presentation.

Acknowledge uncertainty honestly. If you don’t know why something happened, say so, and explain what you’re doing to find out. Guessing or hand-waving is worse than admitting a gap.

Making It Repeatable

The first time you build this analysis, it will take a while. The goal is to make each subsequent time faster.

Build templates. Create a master spreadsheet or data model that you can refresh with new exports each period. Set up your calculations once, then just update the inputs.

Automate where possible. Tools like Menza can pull your Shopify data and let you ask questions directly, reducing the time spent building pivot tables and hunting for insights manually. If you’re doing this monthly, the time savings add up quickly.

Create a regular cadence. Decide how often you’ll update your analysis (monthly, quarterly) and stick to it. Consistency builds trust and makes it easier to spot trends.

Document your methodology. Write down how you calculate each metric, where the data comes from, and any assumptions you’ve made. This prevents confusion later and makes it easier to onboard new team members.

Common Pitfalls to Avoid

Reporting activity instead of outcomes. Boards don’t care how many emails you sent or how many ad campaigns you ran. They care what resulted from those efforts.

Comparing apples to oranges. If you’re showing year-over-year growth, make sure you’re comparing equivalent periods. Account for new channels, product launches, or one-time events that make comparisons misleading.

Hiding bad news. It never works. Sophisticated boards will find the problems in your data whether you surface them or not. Better to address issues proactively and show you have a plan.

Overloading with data. More charts don’t signal rigor; they signal that you couldn’t decide what matters. Curate ruthlessly.

Forgetting the “so what.” Every number should connect to an action or decision. If you’re showing a metric without explaining why it matters, cut it or add context.

Data analysis isn’t about proving you have data. It’s about proving you understand your business. The brands that earn board confidence are the ones who can take messy exports, extract meaning, and present that meaning with clarity and conviction. It’s a skill, and like any skill, it gets better with practice. Start with questions. Focus on what matters. Tell a clear story. The data will follow.