We use cookies on this site to enhance your user experience

Analyzing Revenue Data

Analyzing Revenue Data

Nov 02 2018, 2:26 PM PST 15 min

The Developer Stats page has an option to download a spreadsheet of revenue data for each month. You can use this spreadsheet to create graphs that show you your top earning items and ways you can optimize your game’s revenue.


The spreadsheet contains detailed data about transactions that occurred in your game. You can use this to drill down and find very specific details about how your game is monetizing. For example, you can see how many people bought a specific item on their phone, or what percentage of your revenue comes from Game Pass sales or Developer Product sales. By looking at these numbers, you can find which strategies for monetizing your game are the most efficient.


Go to the Develop page and click on the gear icon next to the game you want to download the stats for. After the drop down menu opens, click on Developer Stats.


On the Developer Stats page, click on the Data Export tab and select the month you want to download, then click the Download button. After the CSV has finished generating, the green button will change from Generating to Download.


Once you have downloaded the .csv file, open it up in your favorite spreadsheet editing program. The page contains instructions for using Microsoft Excel 2014, but you can also use Google Docs or OpenOffice.


You will notice that the spreadsheet does not contain a row for every sale that occurs. Instead, the data is bucketed by day. That means if there were two sales of the same item on the same day, they are going to appear as a single row. For example, if two players joined my game and both bought the same item on the same day, there would only be one row in the spreadsheet, and the SalesVolume would be 2.

Column Name Description Example Notes
PlaceId The ID of the place in which the transaction took place 1818
PlaceName The name of the place in which the transaction took place Crossroads
GameId The ID of the game (universe) in which the transaction occurred 38625144
GameName The ID of the game (universe) in which the transaction occurred Crossroads
ItemId The product ID of the item that was sold. 1492051 This is an internal Roblox ID and is not the same as asset ID
ItemName The name of the item that was sold Jet Boots
ItemType The type of item that was sold Developer Product, Game Pass, Hat, Gear, Face, etc
Date The day that the sale occurred on 2015_08_01
SalesVolume The number of sales of the item 68
Impressions If the row displays Ad Impressions, this is the number of times the mobile video ad was viewed 140
Revenue The profit that you made from the item 1280 Before 8/6/2015, commission revenue was incorrectly logged as 70% of total price. On 8/6/2015, it started being correctly recorded as 10% of total price.
RevenueSource Whether the revenue was from a sale or an ad impression Transactional or Ad Impressions
Device The type of device the player was on Computer, Tablet, or Phone

Microsoft Excel or Google Sheets

Open the file in Microsoft Excel. It should look something like this.


Creating a Pivot Table

A pivot table is a tool in Microsoft Excel that you can use to easily summarize and aggregate data from the larger table. With a pivot table, you select a subset of the table to examine, and you can easily create interactive graphs.

To create a pivot table, select the entire data table. The easiest way to do this is to click on one of the cells in the table and use the Ctrl+A shortcut to select all. Next, click the Insert tab, and click on Pivot Table. The Table/Range will already be filled in. Choose New Worksheet for the location you want the PivotTable to be placed.


Using Pivot Tables

Now that you have a Pivot Table, you can duplicate it and create different tables for different stats. Clicking on any cell in the Pivot Table brings up a pane which lets you choose which fields you want to use in your table. As an example, we will create a table that shows how many Robux you are earning from each item that is being sold in your game. Left click on any cell in the pivot table. In the pane that appears on the right, check the ItemName, Currency, and Revenue boxes. You should see a table like this:


Graphing Data

Pie Chart

To create a pie chart, select the pivot table by clicking on one of the cells and pressing Ctrl+A. Next, click on the Insert tab and select a 2D Pie Chart. You should see a chart like this:


Line Chart

To create a line chart, select the pivot table by clicking on one of the cells and pressing Ctrl+A. Next, click on the Insert tab and select a line chart. If you want to have multiple lines in your line chart, drag the column name into the Legend section of the PivotChart Fields pane.


Adding Labels

To add labels, right click on the pie or line chart and select “Add Data Labels” from the context menu. Check the box for “Category Name.” If the chart is a pie chart, you might want to show the Percentage.

Other Charts

Now that you have the tools, make whatever charts or graphs you want using the data. Here are some examples to start you off.

Instructions Chart
Check the fields ItemName, Currency, Revenue
Currency, Revenue, Device
ItemType, Currency, Revenue
ItemName, Currency, Date, Revenue
ItemName, SalesVolume

![enter image description here][8]

  • tools