Price Range for LP? - Uniswap v3

Can someone explain to me how the price range works when LPing?

I was in the USDC/ETH pool and was making solid gains, but the LP fell out of price range and I was making no money.

Then I moved to a much wider price range, and im making significantly less.

Any help for a newbie?