If you're tracking conversions using the Collect Implementation, you can use the IGO_PURCHASES joined to the IGO_PROFILES Data Extensions.
If you're using the classic conversions tracking (I don't know why Collect's not incorporated this), the Tracking Extract is the way to go. Using Automation Studio, this is broadly the process:
- Create a Data Extension with the same fields as the Conversions Tracking Extract file
- Create a new Automation Studio program with the following steps
- Step 1: Data Extract Activity of type "Tracking Extract". Elect that you need Conversions to be included in the output. The output file's a .zip file when you're choosing the file name.
- Step 2: File Transfer Activity to move the extracted .zip to the Enhanced FTP (Import Directory).
- Step 3: File Transfer Activity to "Manage File". Unzip the file into its current directory.
- Step 4: Import Activity to import conversions.csv into your Data Extension
- Run/Schedule your Automation Studio program