WEBINAR DATA MINING DIRECT ACCESS delta DNA is

WEBINAR DATA MINING & DIRECT ACCESS ©delta. DNA is a trading name of Games. Analytics Ltd.

Agenda Overview Data Structure Data Mining – Events – Users Direct Access – – Connecting Querying Events Querying Users Joining between Events and Users Questions… ©delta. DNA is a trading name of Games. Analytics Ltd.

Overview ©delta. DNA is a trading name of Games. Analytics Ltd.

Overview Aggregated Data - Counts of events, users, sessions, missions, revenue, items etc. . - Fixed set of Dimensions and Measures ©delta. DNA is a trading name of Games. Analytics Ltd.

Overview Aggregated Data - Counts of events, users, sessions, missions, revenue, items etc. . - Fixed set of Dimensions and Measures Raw Data - Not aggregated, contains all events and parameters - Stored in an HP Vertica Analytics Database - Very fast ad hock queries against any events or parameters - Event Data retained for 30 days be default (can be extended on a per game basis) - User Metrics retained for life ©delta. DNA is a trading name of Games. Analytics Ltd.

Overview Aggregated Data - Counts of events, users, sessions, missions, revenue, items etc. . - Fixed set of Dimensions and Measures Raw Data - Not aggregated, contains all events and parameters - Stored in an HP Vertica Analytics Database - Very fast ad hock queries against any events or parmaters - Event Data retained for 30 days be default (can be extended on a per game basis) - User Metrics retained for life Archives - All event data is archived to Amazon S 3 so you can download and run longer map reduce queries. ©delta. DNA is a trading name of Games. Analytics Ltd.

Data Structure Events – Stored in a single wide table – One row per event there are exceptions! more on them later… – One column per parameter – So, simplistically there is a row for each event you send and it contains columns for every possible parameter the game can send. – New columns will be added to the events table automatically as you add new parameters to your event schema. ©delta. DNA is a trading name of Games. Analytics Ltd.

Data Structure Events – Stored in a single wide table – One row per event there are exceptions! more on them later… – One column per parameter – So, simplistically there is a row for each event you send and it contains column for every possible parameter the game can send. – New columns will be added to the events table automatically as you add new parameters to your event schema. - The exceptions, • Some events can span multiple rows (transaction, level. Up etc. . . ) • Some columns are automatically populated by delta. DNA ©delta. DNA is a trading name of Games. Analytics Ltd.

Data Structure User Metrics – Each row contains metrics for a user including • • • Generic Metrics – automatically calculated total. Days. Played, total. Real. Currency. Spent … Counts of events event. Game. Started. Count, event. Level. Up. Count … Parameter Metrics � Auto field. Mission. Name. Last, field. Device. Type. Last, field. User. XPLast … � User Defined. Any String or Integer Game Parameter. Set parameters as metrics in Game Parameters tool. (Warning, don’t just set everything to be a metric, it will just bloat your user metrics table and slow down your direct access queries) – – Multiple rows per user, use effective date to get the most recent Updated every night in the early hours (UTC). – Be aware, some metrics are relative to the user_last_seen_date, e. g. days. Played. Last 7 Days. We are looking to change this at some point to make re-evaluation of inactive users easier. This is an archive for you to run queries on, Segmentaion, Targeting etc. . Work against a live, in memory version of this that has real-time accuracy. ©delta. DNA is a trading name of Games. Analytics Ltd.

Data Mining – Events Moves Remaining on “First Time User Forest #2” ©delta. DNA is a trading name of Games. Analytics Ltd.

Data Mining – Events Moves Remaining on “First Time User Forest #3” ©delta. DNA is a trading name of Games. Analytics Ltd.

Data Mining – Events Ratio of mission events on the first 5 missions ©delta. DNA is a trading name of Games. Analytics Ltd.

Data Mining – Events Ratio of mission events on the first 5 missions 47% failure rate, mission too difficult! ©delta. DNA is a trading name of Games. Analytics Ltd.

Data Mining – Users Moves Remaining by mission ©delta. DNA is a trading name of Games. Analytics Ltd.

Direct Access - Connecting Direct Access Documentation http: //docs. deltadna. com/direct-sql-access/ ©delta. DNA is a trading name of Games. Analytics Ltd.

Direct Access - Queries Event Query -- Event Mining Query SELECT moves. Remaining, count(event. Date) FROM events_live WHERE mission. Name= 'First Time User Forest #2' AND event. Name = 'mission. Completed' GROUP BY moves. Remaining ORDER BY moves. Remaining desc ; User Metrics Query -- User Mining Query select * from user_metrics_dev where effective_date = CURRENT_DATE limit 20 ; ©delta. DNA is a trading name of Games. Analytics Ltd.

Direct Access - Queries Advanced Query with JOIN between events and user metrics SELECT e. mission. Name, count(e. mission. Name) FROM events_live e JOIN user_metrics_live m ON e. user. ID = m. user_id WHERE event. Name = 'mission. Failed' AND e. mission. Name LIKE 'First Time User Forest%' AND m. field. Lives. Balance. Last = 0 AND m. effective_date = CURRENT_DATE GROUP BY e. mission. Name ORDER BY e. mission. Name ; First Time User Forest #3 is causing abandonment It has the highest number of players where it is The last mission they play, and fail and have no lives left ©delta. DNA is a trading name of Games. Analytics Ltd.