War Room — Knights of Good

Weekly Clan Participation Trend

Promote / Keep / Watch / Warn / Kick

This Week — Joined

This Week — Left

Member Database

— members

Name	Tag	Role	Status	🏆 Trophies	Rank	First Seen	Last Seen	Notes

Click any player to open their profile.

Player Profile

Weekly War Tracking

Wk	Name	Tag	Thu	Fri	Sat	Sun	Used	Possible	Part. %	Movement

Recommendations

Based on trailing 4-week and 8-week participation

Name	Tag	4-Wk Avg	8-Wk Avg	Reliability	Perfect Streak	Poor Streak	Recommendation

Reliability Dashboard

Leader-only · scores, streaks, and action queues

Longest Active Perfect Streaks

Longest Active Poor Streaks

🏅 Promotion Queue

0

⚠ Warning Queue

0

🚫 Kick Queue

0

🆕 New Recruits Under Review

0

Clan Rating

Overall health score for the selected scope

— out of 100

—

Weighting: 60% war participation · 15% consistency · 10% longevity · 10% promotion follow-through · 5% leader bonus (a manual modifier you set in the Settings tab). This is one reasonable way to combine those five inputs into a single number — adjust the weights in dashboard.js (RATING_WEIGHTS) if you'd score your clan differently.

Leaderboard

Top 10 Most Reliable

Bottom 10

Promotion Candidates

Kick Candidates

New Players Under Review

Charts

Weekly Clan Participation Trend

Perfect Players Per Week

Missed Attacks By Week

Active vs Inactive Members

Promote / Keep / Watch / Warn / Kick Breakdown

Recruitment

Movement history · never deleted, only re-classified

Recruitment Comparison — when a leaver is followed by a joiner

Pairings marked "Suggested" are guessed by timing (same role, joined within 30 days of a departure) — confirm or correct them by setting Invited By / Notes on the Members tab for a definitive link.

Full Movement History

Name	Tag	Joined	Left	Status	Invited By	Reason For Leaving

Leadership Action Log

Permanent record · every promote, warn, kick, and note

Log a New Action

Weekly Report

⏳ Reserved for AI Generation

📋

This page is intentionally empty for now

Once AI reporting is wired in, a fresh summary will appear here automatically after each war week closes — pulling from the same data already powering the rest of this dashboard.

Clan participation summary
Top performers this week
Players missing attacks
Promotion recommendations
Warning list
Kick list
New recruits
Overall clan performance narrative

Sync Clan

Keep Members database current — always identified by Player Tag, never by name

Export your clan data from your Clash Royale management tool (the CSV format used in this export: tag, name, role, lastSeen, expLevel, trophies, arena_*, clanRank, previousClanRank, donations, donationsReceived, clanChestPoints). Drop the file below or click to browse.

📄

Drop your clan CSV here

or click to browse

⚔ Import War Screenshots ⏳ Coming Soon

1Select Battle Day

2Upload 5–6 screenshots

3AI extracts player data

4Data writes to War_Log

5Dashboard refreshes

Enter war data in the War_Log tab directly for now.

Connect Your Apps Script API

This dashboard reads through a Google Apps Script Web App, not directly from the sheet. The script lives in your Google Sheet and exposes a single URL the dashboard calls for data. See README.md for the full Apps Script deployment walkthrough — short version below.

In your Google Sheet: Extensions → Apps Script, paste in Code.gs from this project.
Deploy → New deployment → Web app. Execute as Me, access Anyone.
Copy the Web App URL it gives you.
Paste it below along with your Leader Key (set in the sheet's Settings tab) and click Save & Reload.

Apps Script Web App URL:

Leader Key:

Tabs expected in the sheet: Members, War_Log, Weekly_Summary, Recommendations, History, Settings, OCR_Import. Only Members and War_Log are required for the dashboard to function — the rest can stay empty until you need them.

Loading Clan