Field notes
Plain answers about depletion data
Written for the person who pulls the reports. How the three-tier data actually works, what the numbers can and can't tell you, and what to do with thirty thousand rows once they land.
One note a week
No product pitch. Unsubscribe in one click.
All notes
iDIG how-tos
Distributor management
Sales ops playbooks
Depletion data
Three-tier basics
Start here
iDIG how-tos · 9 min read · Aug 2026
The accounts missing from your depletion report
A depletion report lists accounts that bought something. An account that stops ordering entirely doesn't show a zero — it drops out of the file. Here's how to find the ones that left, using exports you already pull.
What the file shows
Rows in one export~30,000
Accounts listed13,109
Accounts not listed5,085
Cases they took last year80,932
Figures from one importer's own exports.
Distributor management
Prepping a distributor review in an hour
The quarterly meeting where you're supposed to arrive with numbers. Which four you actually need, where each one comes from, and the one slide that changes the conversation.
7 minAug 2026
Sales ops playbooks
Writing the check-in email that gets answered
What to say to a buyer who quietly stopped ordering, with four openers that don't sound automated — and the two that get ignored every time.
5 minAug 2026
Sales ops playbooks
The Monday call list, built from data you already have
How to turn a monthly export into seven accounts per rep, ranked by what's actually at stake — and why seven is the number that survives a real week.
7 minJul 2026
Depletion data
Seasonal SKUs vs. real churn
Every autumn your summer brands look like they're dying. Here's how to tell a seasonal trough from an account you're actually losing, before you chase the wrong twenty.
6 minJul 2026
iDIG how-tos
Building a lapsed-account report by hand
The file-over-file comparison nobody has time for, with the formulas, the normalization traps, and a template you can copy.
9 minJul 2026
Distributor management
The 90-day distributor check
A quiet wholesaler takes every account behind it dark at once. Here's the monthly check that catches it, and what to do the week you find one.
5 minJul 2026
Sales ops playbooks
What a wholesaler coordinator actually does all month
The reporting calendar of the person who pulls the exports — and the four hours worth automating first.
6 minJul 2026
iDIG how-tos
Reading a VIP depletion export
Which columns carry the signal, which mislead, and the three pivots worth saving as templates the first time you build them.
8 minJun 2026
Depletion data
Depletions vs. shipments vs. POS
Three numbers that never match, why that's normal, and which one to argue from in a distributor meeting.
7 minJun 2026
Three-tier basics
Why you can't see your own customers
The three-tier system in plain terms, and what suppliers actually get to know about the accounts pouring their beer.
6 minJun 2026
Depletion data
What is depletion data, really?
Who reports what to whom, why it lags a couple of days, and what it can never tell you about your own shelves.
6 minJun 2026
Reading this because you pull the reports every month? That's the job Sightglass takes off your desk. Twenty minutes, screen shared, no file required.
Book a 1-1 demo