Overview

The Slice & Dice tool allows users to dig much deeper into the data from their game, finding insights that will allow you to improve the retention and monetisation and address questions such as:

  • Is the mission difficulty correctly balanced?
  • What items are being sold?
  • How much virtual currency is being consumed?

This tool runs against your HOT game data and is subject to any data retention policies on your game. You can access any events and parameters sent from your game and use them to build custom tables and charts.

Query Management

The toolbar at the top of the page provides functions to manage your Slice & Dice queries. You can create New queries and give them a friendly Name. Your queries can be Saved & Loaded again at a later date.  The button to Run your query is at the far right of the toolbar and you can export the results of your query as a JPG, PDF or SQL. Exported SQL can be used in Direct Access to run the query from your preferred SQL management tool.

Query Results

The results of your query will be displayed in the central panel as either a table or a chart.

you can toggle between table and chart display

SnD-chart-table-toggle

and choose the type of chart.

SnD-ChartType

You can maximize your query results area by sliding the “Navigation” and “Dimensions & Measures” panels out of view using the controls highlighted below.

 

Building Queries

Queries are built by choosing the Dimensions and Measures you want to analyse and dragging and dropping them in to the Rows, Columns and Filters panels to construct your query.

SnD-drag

Measures and dimensions that have been added to the Rows or Columns panels can be removed by clicking on their close icon SnD-remove-measure and you can click on the vertical arrows to sort your query results on in ascending or descending order. When you place a measure or dimension in to the filters panel you can click on their magnifying glass icon SnD-filter-measure to select what values you wish to filter on. If you get your rows and columns reversed you can use the swap button SnD-swap-axis to swap their axis.

This simple drag and drop interface will let you quickly build simple or complex queries and easily drill into your player behaviours.

Example –  Unique users per acquisition channel

You want to see how many unique users have started playing your game from each of your acquisition channels.

  1. Click on the NEW query button in the toolbar
  2. Drag the Unique Users Measure in to the Columns panel
  3. Drag the Acquisition Channel Dimension in to the Rows panel
  4. Press the RUN button on the toolbar
    This is a good start, you should see a table showing the number of unique users for each acquisition channel.SnD-UniqueUsers
    Let’s tidy it up a bit by removing the users with no acquisition channel and sorting the results in descending order.
  5. Drag an additional Acquisition Channel Dimension into the Filters panel.
  6. Click on the magnifying glass icon to reveal the filter options
  7. Click the Add All button to move all acquisition channel dimension values to the Selected panel and click OK
    Alternatively, you could have single or multi-selected individual values and used the Add button to select just the acquisition channel values you are interested in.
  8. Click the lower sort arrow on the Unique Users measure that you placed in the columns panel to sort the results by the number of Unique Users in descending order.
  9. Press the RUN button on the toolbar.
    Your display should look like the following.
  10. Click on the Untitled Query label in the toolbar and give your query a meaningful name.
  11. Press the SAVE button on the toolbar to save it
    NB – Queries you save are shared between users on your account.
  12. Click the Table / Chart toggle button to view your results as a Chart.
    Your display should now look like the following.

 

Dimensions and Measures

Dimensions come in 3 flavours.

  • Column Dimensions
    The queries above have all used column dimensions. These are the dimensions that you will use most often, they contain the value of a database row from a specific Column.
    e.g. missionName = “First Time User Forest”
  • Counter Dimensions
    A Counter Dimension is used to attach a counter to an event row based on conditions that you define. The counter can then be used as a filter where you can then analyse another columns on the selected event.
    e.g. A “First Time Deposit” counter dimension would put a counter on all transaction events from a user then you could filter your query to look at only the first transaction for each user.
  • Derived Dimensions
    A Derived dimension is used when you want to create a new dimension by aggregating two existing dimensions.
    e.g. Total Time Played / Number of Sessions = Average Session Length.

Column Dimensions

Column Dimensions are the event parameters you want to track. They refer to the names of the parameters SnD-dimension

Measures

Measures are the quantities of a parameter that you want to measure. Measures can be quantified 6 different ways MIN, MAX, COUNT, UNIQUE, SUM, AVERAGE SnD-Measure

A starting set of Measures and Dimensions are created when a game is added to the deltaDNA platform. They are based on the events and parameters that are added to each game by default.

 

SnD-MeasuresandDimensions

Adding: As you add new events you can add new Dimensions and Measures to track them in. Click on the ADD Button SnD-Add below the Dimension or Measure selection list to create a new one. Then select the parameter, give it a friendly name and click Add

SnD-AddMeasure

 

Date and Time dimensions can be modified if you want to focus on just one element of the Date/Time.

SnD-Month

Dimensions can only be added after data has been received from the event parameter.

Measures can only be added after the corresponding Dimension has been Added

 

When you are adding a Measure, the  aggregate selection list lets you specify how you want the measure to be counted.
NB – A count of UserID will count how many times the userID has recorded an event, e.g. one userID per event. To count the Unique users you need to count the number of UNIQUE userID.

Snd-Measure-Aggregates

 

Editing: Clicking on the Edit icon on a dimension or measure will let you alter or rename it. You may want to give some of your measures or dimensions friendlier names.

Dimension-Edit

 

Remove :  You can remove any Measures or Dimensions that aren’t being used by selecting them and clicking the Remove button. SnD-Remove

 

Counter Dimensions.

A Counter dimension lets you attach a counter to each event row that meets certain conditions that you specify. You can then use the counter to select specific rows and use these in your main query. The following example shows how build a query to find the first item that players are purchasing.

1) Create a new dimension by pressing the “Add” button and select “COUNTER” as the type of dimension.

1

2) Give the dimension a name, then add the conditions that will be used  as event conditions, then press the green “Add” button to create your counter dimension.

 

 

2

3) Your Counter Dimension will appear at the bottom of your Dimensions list. Drag and Drop it into the Query Filter panel

4) Then click the magnifying glass icon and select First Purchase = 0, this will let us query the First Purchase transaction event for each user.

5

5) Add in the details for the columns and rows you want to query. In this case we want to look at the number of UniqueUsers purchasing each itemName

6) And run your query.
Note, a couple of other filters have been added to this one.

 

 

7) You can export the SQL from your query by clicking the export export button on the toolbar if you want to see how the query was built and use it as the starting point for more sophisticated Direct Access queries.

 

Derived Dimensions.

You can build new derived dimensions calculated from existing dimensions or constants. Click on the Add button at the bottom of the Dimensions panel and select Derived from the Dimension Type drop down list.

Snd12

Derived Measures.

It is also possible to create derived measures, calculated from existing measures, constants or other derived measures. Click on the Add button at the bottom of the Measures panel and select Derived from the Dimension Type drop down list.

Snd13

Stacked Charts

Stacked charts can be created by selecting the Snd161 stacked chart icon when there is more than one measure in your query.

Snd15

It is also possible to create charts that are stacked by dimension however, you need to select which of your dimensions should be stacked by clicking on the relevant dimension in the Stack dimensions panel below the chart area.

Snd14