numbers-tracker.md
wiki/content/freebie/numbers-tracker.md · last modified May 14
✏️ Edit
All Fileswikicontentfreebie › numbers-tracker.md

Daily Numbers Tracker

The freebie. What gets DMed to every lead who comments NUMBERS on an @gotauts educational carousel and submits the 3-question qualifier.

Why this is the right freebie

The template mirrors the exact columns Gustavs publishes screenshots of in his "Season ROAS is entering the building" / "There Are Days Like This" / "December $1M+ month" posts. The audience already wants this sheet because they've seen it work in his receipts. Lowest-friction giveaway. Highest perceived value. Zero invented content.

Deliverable

A copy-able Notion / Google Sheet template URL. Stored in this file's frontmatter as template_url: once impl picks the host (Notion is the default — supports gallery duplication without a Google account, plays nicely with mobile readers).

Columns and definitions

The tracker has 10 columns. Every column is something Gustavs reads daily on his own ops dashboard. The lead fills in their own numbers and the sheet computes the derived ones.

Column Type Definition
USA orders int (input) Number of fulfilled US orders yesterday.
Google Spend $ (input) Yesterday's Google Ads spend, USD.
Meta Spend $ (input) Yesterday's Meta Ads spend, USD.
Bing Spend $ (input) Yesterday's Bing Ads spend, USD. Often 0.
Revenue $ (input) Yesterday's gross sales, USD.
Cost per ATC $ (derived) (Google + Meta + Bing Spend) / ATC count.
ROAS ratio (derived) Revenue / (Google + Meta + Bing Spend).
Avg session duration seconds (input) From Shopify or GA.
Bounce rate % (input) From Shopify or GA.
ATC count int (input) Add-to-cart events.

How to use it (the 2-minute Loom)

The DM that ships the tracker also ships a Loom URL. The Loom records Gustavs walking through one of his real days — narrating which row he reads first, what triggers a "kill the campaign" decision, what triggers a "press the accelerator" decision. The walkthrough is non-negotiable. Without it the template is a spreadsheet; with it, the template is a daily ritual.

loom_walkthrough_url: is held in frontmatter pending Gustavs recording. Do not ship the funnel without the Loom.

What this freebie is NOT

  • Not a course.
  • Not a PDF guide.
  • Not a webinar invite.
  • Not a discount code.

The funnel works because the freebie is a tool he literally uses, not marketing collateral. Resist any pressure to dilute it.

Phase 2 evolution

After 30 days of leads, review whether the tracker should be split by sub-persona — Validator may need a simpler version (no ATC, no bounce rate); Scaler may need an extended version (LTV, contribution margin, cohort retention). Decide based on wiki/content/leads.md answers to Q1 (sub-persona) + Q2 (bottleneck).

👔
CEO Agent
Ready
I can add people, log decisions, save ideas, and read any cabinet file. Try: "add me as CEO of YGH", "log decision: school kits build or partner by May 30", or "save idea: rep gifting tour for greenhouse kits". I'll write to the right file and confirm.
now