Skip to content

t1k:marketing:analytics:minder-profit-share

FieldValue
Moduleanalytics
Version1.21.13
Effortlow
Tools—
/t1k:marketing:analytics:minder-profit-share

Part of the the1kit marketing toolset.

Sheet: https://docs.google.com/spreadsheets/d/14Zy3ZL5GrFweCsVJbZDMaiBe3KFpROVkmlEHDHrgznY/edit (Minder x The One: Publishing)

TitlePackageTab gid
TO - Monster Beatbox Horror 3D (AND)com.mirai.spranki.beat.box.music.horror1565099800
TO - Punch Guy: Hit Monster (AND)com.mirai.punch.fight.battle.kick123898140

Each tab has one block per month, 5 rows, a blank row between them, newest on top: header (Oct 1…), Total Cost, Total Revenue, Profit - USD, ROAS. Columns B..AF are days, AG Total, AH Daily average. Profit, ROAS, Total and Daily average are the sheet’s formulas: type only cost and revenue.

Data basis (each verified 2026-11-05, do not substitute)

Section titled “Data basis (each verified 2026-11-05, do not substitute)”
FigureSourceWhy not the obvious one
RevenueMAX maxReport by day, android, country unfilteredThe sheet includes China. It matched MAX to the cent on Sep 24-30. The crawl CSV applovin column excludes China. Never Adjust.
Google Ads costLIVE query (fetchGoogleAdsMonth)Saved CSVs are as-charged. Google credits invalid traffic later: Oct 2026 saved $1,777.94, dashboard and live $1,735.71. The user reconciles against the dashboard.
Mintegral costSaved spend-<date>.csvMintegral returns $0 for dates older than ~30 days, with no error.

Scope is the main package only: store variants (xiaomi_, oppo_, …) carry no cost or MAX revenue. Punch Guy iOS is out. AdMob mediation was $0 for both in Oct 2026, and AdMob bidding is already inside MAX, so nothing is added. Unity is not part of cost here.

Run early in the next month. MAX looks back only 45 days and Mintegral saved days must exist, so a month left too long cannot be rebuilt. Google Ads still settles after that, so a late re-pull may lower cost slightly.

  • MINDER_CRAWL_DIR: the crawldata skill directory the script reads. It must contain credentials/.env (MAX and Google Ads keys), tool/lib/googleads-month.mjs (the live Google Ads query) and data/spend-<date>.csv (saved Mintegral days). Default: the crawldata skill folder inside the ~/marketing-crawl-ads-spend repo (under its .claude/skills/). The kit’s t1k-marketing-analytics-crawldata skill does not ship tool/lib/ or credentials/, so point the variable at a copy that has them.
  • A missing credentials/.env or tool/lib/googleads-month.mjs stops the script with a message that names MINDER_CRAWL_DIR.
  • Needs network access to AppLovin MAX and Google Ads for any run. --check and --write also need the playwright package in the global npm root.
  • Platform: Linux only, with Flatpak Chrome. --check and --write copy ~/.var/app/com.google.Chrome/config/google-chrome/Default and launch flatpak run com.google.Chrome. macOS and Windows need those profile paths and the browser launch rewritten before the script runs there; that is not done. Compute-only runs use no browser.
Terminal window
cd ~/.claude/skills/t1k-marketing-analytics-minder-profit-share/scripts # project installs: .claude/skills/...
bun minder-profit-share.mjs 2026-10 # compute only, no browser
bun minder-profit-share.mjs 2026-10 --check # also compare with the sheet, read-only
bun minder-profit-share.mjs 2026-11 --write # fill an EMPTY block, read back, verify
bun minder-profit-share.mjs 2026-10 --write --replace # overwrite an already filled block
  • The script stops rather than writing zeros: a missing MAX day, saved CSV or package row is an error.
  • --write refuses a filled block without --replace. Use --replace only when the user asked to refresh that month, and say which cells changed.
  • If the user adds a month’s block by hand, it must exist before --write. The script does not create blocks.

Sheets access: the Drive connector cannot see this file and no Sheets API token exists, so the script drives a headless copy of the Chrome Default profile (duongttt@) and deletes the copy afterwards. Never open the user’s own Chrome for it.

Total Profit = Beatbox profit + Punch Guy profit
Net profit = (Total Profit - 1% * Total Profit) / 2

Read both profits from the sheet’s AG Profit cell (the script prints them after --check or --write). The result stays in chat: it is not written to the sheet unless the user says where.

Reference, October 2026: Beatbox $843.49 + Punch Guy $296.06 = Total Profit $1,139.55; 1% = $11.40; Net profit $564.08.

The pull and the arithmetic are fully specified before the run starts, so they are cheap-tier work. Interpreting the result stays on a reasoning tier (routing SSOT: rules/orchestration-rules.md § “Task-Type → Agent Routing”):

StepAgent
Run the compute-only build for one month and report the per-title figures (bun minder-profit-share.mjs <YYYY-MM>)t1k-fact-fetcher
Compare the sheet block with the computed cost and revenue (--check)t1k-data-verifier
Explain why a title’s cost or revenue looks wrong, or judge the profit sharereasoning tier, not cheap: no cheap-tier row

--write changes the live sheet. Run it only on the user’s explicit instruction, in the main session.

  • A 31-day month’s template can miss the day-31 Profit and ROAS formulas (AF4/AF5 in Oct 2026), which understates AG Profit. --write fills them from day 30.
  • Report the Google Ads total next to the block so the user can compare it with their dashboard.
  • Quote what changed. Edits appear under duongttt@the1studio.org in the sheet history.