Krok Odds
Quick Guide

The One Bet Tracker Column Everyone Forgets

A five-minute spreadsheet change that turned my bet tracker from descriptive to diagnostic. The column most advantage bettors miss, and why it matters more than the ones they track.

Daniel Pham
Daniel Pham
Quantitative Strategy Lead
7 min read·Published 25 Sept 2025

Every AU advantage bettor eventually builds a bet tracking spreadsheet. The standard columns cover the obvious ground: date, event, sport, market, stake, odds, outcome, P&L. Most also include closing line odds and a calculated CLV% column. That's the canonical setup.

It's missing a column. Add a per-bookmaker column to your tracker - specifically the account where the bet was placed - and suddenly the spreadsheet goes from describing your betting to diagnosing it. This is the shortest post on this site, because the change itself is small and the reasoning is short. But I think about it a lot.

Why it matters

When I added a bookmaker column to my tracker around month four of advantage betting, three things became instantly visible that weren't before.

Where the edge was actually coming from. My overall CLV at that point was +2.4%. Broken down by bookmaker, my CLV at BlueBet was +5.8%. At TAB it was +0.3%. Those are very different numbers hiding inside the same overall average. Most of my edge was coming from three soft books, and my activity at the sharp books was close to break-even. Knowing that changed how I allocated attention. I concentrated placement volume at the soft books that were actually producing value and reduced energy spent on the sharp books where I was mostly treading water.

Which accounts were about to die. Account limiting doesn't usually happen as a sudden event. It's preceded by a slow shift in your CLV at that book. A few weeks before my BlueBet account got capped, my CLV per bet at BlueBet started trending down - not because my picks got worse but because the book was repricing more aggressively on the specific markets where I had edge. The bookmaker column made this visible in real time. Without it, the gubbing would have felt like a surprise. With it, I could see the warning.

Where promotional value was actually going. Separating P&L by bookmaker revealed that most of my Sportsbet profit came from promotional bets, not from sharp placements. Which meant that when Sportsbet eventually restricted my promo access - which happens well before account limiting - my effective CLV at Sportsbet would collapse. It did, about eight weeks later, and I was ready for it rather than confused by it.

How to actually implement it

If you're on a Google Sheet or Excel tracker, add a column called simply “Bookmaker” somewhere near the beginning. Fill it for every past bet (annoying but usually tractable from your bank statements or the bookmaker account histories). Make it mandatory for every new bet.

Then build four summary views:

CLV by bookmaker. A pivot table or SUMIF showing your average CLV% across each bookmaker. Sort descending. The top of the list is where your edge actually lives. The bottom is where you're wasting effort.

P&L by bookmaker. Total profit or loss at each book. This answers “is this account worth keeping funded.” Some accounts persist for months producing mild break-even results - if the CLV is positive they're still working, but if the P&L is flat and declining, the book is quietly tightening their lines in response to you.

Volume by bookmaker. How many bets you've placed at each book in, say, the last 30 days. This is the diagnostic most relevant to account survival. Bookmakers monitor volume more than anything else. A book running 35% of your weekly turnover is eight weeks away from the chop. Rebalance deliberately.

CLV trend by bookmaker. A rolling 30-bet CLV at each book. Watching the trend matters more than the absolute number. A BlueBet CLV that was +6% and is now +3.5% is a warning sign even though the current number is still strong. The book is tightening.

What it reveals about your operation

The meta-insight of the bookmaker column is that advantage betting isn't one activity - it's a portfolio of 10-15 separate sub-operations, one per account. Each account has its own CLV, its own lifecycle, its own promotional dynamics, its own specific markets where your edge is strongest. The overall tracker averages these together and hides the structure.

Once you can see the per-account view, the decisions you make about how to allocate your attention get much better. You stop putting effort into books that aren't paying it back. You front-load activity at books that are producing edge, to extract maximum value before they limit you. You rebalance deliberately to protect account longevity at the books you most need to survive.

For the deeper logic on why CLV is the right primary metric to track by book, the CLV guide has the full argument. For why account survival matters more than maximising per-bet EV at any single book, the gubbing guide is the read. The bookmaker column is the operational layer that connects both - the single spreadsheet change that makes those strategic pieces applicable to your actual betting.

Five minutes of work. Biggest diagnostic upgrade I've made to my tracker. Should have done it on day one.

Daniel Pham
About the author
Daniel Pham
Quantitative Strategy Lead

Daniel writes about the maths underneath advantage betting — expected value, Kelly sizing, closing line value, bankroll theory. Translates the theoretical side into practical decisions AU punters can actually apply.