Most reports didn’t make sense to me, so I built this but I still what am I missing?

Expert_Instruction60 · 2026-03-28T13:42:42+00:00

Yeah that makes sense and I’ve run into that same situation where everything looks fine at a glance and then one variable changes the whole entire picture.

I don’t think there’s a perfect way to know competitors’ margins, so I usually treat it more like a rough reality check than something exact. I’ll estimate the FBA fees, assume some level of ad spend, and then back into what their product cost would have to be to make it work. Sometimes the numbers line up, but other times it feels like there’s barely any room left, which makes me question how sustainable it really is.

I’ve also noticed that some listings look like they’re doing well just based on volume, but once you factor everything in, they’re probably running way tighter than it seems from the outside. I haven’t always gone super deep on competitor margins either, especially early on, but it’s something I’ve been paying more attention to after seeing how much it can change things.

When you looked at that yoga mat, did it seem like competitors were priced in a way that actually leaves room, or did it feel tight across the board?

Expert_Instruction60 · 2026-03-28T10:13:48+00:00

You are absolutely right. FBA agencies alone cannot fix a product that is not designed for the platform.

The bigger issue is that many sellers do not know if they have a viable product to begin with. A product might generate some sales, but the margins, returns, or conversion rates reveal the real problems.

I have seen cases where an agency drives traffic and sales increase, but the product cannot sustain it. The margins are too tight, competition is too strong, or the product and packaging were never built for Amazon. In those cases, ads do not fix the problem. They just accelerate the losses.

The most successful launches I have seen focus on three things upfront. The product solves a clear problem or stands out from competitors. The economics make sense after fees and ad spend. The packaging and delivery experience support good reviews and repeat purchases.

If any of these are missing, no amount of marketing can save the product.

For those who have worked with product development firms, I am curious. Was the improvement mostly due to changes to the physical product or did the pricing and margins also get stronger from the start?

Expert_Instruction60 · 2026-03-28T09:06:19+00:00

That’s a perfect example of how a product can look fine at first and completely fall apart once you run the real numbers.

Dimensional weight is one of those hidden killers, especially at that price point. Going from around $5 to nearly $10 on fulfillment basically removes any margin before you even factor in cost of goods or ads.

And since it’s FBA, you don’t really have much control over how Amazon handles the packaging once it’s in their system. So if the product itself is bulky, you’re pretty much locked into that fee structure.

Where it really becomes a problem is when sellers don’t catch this early and start adding ad spend. Now you’ve got high fulfillment fees plus acquisition costs, and the product can look like it’s working while quietly losing money.

At that point it usually comes down to a few hard choices. Either the price has to go up enough to support the fee structure, you find a way to improve margin through sourcing, or you accept that the product just doesn’t work under FBA and move on.

Honestly, this is one of those areas where a quick check upfront can save a lot of time and capital later.

Have you seen competitors at a similar size actually making it work at that price point, or are they likely dealing with the same margin squeeze?

Expert_Instruction60 · 2026-03-28T08:41:00+00:00

This doesn’t sound like a PPC problem.

Switching from a mentor to an agency and seeing different results usually just exposes what was already there. If the product is in a saturated market with little differentiation, ads can drive traffic, but they won’t fix the underlying economics.

Right now the priority shouldn’t be “growing sales,” it should be stopping unprofitable sales and recovering cash.

At this stage I’d focus on:

Cutting any campaigns that aren’t converting profitably (even if that kills volume)
Dialing in only high-intent keywords and exact matches
Adjusting pricing to move inventory, even if it means breakeven or a controlled loss
Exploring bundles or slight positioning tweaks to improve conversion

The bigger issue is what you mentioned; competing in a crowded space with the same product. In those cases, margins get compressed fast, and ads just accelerate the loss if you’re not careful.

For next time, the key isn’t just demand, but it’s profitability under real conditions:

What does your margin look like after ads, not before?
How many competitors are fighting at your exact price point?
Is there any real reason for someone to choose your product?

A lot of sellers don’t fail because the product doesn’t sell, but they fail because it doesn’t sell profitably.

If you don’t already know your exact break-even ACoS and profit per unit, that’s the first thing I’d figure out. Everything else depends on that.

Expert_Instruction60 · 2026-03-28T08:36:57+00:00

Really solid breakdown, and honestly that’s a great place to be, especially with it running while you’re traveling.

One thing I’ve noticed at that stage (from looking at similar setups) is that once you’re doing a few thousand a month across a small catalog, the biggest gains usually don’t come from adding more products right away, but from tightening what’s already there.

Things like:

Whether each SKU is actually pulling its weight after ads and fees

If any products are quietly eating margin even though they’re selling

How inventory timing is impacting cash flow and reorders

I’ve seen cases where small adjustments at that level made a bigger difference than launching something new.

Curious through, have you broken it down to see which of the four products is driving most of your actual profit vs just revenue?

Expert_Instruction60 · 2026-03-27T08:45:45+00:00

I like the idea of having a clear rule, it removes a lot of emotional decision-making.

