Marketing Automation Reports Help

We are new to zoho and working with marketing automations.

When we send email campaigns the reports are confusing me. We want to export all report info into in one spreadsheet - clicks, opens, rates, etc all in one. I'm able to see number of opens or clicks in the dashboard but when I export it, that info doesn't come out. And again I need a way to pull it all together as well.

Next question... when I go to the lead, no campaign info is showing for them but I've sent them emails. Why is there no info showing up under the lead?

Thanks so much for helping!