Which workflow is appropriate for importing data from an SFTP site while needing segmentation?

Which workflow is appropriate for importing data from an SFTP site while needing segmentation?

• A. Scheduled Automation: Import File > SQL Query(s) > Send Email(s)
• B. Triggered Automation: Import File > SQL Query(s) > Send Email(s)
• C. Triggered Automation: Import File > Group Refresh > Send Email(s)
• D. Scheduled Automation: Transfer File > Import File > SQL Query(s) > Send Email(s)

Answer: (B)

For importing data from an SFTP site while requiring segmentation, a triggered automation that begins with the import file process is the most suitable choice because it allows for immediate action based on a specific event, such as the arrival of new data. In this context, having a triggered automation means that as soon as files are uploaded to the SFTP site, the system can automatically begin processing them without having to wait for a predefined schedule. The inclusion of SQL queries allows for data manipulation, filtering, and segmentation to ensure that the emails sent are targeted and relevant based on the specific criteria set in the queries. This efficiency in processing aligns with the needs of segmentation because the data can be processed and segmented in real time, allowing for timely and relevant communication. While scheduled automation can be useful in various scenarios, it typically involves a wait period based on a set schedule. This would not be ideal when immediate responses based on incoming data are necessary, especially for segmentation purposes.

For importing data from an SFTP site while requiring segmentation, a triggered automation that begins with the import file process is the most suitable choice because it allows for immediate action based on a specific event, such as the arrival of new data.

In this context, having a triggered automation means that as soon as files are uploaded to the SFTP site, the system can automatically begin processing them without having to wait for a predefined schedule. The inclusion of SQL queries allows for data manipulation, filtering, and segmentation to ensure that the emails sent are targeted and relevant based on the specific criteria set in the queries.

This efficiency in processing aligns with the needs of segmentation because the data can be processed and segmented in real time, allowing for timely and relevant communication.

While scheduled automation can be useful in various scenarios, it typically involves a wait period based on a set schedule. This would not be ideal when immediate responses based on incoming data are necessary, especially for segmentation purposes.