t1k:marketing:analytics:minder-profit-share
| Field | Value |
|---|---|
| Module | analytics |
| Version | 1.21.13 |
| Effort | low |
| Tools | — |
How to invoke
Section titled “How to invoke”/t1k:marketing:analytics:minder-profit-shareMinder Profit Share
Section titled “Minder Profit Share”Part of the the1kit marketing toolset.
Sheet: https://docs.google.com/spreadsheets/d/14Zy3ZL5GrFweCsVJbZDMaiBe3KFpROVkmlEHDHrgznY/edit (Minder x The One: Publishing)
| Title | Package | Tab gid |
|---|---|---|
| TO - Monster Beatbox Horror 3D (AND) | com.mirai.spranki.beat.box.music.horror | 1565099800 |
| TO - Punch Guy: Hit Monster (AND) | com.mirai.punch.fight.battle.kick | 123898140 |
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)”| Figure | Source | Why not the obvious one |
|---|---|---|
| Revenue | MAX maxReport by day, android, country unfiltered | The sheet includes China. It matched MAX to the cent on Sep 24-30. The crawl CSV applovin column excludes China. Never Adjust. |
| Google Ads cost | LIVE 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 cost | Saved spend-<date>.csv | Mintegral 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.
Timing
Section titled “Timing”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 containcredentials/.env(MAX and Google Ads keys),tool/lib/googleads-month.mjs(the live Google Ads query) anddata/spend-<date>.csv(saved Mintegral days). Default: the crawldata skill folder inside the~/marketing-crawl-ads-spendrepo (under its.claude/skills/). The kit’st1k-marketing-analytics-crawldataskill does not shiptool/lib/orcredentials/, so point the variable at a copy that has them.- A missing
credentials/.envortool/lib/googleads-month.mjsstops the script with a message that namesMINDER_CRAWL_DIR. - Needs network access to AppLovin MAX and Google Ads for any run.
--checkand--writealso need theplaywrightpackage in the global npm root. - Platform: Linux only, with Flatpak Chrome.
--checkand--writecopy~/.var/app/com.google.Chrome/config/google-chrome/Defaultand launchflatpak 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.
cd ~/.claude/skills/t1k-marketing-analytics-minder-profit-share/scripts # project installs: .claude/skills/...bun minder-profit-share.mjs 2026-10 # compute only, no browserbun minder-profit-share.mjs 2026-10 --check # also compare with the sheet, read-onlybun minder-profit-share.mjs 2026-11 --write # fill an EMPTY block, read back, verifybun 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.
--writerefuses a filled block without--replace. Use--replaceonly 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.
Profit share
Section titled “Profit share”Total Profit = Beatbox profit + Punch Guy profitNet profit = (Total Profit - 1% * Total Profit) / 2Read 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.
Executed by
Section titled “Executed by”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”):
| Step | Agent |
|---|---|
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 share | reasoning 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.
Hard rules
Section titled “Hard rules”- A 31-day month’s template can miss the day-31 Profit and ROAS formulas (AF4/AF5 in Oct 2026), which understates AG Profit.
--writefills 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.