Scarlet Moon DAU Event Difficulty Review

Executive Summary

Three of the four fully reviewable activities need tuning. Granat Scarlet and Jeep Scarlet set their core rewards too high. Toko Scarlet has an uneven ladder: the first grand prize is too easy, while collecting both equal-cost grand prizes is too difficult.
Login Weekend is appropriately tuned. Median50 players receive the first reward at their expected weekend activity level and unlock the second reward by adding one active day.
Three activities still lack enough detail for final approval. Purple Diamond has no setting; Special Interface has no stage thresholds or progress source; Local Campaign only describes a discount concept without a confirmed duration, reward list or price mapping.
Recommended priority: Granat → Jeep → Toko. Lower Granat's first playtime milestone to 15–18 minutes and fix the voucher inversion; make Jeep's GP reachable for the intended segment; align Toko so Median50 +1 can cover both equal-tier GPs.

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Activities listed

7

Named activities or defined concepts listed in the planning tab.

Named activities or defined concepts listed in the planning tab.Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Fully reviewable

4

Activities with enough mission, reward and threshold detail for a quantitative review.

Activities with enough mission, reward and threshold detail for a quantitative review.Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Tuning recommended

3

Fully reviewable activities that need a difficulty or reward-ladder adjustment.

Fully reviewable activities that need a difficulty or reward-ladder adjustment.Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Settings incomplete

3

Activities that still lack missions, thresholds, rewards or a confirmed duration.

Activities that still lack missions, thresholds, rewards or a confirmed duration.Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Portfolio view: the main issues are milestone gaps and uneven reward ladders

The chart answers one question only: after the intended incremental effort, how close is Median50 to the next meaningful milestone? Because the underlying units differ, use the chart to read the size of the gap and the event tables below as the approval authority.

Median50 attainment of the next key milestone after incremental effort

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Median50 attainment of the next key milestone after incremental effort data
Activity	Attainment	Incremental effort	Next key milestone	Expected result
Toko	83.3%	+1 match per active day	Both co-GPs, 24 token total	20 token
Granat	62%	+1 match per active day	First playtime reward, 30 minutes	18.6 minutes
Jeep	40%	+1 match per active day	Jeep GP, 15 token	6 token
Login Weekend	100%	+1 active day	Second login reward, 2 days	About 2.1 days; reached

Activity review overview

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Activity review overview
#	Activity	Open window	Mission / mechanic	Review conclusion	Key judgment
1	Purple Diamond	Jul 20–26 (calendar only)	Not provided	Insufficient information	No missions, rewards or thresholds; not reviewable
2	Special Interface	Aug 21–Sep 7	Five reward stages	Insufficient information	Stage thresholds, progress source and token conversion are missing
3	Toko Scarlet	Aug 24–Sep 7 (14 days)	Daily token / new gameplay + normal matches	Uneven reward ladder	Median50 baseline gets 1 GP; +1 remains 4 token short of the second equal-tier GP
4	Granat Scarlet	Aug 28–31 (3-day weekend)	Cumulative playtime	Clearly too hard	Median50 +1 reaches 18.6 minutes, below the first 30-minute playtime reward
5	Jeep Scarlet	Aug 31–Sep 7 (7 days)	Daily token / normal matches	GP too hard	Top30 baseline and +1 both earn 12 token, below the 15-token GP
6	Login Weekend	Sep 4–7 (3-day weekend)	Cumulative login	Reasonable	Median50 gets milestone 1 at baseline and milestone 2 with +1 active day
7	Local Campaign / DAUxRev	Sep 7–13 (calendar inference)	+2% discount per match, cap 90%	Early risk / setting incomplete	Provisional Median50 +1 reaches 11.1%; 90% requires 45 matches

1. Purple Diamond — Not reviewable yet

Conclusion: the setting is missing. The tab only shows a July 20–26 calendar slot. It does not provide missions, rewards, token rules, thresholds or formal start/end timestamps.

