I have multiple journey builder emails using transactional API and I want to extract daily data for sends and clicks. Using sends as an example, I have created an Automation with these steps:
SQL QUERY- query the
_sentdata view to extract daily journey builder email sends - and I can find the data is available in the
sent_data_extensiononce I run this step.
Data Extract- extracting the data from the
sent_data_extension(here when I run the automation at this point, is it possible to see this data extract, if so where? Either way this is also is successful.)
File Transfer- pulling the data into the SF marketing cloud ftp - this is breaking and I receive this error:
File not found matching the pattern EnhancedSFTP://Import/xxxxxxxx.csv
Are the steps above correct and in the right order? Should first use data extract to create the .csv for the data found in the
sent_data_extension and then only can I transfer file to ftp. OR SHOULD I be querying the data view and then immediately transferring the data to ftp?