1 of 33

2 of 33

Here be Big Query

Building Social Gaming Infrastructure on �the Google Cloud Platform

Matt McNeill

Head of Strategic Customer Relationships, �Google Cloud Platform, EMEA

Tom Newton

Director of Social Gaming, Gamesys

3 of 33

The Life of a Game

Game lifetime measured in weeks

1

2

1 http://www.localytics.com/blog/2011/first-impressions-matter-26-percent-of-apps-downloaded-used-just-once/

2 Representative sample of usage data from a typical mobile game

4 of 33

Connected Games are the Future

Interest in connected games has been trending upwards in Google search since Q4 2012

1 data from google.com/trends for interest in mobile backend as a service solutions

1

Reduces Piracy

Enables Social

Enables Measurement

5 of 33

The Science of Gaming

Tom Newton, Director of Social Gaming, Gamesys

6 of 33

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

7 of 33

Social and Mobile Gaming at Gamesys

  • Started investing in Social in 2011
  • 100 people employed on the Social Team today
  • Currently operating 5 cross-platform games
  • Leader in Social Casino genre, also powering games for PopCap/EA

​

​

8 of 33

Gamesys chose Google

9 of 33

Why Google?

APIs

Scale

Take advantage of the scalability, reliability and availability of Google’s infrastructure

Google provide 99.95% SLA and 24x7 phone, and many other support options

Reliability

Utilise the full range of Google APIs to access many powerful and sophisticated services

10 of 33

Inside a Game

1

Case Study: Here Be Monsters

2

Data, Data, Data: processing and reporting

3

Industrialising our systems on the Google Cloud

4

Putting it all together

11 of 33

12 of 33

Travel, Collect, Craft!

13 of 33

Trap Monsters

Demo

14 of 33

Data

Importance of insight

15 of 33

Events drive Analysis

Enables deeper ad hoc analysis.

​

Analysis goes only as far as the data.

​

Finer the grain, the bigger the volume.

01001001010010010010100100010101110010100010

01001001010010010010100100010101110010100010

01001001010010010010100100010101110010100010

01001001010010010010100100010101110010100010

01001001010010010010100100010101110010100010

01001001010010010010100100010101110010100010

01001001010010010010100100010101110010100010

16 of 33

Be Ready for Success

​

Game 1

Game 2

Here Be Monsters ( Beta )

DAU

600,000+

150,000+

10,000+

Sessions

45 Million+

8 Million+

1 Million+

Events

5 Billion +

​

500 Million +

​

200 Million +

​

17 of 33

Why Big Query?

Scales

Managed

Fully managed architecture, allows instant project startup, and rapid time to insight

Easy to learn, no training necessary.

SQL

Grows with your project, scales horizontally to 100 Bn's of rows with no loss of performance on interactive queries

18 of 33

Nightly ETL

Cloud Storage

Big Query

ETL

Events

19 of 33

Aggregations Drive Reporting

Profiles

Transactions

Sessions

20 of 33

Reporting

Reporting

Apps Script

Spreadsheets

Cloud Storage

Big Query

ETL

21 of 33

KPI Dashboards in Google Spreadsheets

Demo

22 of 33

Industrialise

Data driven tools with App Engine

23 of 33

Engagement

email

mobile push notifications

4

facebook notifications

Reporting

Apps Script

Spreadsheets

Mailman

App Engine

Cloud Storage

Big Query

ETL

24 of 33

Why App Engine?

Deployment

Productivity

Focus on solving the problem, and building the application, don't need to worry about the plumbing

One click deployment makes it easy. Iterate very fast. No maintenance overheads.

Scale

Take advantage of the scalability, reliability and availability of Google’s infrastructure

25 of 33

Mailman

cron

blobstore

Lists

Big Query

App Engine

Jobs

App Engine

Pipeline API *

blobstore

cron

datastore

  • Automated, scheduled message delivery service

​

  • Designed to improve player retention, and improve life time value

​

  • Allows definition of message recipients based on profile, session and events data

​

​

Task Queue

mobile push notifications

email

4

facebook notifications

*ETA

26 of 33

Personalised Offers

Reporting

Apps Script

Spreadsheets

Mailman

App Engine

Cloud Storage

Big Query

ETL

email

mobile push notifications

4

facebook notifications

Cobra

App Engine

Prediction API

27 of 33

Cobra

  • A real-time offer system�
  • Builds offers tailored to each user based on their profile�
  • Built with App Engine, integrated with our games platform�
  • Support for purchases through Google Play, App Store, Amazon and Facebook (anti-piracy)

Big Query

Cobra

App Engine

Offer Verification

28 of 33

Prediction

Train

Model

Predict

29 of 33

Cobra

With prediction:�

  • Update our prediction model with data as users redeem offers�
  • Eventually using the Prediction API to help improve the quality of offer conversions.

​

Cobra

App Engine

Big Query

Offer Verification

Prediction API

30 of 33

Putting it Together

A single, scalable, platform for rapid innovation

31 of 33

Focus on the Game...

Reporting

Apps Script

Spreadsheets

Cobra

App Engine

Prediction API

Cloud Storage

Big Query

ETL

Mailman

App Engine

email

mobile push notifications

4

facebook notifications

32 of 33

Google Cloud - A Platform for Success

Technology

Marketing

Analytics

33 of 33

Questions ?

cloud.google.com

developers.google.com

cloud.google.com/newsletter

googlecloudplatform.blogspot.com