Comment on page
How to Use - Scorecard
Information on how to navigate and utilize our Scorecard tool
- 1.
- 2.On your Scorecard, set the correct scoring scale (see image) on the "Total Score" tab.
- 1.Currently, only casino apps are able to be scored.
- 2.To score multiple apps from different sub-genres set the scoring scale to "Casino- Total Market".
- 3.Add all apps that you want to score to the "Game Set" column (see image).
- 1.Any casino app tracked by Liquid and Grit may be added to compare scores.
- 2.
Set the scoring scale at the top left and replace "App #" with all apps you want to score. - 4.Next, you will use the Creating the Dataset guide to extract the necessary data from Liquid and Grit's Impact Portal tools.
- 2.Set baseline parameters on the sidebar.
- 1.Checkmark the boxes for "Features", "Events", and "Content".
- 2.Set the date range to "All Time".
- 1.Setting a limited date range in this step will cause some characteristic data to not match up with the scoring scale.
- 3.Select a market.
- 1.Currently, only casino apps tracked by Liquid and Grit are available to score.
- 4.Select a genre and subgenre.
- 1.Apps can be scored against a broader market or within a sub-genre.
- 5.Select apps to compare.
- 1.
- 6.Download the CSV file and import it onto the "Upload Database CSV" tab on your Scorecard.
- 1.The CSV button is at the bottom of the left sidebar (see image).
- 7.Select all data on the sheet then press "Insert" > "Pivot table", and rename the new tab “Database Pivot”.

Download CSV
- 2.Set baseline parameters on the sidebar.
- 1.Set a date range.
- 1.We recommend quarterly or yearly ranges.
- 2.Checkmark "Events".
- 3.Select a market.
- 1.Currently, only casino apps tracked by Liquid and Grit are available to score.
- 4.Choose a genre and subgenre.
- 1.Choose the same market and subgenre selections as you did in the previous section when building your Database Pivot.
- 5.Select apps to compare.
- 1.Pick the same apps as you did when building your Database Pivot.
- 6.Download the CSV file and import it onto the "Upload Event Tracker CSV" tab.
- 7.Select all data on the sheet then press "Insert" > "Pivot table", and rename the new tab “Event Pivot”.
Open your Database Pivot to determine characteristic data for
- Total available features.
- Feature mechanic variety.
- New feature release rate.
- Event mechanic variety.
- New event release rate.
- Total available content.
- New content release rate.
- 1.Set Database Pivot parameters.
- 1.Under Rows add “tgp_game”.
- 2.Under Values add “title” summarized by “COUNTA”.
- 3.Under Filters add “type”.
- 2.Determine the total available features and content by swapping the “type” filter between the two.
- 1.Be sure only one "type" is active at a time, either features or content.
- 3.Add the number of total features to the proper "Results" column of the "Features" and "Content" tabs on your scorecard.
- 1.Add results for the total available features to table 1a (on the "Features" tab).
- 2.Add results for the total available content to table 3a (on the "Content" tab).
- 4.Set a score by determining where the results land on each tab’s scoring scale (see image).
In this instance, a result of 75 total available features falls within the range for a score of 8, a result of 36 gets a score of 4, and a result of 111 gets the maximum score of 12.
- 1.To score all-time release rates, continue to step #3.
- 2.To score release rates for a specific date range:
- 1.Add “publish_date” to Filters.
- 2.Set filter status to “Filter by condition> Is between" then add date ranges formatted as YYYY-MM-DD.
- 3.For consistent results set the same date range used to build the event pivot.
- 4.Recommended minimum date range is a quarter year.
- 3.Determine the total releases within the selected time frame by swapping the "type" filter between features, events, and content.
- 1.Be sure only one "type" is active at a time.
- 4.Add the total releases within the time frame to the proper "Results" column of each tab.
- 1.Add feature release rate results to table 1b (on the "Features" tab).
- 2.Add event release rate results to table 2a (on the "Events" tab).
- 3.Add content release rate results to table 3b (on the "Content" tab).
- 5.Determine the number of months in the selected date range for each app and add the results to the column labeled “Months” on the same table.
- 1.
- 6.Set a score by determining where the results for the release rates land on each tab’s scoring scale.
- 1.Remove the "publish_date" filter if one was set in the previous section.
- 2.Remove “title” from Values and replace it with “mechanic” summarized by “COUNTUNIQUE”.
- 3.Determine mechanic variety for features and events by swapping the “type” filter between the two.
- 1.Be sure only one "type" is active at a time, either features or events.
- 4.Add mechanic variety to the proper "Results" column on the "Features" and "Events" tabs.
- 1.Add feature mechanic variety results to table 1c (on the "Features" tab).
- 2.Add event mechanic variety results to table 2b (on the "Events" tab).
- 5.Set a score by determining where the results for mechanic variety land on each tab’s scoring scale.
Open your Event Pivot to determine characteristic data for
- Simultaneous active events.
- Active event days.
- 1.Set event pivot parameters.
- 1.Under Rows add “game”.
- 2.Under Values add “activity#” (starting with “activity1”) until there is one with no data listed for any app (see images #1 and #2).
- 3.Summarize each “activity#” by “COUNTA”.
- 4.Calculate the sum of each app’s row (see image #3).
- 1.Use the formula “SUM (value1:value2)” to quickly add the total for each game.
- 5.Add the sum to the results column of table 2c on the "Events" tab.
- 6.Determine the total number of days in the selected date range and add results to the "Days" column in table 2c (of the "Events" tab).
- 1.Use the formula “DATEDIF(start_date, end_date, “unit”) to determine the difference in days between two dates.
- 2.
- 7.Repeat for each app to compare simultaneous active events.
- 8.Set a score by determining where the results land on the scoring scale on the "Events" tab.
#1. Bingo Blitz has up to two activity numbers compared to Bingo Party’s three activity numbers.
#2. Continue to add “activity#” to Values until a column lists a “0” for all apps.
#3. Big Fish Casino’s total event count is 142.
- 1.On your Event Pivot table find the value in column “activity1” for each app (see image).
- 2.Add the value of “activity1” to the “Results” column of table 2d on the “Events” tab.
- 3.The value calculated under the percent column represents the percentage of days that had at least one active event within the time frame.
- 4.Set a score by determining where the results land on the scoring scale found on the "Events" tab.
Results from each tab are auto-populated onto the “Total Score” tab. When comparing a set of apps, ranked results for each section can be reviewed.
%20-%20Scorecard%20(Template)%20-%20Total%20Score.pdf.png?alt=media&token=ccef24f3-b1f0-4d2c-942f-83a5669b8c5d)
Example of final results.
Last modified 5mo ago