I had the idea of using an SW-420 vibration sensor mounted to the outside of a water pipe to detect water flow in that pipe.
The idea would be to implement several different flows from the detection.
One flow would be if water flow is detected for too long either a: the water has been left on or a pipe has broken, or b: if that water line is a toilet, the valve is stuck open.
Another flow could be used for how long did the tap stay open each time it was used?
That sensor is technically a switch. You can’t measure how strong some vibration is. According to your sensitivity adjustment either it’s detected or it’s not. You could probably detect when you open and close a faucet.
Why not?? Many people including myself installed flow meters on water mains or water branches. I put mine right before it goes into my water softener and it tracks everything the house uses. I have another one on the main line that ffeeds my irrigation and track that water use seperately and have been doing this for 2+ years now. It would be orders of magnitude better and more useful to you than what kind of information you could possibly infer from the use of a vibration sensor on your best day.
It’s actually quite easy to shut off the water, cut a pipe, place a flow meter in that cut section of pipe. They even make push on “Sharkbite” fittings that make it super easy. https://www.sharkbite.com/us/en