Required information: activity type, mission list, daily versus cumulative reset rules, reward costs and exchange limits. Difficulty should not be approved before those fields are complete.

Source: Monthly Plan Check - ID / Scarlet Moon DAU PlanTable: Monthly Plan Check - ID / Scarlet Moon DAU Plan!A1:AG51

Materializes the Special Interface stage rows read from Scarlet Moon DAU Plan!A1:AG51.

SELECT * FROM (VALUES
  (1, 'Photo Template (30D) + 3x In-Game Bonus', 'Filler'),
  (2, 'Photo Frame (30D) + Photo Sticker (30D)', 'Filler'),
  (3, 'Purple Gloo Wall', 'Pending cost'),
  (4, '2x Voice Pack (30D)', 'Pending cost'),
  (5, 'Purple Female Bundle', 'Final reward by position')
) AS special_interface(stage, reward, role)

2. Special Interface — Rewards are listed, but unlock logic is missing

Conclusion: the reward structure can be read, but difficulty cannot be quantified. The interface runs from August 21 to September 7 and lists five reward stages. It does not state the point/token requirement for each stage, the progress source, or how Event Tab currencies contribute to interface progress.

By final-stage position, the Purple Female Bundle is the headline reward. The other items cannot be reliably labeled GP or sub-GP without their actual costs.

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Special Interface reward stages

Source: Monthly Plan Check - ID / Scarlet Moon DAU PlanTable: Monthly Plan Check - ID / Scarlet Moon DAU Plan!A1:AG51

Materializes the Special Interface stage rows read from Scarlet Moon DAU Plan!A1:AG51.

SELECT * FROM (VALUES
  (1, 'Photo Template (30D) + 3x In-Game Bonus', 'Filler'),
  (2, 'Photo Frame (30D) + Photo Sticker (30D)', 'Filler'),
  (3, 'Purple Gloo Wall', 'Pending cost'),
  (4, '2x Voice Pack (30D)', 'Pending cost'),
  (5, 'Purple Female Bundle', 'Final reward by position')
) AS special_interface(stage, reward, role)

Special Interface reward stages
Stage	Reward	Provisional role
1	Photo Template (30D) + 3× In-Game Bonus	Filler
2	Photo Frame (30D) + Photo Sticker (30D)	Filler
3	Purple Gloo Wall	Pending cost
4	2× Voice Pack (30D)	Pending cost
5	Purple Female Bundle	Final reward by position

Information needed for review

Add each stage threshold, the source and daily cap of progress currency, and whether Toko, Jeep or other Event Tab activities jointly contribute to interface progress.

3. Toko Scarlet — The first GP is too easy, while collecting both GPs is too hard

Mission type: a 14-day daily-token activity. Login and Play 1/3 are normal activeness missions. Entering Scarlet Moon Realm and killing a Lead Wolf are new-gameplay participation missions, so they are assumed completable by any active player.

Reward identification: the two 12-token rewards have exactly the same highest cost and must both be treated as co-grand-prizes. The two 5-token voice packs are co-sub-grand-prizes. Median50 earns 16 token at baseline and can already redeem one GP without +1. With +1, Median50 earns 20 token but remains 4 token short of the second GP.

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Toko Scarlet — player activity reference

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Toko Scarlet — player activity reference
#	Player segment	Reference month	Scaling basis	Expected active days	Matches / active day	Baseline total matches	Total matches after +1/day	Average match minutes
1	Top30	August 2025	14 days / monthly activity	7.77	2.89	22.48	30.26	7.04
2	Median50	August 2025	14 days / monthly activity	4.36	1.56	6.79	11.15	6.59

Toko Scarlet — token and redemption outcome

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Toko Scarlet — token and redemption outcome
#	Player scenario	Expected active days	Token / active day	Total token	GP-first redemption
1	Top30 baseline	8	5	40	2 GPs + 2 sub-GPs + 6 fillers
2	Top30 +1 match/day	8	5	40	Same as baseline; no incremental reward
3	Median50 baseline	4	4	16	1 GP + 4 fillers
4	Median50 +1 match/day	4	5	20	1 GP + 1 sub-GP + 3 fillers; second GP short by 4 token

