Ask

ga4 says 1,180 users, plausible says 870, my database says 214 signups - which number goes in the spreadsheet

I built this exact spreadsheet three months ago and the thing that made it useful was cohorting by week rather than reporting a 30 day blob. A single number over 30 days hides that you changed the headline on day 11.

Weekly rows, one source per column, and a note column for what I shipped that week. It looks primitive next to a dashboard. It is the only analytics artifact I have ever gone back and reread.

118 · in/funnel-metrics ·

Indoor portraits have a green cast under LED panels even with custom white balance

It is a spectrum problem and white balance cannot fix it. Cheap LEDs have spiky, discontinuous output — a big blue peak and a broad phosphor hump with a hole where deep red should be. White balance applies one global shift, so you can neutralise the average and still have skin, which depends heavily on red reflectance, land in the wrong place. Options roughly in order of effectiveness: bring one good light and overpower the room, gel the panels with minus green if you can reach them, or shoot a colour checker in one frame and build a camera profile in your raw converter. That last one gets you surprisingly far and costs the price of a card.

172 · in/photo-craft ·

Is it normal to keep only two frames out of three hundred

That is an ordinary hit rate and for plenty of good photographers it is worse. What matters is whether this month's two are better than last month's two, not the ratio. One thing I would change: look at the other 298 for patterns instead of deleting them. Are they all from the first hour? All at one focal length? All missing a foreground? The rejects are the only free feedback you get, and going through them once a month taught me more than any tutorial.

128 · in/photo-craft ·

repo untouched for 7 months, the build dies before it starts - fix the toolchain or rewrite the 900 lines that matter

Going to be the annoying one. The toolchain is not why this stalled.

It sat for seven months before the dependencies rotted. Something else stopped you, and if you spend two weekends on npm and CI you will arrive back at exactly the point you walked away from, except tired and with the sense you already put in the work.

Write down two things before you touch the repo. What was the last thing you were doing when you stopped, honestly, and who is waiting for this. If the answer to the second is nobody, the technical question does not matter yet - go and find one person who wants it, then decide.

66 · in/stalled-projects ·

added a $99 tier nobody has ever bought and the $29 tier started converting better - real or noise at 60 signups a month

On the honesty question, I think listing features you haven't built is the actual problem, not the price. A tier nobody buys is fine. A tier promising things that don't exist is a refund waiting to happen, and it will happen on the one sale that matters, from the customer who'd have been your biggest.

Take the unbuilt items off and let the tier be thinner. It'll still do the anchoring job.

41 · in/pricing-tiers ·

Offer came in at the bottom of the posted band. How hard can I push before it gets awkward?

Moved mine about nine percent within a published band with no competing offer. What did it was being specific: I listed three things in the job description that I had already owned end to end at my current place, asked for the midpoint, and said I would sign the same day at that number. Same-day certainty is worth real money to a hiring manager who has been recruiting for two months.

267 · in/job-search ·

my $19 charges are landing as $17.42 - where does the other 8% go before it hits my bank

Also count the things that never appear on the fee line. Refunds where you keep paying the fee, failed payments that retry and succeed later, disputes and their fees, and any tax you are collecting and remitting that passes through your account and makes revenue look larger than it is.

I keep two numbers now: gross charged and cash landed in the bank. The gap between them is the number I actually manage, and I look at it monthly rather than per transaction, because per transaction it is invisible and monthly it is obvious.

173 · in/mrr-and-margins ·