how to harvest the gold in your game sales database nick berry, m.eng , araes , cipp president,...
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 PresentationTRANSCRIPT
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.
Biography
1988 1994 2008 2010
Agenda1) What is Social Gaming?
2) Why is it so popular?
3) How to find out more about download customers
4) Examples
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!”
A Social Game is …… any non-obligatory activity that is performed, for fun, on
a Social Network.
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.
What do you know about your existing
customers?
Social Game Developers have it “easy”
Age=18 Age=49 Age=23 Age=38
Age=27 Age=17 Age=58 Age=16
What do you know about your Deluxe Download customers?
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
What’s in a name? (Gender)
NicholasJessicaTaylor
What about androgynous names?
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
History of Male Names
History of Female Names:
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
Trivia – Highest scoring name in the 86,987 distinct names in the SSA database is:Jazzmyne (scoring 38 points)
Returning to Androgynous names
2009 Data
Taylor over the years
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) +
…
Life (Death) tables
CDC/NCHS – Center for Disease Control and Prevention/National Center for Health Statistics
1901 Life Tables
Life (Death) Percentage chance of reaching a specified age.
39.1%67.9%
82.4%88.7%
92.1%
65
100%
0%
Perc
enta
ge C
hanc
e of
Rea
chin
g Sp
ecifi
ed A
ge Gender Differences
1930
Gender Differences – Age at Death
1980Age at Death (per 100,000)
Male Female
Multiply
Taylor
Probability density function
Who names their child “Ethel” these days?
Probability Density Functions
Facebook demographics
FaceBook Demographics
AGE
13
65+
FemaleMale
FaceBook Demographics
Many users of college
age
In USA large number of members over 65
Bejeweled
Jay Leno vs. Conan
Comparing Demographic “Genes”
38.41% correlation
80.89% correlation
Bejeweled Blitz Affinity
What are fans of glee on facebook interested in?
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
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
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
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%
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%
Example #1
GreatPokerHandsTexas Hold’em Poker Strategy cards sold at retail.
GreatPokerHands sales Database
GreatPokerHands Age/Gender Profile
Children under 18 do not have credit cards
GreatPokerHand Sales Correlations
45.63%34.81%25.72%
Results:
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
White House Visitor Logs
Every visitor to White House recorded, but no gender or age information …
1.95 1.95 million records available
The End
Slides available: DataGenetics.com/content.htmlEmail: [email protected]