A financial company wans to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week. The company has shared the following:
*Payment.csv will arrive on the Enhanced SFTP each Monday at 1 a.m.
*Payments.csv will be encrypted.
*Payments.csv will contain data from the previous week.
*Late payment notices will be sent each Monday at noon.
*They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send.
Which automation sequence represents a viable solution?

Question

A financial company wans to use Marketing Cloud to send late payment notices to accounts whose payment due date lapsed the previous week. The company has shared the following:

*Payment.csv will arrive on the Enhanced SFTP each Monday at 1 a.m.

*Payments.csv will be encrypted.

*Payments.csv will contain data from the previous week.

*Late payment notices will be sent each Monday at noon.

*They need to receive a file containing customers who opened or clicked on the late payment notice email within five days after send.

Which automation sequence represents a viable solution?

Felix Bourdier · Accepted Answer

Import File > File Transfer > SQL Query > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer

Felix Bourdier · Answer

File Transfer > Import File > Filter > Wait > Send Email > SQL Query > Wait > Data Extract > File Transfer

Felix Bourdier · Answer

File Transfer > File Transfer > Import File > SQL Query > Wait > Send Email > SQL Query > File Transfer

Felix Bourdier · Answer

File Transfer > Import File > Filter > Wait > Send Email > Wait > SQL Query > Data Extract > File Transfer

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 136 - Certified Marketing Cloud Consultant discussion

Suggested answer: B

0 comments