| Parent Family | Units | Sales | Ref | Ref Cost | % Ref | Ads | Fees | COGS | Net Profit | Margin | R.ACOS | Sess | USP | BB % | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Premium Canned Tuna (B0DP7TKD77) | 385 | $16,215 | 4 | -$149 | 1.04% | -$3,446 | -$5,821 | -$5,701 | $589 | 3.63% | 21.25% | 3,089 | 12.46% | 99.66% | Thin |
| Tuna Salads (B0HCZ7FXCP) | 346 | $10,347 | 9 | -$214 | 2.60% | -$1,634 | -$438 | -$8,341 | -$480 | -4.64% | 15.79% | 9,599 | 3.60% | 99.21% | Loss-making |
| Tuna Fillets (B0FFBM6PY4) | 60 | $2,782 | 12 | -$434 | 20.00% | -$673 | -$823 | -$1,320 | -$620 | -22.29% | 24.19% | 1,016 | 5.91% | 99.92% | Loss-making |
| Tuna Pouches (B0HBC47B2T) | 15 | $724 | 0 | $0 | 0.00% | -$182 | -$220 | -$353 | -$30 | -4.16% | 25.09% | 213 | 7.04% | 100.00% | Loss-making |
| Tuna Bites (B0FCCQD6XC) | 10 | $190 | 1 | -$8 | 10.00% | -$59 | -$173 | -$77 | -$128 | -67.56% | 31.30% | 407 | 2.46% | 98.53% | Loss-making |
| Total (5 parent families) | 816 | $30,258 | 26 | -$805 | 3.19% | -$5,994 | -$7,475 | -$15,793 | -$669 | -2.21% | 19.81% | 14,324 | 5.70% | 99.35% |
| SKU | ASIN | Product | Units | Sales | Ref | Ref Cost | % Ref | Promo | Ads | Fees | COGS | Net Profit | Margin | R.ACOS | Sess | USP | BB % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 500001 | B0D5J56XVQ | Premium Yellowfin Tuna in Spring Water, Wild C | 294 | $11,757 | 3 | -$106 | 1.02% | -$394 | -$2,678 | -$4,525 | -$4,114 | -$59 | -0.51% | 22.78% | 2,081 | 14.13% | 99.69% |
| 500016 | B0DXMR77YT | Italian Tuna Salad with Beans, Chickpeas, Peas | 174 | $5,218 | 5 | -$129 | 2.87% | -$118 | -$1,197 | -$225 | -$4,330 | -$781 | -14.96% | 22.94% | 7,747 | 2.25% | 99.73% |
| 500002 | B0D5DPGXHP | Premium Yellowfin Canned Tuna in Olive Oil, Wi | 91 | $4,458 | 1 | -$43 | 1.10% | -$115 | -$768 | -$1,295 | -$1,588 | $649 | 14.56% | 17.23% | 1,008 | 9.03% | 99.61% |
| 500017 | B0DXMJPFV8 | Mexican Tuna Salad with Beans, Peppers, Corn & | 93 | $2,789 | 3 | -$59 | 3.23% | -$48 | -$288 | $285 | -$2,688 | -$8 | -0.30% | 10.33% | 1,057 | 8.80% | 99.68% |
| 500018 | B0DXMQLPP1 | Quinoa Tuna Salad with Quinoa, Peppers, Corn & | 48 | $1,410 | 0 | $0 | 0.00% | -$27 | -$83 | -$201 | -$985 | $114 | 8.09% | 5.89% | 538 | 8.92% | 90.34% |
| 500006 | B0DJQJP5HX | Yellowfin Tuna in Olive Oil Fillets, Wild Caug | 22 | $1,100 | 0 | $0 | 0.00% | -$60 | -$378 | -$305 | -$504 | -$147 | -13.35% | 34.38% | 459 | 4.79% | 100.00% |
| 500005 | B0DK6NGG4R | Yellowfin Tuna in Spring Water Fillets, Wild C | 25 | $1,075 | 11 | -$396 | 44.00% | -$69 | -$240 | -$345 | -$532 | -$506 | -47.10% | 22.29% | 318 | 7.86% | 99.73% |
| 500077 | B0H1MPGWQK | Orzo Pasta Salad with Tuna, White Beans, Peas | 31 | $930 | 1 | -$26 | 3.23% | -$7 | -$65 | -$298 | -$339 | $195 | 20.95% | 7.02% | 257 | 12.06% | 100.00% |
| TUNA-POUCH-SP | B0GSJT8F9X | Yellowfin Tuna Pouches, Spring Water, Wild Cau | 14 | $672 | 0 | $0 | 0.00% | $0 | -$150 | -$201 | -$326 | -$6 | -0.85% | 22.37% | 158 | 8.86% | 100.00% |
| 500007 | B0DJQKP25M | Yellowfin Tuna in Peruvian Peppers Fillets, Wi | 7 | $350 | 0 | $0 | 0.00% | -$16 | -$16 | -$96 | -$153 | $69 | 19.64% | 4.58% | 120 | 5.83% | 100.00% |
| 500008 | B0DJQKNVPT | Yellowfin Tuna in Lemon Peppercorn Fillets, Wi | 6 | $258 | 1 | -$38 | 16.67% | -$7 | -$39 | -$78 | -$131 | -$36 | -13.89% | 15.30% | 119 | 5.04% | 100.00% |
| n/a | B0DQDGDKB1 | Yellowfin Tuna Bites, Curry Arrabbiata, Creamy | 5 | $145 | 0 | $0 | 0.00% | $0 | -$57 | -$108 | -$54 | -$75 | -51.52% | 39.61% | 370 | 1.35% | 98.92% |
| TUNA-POUCH-OL | B0GSH5WGV4 | Yellowfin Tuna Pouches, Olive Oil, Wild Caught | 1 | $52 | 0 | $0 | 0.00% | $0 | -$31 | -$18 | -$27 | -$24 | -46.87% | 60.26% | 55 | 1.82% | 100.00% |
| 500012-PACK-1 | B0FBWYJPDN | Yellowfin Tuna Bites, South Asian Curry Sauce, | 3 | $27 | 0 | $0 | 0.00% | $0 | $0 | -$29 | -$16 | -$18 | -67.93% | 0.00% | 9 | 33.33% | 88.89% |
| 500011-PACK-1 | B0FBWXS2ZM | Yellowfin Tuna Bites, Italian Creamy Brandy Sa | 1 | $9 | 0 | $0 | 0.00% | $0 | -$1 | -$27 | -$3 | -$22 | -249.27% | 6.48% | 11 | 9.09% | 100.00% |
| 500010-PACK-1 | B0FBX2XLD4 | Yellowfin Tuna Bites, Italian Arrabbiata Sauce | 1 | $9 | 1 | -$8 | 100.00% | $0 | -$1 | -$9 | -$3 | -$13 | -144.47% | 15.53% | 17 | 5.88% | 100.00% |
| Total | 16 ASINs | 816 | $30,258 | 26 | -$805 | 3.19% | -$861 | -$5,994 | -$7,475 | -$15,793 | -$669 | -2.21% | 19.81% | 14,324 | 5.70% | 99.35% |
| Marketplace | Units | Sales | Ref | Ref Cost | % Ref | Ads | Fees | COGS | Net Pft | Margin | R.ACOS | Sess | USP | BB % | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 🇺🇸 Amazon.com (US) | 814 | $30,218 | 25 | -$781 | 3.07% | -$5,994 | -$7,522 | -$15,778 | -$719 | -2.38% | 19.83% | 14,324 | 5.68% | 99.35% | Loss-making |
| Total (all channels) | 814 | $30,218 | 25 | -$781 | 3.07% | -$5,994 | -$7,522 | -$15,778 | -$719 | -2.38% | 19.83% | 14,324 | 5.68% | 99.35% |
| Portfolio | Spend | Ad Sales | ACOS | CVR | Aug ACOS | Change | % of Spend | Status |
|---|---|---|---|---|---|---|---|---|
| Tuna Cans | $3,213.49 | $6,854.37 | 46.88% | 7.41% | 29.62% | +17.26 pp | 53.6% | Monitor |
| Tuna Salad | $1,627.07 | $4,901.37 | 33.20% | 9.12% | 29.01% | +4.18 pp | 27.1% | Healthy |
| Tuna Fillets | $665.60 | $1,511.67 | 44.03% | 5.17% | 34.74% | +9.29 pp | 11.1% | Monitor |
| Unassigned | $291.23 | $1,345.61 | 21.64% | 5.36% | 36.20% | -14.56 pp | 4.9% | Efficient |
| Tuna Pouches | $181.63 | $661.85 | 27.44% | 7.14% | new | n/a | 3.0% | Efficient |
| All | $14.50 | $228.88 | 6.34% | 25.00% | new | n/a | 0.2% | Efficient |
| Total (Sponsored Ads export) | $5,993.52 | $15,503.75 | 38.66% | 7.68% | 30.69% | +7.97 pp | 100.0% |
| ASIN | SKU | Product | Price | Subscriptions | 30d Projected | 90d Projected | Inventory | Status |
|---|---|---|---|---|---|---|---|---|
| B0D5J56XVQ | 500001 | Premium Yellowfin Tuna in Spring Water, Wild Cau | $39.99 | 163 | 54 | 195 | 293 | Active |
| B0DXMR77YT | 500016 | Italian Tuna Salad with Beans, Chickpeas, Peas & | $29.99 | 70 | 26 | 101 | 187 | Active |
| B0D5DPGXHP | 500002 | Premium Yellowfin Canned Tuna in Olive Oil, Wild | $48.99 | 57 | 23 | 72 | 135 | Active |
| B0DXMJPFV8 | 500017 | Mexican Tuna Salad with Beans, Peppers, Corn & L | $29.99 | 48 | 18 | 75 | 97 | Active |
| B0DXMQLPP1 | 500018 | Quinoa Tuna Salad with Quinoa, Peppers, Corn & P | $29.99 | 37 | 31 | 89 | 58 | Active |
| B0DK6NGG4R | 500005 | Yellowfin Tuna in Spring Water Fillets, Wild Cau | $42.99 | 24 | 5 | 24 | 75 | Active |
| B0DJQJP5HX | 500006 | Yellowfin Tuna in Olive Oil Fillets, Wild Caught | $49.99 | 21 | 4 | 17 | 56 | Active |
| B0DJQKP25M | 500007 | Yellowfin Tuna in Peruvian Peppers Fillets, Wild | $49.99 | 6 | 4 | 10 | 14 | Active |
| B0DJQKNVPT | 500008 | Yellowfin Tuna in Lemon Peppercorn Fillets, Wild | $42.99 | 6 | 0 | 5 | 6 | Active |
| B0DQDGDKB1 | 500080 | Yellowfin Tuna Bites, Curry Arrabbiata, Creamy B | $28.97 | 4 | 0 | 5 | 31 | Active |
| B0H1MPGWQK | 500077 | Orzo Pasta Salad with Tuna, White Beans, Peas & | $29.99 | 1 | 1 | 3 | 25 | Active |
| B0FBX2XLD4 | 500010-PACK-1 | Yellowfin Tuna Bites, Italian Arrabbiata Sauce, | $8.95 | 1 | 1 | 2 | 6 | Active |
| B0FBWYJPDN | 500012-PACK-1 | Yellowfin Tuna Bites, South Asian Curry Sauce, 1 | $8.95 | 1 | 0 | 2 | 8 | Active |
| Total | 16 active offers | 439 | 167 | 600 | 1,081 |
| ASIN | Product (SKU) | Sep Sales | FBA Units | Velocity (u/day) | Days of Supply | Inbound | Health |
|---|---|---|---|---|---|---|---|
| B0DJQKNVPT | Yellowfin Tuna in Lemon Peppercorn Fille (500008) | $258 | 6 | 0.20 | 30.0 days | 5 inbound | Healthy |
| B0D5J56XVQ | Premium Yellowfin Tuna in Spring Water, (500001) | $11,757 | 361 | 11.14 | 32.4 days | 161 inbound | Healthy |
| B0DXMJPFV8 | Mexican Tuna Salad with Beans, Peppers, (500017) | $2,789 | 117 | 3.20 | 36.6 days | 288 inbound | Healthy |
| B0DXMR77YT | Italian Tuna Salad with Beans, Chickpeas (500016) | $5,218 | 221 | 5.42 | 40.8 days | 337 inbound | Healthy |
| B0DXMQLPP1 | Quinoa Tuna Salad with Quinoa, Peppers, (500018) | $1,410 | 78 | 1.87 | 41.7 days | 160 inbound | Healthy |
| B0H1MPGWQK | Orzo Pasta Salad with Tuna, White Beans, (500077) | $930 | 36 | 0.75 | 48.0 days | 48 inbound | Healthy |
| B0FBX2XLD4 | Yellowfin Tuna Bites, Italian Arrabbiata (500010-PACK-1) | $9 | 7 | 0.14 | 50.0 days | 4 inbound | Healthy |
| B0D5DPGXHP | Premium Yellowfin Canned Tuna in Olive O (500002) | $4,458 | 161 | 3.14 | 51.3 days | 56 inbound | Healthy |
| B0DJQKP25M | Yellowfin Tuna in Peruvian Peppers Fille (500007) | $350 | 16 | 0.26 | 61.5 days | none | Healthy |
| B0GSJT8F9X | Yellowfin Tuna Pouches, Spring Water, Wi (TUNA-POUCH-SP) | $672 | 29 | 0.40 | 72.5 days | none | Healthy |
| B0FBWXS2ZM | Yellowfin Tuna Bites, Italian Creamy Bra (500011-PACK-1) | $9 | 15 | 0.14 | 107.1 days | 1 inbound | Healthy |
| B0DQDGDKB1 | Yellowfin Tuna Bites, Curry Arrabbiata, (500080) | $145 | 31 | 0.26 | 119.2 days | none | Healthy |
| B0DK6NGG4R | Yellowfin Tuna in Spring Water Fillets, (500005) | $1,075 | 87 | 0.67 | 129.9 days | 20 inbound | Healthy |
| B0FBWYJPDN | Yellowfin Tuna Bites, South Asian Curry (500012-PACK-1) | $27 | 9 | 0.05 | 180.0 days | 24 inbound | Healthy |
| B0DJQJP5HX | Yellowfin Tuna in Olive Oil Fillets, Wil (500006) | $1,100 | 96 | 0.52 | over 180 days | none | Healthy |
| B0GSH5WGV4 | Yellowfin Tuna Pouches, Olive Oil, Wild (TUNA-POUCH-OL) | $52 | 47 | 0.04 | over 180 days | none | Healthy |
| Metric | As verified Oct 5 | Target | Status |
|---|---|---|---|
| Account Health Rating | 272 / 1000 | healthy band | Healthy |
| Order Defect Rate (60 days) | 0% (0 of 1,447 orders) | under 1% | Healthy |
| Negative Feedback | 0% | low | Healthy |
| A-to-z Guarantee Claims | 0% | low | Healthy |
| Chargeback Claims | 0% | low | Healthy |
| Food and Product Safety Issues | 0 | 0 | Clean |
| Late Dispatch / Cancel / Tracking | N/A (FBA) | n/a | FBA |
| Suspected IP Violations | 0 | 0 | Clean |
| Listing Policy Violations | 0 | 0 | Clean |
| Regulatory Compliance | 0 | 0 | Clean |
The account made $1,840.39 in August at 14.56% TACoS and lost $719.29 in September at 19.83%, on 8.1% more revenue. Spend rose +47.2% to $5,993.52; ad sales rose 16.9%. That is the whole of the swing before the inventory adjustment. Set a TACoS ceiling of 16% for October and hold it, taking the cut from the campaigns with the worst conversion rather than across the board. Revenue will come down from $30,217.56 and the account will make money; the September trade was the wrong way round.
Premium Canned Tuna in Spring Water took $2,677.68 of advertising, 44.7% of all account spend, and finished at -$59.49 on $11,757.06 of sales. It is the largest line in the catalogue, it carries 163 Subscribe and Save subscriptions, and it has been reliably profitable all year. Pull its search term report, cut the terms converting below the account average, and bring its real ACoS back under 20%. Nothing else in the plan matters as much as this one line.
Amazon booked $4,891.00 of stock as lost or damaged in September, against $100.08 in August, and separately reimbursed $4,256.34 for warehouse losses. The two net to $634.66, which is most of the difference between a small loss and break-even. Establish whether these relate to the same shipments, whether the reimbursement is complete, and whether any further claim is open. If the write-off is a one-off reconciliation it should not recur in October; if it is not, the reorder quantities need revisiting.
The salad parent draws 9,599 sessions, 67.0% of all account traffic, and converts 3.60% of them, against 12.46% on cans. The Italian Salad alone took $1,197.25 of advertising for $5,218.26 of sales and lost $780.52. Traffic is not the constraint on this line; the detail pages are. Closing even a third of the gap to the can conversion rate would add more revenue than the entire September spend increase did, at no extra cost.
Fillets returned -$620.11 on $2,782.40 of sales at a -22.29% margin, after -$509.45 in August and a loss in July. That is three consecutive loss-making months on a line that absorbed $673.12 of advertising in September. The August plan said hold rather than cut and expect gradual recovery; the recovery has not come. Either set a specific margin target and a date, or take the line to organic-only and let the subscribers carry it.
The Account Health page is flagging unverified emergency contact information. Account Health Assurance eligibility depends on it, and AHA is what gets a specialist on a listing problem before it becomes a suspension. For a grocery catalogue that protection is worth keeping. It is a short task and it is the only compliance item on the account.
Tuna Pouches got their first paid support in September and sales tripled to $723.85 on $181.63 of spend at 25.09% real ACoS, the cleanest efficiency in the catalogue. Volume is still small at 15 units, but this is the only line where added spend bought profitable growth this month. Give it a defined budget for October rather than leaving it as a residual.