Strategy
History
Month | (KPI) Active Paying Users | Growth rate |
June 2023 | 662 | |
May 2023 | 677 | 3.2%  |
Apr 2023 | 656 | |
Mar 2023 | 734 | 17.6% |
Feb 2023 | 624 | 15.5% |
Jan 2023 | 540 | 17.6% |
Dec 2022 | 459 | 13.6% |
Nov 2022 | 404 | 2.6% |
Oct 2022 | 415 | 10% |
Sep 2022 | 377 | 3.9% |
Aug 2022 | 363 | -1% |
July 2022 | 367 | -5.9% |
Jun 2022 | 390 | 3.4% |
May 2022 | 377 | -2.8% |
Apr 2022 | 388 | -0.5% |
Mar 2022 | 386 | 45% |
Feb 2022 | 265 | 2.7% |
Jan 2022 | 258 |
Calculation
SET @target_month = '2023-05-01';
SELECT COUNT(*) FROM (
SELECT * FROM payment
WHERE start_date < DATE_ADD(@target_month, INTERVAL 1 MONTH) AND end_date > DATE_ADD(@target_month, INTERVAL 1 MONTH) AND amount > 0 AND payment_key NOT LIKE '%daypass%'
GROUP BY user_id
) as temp
SQL
복사