The Portland Designer’s Guide to Tracking Skin and Gut Data

Refreshed
Skin tracking and gut health data spreadsheet used for an ongoing acne journey in data-driven skincare.

Six tabs open in a spreadsheet is nothing next to what happens when a software developer decides his own skin is a bug to be triaged. That contrast is basically why I got serious about skin tracking in the first place. My own system is a plain grid logging hydration, sleep, sugar, my probiotic dose, and a redness score for the cluster along my jaw — and it looks almost quaint next to what a reader named Cormac Duda built after a round of antibiotics sent him down the same gut-health rabbit hole. Both of us were chasing the same question: does anything happening in the gut actually show up on skin, and how would you prove that to yourself instead of just hoping? We built completely different machines to find out. The short version, if you only take one thing from this: track how fast a breakout resolves, not how many you're counting — that's the number that actually tells you whether something is working. As a freelance graphic designer, I think in systems by default — inputs, outputs, revisions — so folding my acne journey into something closer to data-driven skincare never felt like a stretch.

Before any of this, I trusted a dermatologist's plan that included a five-percent benzoyl peroxide wash. It bleached two of my pillowcases and did nothing measurable for the breakouts along my chin. That kind of topical failure is what eventually pushed me toward tracking gut inputs instead of buying yet another cleanser. My partner, Felix, still reads every new bottle I bring home with a raised eyebrow and a question about serving size (logistics, always logistics), which is honestly its own kind of useful data — he's the control group with the good gut health and zero skin complaints I'd trade him for in a heartbeat.

Skin Tracking Without the Spiral: Two Very Different Systems

A detailed spreadsheet tracking skin and gut-health variables like hydration, sugar, and probiotic dose.

My version of this system is deliberately boring, built entirely to support that one recovery-time number. Six variables, entered once a day, in the same order, so filling it out never turns into its own project: hydration, sleep quality, sugar intake, probiotic dose, a redness score from one to ten, and a notes field (mostly for complaining). Every Sunday, before coffee, there's a small sound I could probably pick out blindfolded by now: my phone's shutter going off in front of the bathroom mirror, then one more entry in the spreadsheet. The redness score matters less on its own than how quickly it climbs back down after a bad stretch.

Cormac's setup goes several steps further: a personal API that timestamps symptoms and cross-references them against a running skin log, the way you'd debug a production issue. I find it both impressive and slightly excessive, which is probably exactly what Felix says about my spreadsheet. The upside of Cormac's approach is precision: automated timestamps catch correlations a manual entry at the end of a long day will always blur. The downside is that it only works if you already have the skills and the patience to build it, and most people don't want a side project just to figure out whether probiotics are worth the shelf space.

Where Do the Two Systems Actually Disagree?

A probiotic capsule next to a smartphone used for daily skin tracking entries.

Both systems eventually pointed at the same delay, even though they measured it differently. My spreadsheet showed the pattern loosely — a sluggish couple of days between a bad sugar stretch and a flare-up along my jaw — while Cormac's timestamps could isolate it almost to the hour. I wrote more about that lag in Beyond the Topicals: Why My Spreadsheet (and My Skin) Finally Pointed to My Gut, and it's the piece I point to whenever someone insists their skin issue is purely topical. A cheaper cleanser was never going to fix something that started two days upstream.

That's also the argument behind Why Probiotic Supplements Work Better for My Skin Than Topicals — you're addressing the source instead of the symptom, but the source has a lag built into it, and neither a plain spreadsheet nor a full API removes that lag. It just makes it visible. Where the two systems genuinely disagreed was on false alarms. My manual entries flagged more days as "bad" just from mood or bad lighting in a photo, while Cormac's structured data filtered out some of that noise automatically — mine still gets thrown off by a genuine sugar bender from a bakery in Alberta Arts District that has nothing to do with my gut and everything to do with willpower.

One Tuesday I reached for concealer purely out of habit, got halfway through applying it, and stopped. The cluster along my chin had gone quiet enough that I didn't actually need it. Neither spreadsheet nor API notices a moment like that on its own — a tracking system shows you the trend, not the second you stop reaching for concealer without thinking about it. Cormac says something similar about his own data: the graphs showed his digestion improving before he'd have noticed anything about his skin on his own.

The Questions This Guide Doesn't Answer

Sound tracking data is only half the picture, and it's worth being upfront about what a single guide like this doesn't try to cover. Which specific probiotic strain matters more than dose, whether you can map a breakout zone on your face back to a specific gut issue, what happens to your skin if you stop taking probiotics cold, prebiotics versus probiotics as categories, and how to tell hormonal acne apart from gut-triggered acne are each their own rabbit hole, not a paragraph tacked onto a tracking guide. I also only test capsules, never gummies, so the capsule-versus-gummy argument isn't one I referee here either. The full selfie cadence and the spreadsheet structure behind my own tracking live in a separate piece, for anyone who'd rather copy a whole system than build one from scratch.

Designing Your Own Audit

A minimalist bathroom shelf holding gut-health probiotics as part of a data-driven skincare routine.

If you want to build your own version of either system, keep the variable count low enough that you'll actually stick with it. Six or seven fields is plenty, and hydration, sleep, and probiotic dose usually move the needle more than anything else you'd add. Photograph yourself in the same spot, in the same light, at the same point in your routine — flattering light is great for a feed and useless for comparison. Give any single change real time before judging it, since gut-driven skin changes lag behind whatever caused them. And don't just track the redness score. Track how fast a cluster resolves once it starts, because that's the number that actually separates a supplement doing something from a supplement doing nothing. I also started looking at the best foods to support probiotic supplements for clearer skin once the tracking data made it obvious that supplements alone weren't the whole system.

Choose the plain spreadsheet if your main goal is figuring out whether probiotics are doing anything at all. It's low effort, it's honest, and it's enough to catch an obvious trend. Choose something closer to Cormac's API if you already track other parts of your life obsessively and want cross-referenced timestamps instead of a gut feeling about a gut feeling. Neither system makes the decision for you, and neither replaces an actual conversation with a health professional if something along your jaw isn't behaving the way ordinary breakouts do. Mine just happens to be the version that fits on one screen without Felix asking what half the columns mean.

Important:
All opinions and observations on this site are my own and are shared purely for informational purposes. They do not constitute professional medical, financial, or legal advice. Please consult the relevant professional before acting on any information presented here.