Recommendation

Reduce both co-GPs from 12 to 10 token, or add 4 reliably obtainable token across the 14-day event. This lets Median50 baseline redeem one GP and Median50 +1 redeem both, creating a cleaner incentive ladder.

4. Granat Scarlet — Clearly too hard; +1 match creates no incremental reward

Mission type: a three-day weekend cumulative-playtime activity using the August 2025 weekend active-day rate.

Top30 reaches about 37.8 minutes at baseline and 50.9 minutes after +1. Median50 reaches about 11.3 minutes at baseline and 18.6 minutes after +1. Neither segment crosses another reward milestone after the incremental effort. Median50 needs about 4.12 matches per active day to reach 30 minutes, roughly +2.57 matches above baseline.

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Granat Scarlet — player activity reference

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Granat Scarlet — player activity reference
#	Player segment	Reference month	Scaling basis	Expected active days	Matches / active day	Baseline total matches	Total matches after +1/day	Average match minutes
1	Top30	August 2025	3 days / weekend activity	1.86	2.89	5.37	7.23	7.04
2	Median50	August 2025	3 days / weekend activity	1.1	1.56	1.72	2.82	6.59

Granat Scarlet — cumulative playtime

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Granat Scarlet — cumulative playtime
#	Player scenario	Expected weekend active days	Minutes / active day	Total minutes	Reward obtained
1	Top30 baseline	1.86	20.4	37.8	2 login vouchers + 1 playtime voucher; 3 total
2	Top30 +1 match/day	1.86	27.4	50.9	Still 3 vouchers; no incremental reward
3	Median50 baseline	1.1	10.3	11.3	2 login vouchers only
4	Median50 +1 match/day	1.1	16.8	18.6	Still 2 login vouchers; no incremental reward

Recommendation

Lower the first playtime milestone from 30 minutes to 15–18 minutes so Median50 +1 can reach it.
Swap the first two voucher quantities: 1 voucher for login and 2 vouchers for the playtime milestone.
Keep 75/120 minutes as stretch milestones, but do not treat them as the primary reachable reward for the Event Tab target.

5. Jeep Scarlet — The sub-GP step works, but the GP is unreachable even for average Top30

Mission type: a seven-day daily-token activity made entirely of normal login and match-count missions. Play 5 must use the actual five-match threshold.

Top30 earns 12 token both at baseline and after +1, still 3 short of the 15-token GP. Median50 moves from 4 token at baseline to 6 after +1, which upgrades the outcome from fillers only to one 5-token sub-GP plus one filler.

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Jeep Scarlet — player activity reference

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Jeep Scarlet — player activity reference
#	Player segment	Reference month	Scaling basis	Expected active days	Matches / active day	Baseline total matches	Total matches after +1/day	Average match minutes
1	Top30	August 2025	7 days / monthly activity	3.89	2.89	11.24	15.13	7.04
2	Median50	August 2025	7 days / monthly activity	2.18	1.56	3.39	5.57	6.59

Jeep Scarlet — token and redemption outcome

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Jeep Scarlet — token and redemption outcome
#	Player scenario	Expected active days	Token / active day	Total token	End-of-event redemption
1	Top30 baseline	4	3	12	GP unreachable; 2 sub-GPs + 2 fillers at event end
2	Top30 +1 match/day	4	3	12	Same as baseline; GP still short by 3 token
3	Median50 baseline	2	2	4	4 fillers
4	Median50 +1 match/day	2	3	6	1 sub-GP + 1 filler

Recommendation

If the GP is intended to be reachable for average Top30, reduce its cost from 15 to 12 token or add at least 3 achievable token. The current 5-token sub-GP step works for Median50 +1 and can remain. If the GP is intended for Median50 +1, the current 6-versus-15 gap requires a much larger redesign.

