Which source is series_id coming from?

That's the way to do it.

Sanne Moretti Makes sense.

That matches what I had.

That's fair.

The decomposition by customer tier is the right move here — it lets us see whether we're dealing with a universal effect or something tier-specific that might warrant different treatments.