how to harvest the gold in your game sales database nick berry, m.eng , araes , cipp president,...

56
How to Harvest the Gold in your Game Sales Database Nick Berry, M.Eng, ARAeS, CIPP President, DataGenetics All logos and trademarks in this presentation are property of their respective owners.

Upload: jaafar

Post on 26-Feb-2016

29 views

Category:

Documents


6 download

DESCRIPTION

How to Harvest the Gold in your Game Sales Database Nick Berry, M.Eng , ARAeS , CIPP President, DataGenetics. All logos and trademarks in this presentation are property of their respective owners. Biography. 2008. 1994. 1988. 2010. Agenda. What is Social Gaming ? Why is it so popular? - PowerPoint PPT Presentation

TRANSCRIPT

Page 1: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

How to Harvest the Gold in your Game Sales DatabaseNick Berry, M.Eng, ARAeS, CIPP

President, DataGeneticsAll logos and trademarks in this presentation are property of their respective owners.

Page 3: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Agenda1) What is Social Gaming?

2) Why is it so popular?

3) How to find out more about download customers

4) Examples

Page 4: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

What is a Social Game?“But they’re not social!”

“A game played on a Social Network”

So what is a game?

PP (After all, “Casual Games” are not casual either!)

Not Work!“Any non-obligatory activity that is performed for fun!”

Page 5: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

A Social Game is …… any non-obligatory activity that is performed, for fun, on

a Social Network.

Page 6: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Discoverability Accessibility

CamaraderieWhy are Social Games so Popular?

Facebook has exposed people to copious quantities of non-essential activities and

provided easy channels to announce participation in these entertainments to

others.

Players broadcast their indulgences, performances and achievements (both actively and passively).

In no more than a couple of clicks, exposed users can

be having fun, and jumping on the latest bandwagon of

distraction.

Whilst social could be considered a poor

adjective to describe games when many

games are solo activities, these

activities do earn it the moniker social because

they offer a shared experience. Albeit

asynchronously, all the people who have

enjoyed the same activity have been

down the same path.

Curiosity, Invitation, Peer Pressure,

Challenge.

Page 7: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

What do you know about your existing

customers?

Page 8: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Social Game Developers have it “easy”

Age=18 Age=49 Age=23 Age=38

Age=27 Age=17 Age=58 Age=16

Page 9: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

What do you know about your Deluxe Download customers?

Page 10: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Sales DatabaseSales Date

Sales ValueCredit card Name

Credit card Number

2/3/2001 $6.95

Nicholas Berry 3713 xxxx xxxx 9980

2/3/2001 $6.95

Nicholas Berry 3713 xxxx xxxx 9980

2/3/2001 $6.95

Nicholas Berry 3713 xxxx xxxx 9980

2/3/2001 $6.95

Nicholas Berry 3713 xxxx xxxx 9980

Page 11: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

What’s in a name? (Gender)

NicholasJessicaTaylor

What about androgynous names?

Page 12: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

US Social Security Administration

Database of all registered names in

USA since 1880complete with gender.

NAME Year FrequencyMary F 1967 25,320Susan F 1967 22,259Karen F 1967 21,544Angela F 1967 19,537Melissa F 1967 18,370Patricia F 1967 17,745

Amy F 1967 16,130Elizabeth F 1967 16,110Christine F 1967 15,992

Laura F 1967 15,820Julie F 1967 15,541

Cynthia F 1967 15,336Donna F 1967 14,789Tina F 1967 14,154

Deborah F 1967 14,004

Page 13: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

History of Male Names

Page 14: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

History of Female Names:

Page 15: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Scrabble™ ScoreCreative spelling:

Z replacing SY replacing I

Izzabellah (33 points) instead of Issabella (11 points)

Kristyn (14 points) instead of Kristin (11 points)

Score Letters1 A , E , I , O , U , L , N , R , S , T 2 D , G 3 B , C , M , P 4 F , H , V , W , Y 5 K 8 J , X 10 Q , Z

Page 16: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Trivia – Highest scoring name in the 86,987 distinct names in the SSA database is:Jazzmyne (scoring 38 points)

Page 17: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Returning to Androgynous names

2009 Data

Page 18: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Taylor over the years

Page 19: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Nobody lives forever

Males named Taylor who

are still alive

Females named Taylor

who are still alive

Number of male Taylors born in 2012 (still alive) +Number of male Taylors born in 2011 (still alive) +

Number of male … +Number of male Taylors born in 1940 (still alive) +

Male %

Female % Number of female Taylors born in 2012 (still alive) +Number of female Taylors born in 2011 (still alive) +

Number of female … +Number of female Taylors born in 1940 (still alive) +

Page 20: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Life (Death) tables

CDC/NCHS – Center for Disease Control and Prevention/National Center for Health Statistics

1901 Life Tables

Page 21: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Life (Death) Percentage chance of reaching a specified age.

39.1%67.9%

