This page shows which events and parameters drive each of the Games Analysis charts.
These are the basic set of events that are pre configured for each game. Implement these and the charts in the dashboard will display the correct information.
Where a chart can be driven by any event, a good example would be gameStarted.
Average Payments Per User
Calculation
Count of transaction Events Where transactionType is PURCHASE/Unique Player Count per day
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Average Revenue Per Paying Player
Calculation
Sum of Real Currency Amount Where transactionType is PURCHASE/Unique Payer Count per day
Events of Interest
- transaction
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Average Revenue Per Transaction
Calculation
Sum of Real Currency Amount/Count of transaction Events Where transactionType is PURCHASE per day
Events of Interest
- transaction
Fields of Interest
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Average Revenue Per User
Calculation
Sum of Real Currency Amount Where transactionType is PURCHASE/Unique Player Count per day
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Daily Active Users
Calculation
Count of Unique Players (Banded within time frames of Day, Week, Month) per day
Events of Interest
- Any Event
Fields of Interest
- userID
Daily Active Users By Age
Calculation
Unique Player Count By Years Since birthYear (Banded) per day
Events of Interest
- newPlayer
- Any Event
Fields of Interest
- userID
- birthYear
Daily Active Users By Country
Calculation
Unique Player Count By Country
Events of Interest
- newPlayer
- Any Event
Fields of Interest
- userID
- userCountry
Daily Active Users By Gender
Calculation
Unique Player Count By Gender per day
Events of Interest
- newPlayer
- Any Event
Fields of Interest
- userID
- gender
Daily Unique Spenders
Calculation
Count of Unique Payers With transaction Events Where transactionType is PURCHASE per day
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Difficulty & Frustration
Calculation
Difficulty: (Count of missionCompleted Events/Count of missionFailed Events) * 100 per day, Frustration: (Count of missionAbandoned Events/Count of missionStarted Events) * 100 per day
Events of Interest
- missionStarted
- missionCompleted
- missionFailed
- missionAbandoned
Fields of Interest
- userID
Events Distribution
Calculation
Count of Events By Event Name per day
Events of Interest
- Any Event
Fields of Interest
- eventName
Events Per Player
Calculation
Count of Events/Count of Unique Players per day
Events of Interest
- Any Event
Fields of Interest
- userID
- eventName
Gifting Players Percentage
Calculation
(Count of Unique Players with a giftSent event/Count of Unique Players) * 100 per day
Events of Interest
- giftSent
- Any Event
Fields of Interest
- userID
Invites Accepted
Calculation
Count of inviteReceived Events Where isInviteAccepted is 1 per day
Events of Interest
- inviteReceived
Fields of Interest
- isInviteAccepted
Invites Accepted Percentage
Calculation
(Count of inviteReceived Events Where isInviteAccepted is 1/Count of inviteSent Events) * 100 per day
Events of Interest
- inviteSent
- inviteReceived
Fields of Interest
- isInviteAccepted
Invites Sent
Calculation
Count of inviteSent Events
Events of Interest
- inviteSent
Fields of Interest
Items Per Day
Calculation
Count of transaction Events Where items are recieved and the transactionType is PURCHASE per day
Events of Interest
- transaction
Fields of Interest
- productsReceived
- items
- item
- itemName
- itemAmount
- transactionType
K-Factor
Calculation
(Count of Unique Players/Count of inviteReceived Where isInviteAccepted = 1) * 100
Events of Interest
- inviteReceived
- Any Event
Fields of Interest
- isInviteAccepted
Monetisation Matrix
Calculation
Sum of revenueAmount from transaction events Where transactionType = PURCHASE grouped by the number of years since birthYear (Banded)
Events of Interest
- transaction
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Payers By Current Player Value
Calculation
Count of Players with a transaction event Where transactionType = PURCHASE Grouped by the sum of the realCurrencyAmount (Banded) per day
Events of Interest
- transaction
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Payers By Number of Sessions
Calculation
Count of players with transaction events Where transactionType = PURCHASE against the count of their sessions (Banded)
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- sessionID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Payers By Playing Speed
Calculation
Count of players with transaction events Where transactionType = PURCHASE banded by the rate of event flow in seconds/event (Banded)
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Paying Players By Age
Calculation
Count of players with transaction events Where transactionType = PURCHASE (Banded) against the counts of transction events (Banded)
Events of Interest
- transaction
- newPlayer
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
- birthYear
Paying Players By Country
Calculation
Count of players with transaction events Where transactionType = PURCHASE (Banded) against the userCountry
Events of Interest
- transaction
- newPlayer
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
- userCountry
Paying Players By Gender
Calculation
Count of players with transaction events Where transactionType = PURCHASE (Banded) against theie gender
Events of Interest
- transaction
- newPlayer
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
- gender
Payments By Number of Sessions
Calculation
Count of transaction events Where transactionType = PURCHASE against the count of the player’s sessions (Banded)
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- sessionID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Payments By Playing Speed
Calculation
Count of transaction events Where transactionType = PURCHASE banded by the rate of event flow in seconds/event (Banded)
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Percentage Paying
Calculation
Count of players with transaction events Where transactionType = PURCHASE over the count of players.
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Percentage of Social Events
Calculation
Count of the inviteSent, inviteReceived, giftSent, giftReceived, messageSent and messageReceived events over the count of all events expressed as a percentage
Events of Interest
- inviteSent
- inviteReceived
- giftSent
- giftReceived
- messageSent
- messageReceived
- Any Event
Fields of Interest
- userID
Percentage of Social Players
Calculation
Count of players with inviteSent, inviteReceived, giftSent, giftReceived, messageSent or messageReceived events over the count of all players expressed as a percentage
Events of Interest
- inviteSent
- inviteReceived
- giftSent
- giftReceived
- messageSent
- messageReceived
- Any Event
Fields of Interest
- userID
Players By Current Player Value
Calculation
Count of Players grouped by the sum of the realCurrencyAmount (Banded)
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Players By Number of Sessions
Calculation
Count of players against the count of their sessions (Banded)
Events of Interest
- Any Event
Fields of Interest
- userID
- sessionID
Players By Playing Speed
Calculation
Count of players banded by the rate of event flow in seconds/event (Banded)
Events of Interest
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Players By Time To First Payment
Calculation
Count of players with transaction events Where transactionType = PURCHASE against the time between their start date and their first transaction (Banded)
Events of Interest
- transaction
Fields of Interest
- userID
- sessionID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Predicted Churn
Calculation
Predicted rate at which players will leave the game based on their playing behaviour (or lack thereof)
Events of Interest
- Any Event
Fields of Interest
- userID
Predicted Lifetime Value
Calculation
Predicted ltv based on the players spending behaviour (or lack thereof)
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Retention
Calculation
Of the players seen on day n, how many were also seen on day n-1 (1 day retention), n-7 (7 day retention), n-14 (14 day retention) and n-30 (30 day retention).
Events of Interest
- Any Event
Fields of Interest
- userID
Retention Matrix
Calculation
Days played by the players (Banded) against the number of days since they last played (Banded)
Events of Interest
- Any Event
Fields of Interest
- userID
Revenue By Current Player Value
Calculation
Sum of revenueAmount from transaction events Where transactionType = PURCHASE Grouped by the player’s sum of the realCurrencyAmount (Banded) per day
Events of Interest
- transaction
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Revenue By Number of Sessions
Calculation
Sum of revenueAmount from transaction events Where transactionType = PURCHASE against the count of the player’s sessions (Banded)
Events of Interest
- transaction
Fields of Interest
- userID
- sessionID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Revenue By Playing Speed
Calculation
Sum of revenueAmount from transaction events Where transactionType = PURCHASE banded by the rate of event flow in seconds/event (Banded)
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Revenue By Time To First Payment
Calculation
Sum of revenueAmount from transaction events Where transactionType = PURCHASE against the time between their start date and their first transaction (Banded)
Events of Interest
- transaction
Fields of Interest
- userID
- sessionID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Stickiness
Calculation
Count of users seen on day n over the count of users for the range n-30 to n, expressed as a percentage
Events of Interest
- Any Event
Fields of Interest
- userID
Top Ten Items
Calculation
Top ten itemNames by count in descending order taken from transactions where the transactionType = PURCHASE
Events of Interest
- transaction
Fields of Interest
- userID
- transactionType
- productsReceived
- items
- item
- itemName
Top Ten Missions
Calculation
Top ten missionNames by count in descending order
Events of Interest
- missionStarted
Fields of Interest
- userID
- missionName
Total Events
Calculation
Count of all the events group by their eventName within a given time period
Events of Interest
- Any Event
Fields of Interest
- userID
- eventName
Total Installs
Calculation
Count of the newPlayer events per day
Events of Interest
- newPlayer
Fields of Interest
- userID
Total Missions
Calculation
Count of all the missionStarted, missionCompleted, missionFailed and missionAbandoned events per day
Events of Interest
- missionStarted
- missionFailed
- missionAbandoned
- missionCompleted
Fields of Interest
- userID
Total Payers
Calculation
Count of players with transaction events Where transactionType = PURCHASE within a given time period
Events of Interest
- transaction
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Total Percentage Paying
Calculation
Count of players with transaction events Where transactionType = PURCHASE against the count of the unique players all within a given time period
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Total Players
Calculation
Count of the unique players seen within the a given time period
Events of Interest
- Any Event
Fields of Interest
- userID
Total Revenue
Calculation
Sum of the revenueAmount from transaction events Where transactionType = PURCHASE per day
Events of Interest
- transaction
Fields of Interest
- userID
- sessionID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Total Revenue By Current Player Value
Calculation
Cumulative sum of revenueAmount from transaction events Where transactionType = PURCHASE Grouped by the player’s sum of the realCurrencyAmount (Banded)
Events of Interest
- transaction
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Total Revenue By Number of Sessions
Calculation
Cumulative sum of revenueAmount from transaction events Where transactionType = PURCHASE against the count of the player’s sessions (Banded)
Events of Interest
- transaction
Fields of Interest
- userID
- sessionID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Total Revenue By Playing Speed
Calculation
Cumulative sum of revenueAmount from transaction events Where transactionType = PURCHASE banded by the rate of event flow in seconds/event (Banded)
Events of Interest
- transaction
- Any Event
Fields of Interest
- userID
- productsSpent
- realCurrency
- realCurrencyAmount
- realCurrencyType
- transactionType
Total Revenue By Time To First Payment
Calculation
Cumulative sum of revenueAmount from transaction events Where transactionType = PURCHASE against the time between their start date and their first transaction (Banded)
Events of Interest
- transaction
Fields of Interest
- userID
- sessionID