Tweet
Tweet

Slide 1

Slide 1 text

BigQuery in Social Gaming Yan Cui, Senior Developer Davinder Pank, Social BI Manager

Slide 2

Slide 2 text

Who is Gamesys? • Founded in 2001 • #1 in the UK • Handle $5 Billion in turnover annually • First company to launch real money gaming on Facebook • Employ 1,000 globally

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

Travel, Collect, Craft!

Slide 7

Slide 7 text

Trap Monsters

Slide 8

Slide 8 text

No content

Slide 9

Slide 9 text

Events driven Analysis Enables deeper ad hoc analysis Analysis goes only as far as the data Finer the grain, bigger the volume

Slide 10

Slide 10 text

Be Ready for Success Jackpotjoy Slots Bingo Lane Here Be Monsters DAU 600,000+ 150,000+ 40,000+ Events (monthly) 5 billion+ 500 million+ 700 million+ 1 TB+ 200 GB+ 500 GB+

Slide 11

Slide 11 text

• Ensure the health of our defined KPIs across our products – Jackpotjoy Slots, Bingo Lane and Here Be Monsters • Develop player insights to better improve the depth with which users engage with our games Social Gaming Business Intelligence, Gamesys BigQuery

Slide 12

Slide 12 text

Why BigQuery? Scales Managed Fully managed architecture, allows instant project startup, and rapid time to insight Easy to learn, minimal transition period, especially for those moving from traditional relational databases SQL Grows with your project, scales horizontally from 100 thousands to 100 Bn's of rows with no loss of performance on interactive queries

Slide 13

Slide 13 text

Monitoring KPI Health Reporting Apps Script Spreadsheets Cloud Storage Big Query ETL

Slide 14

Slide 14 text

KPI Dashboards in Google Spreadsheets

Slide 15

Slide 15 text

Custom Dashboards in Google Spreadsheets

Slide 16

Slide 16 text

Developing Player Insights Big Joins No need for temporary tables, let’s us get to the results we need in as few steps as possible How BigQuery features and functions allow us to better explore our data

Slide 17

Slide 17 text

Developing Player Insights • Our analysis hinges on being able to compare behaviour amongst players with similar in-game maturity to one another • Where we gain some of our most invaluable insights are where changes in player behaviour lie outside the norm of what we would expect How BigQuery features and functions allow us to better explore our data

Slide 18

Slide 18 text

Developing Player Insights Window Functions Rank and partition allow us to compare fairly player engagement and monetisation metrics across players with the same in- game maturity. Reduces dependence on external tools. Lead and lag allow us to easily identify segments exhibiting interesting changes in behaviour How BigQuery features and functions allow us to better explore our data

Slide 19

Slide 19 text

Reporting Apps Script Spreadsheets Cobra App Engine Cloud Storage Big Query ETL Mailman App Engine email mobile push notifications 4 facebook notifications Beyond BigQuery

Slide 20

Slide 20 text

In the near future.. • Move from nightly ETL to real-time – BigQuery streaming insert • Predication API

Slide 21

Slide 21 text

Thank You!

Slide 22

Slide 22 text

JackpotJoy Slots http://apps.facebook.com/jackpotjoyslots Bingo Lane http://apps.facebook.com/bingolane Here Be Monsters http://apps.facebook.com/herebemonsters Building a MMORPG http://bit.ly/1hjqoL8 http://slidesha.re/18MD4XY Google I/O 2013 – Here Be BigQuery http://bit.ly/1fHjbce