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

https://docs.google.com/spreadsheets/d/1SK-8BtrMLXWradfw70Rnu4IZm8ppuxPV/edit?usp=sharing&ouid=107351716570025173091&rtpof=true&sd=true

0. 메인 컬러

1. KPI 카드

Max Event Date

{MAX([Event Time])}

Event Period Week

Last 7 days 로 주요 kpi 필터링

IF [Event Time] >= [Max Event Date]-6 and [Event Time] <= [Max Event Date]
then "Last 7 days"
ELSEIF [Event Time] >= ([Max Event Date]-13) and [Event Time] < [Max Event Date]-6
then "Previous 7 days"
END

Max Install Date

{MAX([Install Time])}

Install Period Week

IF [Install Time]>= [Max Install Date]-6 and [Install Time] <= [Max Install Date]
then "Last 7 days"
ELSEIF [Install Time] >= [Max Install Date]-13 and [Install Time] < [Max Install Date]-6 
then "Previous 7 days"
END

1-1 AVG DAU

AVG DAU