Ad spend
₱0
0 products
Commission earned
₱0
Confirmed only, excludes pending
Net profit
₱0
Commission − ad spend
Overall ROAS
—
Scale target 2.5× · break-even 1.0×
Portfolio health
Products 0
Click any cell to edit. Changes save automatically.
| Product & SubID | Ad spend (₱) | Commission (₱) | Net profit | ROAS | Status |
|---|
No products yet
Add each product you're running ads for. Use its SubID so spend and commission match up.
ScaleROAS ≥ 2.5×, raise budget
Monitor1.5–2.5×, hold steady
Pause1.0–1.5×, change creative
Dropbelow 1.0×, stop spending
Figures for one product
Use the same date range for Meta and Shopee.
₱
Meta Ads Manager → Amount spent₱
Shopee report, confirmed onlyOptional, from Meta
Optional, from Shopee
Result
Updates as you type
Enter ad spend and commission
Add clicks and orders too to see cost and earnings per click.
ROAS
—
Net profit
—
Cost per click
—
Earnings per click
—
Decision rules
Apply after at least 3–7 days of data
| ROAS | Status | What it means | What to do |
|---|---|---|---|
| 2.5× and above | Scale | Strong winner | Raise the daily budget 20–50% |
| 1.5× – 2.49× | Monitor | Profitable | Hold budget; test a new video if CTR falls below 1% |
| 1.0× – 1.49× | Pause | Thin margin | Pause, swap video or audience, retest for 3 days |
| Below 1.0× | Drop | Losing money | Turn off and move budget to a winner |
New SubID
Sequence numbers fill in automatically
FB-20261011-GADGET-001
Format FB-YYYYMMDD-CATEGORY-SEQ. Paste the exact same text as your Meta campaign name and your Shopee link SubID.
Saved SubIDs 0
Your record of every campaign you've launched
| SubID | Product | Created | Status |
|---|
No SubIDs saved
Generate one above when you launch a new product.
Week of
0 / 14steps done
The workflow
From finding a product to scaling it
- 1Pick a productShopee Affiliate items with 5%+ commission, good reviews and trending on TikTok.
- 2Create a SubIDOne SubID per product, made in the SubID generator.
- 3Post and boostPost the video on your page with the SubID link in the caption. Name the campaign with the same SubID.
- 4Review on MondayEnter last week's spend and confirmed commission per product.
- 5Scale or cutFollow the status: raise budget on Scale, stop Drop right away.
Excel tracker tabs
The spreadsheet that goes with this site
| Tab | Purpose | When |
|---|---|---|
| Dashboard | Totals calculated from every product | First thing each Monday |
| Meta Ads Input | Paste the Ads Manager CSV export | Weekly |
| Shopee Commissions | Paste the conversion report; mark Confirmed or Pending | Weekly |
| Product Performance | Type a SubID and ROAS, profit and status fill in | When you launch a product |
| Weekly Review SOP | Step-by-step checklist | Every Monday |
| SubID Guide | Naming rules and examples | When creating a campaign |
Rules to keep
SubIDs must match exactlyThe Meta campaign name and the Shopee SubID must be identical. One typo and the numbers won't connect.
Count confirmed commission onlyPending commission can still be cancelled. Counting it makes ROAS look better than it is.
Cut losers fastA product under 1.0× for two weeks in a row gets turned off, no exceptions.
Test small, scale provenNew products get ₱300–500 a day. Scale only after 7 days at 2.5× or better.