I am trying to set up my first data extract activity, and I'm having a lot of trouble with the basic setup because I don't truly understand what the activities do. I'm trying to do a tracking export to send data to the Salesforce SFTP (ftp.s6.exacttarget.com) and then download it onto my machine.
From reading the Salesforce documentation, I gather that I need to set up the Data Extract first, then use a File Transfer Activity to send the file to the FTP. I've gotten those two activities to run correctly a couple of times, but each time the file I download from the FTP is still encoded and can't be read by Excel.
Another Stack Exchange question recommended using two File Transfer Activities: one to post the file to the FTP and another to unzip it. I've only gotten that to run once, and the resulting zip file was empty, and the two files inside were an empty CSV and another file with no extension. Every other time I've tried to run these three activities in an automation, the second step fails because "File not found matching the pattern: Clicks.zip".
I'm running out of ideas. Do I need to set up some new file location? Am I doing things out of order? Am I missing a step?