Streamlining Newsletter Data Collection for Better Metrics

Metrics question- How are you pulling data for evaluating the performance of your newsletters? Ideally, I’d like to pull:

This info is located in various locations and it’s taking too long to copy/paste exactly what I need. Is there a tool that automates this? Even better if it exports to a Google sheet