Download - Space Ape's Analytics Stack
![Page 1: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/1.jpg)
![Page 2: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/2.jpg)
1. Samurai Siege Overview2. Samurai Analytics Stack Evolution3. DWH Components4. User Acquisition Tools5. Product Tools6. CRM Tools
![Page 3: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/3.jpg)
![Page 4: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/4.jpg)
Mobile real time strategy, iOS, Android
Developed in 6 months by team of 12
Live October 2013
11M Installs / 1.2M MAU / 250K DAU
$23M in Gross Revenue to Date
![Page 5: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/5.jpg)
Small dev teams
Creative + Science
Agile
Live Operations
Data empowered
![Page 6: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/6.jpg)
![Page 7: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/7.jpg)
135 Billion Rows
13TB Of Compressed Data
250m x 125 columns Rows Per Day
![Page 8: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/8.jpg)
DATA MINING
ANALYSIS
REPORTING
CRM
Data Capture
A/B Tests
Samurai Siege Data StackDisconnected from live game
Insights & LearningsWeekly reporting
ETL
![Page 9: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/9.jpg)
![Page 10: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/10.jpg)
Spend Tier
In GameBehaviour
Monetisation
Device
Tenure
Balances
![Page 11: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/11.jpg)
● Automated and Run Daily through an SQL Runner
● Delta Process. Clear and Insert Data for Past 3 Days
● Process completed in Minutes not Hours
![Page 12: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/12.jpg)
DIMENSIONS
MEASURES
![Page 13: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/13.jpg)
Platform
Spend BehaviourDevice
Retention
Country Language
Acquisition Channel
Game Balances
Operating System
Castle Level
Retention
![Page 14: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/14.jpg)
player_id 71724ca2-c1f8-4519-8ae5-f8628a005653
villagename XXXXXXXX
allianceid 9b9f3aaa-09ee-42f9-b53f-5f9003e59c79
alliancename XXXXXXXX
signupdate 17/08/2013 06:39:00
max_actiondate 08/02/2015 17:58:00
controlflag 0
playerlevel 35
castlelevel 9
max_pveseq 11000
playerhonor 411
cohort 2
tenure 540
![Page 15: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/15.jpg)
first_deviceraw iPad2,1
first_devicelong iPad2 - Wi-Fi
first_deviceshort iPad2
first_playerlanguage English
first_deviceos ios
first_deviceplatform ios
first_deviceid c82848be88d034317526fa72b1b597ad
last_deviceraw samsung SM-G900F
last_devicelong Samsung Galaxy S5 (Europe)
last_deviceshort Samsung Galaxy S5
last_playerlanguage English
last_deviceos android
last_deviceplatform android
![Page 16: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/16.jpg)
first_country_iso US
last_country_iso GB
first_country UNITED STATES
last_country UNITED KINGDOM
first_continent NORTH AMERICA
last_continent EUROPE
email XXXXXXXXXXX
ret_d1 0
ret_d3 0
ret_d7 0
ret_d12 0
![Page 17: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/17.jpg)
spend_first24hours $ -
spend_first3days $ 9.00
spend_first7days $ 9.00
spend_first2weeks $ 9.00
spend_last24hrs $ -
spend_last0to7days $ -
spend_last8to14days $ -
spend_last15to21days $ -
spend_last22to28days $ -
spend_total $ 104.00
last_purchasedate 18/04/2014 00:00:00
![Page 18: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/18.jpg)
last_purchasedate 18/04/2014 00:00:00
tot_login_first7days 86
login_last0to7days 0
login_last8to14days 0
login_last15to21days 1
login_last22to28days 1
spendtier Villager
is_newbie 0
is_nonspenderprio 0
is_spendrisk 0
publishername ORGANICcampaignname
subadgroup
publisherid
![Page 19: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/19.jpg)
● Automated and Run Daily through an SQL Runner
● Recreated in Full every day
● Based on Daily Summary Table
● Process completed in Minutes not Hours
DAILY SUMMARY
![Page 20: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/20.jpg)
DIMENSIONS
MEASURES
![Page 21: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/21.jpg)
+ 30 more channels
![Page 22: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/22.jpg)
![Page 23: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/23.jpg)
Install Date
Campaign Network
Campaign Name
Country
Cost
Clicks
Impressions
![Page 24: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/24.jpg)
![Page 25: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/25.jpg)
SEGMENTATION BASED ON MONETISATION AND ENGAGEMENT IN THE FIRST 7 DAYS
![Page 26: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/26.jpg)
![Page 27: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/27.jpg)
● Segment Users
● Assign Appropriate Curve based on Segmentation
● Calculate pLTV based on different time periods
● Automated and Run Daily through an SQL Runner
![Page 28: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/28.jpg)
Fragmented Area
Data Driven
Unified Dashboard is needed to scale
Fast Reaction
![Page 29: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/29.jpg)
![Page 30: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/30.jpg)
![Page 31: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/31.jpg)
![Page 32: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/32.jpg)
RetentionAverage Revenue Per User
Average Revenue Per Paying UserDaily/Monthly Active Users
New UsersSession Length
Average Sessions Per UserSpend Metrics
![Page 33: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/33.jpg)
Spender Conversion %Life Time ValueRe-engagement
![Page 34: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/34.jpg)
Spend TiersTime Cohorts
Acquisition ChannelDevice Platform
CountryIn Game Segments e.g. Castle Level
![Page 35: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/35.jpg)
![Page 36: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/36.jpg)
Set up A/B test in SWRVE + basic results
More advanced metrics analysis in DWH
![Page 37: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/37.jpg)
Army composition for castle 9 and 10 ? in Japan, during a event, ...More dimensions, aggregation flexibility
● Monthly / weekly revenue● Full device split● Event type● ...
To be applied on a lot of information ● IAPs , diamonds spending● Economy movements● Event performance ● Honor movement● Behavioural changes (eg army
composition)● Community stats (time to first response,
CSAT, per value tier)● ...
![Page 38: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/38.jpg)
![Page 39: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/39.jpg)
BEHAVIOURAL SEGMENTSSPEND LEVELS
EMAILMESSAGE DETAILS
![Page 40: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/40.jpg)
![Page 41: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/41.jpg)
![Page 42: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/42.jpg)
![Page 43: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/43.jpg)
![Page 44: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/44.jpg)
![Page 45: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/45.jpg)
![Page 46: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/46.jpg)
![Page 47: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/47.jpg)
![Page 48: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/48.jpg)
Decide from the Beginning if you want to create a Data Warehouse
![Page 49: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/49.jpg)
Do not collect everything!
![Page 50: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/50.jpg)
Make Data Accessible
![Page 51: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/51.jpg)
Keep your finger on the pulse
![Page 52: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/52.jpg)
Automate!
![Page 53: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/53.jpg)
![Page 54: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/54.jpg)
Using Predictive Analytics to Trigger In-App Messages/Offers for users.
![Page 55: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/55.jpg)
Enhancing our Machine Learning capabilities
![Page 56: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/56.jpg)
Network / Cross Platform View and Analysis
![Page 57: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/57.jpg)
![Page 58: Space Ape's Analytics Stack](https://reader030.vdocuments.us/reader030/viewer/2022032616/55a50e0d1a28abda588b4826/html5/thumbnails/58.jpg)
Website:http://www.spaceapegames.com/
Blog: http://weare-bananas.tumblr.com/
Rival Kingdoms: http://www.rivalkingdomsgame.com/
Questions:[email protected]