82.4%88.7%

92.1%

65

Page 22: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

100%

0%

Perc

enta

ge C

hanc

e of

Rea

chin

g Sp

ecifi

ed A

ge Gender Differences

Page 23: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

1930

Gender Differences – Age at Death

1980Age at Death (per 100,000)

Male Female

Page 24: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Multiply

Page 25: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Taylor

Probability density function

Page 26: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Who names their child “Ethel” these days?

Probability Density Functions

Page 27: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Facebook demographics

Page 28: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

FaceBook Demographics

AGE

13

65+

FemaleMale

Page 29: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

FaceBook Demographics

Many users of college

age

In USA large number of members over 65

Page 30: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Bejeweled

Page 31: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics
Page 32: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics
Page 33: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Jay Leno vs. Conan

Page 34: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Comparing Demographic “Genes”

38.41% correlation

Page 35: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

80.89% correlation

Page 36: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Bejeweled Blitz Affinity

Page 37: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

What are fans of glee on facebook interested in?

Page 39: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Sims

Pet S

ociet

yTe

tris Wii

Countr

y Stor

y

Guitar

Hero

Supe

r Mari

o Bros

Petvi

lle

Doodle

Jump

Civiliza

tion

Zoo W

orld

Pillow

Fight

Wii Fit

TextT

wist

Cityvil

le

Barn Bud

dy

Settle

rs of

Catan

Vampir

e Wars

Scrab

ble

World o

f Warc

raft

Texa

s Hold

em Po

ker

Mafia W

ars

Castle

Age

Farm

Town

Mobste

rs 2 -

Vende

tta PS3

Warstorm

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100% Affinity for Games

Page 40: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Jers

ey S

hore

Amer

ican

Idol

MTV

Spon

geBo

bAm

eric

as N

ext T

op M

odel

Satu

rday

Nig

ht L

ive

Scru

bsHo

w I m

et y

our M

othe

rLo

stTh

e Offi

ceHe

roes

Fam

ily G

uyUg

ly B

etty

Dr W

ho CSI

The

Bach

elor

Sim

pson

sDe

sper

ate

Hous

ewiv

esNC

ISGh

ost W

hisp

erer

Sex

and

the

City

Myth

bust

ers

Big

Bang

The

ory

Two

and

a Ha

lf M

enCr

imin

al M

inds

Colb

ert

Law

and

Ord

erCo

nan

oBrie

nEl

len

Dege

nero

usSo

uth

Park

Jay

Leno

Bigg

est L

oser

Star

Tre

kMa

rtha

Stew

art

Medi

umOp

rah

Win

frey

Sho

wTo

p Ge

arBa

ttles

tar G

alac

tica

How

ard

Ster

n

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

TV Shows

Page 41: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Taylor Swift

Lady Gaga

Katy Perry

Britney Spears

Shakira Justin Bieber

Avril Lavigne

Rihanna Black Eyed Peas

Michael Jackson

Frank Sinatra

Red Hot Chili

Peppers

Elvis Barry Manilow

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100% Music

Page 42: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Peps

i

Coca

-...

Red

Bull

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

Star

buck

s

McDo

nald

s

Taco

Bel

l

Dairy

Q...

Dunk

in D

...

Pizz

a Hu

t0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

Conv

erse

Pum

a

Nike

Reeb

ok

Adid

as

Croc

s

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

Page 43: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Make

up

Fash

ion

Socc

er

Snow

boar

ding

Skiin

g

Baki

ng

Jogg

ing

Fishi

ng

Yoga

Scub

a Di

ving

Knitt

ing

Marti

al A

rts Golf

NASC

AR

Gard

enin

g

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

Hors

es

Cats

Dogs

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

iTun

es

Twitt

er

Four

sq...

Inve

stin

g

Ciga

rs

0%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

Page 44: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Example #1

GreatPokerHandsTexas Hold’em Poker Strategy cards sold at retail.

Page 45: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

GreatPokerHands sales Database

Page 46: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

GreatPokerHands Age/Gender Profile

Children under 18 do not have credit cards

Page 47: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

GreatPokerHand Sales Correlations

45.63%34.81%25.72%

Page 48: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Results:

Page 49: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Example CPC Prices:

Texas Holdem $1.73Golf (74.77%) $0.88

Texas Holdem $2.05 - $3.06Scuba Diving (65.93%) $0.79 - $1.16NASCAR (65.56%) $0.41 - $0.56

Page 50: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

White House Visitor Logs

Page 51: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

Every visitor to White House recorded, but no gender or age information …

1.95 1.95 million records available

Page 52: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics
Page 53: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics
Page 54: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics
Page 55: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics
Page 56: How to Harvest the Gold in your Game Sales Database Nick Berry,  M.Eng ,  ARAeS , CIPP President, DataGenetics

The End

Slides available: DataGenetics.com/content.htmlEmail: [email protected]