Are projections good for this?

why can’t two projections write to the same stream?

It would mess up the checkpoint on the projection stream and give you non deterministic results in case of a database crash. Longer answer here: "Multiple projections emitting to the same stream detected" after recreating a projection - #8 by Hayley-Jean_Campbell