The saved games for Campaign and Sandbox should not share the same file location, especially without an overwrite confirmation! I just lost several in-game years worth of progress in the Campaign because I erroneously thought, given how the UI was presented, that I could safely name my saves the same.

EDIT: Added screenshot of save game UI for clarity, as people may not be aware that the game visually separates the two game modes on this screen.