• Gaming
  • 18 columns
  • 200 rows
  • 8 formats

Gaming In-Game Purchase Records

This dataset provides detailed records of in-game purchases across multiple games, platforms, and regions, including player identifiers, item details, transaction amounts, payment methods, and promotional usage. It enables game studios and publishers to analyze monetization strategies, player spending behavior, and the effectiveness of promotions for optimizing revenue and engagement.

  • opened 12 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Monetization strategy optimization for game studios and publishers

Sample rows

preview · 8 of 200 rows · all 18 columns
purchase_idstringpayment_methodstringprice_usdfloatis_first_purchasebooleanregionstringplayer_idstringgame_idstringstudio_idstringpurchase_datetimedatetimeitem_idstringitem_namestringitem_typestringquantityintegercurrency_codestringplatformstringplayer_levelintegerpromotion_appliedbooleanpromotion_codestring
A1B2C3D4-001app_store4.99trueUSplayer_001game_101studio_A2024-06-17T14:23:45Zitm_001Diamond Packcurrency3USDiOS2trueJUNEDEAL1
E5F6G7H8-002credit_card9.99falseUSplayer_002game_102studio_B2024-06-17T16:18:21Zitm_002Spring Warrior Skinskin1USDPC38falseblank
JKL9MNOP-003debit_card2.99trueUSplayer_003game_103studio_C2024-06-17T17:55:12Zitm_003Mega Power-Uppower-up2USDAndroid7trueBOOSTJUNE
QRS1TUV2-004paypal14.99falseCAplayer_004game_104studio_D2024-06-17T19:33:01Zitm_004Holiday Event Bundleconsumable1USDWeb12falseblank
WXY3ZAB4-005credit_card24.99falseUSplayer_005game_105studio_E2024-06-17T21:40:37Zitm_005Premium Battle Passbattle pass1USDConsole57trueBPJUNE24
CDE5F6GH-006app_store0.99trueUSplayer_006game_106studio_F2024-05-22T10:11:00Zitm_006Starter Charactercharacter1USDiOS3falseblank
IJK7LMNO-007credit_card49.99falseUSplayer_007game_107studio_G2024-06-15T16:03:45Zitm_007Legendary Swordother1USDPC82falseblank
PQRS8TUV-008paypal5.99falseCAplayer_008game_108studio_H2024-06-16T12:22:55Zitm_008Energy Drinkconsumable6USDAndroid19falseblank

What the 200 rows show

from the 200-row sample

App_store (payment method) stands out: 50 of its 51 rows have is_first_purchase = true, against 34 of 136 for the rest.

  • 45%is_first_purchase = true
  • 3.5median price_usd
  • 5platforms
  • 7item types
  • 8currency codes
  • 36studios
Is first purchase rate by payment_methodis_first_purchase = true
0%50%100%14%credi…8 of 5843%debit…9 of 2122%paypal8 of 3798%app_s…50 of …60%gift_…3 of 540%virtu…6 of 15
price_usd200 rows, in bands of 50
0901801801324010150300price_usd →

Median 3.5, from 0.0 to 300.0.

region189 rows with a value · 11 left blank
  1. US76
  2. JP31
  3. FR14
  4. DE13
  5. GB10
  6. CA9
  7. ES9
  8. IN9
  9. IT8
  10. BR4
18 columns by typefrom the column list below
  • string 12
  • integer 2
  • float 1
  • datetime 1
  • boolean 2

Columns

18 columns in four groups
blueprint · 18 columns
columntypedescriptionexample
Text 12 columns
purchase_idstringUnique identifier for each in-game purchase eventuniqueA1B2C3D4-001
player_idstringUnique identifier for the player making the purchaseplayer_001
game_idstringUnique identifier for the game in which the purchase was madegame_101
studio_idstringUnique identifier for the game studio or publisherstudio_A
item_idstringUnique identifier for the purchased in-game item or bundleitm_001
item_namestringName of the purchased in-game item or bundleDiamond Pack
item_typestringType/category of the purchased item (e.g., skin, currency, power-up, battle pass)7 valuescurrency
currency_codestringISO 4217 currency code used for the transaction (e.g., USD, EUR, JPY)8 codesUSD
payment_methodstringPayment method used for the purchase (e.g., credit_card, paypal, app_store, gift_card, virtual_currency)7 valuesapp_store
platformstringPlatform on which the purchase was made (e.g., iOS, Android, PC, Console)6 valuesiOS
regionstringGeographical region or country code of the player at time of purchaseoptionalUS
promotion_codestringPromotion or discount code used, if applicableoptionalJUNEDEAL1
Numbers 3 columns
quantityintegerNumber of units/items purchased in this transaction1 or more3
price_usdfloatTotal price paid for this purchase in US dollars0 or more4.99
player_levelintegerPlayer's level at the time of purchase1 or more · optional2
Dates and times 1 column
purchase_datetimedatetimeTimestamp of when the purchase occurred (UTC)2024-06-17T14:23:45Z
True or false 2 columns
is_first_purchasebooleanIndicates if this is the player's first purchase in the gameoptionaltrue
promotion_appliedbooleanIndicates if a promotion or discount was applied to this purchaseoptionaltrue

15 SQL practice questions for the Gaming In-Game Purchase Records

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    High-priced purchases

    Return purchase_id, item_name and price_usd for every purchase with a price_usd greater than 50. Order the results by price_usd from highest to lowest, then by purchase_id in ascending order.

    Tables: gaming_in_game_purchase_records · your result: 3 columns, 20 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct payment methods

    List each distinct payment_method found in the data, sorted alphabetically. Return a single column named payment_method.

    Tables: gaming_in_game_purchase_records · your result: 1 columns, 6 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Purchases per platform

    Count the purchases for each platform. Return platform and purchase_count, ordered by purchase_count from highest to lowest, then by platform in ascending order.

    Tables: gaming_in_game_purchase_records · your result: 2 columns, 5 rows
  1. 04Average price by item typeBeginner
  2. 05Revenue by region bar chartPower BI
  3. 06Payment methods with many purchasesIntermediate
  4. 07Price tier bucketsIntermediate
  5. 08Platforms above overall average priceIntermediate
  6. 09Promotion effect by item typeIntermediate
  7. 10Promotion usage rate by platformPower BI
  8. 11Top item type by revenue per platformAdvanced
  9. 12Gap between a player's purchasesAdvanced
  10. 13Running revenue by dayAdvanced
  11. 14Price anomalies within item typeAdvanced
  12. 15Platform share of total revenuePower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • is first purch…45%84 of 187 rowsmean price usd by pay…48.1cred…11.1debi…29.7payp…2.4app_…

    A gaming dashboard

    The is_first_purchase rate, price_usd by payment_method and a breakdown of region. Excel, Power BI or Tableau.

  • Why do 84 of 187 rows have is_first_purchase = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable purchases with player_id, game_id and studio_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 18 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows18 columns
Yours1,000 rows18 columnsregion: UK only

blueprint · gaming-in-game-purchase-records

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 18 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Include user ID and purchase amount
  • Segment by item type
  • Flag high-value purchases
  • Track purchase frequency per user
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
gaming-in-game-purchase-records

What should your data show?

Preview 20 rows free
No signup. No card.