DESCRIPTION

This table contains the daily revenue data for Intendo's Super Jetroid game. All data is for the complete year of 2015. Each row represents a single revenue by a user user_id in a particular session session_id. Revenue could be earned through ad views (where type == 'ad') or through in-app purchases.

user_id  text → character

INFO This is the User ID field. ID fields like this one are unique.

session_id  text → character

INFO This is the Session ID field. ID fields like this one are unique.

time  text → character

INFO This is a date-time field. Even though it's a character column, the times are in ISO-8601 format.

TODO Ensure that this becomes a DATETIME column.

name  text → character

INFO These contain the names of buyable products. Currently these products are "gold7", "gold1", "gems1", "gold6", "pass", "offer4", "offer5", "gems5", "gold2", "offer3", "gems4", "gold3", "offer1", "ad_5sec", "gold5", "offer2", "gems2", "gold4", and "gems3" .

PERSON RESPONSIBLE Rita Mercer (r.mercer@example.com)

size  text → character

INFO The size refers to the relative size of the product. Ads are always NULL but products like gold and gems have a size value.

type  text → character

INFO These contain the names of buyable products. Currently there are the following types: "season_pass", "offer_agent", "ad", and "currency" .

PERSON RESPONSIBLE Rita Mercer (r.mercer@example.com)

price  double precision → numeric

INFO The price (in USD) for the product in the name column. This value will always be greater than the corresponding revenue value (30% higher). PARTNER

revenue  double precision → numeric

INFO The reported revenue (in USD) for the product. The value may change up to 3-4 weeks after the sale date due to processing of refunds. The revenue total is $21,923,792.04. PARTNER

DATABASE

Data table hosted in a PostgreSQL database on DigitalOcean (134.122.40.123). Email roy@example.com for access info.

REPO

Original datasets available in the intendo repo