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.