← Amplitude
Complex day at Amplitude

Settle how nulls are counted before consumers adopt the contract

You’re the software engineer. Your team is in the room. Printed Oct 8, 2026.

The generic-table contract makes more analysis possible while fixing null behavior in place.

Faster parallel queries protect product responsiveness, while stable null semantics protect the meaning of customer analysis.

Who you’d be doing this for

“I can explain a slow chart, but I can’t defend two different answers to the same funnel.”

Blanca Dimitriou · Group Product Manager

She uses funnel and retention analysis that joins event behavior with account profile properties for an enterprise product-led company.

What is at stake

Complex funnel queries can return plausible but different counts when optional profile data is missing. You must weigh faster generic-table execution against a compatibility commitment customers cannot easily unwind.

Why it isn’t already fixed

Every obvious fix costs something else. That’s the part you’d have to decide.

  • parallel execution speed vs stable analysis meaning
  • generic data modeling vs compatibility guarantees
  • automated test breadth vs human verification
  • migration timing vs irreversible API commitments

Why Amplitude

Nova-backed analysis depends on the compute API returning the same behavioral answer as the data model expands beyond events.

Written with these in mind

distributed systems builderquery engine engineerplatform-minded backend engineer

Not your kind of problem? 13 more at Amplitude, or browse every organization.

This is the setup. The work is inside.

Running it puts you in the room: the full situation and its constraints, stakeholders who push back in their own words, and the decisions that are yours to make. What you produce becomes a Day One Plan — work you can show someone instead of describing.