Game Center Tracking CSV
Paste the following prompt into your AI chat to install this skill:
Please follow https://skillhub.cn/install/skillhub.md to install @user_d786d32b/tracking-skill into your AI assistant.
About this skill
Problem
Game Center tracking docs often drift because inputs are scattered: oper_id, game_id, and activity_id lack a source, page_name and element_level naming is inconsistent, paired exposure/click events are missing, and CSV files break Chinese text in Excel. This skill targets tracking doc generation, completion, and review, turning Figma, PRDs, screenshots, and existing CSVs into a deliverable table without inventing business facts.
How It Works
- Reads
references/tracking_spec.md,references/example_patterns.md, andassets/tracking_template.csvto confirm column order, required fields, and extension-field semantics. - Extracts pages, modules, elements, interactions, and events from the source material, then builds an event matrix for page show/hide, module exposure, element exposure/click, playback, scroll, and download.
- Populates
page_name,module_name,element_name,element_level,game_id,activity_id,adtag, andext1-ext25according to the spec. - Leaves unknown fields empty or marks them as “to confirm” rather than fabricating
oper_idor business parameters. - Uses
scripts/tracking_csv_tool.pyto generate a template, writeoutput.csv, and runvalidate, then revises errors and warnings.
Boundaries
The skill relies on the stated spec and reference patterns, so it works best when Figma, PRD, screenshots, or an old CSV are available. Missing real oper_id, entry source, dynamic parameters, or navigation targets should remain pending. Complex permission states, failure states, and cross-page state machines still need human source checks.
Use Cases
- Extract Game Center events from Figma and PRDs to generate a spec-compliant tracking CSV.
- Fill missing events in existing tracking CSVs and align page_name, element_level, and ext fields.
- Validate CSV column order, required fields, exposure/click pairing, and pending sources before delivery.
- Map screenshots and flows to buttons, lists, and overlays to produce a test-ready tracking sheet.
Best For
- Product owners for Game Center revisions who need PRDs and page designs turned into review-ready CSVs.
- Testers checking tracking fields and event levels who need missing exposures and naming drift caught pre-delivery.
- Frontend or client engineers maintaining data semantics who need to avoid invented oper_id and business params.
- Analysts collecting reports who need a fixed-column CSV ready for import.
Related Skills
Turns files, references, or chat context into styled single-page HTML reports with built-in templates and preset themes.
An engineering-oriented email automation solution for batch sending, Jinja2 templates, attachments, scheduled sending, inbox monitoring, and rule-based auto-reply.
An engineering workflow for creating, editing, reviewing, analyzing, and image-converting .docx files using pandoc, docx-js, OOXML, and LibreOffice.
Pre-submission scanner for Word/PDF blind-bid files that checks margins, fonts, page numbers, and metadata against tender requirements and flags residual bidder identities.