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 <rant>I don't know why Collect's not incorporated this as it's easy to fork Collect, but should be implemented for you</rant>, the Tracking Extract is the way to go. Using Automation Studio, this is an outline of 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