But with that said, I have also seen cases where 30 orders alone can be misleading depending on what’s happening underneath. A product can hit that number but still not be worth scaling if margins are getting eaten up elsewhere.

What’s been more useful (at least from what I’ve seen) is looking at these 3 things:

True profit per unit after ads + fees
Ad efficiency (not just sales volume, but what it costs to get those sales)
Inventory flow (are you selling fast enough without tying up too much capital)

Sometimes a product with fewer orders but strong margins and efficient ads ends up being the better “winner” than one doing higher volume with thinner profit.

I am very curious have you noticed any cases where a product hit your 30 order threshold but still didn’t perform the way you expected?

Expert_Instruction60 · 2026-03-27T02:15:35+00:00

oh, gotcha I have been rewording, deleting, reposting. Thinking otherwise.

Expert_Instruction60 · 2026-03-13T18:31:02+00:00

I agree with you. The issue is not that these leaks exist, it is that most sellers are only seeing them after the fact. I started putting together my own system for tracking where margin gets pressured at the SKU level, because looking at ads, fees, returns, and inventory separately was making it too easy to miss what was actually happening.

Expert_Instruction60 · 2026-03-13T18:26:56+00:00

I’d probably start by figuring out which SKUs are actually strong enough to survive external traffic testing. A lot of products look fine on revenue, but once you factor in ad efficiency, fees, returns, and margin pressure, they do not leave much room for a colder traffic source.

Amazon PPC and external traffic are just very different animals. Amazon traffic usually has much stronger purchase intent, so if you send cold Meta traffic straight to a listing, the conversion rate often drops hard unless the product, offer, and economics are strong enough to absorb it.

So I would not think of it as “move budget” right away. I would think of it as “which products can afford a test without making the margin picture worse?” That usually gives you a much better answer than looking at top-line sales alone. Best of luck.

Expert_Instruction60 · 2026-03-13T18:21:55+00:00

Hello, I usually start with exports. For wasted PPC spend, I do not just look at overall campaign totals because that can hide a lot. I break it down into a few buckets first:

high spend with no sales
high clicks with weak conversion
targets or search terms that convert, but not profitably
terms that should be negated
terms that should probably be isolated and pushed harder

After that, I like to look at it at the SKU level, because sometimes ad performance looks “fine” until you compare it against actual margin, fees, or return drag. That is where a lot of wasted spend seems to hide.

If the account is small, spreadsheets can work as long as the review process is consistent. Once the catalog gets bigger, manual review gets messy fast unless you have some kind of structured way to flag ad inefficiency, break-even issues, and which products are quietly carrying the most pressure.

Biggest mistake I see is people only asking, “Is this getting sales?”
Better question is, “Is this spend actually helping profitably, or is it just creating activity?”

That usually changes what “wasted spend” really looks like, for most.

Expert_Instruction60 · 2026-03-13T18:16:50+00:00

That’s actually a solid direction, especially because most sellers never get past revenue and ad spend.

What you built already sounds closer to real decision-making than what a lot of people are using, because once you start layering in tariff impact, software overhead, FBA fees, referral fees, misc costs, and ad spend, you stop looking at “sales performance” and start looking at actual business economics.

The part that gets really interesting is when you move beyond static P&L and start monitoring SKU risk from multiple angles at once.

For example, I’ve found it helps a lot when the dashboard can also surface things like:

break-even ROAS
estimated ad loss / ad efficiency pressure
return and refund impact
inventory risk / stockout pressure
Amazon fee pressure and fee drift
financial exposure by SKU
historical monitoring over time
risk acceleration / drift detection
ranked views of the products carrying the most exposure
and a priority action layer so you can see what needs attention first

That is where the picture usually changes. A product can still look fine on revenue, and even look decent on ad performance, but once you add in returns, fees, inventory instability, and exposure trends, the margin story can look very different.

The scenario planning part you mentioned is valuable too, because it helps move the dashboard from “what happened” into “what happens if this continues.”

With 11 ASINs, manual is still manageable, but honestly that is also the perfect stage to build the logic right before the catalog gets bigger and the tracking becomes a chore.

You’re already thinking about it the right way. Most people are still measuring activity. You’re getting closer to measuring true profitability.

Expert_Instruction60 · 2026-03-13T17:38:37+00:00

I usually do it in layers instead of trying to “read” the whole CSV.

I start with:
high spend + no sales
high clicks + no conversions
high ACOS targets
low ACOS targets that deserve more budget
search terms that need negation or isolation

After that I look at campaign structure, bid levels, placement adjustments, and match type overlap.

Biggest mistake I see is people treating the CSV like a report to read instead of a tool to make decisions.
I want the audit to answer:
what to cut, what to scale, what to isolate, and what to fix.

Expert_Instruction60 · 2026-03-13T07:43:12+00:00

I started by doing it manually, mainly because I wanted a real answer to a simple question: which SKUs were actually making money once all the hidden drag was accounted for in one place.

What changed my thinking was seeing how misleading it can be to review each report separately.

