비즈니스 시나리오 제작 가이드 템플릿

https://docs.google.com/spreadsheets/d/1pfoYmC5WSHPN9XeiRE3442C_Mi71a0DS/edit?usp=drive_link&ouid=107351716570025173091&rtpof=true&sd=true

0. 컬러

1. 필터

Date Period

IF [Date] <= {MAX([Date])} AND [Date] >= {MAX([Date])}-29 
then "last 30 days"
ELSEIF [Date] <= {MAX([Date])}-29 AND [Date] >= {MAX([Date])}-58 
then "previous 30 days"
end

2. KPIs

2-1. 발송 성공률

Deliveryrate

SUM([발송성공])/SUM([발송])

DeliveryrateCM

SUM(IF [Date Period] = "last 30 days" then [발송성공] END)
/ 
SUM(IF [Date Period] = "last 30 days" then [발송] END)

DeliveryratePM