6. Login Weekend — Appropriately tuned

Mission type: a three-day cumulative-login activity. It is evaluated on active days, not +1 match. Top30 is expected to be active for about 1.86 days and Median50 for about 1.10 days.

Median50 receives the first two vouchers at baseline and gains another two vouchers by adding one active day. Top30 receives four vouchers at baseline, while the 7-day trial gun skin requires full-weekend attendance. The ladder encourages one additional active day and preserves a full-attendance stretch reward.

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Login Weekend — player activity reference

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Login Weekend — player activity reference
#	Player segment	Reference month	Scaling basis	Expected active days	Matches / active day	Baseline total matches	Total matches after +1/day	Average match minutes
1	Top30	August 2025	3 days / weekend activity	1.86	2.89	5.37	7.23	7.04
2	Median50	August 2025	3 days / weekend activity	1.1	1.56	1.72	2.82	6.59

Login Weekend — active days and rewards

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Login Weekend — active days and rewards
#	Player scenario	Expected active days	Whole-day proxy	Reward obtained
1	Top30 weekend baseline	1.86	2	4 Gold Vault Vouchers
2	Top30 +1 active day	2.86	3	4 vouchers + 7D trial gun skin
3	Median50 weekend baseline	1.1	1	2 Gold Vault Vouchers
4	Median50 +1 active day	2.1	2	4 Gold Vault Vouchers

Recommendation

Keep the current setting. If rewards change later, preserve the requirement that Median50 needs roughly one additional active day for the second milestone.

7. Local Campaign / DAUxRev web event relaunch — Early indication that discount growth is too slow

Current information: discount starts at 0%, increases by 2% per match, caps at 90%, and does not reset daily. The calendar appears to cover September 7–13, but the formal duration, free-item thresholds, price mapping and target audience are missing.

Under a provisional seven-day assumption, Median50 reaches only about 6.8% at baseline and 11.1% after +1. Top30 reaches about 30.3% after +1. The 90% cap requires 45 matches, far above both benchmark segments.

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Local Campaign — estimated discount progress

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Local Campaign — estimated discount progress
#	Player scenario	Expected active days	Expected matches	Expected discount
1	Top30 baseline	3.89	11.24	22.5%
2	Top30 +1 match/day	3.89	15.13	30.3%
3	Median50 baseline	2.18	3.39	6.8%
4	Median50 +1 match/day	2.18	5.57	11.1%

Recommendation

Only a preliminary risk flag is possible. Add the formal duration, eligible modes, free-item thresholds, original prices and the value of each discount tier before confirming whether 2% per match is reasonable.

Recommended priority

Granat Scarlet: lower the 30-minute milestone and fix the voucher inversion.
Jeep Scarlet: define the intended GP audience; use 12 token or add 3 token if Top30 is the target.
Toko Scarlet: align the two equal-tier GPs, preferably 10 token each or +4 event token.
Complete missing settings: add thresholds and rewards for Purple Diamond, Special Interface and Local Campaign before final approval.
Login Weekend: no change required.

Questions to resolve

Should Median50 +1 obtain one Toko GP or both equal-tier GPs?
What are the Special Interface thresholds and progress sources for each stage?
What are the formal Local Campaign dates, products, free-item thresholds and discount values?
Will Purple Diamond receive a complete Event Info setting, or has it moved out of this review?

Method and assumptions

Scarlet Moon is concentrated in August, so all campaign reviews use ID August 2025 activeness.
The Calculator monthly denominator remains fixed at 33; only the event-open-day input changes.
Discrete daily-token calculations round expected active days to whole days; cumulative playtime keeps fractional active days.
Friday–Sunday events use avg_active_days_weekend; August 2025 contains 10 Saturday/Sunday days.
New-gameplay participation missions are assumed completable by all active players. Normal match/playtime missions use their actual numeric thresholds.
Results use segment averages. Distribution affects borderline players, but the Granat and Jeep gaps are large enough that the directional conclusions are robust.

