Exporting an Eloqua Insight report with over 200k rows

Summary:

I'm running an Insight report detailing customer engagement with Eloqua emails sent in the last 7 days. The report needs to be exported and show granular, contact level data (1 row per contact), as a result it's being truncated when it's exported, I believe there's a 200k export limit.

My question is 2 fold:

• How can I export reports with over 200k records
• If the export is possible (Bulk API has been mentioned in my searches), will it allow me to export to an SFTP?
  

Content (please ensure you mask any confidential information):

Contact level report of email openers from the last 7 days