A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL statement:
What updates should be made to ensure this SQL statement returns the desired results?

Question

A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specific data; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

Natcha Koopipat · Accepted Answer

Marketing Cloud _Bounce data view does not contain EmailAddress. They should join on SubscriberlD.

Natcha Koopipat · Answer

Marketing Cloud does not allow DateAdd functions in Query Activities. They should define a specific date.

Natcha Koopipat · Answer

Marketing Cloud Data Views only hold 20 days worth of data. They should narrow scope of DateAdd function.

Natcha Koopipat · Answer

Marketing Cloud does not allow use of GETDATE function. They should define a specific date.

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 110 - Certified Marketing Cloud Developer discussion

Suggested answer: B

0 comments