Intro
Hello there!
So, you're interested in what's in the CSV export? You've come to the right place!
This page was first written to accompany the v2.0.1.3 update, which drastically changed the format of the exported CSV file. It has since been updated and maintained to keep track of all variables within the CSV file format.
Here's how to export the match report from the R6 Analyst app, in case you didn't know:
Documentation and Example
If you'd rather just dive in yourself
Here's an example .CSV export in Google Sheet format:
The first worksheet shows the export exactly as it comes out of the app.
The second worksheet shows a neatly formatted version of the same export. I'd recommend using it as a starting point for your own importation system.
Scroll down for an explanation per variable.
Why this Format?
A reason for why the format is like this
I received a lot of feedback from a wide range of users on how to format the CSV. Based on that, concensus on a rework concept was reached which focused on:
- Ease of use for a variety of software (SQL, Databases, Excel, Google Sheets, Others)
- Structured data display logic, low data redundancy
- Consideration of what PL and CL staff wants to look at.
- Fixed data placement (for automatic imports, exports, advanced ETL)
Documentation per Variable
A note about empty rows
Each "table" of data is filled to the maximum possible length, to ensure the table below it always starts on the same cell. E.g. PLAYER ROUNDS DATA always starts on cell A55.
A note about timing
Depending on the shittyness of the participating players' PCs, all the tracked timings could be off by upwards of 2000ms, as the scene loading cannot be taken into account.
A note about operator names
The following Operators can potentially appear incorrectly named, due to character encoding limitations inherent to the .CSV filesystem.
- Jäger could appear as Jäger
- Capitão could appear as Capitâo
- Nøkk could appear as Nøkk
SEP=
Technical code used by Excel to set "separator" symbol for different localizations. Ignored by Google Sheets, and you should ignore it too (you can delete it if you want).
Integrity Verification
Use https://r6analyst.com/verify-match-data to verify a given .csv export is unaltered and accurate.
Match ID
Unique ID key for this match, for database storing purposes.
Timestamp
Time when the first round begun. Local time for Custom matches, UTC for Ranked/Unranked/etc.
ATK at Start
Which team started on Attack.
Team X ATK/DEF Wins
Number of rounds that Team X won on Attack/Defence.
Team X Score at Half
The score of Team X at the first side-switch (half-time).
Team X ATK/DEF Op Ban v2.1.0.17
The Attacker/Defender Operator Ban performed by Team X.
"unknown" when tracking failed.
"none" when No Ban was performed.
Player Rating
Rating for this player for this match. Based on a reverse-engineered formulae similar to Siege.GG. See here for details.
ATK/DEF Rating
Rating for this player based solely on their Attack/Defence rounds.
K-D (+/-)
Kills - Deaths (difference).
Entry (+/-)
Opening Kills - Opening Deaths (difference).
Shows the effectiveness of this player on first contact with the enemy.
Trade Diff.
Trade Differential.
Untraded Kills minus Untraded Deaths.
Higher means they had a more positive effect on their team's man-advantage.
KOST
Percentage of rounds in which this player either got a Kill, planted or defused (Objective), Survived, or got Traded out when dying.
KPR
Kills Per Round
Number of kills divided by number of rounds.
SRV
Percentage of rounds in which the player survived until the end of the round.
HS%
Headshot percentage.
Number of headshot kills divided by total number of kills for this player.
ATK/DEF Op
Most played Attack/Defence Operator.
Kills
Total kills this match.
Refrags
Total refrags this match.
Refrag is when this player killed an enemy that just killed a friendly within the trade time window.
The trade time window is 10 seconds by default, but can be customized in the App Settings for Custom Matches.
Headshots
Total number of headshot kills.
Underdog Kills
Total number of kills at a time when this player's team was at a man disadvantage.
1vX
Number of 1vX clutches won by this player.
Adhering to Siege.gg definition, a 1v1 does count as a 1vX clutch.
Multikill Rounds
Number of rounds where this player got more than 1 kill.
Deaths
Total number of deaths.
Traded Deaths
Deaths where the player was traded out soon after (within the Trade Window, which is 10sec by default, but can be changed in the App Settings for Custom Match tracking).
Traded by Enemy
Number of deaths where player just got a kill but then was killed by an enemy. This is known as Traded Kill within the app.
Opening Kills
Number of times where this player got the first kill of the round.
Opening Deaths
Number of times where this player was the first player to die in a round.
Entry Kills
Number of times where this player was the first on their team to get a kill in the round.
Entry Deaths
Number of times where this player was the first on their team to die in the round.
Planted Defuser
Number of times this player planted the Defuser.
Disabled Defuser
Number of times this player disabled the Defuser.
Teamkills
Number of teamkills committed by this player.
Teamkilled
Number of times this player was teamkilled this match.
In-game Points
The in-game points as given by Ubisoft for all manner of things. From using utility to getting assists to spotting the bomb on drone.
Sixth Pick Overview
An overview of the Sixth-Picks performed. This is only relevant for Custom Matches.
Note that if the app is run by a player, the app only tracks Operator selection for teammates, not the enemy. This includes Sixth Pick tracking.
Run the app as spectator to get both team's Operator selections and Sixth-Picks.
Winner (in Sixth Pick)
Which team ended up winning the round.
Site
What was the Objective Site for this round?
This needs to be manually tracked by the app user by means of a prompt, which can be enabled in the Settings.
Result (in Player Rounds Data)
Whether this player's team won or lost the round.
Round Time (ms)
Number of milliseconds since start of Prep-phase until the round ended, or until the Defuser was planted, whichever occurs first.
Victory Type
Type of round ending.
- Defuser Disabled - Defuser was planted, and Defence won the round.
- Defuser Planted - Defuser was planted, and Attack won the round.
- Elimination - Defuser was not planted, and all players on a team died.
- Time Limit Reached - Defuser was not planted, and the time-limit (3mins for most gamemodes) was reached before all players on a team were killed.
Operator
Which Operator was played by this player in this round.
Note that the app can only track teammates' Operators when run as a player.
Run as a Spectator to track everyone's Operator use.
Time Spent Alive (ms)
Number of ms since start of Prep-phase until this player died this round.
'-' when the player didn't die.
Refragged By
Name of teammate that refragged this player's death within the Trade Time Window.
Last Alive v2.0.5.2
Whether this player was the Last Alive for his team.
1 or 0.
Another definition would be whether this player got into a 1vX situation (regardless of if they won it).
Drones Deployed v2.0.9.1
The number of Drones Deployed.
Either 1 or 2.
This and the below four drone stats only takes into account default Attacker drones, NOT Twitch or Flores drones.
This and the below four drone stats are only tracked for the LOCAL PLAYER, meaning the player that is running the app.
Drone Survived Prep Phase v2.0.9.1
Whether the Prep Phase Drone survived into the Action Phase.
TRUE or FALSE
Drone Found Bomb v2.0.9.1
Whether either drone was the first to spot either bomb.
TRUE or FALSE
Total Droning Distance v2.0.9.1
How many meters in total were driven with both drones this round.
Total Time Drone Piloting v2.0.9.1
How many milliseconds in total were spent in own owned drones this round.
Yellow Ping Leading To Kill v2.0.9.1
Whether the player placed a Yellow Ping (Z-ping) close to an enemy, with this enemy dying soon after, in this round.
TRUE or FALSE
Both yellow pings from Drone as well as in person count. Specifically, a yellow ping must be placed within 5 meters distance from the enemy, and the enemy must die within 15 seconds after placing the ping.
Time into Round (ms)
Milliseconds into the round (from start Prep-phase) that this event occured.
VOD Time
Timestamp as shown on the screen during this event. Useful for VOD review.
For prep phase events, remove 03:00 from the clock.
Negative numbers mean the event happened after the original 3 minute round time is ended (so events occuring whilst the plant is down in round overtime).
Actor
Who performed the event.
Victim
Who was the "victim" of the event (e.g. who died in this kill)
Blue/Orange Team Alive
How many players were alive on Blue/Orange team when this event took place.
This stat assumes 5 players are on each team at the start of each round.
Kill Subtype
Subtype for kill events.
- Entry Kill - First kill this round for this team.
- Refrag - Killed an enemy that just killed a teammate within the Trade Window.
- Teamkill - Killed a teammate.
- Suicide - Killed themselves.