Do I need to have the app open for every trip in my car?
You don't need to open the app for every trip. It works in the background and will collect your data any time a trip is detected. However, make sure that your smartphone is turned on, has a minimum of 20% battery and Power Saving mode is turned off. Bluetooth should also be turned on, and location settings set to "always allow".
Remember not to force quit the Connect app before your trip.