Setting Up a Consistent Character Archive

Genshin Impact Build Journal Yearly is a way to track every build you attempt across the entire game year, not just the meta recommendations you see online. Most players document one or two characters at a time. The yearly approach consolidates everything into a single reference point. That changes how you collect data and how you use it later. I started keeping a consolidated log after the 4.0 release when I had more active characters than I could reasonably manage in my head. The system is simple on paper, but the execution creates problems most people don't anticipate until they've already wasted materials. The journal lives in a spreadsheet. I use Google Sheets because it syncs across devices and I can access it mid-pull on my phone. Each character gets a dedicated tab. The columns I actually use are narrow and specific:

Character Name | Path | Weapon | Gacha Source Date | Constellation Level | Artifact Set(s) | Substat Priority Applied | Refinement Tier | Result Rating | Notes "Result Rating" is a one-word summary after three combat tests: viable, solid, optimal, or replace. "Notes" captures anything the spreadsheet format can't express—specific domain days, wish pity state, or whether a particular stat roll on a piece was an outlier worth mentioning. The first mistake people make is tracking too many detail columns. They create fields for main stat, percent HP, crit rate, and every substat on every artifact piece. This takes roughly twenty minutes per build and the data decays fast because artifact RNG doesn't follow a predictable pattern. I stopped tracking individual piece rolls around late 2023. Instead I track aggregate outcome: how many runs it took to hit target substat thresholds and whether the final set performed above or below expectation for the character's role.

Here is a specific edge case that cost me six hours last year. I was logging Kazuha builds across two different regions—Viridescent Venerer for support and Golden Wind Reverie for a damage-focused approach. The spreadsheet columns didn't capture that the two builds required different secondary stats because Kazuha's Elemental Burst scales differently with CRIT versus Elemental Mastery depending on team composition. I wrote both builds down identically in the notes column because I focused on the artifact set and weapon. When I pulled him out for an Abyss run with a different team composition, the build I recorded as "solid" performed poorly because the underlying stat priority had shifted. The workaround was to add a "Primary Stat Focus" column to every character tab that records whether the build prioritizes ER, EM, CRIT, or ATK based on the actual team role, not just the artifact set name. This took about two minutes to add and prevented every similar error after that. A counter-intuitive insight most beginners miss: refinement level matters more than artifact quality for many off-meta characters. I tracked Fischl builds across four refinement tiers of Nighthawk. The jump from Ref 1 to Ref 3 produced a noticeably larger DPS increase than swapping her artifact set from a 4-piece Wanderer's Troupe to a 2+2 hybrid. The spreadsheet captured this clearly when I added a "Refinement Delta" field to compare performance at each tier. Most players never record this because they assume artifact swaps are the primary optimization lever. For Fischl specifically, and for several other characters in the 3-star and 4-star weapon pool, the data shows the opposite. Another thing nobody emphasizes: tracking weapon ascension material costs per build matters for resource planning. A full refine 5 of a signature weapon plus optimal artifact rolls costs approximately 144 precious ores per weapon and 360+ hero's wit per character across all enhancement materials. If you log these costs alongside each build attempt, you can see your actual annual expenditure and plan material farming more efficiently. I estimate this tracking saves roughly 15 to 20 primogems per month by preventing unnecessary refines on weapons you don't actually need at higher tiers.

Get the Full Details

17/09 Journal -# EndlessJourney Genshin Impact | HoYoLAB
17/09 Journal -# EndlessJourney Genshin Impact | HoYoLAB

The yearly format creates a bottleneck around the 6-month mark. By that point, your spreadsheet has enough data that scrolling becomes slow and the format starts to obscure patterns. I solved this by adding a "Year Summary" tab that auto-calculates from all character tabs: total builds attempted, average result rating, total primordial jades spent on gacha for tracked characters, and total material cost. This summary tab reduces what used to take me ten minutes of manual review down to about thirty seconds of visual scanning. There are scenarios where this approach fails entirely. If you play casually and only maintain three or four characters at any given time, the overhead of maintaining a yearly journal isn't justified. The system shines when you're pulling multiple new characters per banner cycle and rotating team compositions frequently. It also fails for players who don't own a computer and rely exclusively on mobile play. The spreadsheet approach requires a desktop workflow for data entry efficiency. Mobile entry is possible but adds significant friction that breaks the habit for most people. I maintain my journal through the current version using the same spreadsheet template. The system has been stable for over a year of updates and expansions. The core value is the pattern recognition you gain after the sixth or seventh character. You start seeing substat distribution trends across artifact domains that the game's UI never reveals. That's the practical benefit of tracking builds at this scale. The raw numbers become actionable data instead of abstract opinions.