Source: Scarlet Moon review calculation notesTables: Monthly Plan Check - ID / Scarlet Moon DAU Plan, [C3][FF] User Ops Guideline v 1.0 / Monthly Raw Data, DAU Plan Review 2026-05 / Calculator, [C3][FF] User Ops Guideline v 1.0 / User Operation Guideline

Materializes the reviewed spreadsheet calculations used by the report. The underlying Google Sheets values and formulas are documented in the linked calculation notes.

SELECT * FROM (VALUES
  ('portfolio_metrics', 1, 'All activities', 'Named activities', 7.0, NULL, '7 named activities'),
  ('portfolio_metrics', 2, 'All activities', 'Fully reviewable', 4.0, NULL, '4 fully reviewable'),
  ('next_milestone_attainment', 1, 'Toko', 'Median50 +1 match/day', 0.8333, 20.0, '20 of 24 token'),
  ('next_milestone_attainment', 2, 'Granat', 'Median50 +1 match/day', 0.6203, 18.6, '18.6 of 30 minutes'),
  ('next_milestone_attainment', 3, 'Jeep', 'Median50 +1 match/day', 0.4000, 6.0, '6 of 15 token'),
  ('next_milestone_attainment', 4, 'Login Weekend', 'Median50 +1 active day', 1.0000, 2.1, '2.1 of 2 active days'),
  ('toko_results', 1, 'Toko', 'Top30 baseline', 40.0, 5.0, '2 GP + 2 sub-GP + 6 fillers'),
  ('toko_results', 2, 'Toko', 'Median50 baseline', 16.0, 4.0, '1 GP + 4 fillers'),
  ('toko_results', 3, 'Toko', 'Median50 +1 match/day', 20.0, 5.0, '1 GP + 1 sub-GP + 3 fillers'),
  ('granat_results', 1, 'Granat', 'Top30 baseline', 37.8, 1.86, '3 vouchers'),
  ('granat_results', 2, 'Granat', 'Top30 +1 match/day', 50.9, 1.86, '3 vouchers'),
  ('granat_results', 3, 'Granat', 'Median50 baseline', 11.3, 1.10, '2 vouchers'),
  ('granat_results', 4, 'Granat', 'Median50 +1 match/day', 18.6, 1.10, '2 vouchers'),
  ('jeep_results', 1, 'Jeep', 'Top30 baseline', 12.0, 3.0, '2 sub-GP + 2 fillers'),
  ('jeep_results', 2, 'Jeep', 'Median50 baseline', 4.0, 2.0, '4 fillers'),
  ('jeep_results', 3, 'Jeep', 'Median50 +1 match/day', 6.0, 3.0, '1 sub-GP + 1 filler'),
  ('login_results', 1, 'Login Weekend', 'Top30 baseline', 1.86, 2.0, '4 vouchers'),
  ('login_results', 2, 'Login Weekend', 'Median50 baseline', 1.10, 1.0, '2 vouchers'),
  ('local_campaign_results', 1, 'Local Campaign', 'Top30 baseline', 11.24, 22.5, '22.5% discount'),
  ('local_campaign_results', 2, 'Local Campaign', 'Median50 +1 match/day', 5.57, 11.1, '11.1% discount')
) AS review_snapshot(dataset, row_order, activity, scenario, metric_value, comparison_value, result)

Executive Summary

Portfolio view: the main issues are milestone gaps and uneven reward ladders

1Source for 1Source: Monthly Plan Check - ID / Scarlet Moon DAU PlanTable: Monthly Plan Check - ID / Scarlet Moon DAU Plan!A1:AG51. Purple Diamond — Not reviewable yet

Information needed for review

Recommendation

Recommendation

Recommendation

Recommendation

Recommendation

Recommended priority

Questions to resolve

Method and assumptions

Sources

1. Purple Diamond — Not reviewable yet