Charlaine of Marketing Cloud Team
8/1/2018 - 1:07 PM
Feedback Tool Overview
Vullen van data extension met overview van positieve en negatieve clicks en NPS score per email name.
SELECT EmailName,
COUNT(case Rating when 'Positief' then 1 else null end) AS Positief,
COUNT(case Rating when 'Negatief' then 1 else null end) AS Negatief,
10.0*(COUNT(case Rating when 'Positief' then 1 else null end)-COUNT(case Rating when 'Negatief' then 1 else null end))/(COUNT(case Rating when 'Positief' then 1 else null end)+COUNT(case Rating when 'Negatief' then 1 else null end)) AS NPS
FROM [FS Feedback]
WHERE EmailName != ''
GROUP BY EmailName