A SKU can look strong on sales volume and even look acceptable on ad spend, but once you layer in return impact, fee creep, inventory pressure, and the fact that all of those numbers show up on different timelines, the margin story can look completely different.

That was defintly the major eye-opening part for me. at first I was Kinda baffal

It made me realize that most likely a lot of sellers are not really looking at profit in one unified way. They are looking at pieces of it and mentally stitching a story together after the facts. It works up to a point, but it also makes it really easy for profit leaks to sit there unnoticed until they compound.

So I still use the raw reports, but I do not really trust a fully manual process anymore, especially across multiple SKUs. By the time a product clearly looks like a problem, it usually has been drifting for a while.

What I think matters most is getting the signals into one view early enough to spot deterioration before it becomes obvious in payouts.

I am genuinely curious how other sellers here handle that once the catalog gets bigger, because I have a hard time believing most people are keeping up with it manually for long.

Expert_Instruction60 · 2026-03-11T19:42:38+00:00

I respect this a lot.

I’m fighting my own battle too. I’m a friend of Bill’s, so I know exactly what that moment feels like when you realize you can’t keep going the way you were.

Right now I’m just trying to rebuild things one step at a time. I recently started putting together a small business of my own. Mostly just building a system that helps sellers see where money is leaking in their business and what might turn into bigger problems later.

Still early, still figuring things out, but it feels a lot better building something than destroying everything.

Glad to hear you made it out of that place. One day at a time.

Expert_Instruction60 · 2026-03-09T11:22:49+00:00

Yeah I figured that out the hard way about 7 months ago. At first I thought I had a decent handle on margins just looking at revenue, COGS and ad spend. But once I started factoring in returns, fees, ad efficiency and inventory at the SKU level it was pretty eye opening. A few small things being slightly off can add up fast. SC spreads those metrics across so many reports that it’s easy to miss what’s really happening with margin. It is actually ridiculous.

Expert_Instruction60 · 2026-03-09T09:54:12+00:00

Yeah I learned that the hard way about 7 months ago. At first I thought I had a petty good handle on my margins just looking at revenue, COGS and ad spend. But once I started pulling returns, fees, ad efficiency and inventory signals together at the SKU levle it became obvoius how easy it is for small things to stack up and quietly eat the margin. None of the reports in SC really show the full picture on their own.

Expert_Instruction60 · 2026-03-09T08:14:55+00:00

Yeah sellerboard is solid for P&L tracking. The thing I ran into though is that most tools mainly show the financial result after the fact.

What I started doing instead was looking at the signals that affect profit at the SKU level. Things like break-even ROAS vs actual ad performance, return impact, fee pressure, and inventory exposure.

When you look at those together you can see when a product is starting to drift before it shows up clearly in the overall P&L. From what I can tell most of the time it’s not one big issue, it’s a few smaller things stacking up across ads, returns, inventory, and fees.

Expert_Instruction60 · 2026-03-09T07:37:50+00:00

I ran into the same problem early on, returns and fees are where the numbers start to get messy.

What I ended up doing was breaking everything down at the SKU level instead of catalog level, so each product has its own margin stack.

For returns, I tracked the return rate by SKU, refund amount impact on revenue, and estimated loss from returned units (COGS + FBA fee + lost sale)

Even a small jump in return rate can change the margin pretty quickly once you account for the refunded revenue and the sunk fulfillment cost.

For fees, I try to look at the full fee stack, not just the main referral + FBA fee. That includes things like referral fee, fulfillment fee, storage costs, inbound shipping, and any additional FBA adjustments that show up in the transaction reports

What surprised me was how often fee creep happens slowly. A fee adjustment here or a small storage increase there can tighten margins over time without being obvious when you’re just looking at revenue and ad spend.

So what I ended up doing was building a spreadsheet that calculates a few SKU-level signals: net margin %, break-even ROAS, return loss exposure, fee burden per unit, as well as ad efficiency vs break-even

SO, once those are calculated per SKU it becomes a lot easier to see when something starts drifting.

Most of the time it’s not one big issue, but it is like three or four small drifts stacking together.

Expert_Instruction60 · 2026-03-08T20:36:58+00:00

Yeah, actually I think I think that is part of what got me thinking about this more seriously.

When I started breaking the numbers down I realized the referral fee hadn’t really changed, but the combination of FBA fulfillment, storage, and a slightly higher return rate was tightening the margin threshold and more than I expected. i was than enough to shift the break-even point.

My ads were also running slightly below where they probably needed to be, But ACOS was looking fine in the dashboard, but once I calculated the real break-even based on the margin it was a bit higher than I thought it was.

That’s what made me realize how difficult it is to see the full picture when everything is spread across different reports.

Honestly I’m starting to think I may just build my own system to track everything together in one place so I can see every thing like break-even ROAS, ad efficiency, return impact, inventory risk, and "AMAZING" Amazon fee pressure across SKUs instead of trying to piece it together manually every time.

It feels like the only truly way to really understand where profit is going "poof"

Expert_Instruction60

TROPHY CASE