PUGC Tracking

Google Sheets performance dashboard

Sign in

No permission

No permission to access this website.

0. Overview

Data Sheet / Map

Display Range

Reads the selected map and aggregates all available regions. AI commentary is intentionally omitted.

Game Change Log Summary

Recent completed updates, next update, and planning items from the configured Game Design Document.

Daily Trends

Global daily values, all available regions aggregated.

Daily Data

R2 Tier 1 Scenario

Target: weighted R2 ≥ 40%

Quick Analysis (rule-based)

Window

Month-to-Month Comparison

Monthly averages of the daily per-map values. The latest month may be partial.

Monthly Data

Week-to-Week Comparison

Weekly values from the selected map. The latest week may be partial.

Weekly Data

Jump to section

1. Data Filters

Data Sheet / Map

Start Date

Lock 1 Week

End Date

Comparison Start Date

Comparison Lock 1 Week

Comparison End Date

week(s)

2. Map Performance Data By Region

3. WoW Comparison

Show diff only

Jump to section

1. Data Filters

Data Sheet

Start Date

End Date

Region

Select All Region for the total view, or one region for daily data.

2. Performance Chart

3. Daily Chart Table

Jump to section

1. Data Filters

Map

Start Date

End Date

Region

Select All Region for the total view, or one region for weekly data.

2. Performance Chart

3. Weekly Chart Table

4. Change Logs Analysis

Comparison windows are automatic: previous-cycle length before the update vs the same number of days after it, shortened when the next update or latest data arrives earlier.

Project (Map)

Change log range

Change Log Effectiveness

Sort

5. Map Comparison

Compare two projects over independent timelines. Useful reads: compare scale (DAU/DNU/Revival7), quality (R2), session depth (survival time), and match loop (Avg Match Cnt where available).

Project 1

Project

Start Date

End Date

Project 2

Project

Start Date

End Date

Map Comparison Result

97. Overall - Official Maps Performance

Private overall table for official maps. Source sheet, filters, and fields are configured in config/official_maps.json.

Map Name

Default visible fields: Date, DAU, R2, R7, Avg Survival Time (minutes), Avg Match Cnt.

Official Maps Data

98. AI Settings

Add an AI explanation on top of the rule-based Quick Analysis (0.Overview). Choose one of three modes below. With your own key, it is stored encrypted per user and never shown back in full.

Don't use AI — Quick Analysis stays rule-based only (default). Use built-in AI — the pre-configured provider, no key needed. Use my own AI API — pick a provider and paste your key.

Provider

Model

API Key

Base URL (optional / for custom)

Max tokens

Temperature

How to get an API key

99. Admin Config

All settings are saved to config/admin_config.json. Sections are collapsed by default — click a header to expand.

1.Sheet Config

Configure data sheets and their reading rules.

2.Group Config

Manage user groups. The Admin group members can open this Admin tab and bypass all data restrictions.

Admin Emails (full admin access)

Groups

3.Permission

For each group, choose which data sheets and regions members may read. Default: all sheets and all regions enabled.

4.Map Performance Field Config

Configure the metric groups and fields shown in 1.Performance Comparison. Saved to config/app_config.json (dashboard.metric_groups and wow_comparison.metric_groups).

Map Performance Data By Region (Performance Comparison tab 2)

WoW Comparison (Overview tab 3)

In WoW each field renders three columns: <Label> 2, <Label> 1, and Diff <Name>.