scorecard-update

patniko 的头像作者 patniko

审查Azure Data Explorer仪表板中的Copilot CLI指标,并更新Google Sheets评分卡。连接到现有的Chrome会话进行身份验证。

📖 中文导读:审查Azure Data Explorer仪表板中的Copilot CLI指标,并更新Google Sheets评分卡。连接到现有的Chrome会话进行身份验证。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: scorecard-update description: Review Azure Data Explorer dashboards for Copilot CLI metrics and update Google Sheets scorecard. Connects to existing Chrome session for authentication. license: MIT compatibility: Requires Node.js, Playwright, and Chrome running with --remote-debugging-port=9222 metadata: author: patrick version: "1.0" allowed-tools: bash node

Scorecard Update

Review Copilot CLI metrics from Azure Data Explorer dashboards and update the Google Sheets scorecard.

Prerequisites

Before using this skill, start Chrome with remote debugging:

# macOS
/Applications/Google\ Chrome.app/Contents/MacOS/Google\ Chrome --remote-debugging-port=9222

# Then log into your Azure and Google accounts in that browser session

Workflow

This skill follows a review-before-update workflow:

  1. Read scorecard → Identify which Copilot CLI metrics need updating
  2. Capture dashboards → Screenshot and extract data from Azure Data Explorer
  3. Generate summary → Create a review document with proposed updates
  4. Human review → You approve/modify the proposed changes
  5. Update scorecard → Apply approved changes to Google Sheets

Data Sources

Dashboards (Azure Data Explorer)

Dashboard Purpose
Launch Metrics Metrics since launch date
30-Day Trends Rolling 30-day window
Overview General dashboard view

Scorecard (Google Sheets)

Copilot CLI Scorecard

Quick Start

# 1. Ensure Chrome is running with debugging port (see Prerequisites)

# 2. Install dependencies (first time only)
cd scorecard-update && npm install

# 3. Run the workflow
node scripts/workflow.js

Step-by-Step Instructions

Step 1: Read the Scorecard

Connect to Chrome and navigate to the scorecard to identify metrics that need updating:

// The script will:
// 1. Open the scorecard
// 2. Find the Copilot CLI section
// 3. List metrics and their current values
// 4. Identify which need updating (blank, outdated, etc.)

Step 2: Capture Dashboard Data

For each dashboard, the script will:

  1. Navigate to the URL
  2. Wait for charts to render
  3. Take a screenshot
  4. Extract visible metrics/numbers from the page

Step 3: Review Summary

Before any updates, you'll receive a summary like:

## Proposed Scorecard Updates

| Metric | Current Value | New Value | Source |
|--------|---------------|-----------|--------|
| DAU    | 1,234         | 1,456     | 30-Day Dashboard |
| ...    | ...           | ...       | ... |

Screenshots saved to: ./screenshots/

Please review and confirm before updating.

Step 4: Update Scorecard

After your approval, the script navigates to the scorecard and updates the specified cells.

Scripts

Script Purpose
workflow.js Main orchestrator - runs full workflow
connect.js Connect to Chrome debugging session
capture-dashboards.js Screenshot and extract dashboard data
read-scorecard.js Read current scorecard values
update-scorecard.js Write updates to scorecard

Output Files

scorecard-update/
├── screenshots/           # Dashboard screenshots (timestamped)
├── data/
│   ├── scorecard-current.json   # Current scorecard state
│   ├── dashboard-data.json      # Extracted dashboard metrics
│   └── proposed-updates.json    # Summary for review
└── summaries/
    └── YYYY-MM-DD-summary.md    # Human-readable summary

Notes

  • All changes require human approval before applying
  • Screenshots provide audit trail of data sources
  • The script waits for Azure dashboards to fully render (they can be slow)
  • If a metric can't be automatically extracted, it will be flagged for manual review