Reports
In this section you have several menu tabs:

Basic Metrics

In this section you can create and save custom reports. To create a custom report, choose metrics you want to see and click the “View result” button. If you would like to build the report after changing settings, use the “Refresh” button. You can choose up to 3 metrics.
You can change the following settings of the chart:
‘Group By’ section includes two lists: ‘Main groups’ with the basic criteria for grouping such as ‘Applications’, ’Country’, ‘Platforms’, etc. and ‘Custom user properties’ which contains custom properties that are being sent to ‘User profile’.
If you select any parameter in the ‘Group By’ dropdown list, except ‘None’, you will be able to see the result for the top values by ticking the box.
This setting is optional for the ‘Main groups’ and mandatory for ‘Custom user properties’.
Also, you can select the number of top values to be shown (from 1 to 50) and select a specific metric to be displayed.
If you are going to group metrics by Custom user properties with numeric values, please note that only properties with up to 1,000 unique values could be used for grouping.
Moreover, you can turn in the following options:
    Trend - add a trend function
    Smooth - makes lines on the chart more smooth
    Cumulative - add a cumulative function
    Labels - if you previously created any labels, you can turn them on/off on the reports
Default report period is the last 30 days, you can change it in the top right corner. You can configure a filter in the report. Use already created filter template or custom segment to get more detailed data. To apply changes press “Refresh” button.
For example, if you update your custom user characteristic that shows how many friends your players invited, you can later monitor the distribution of the revenue metrics by the number of users a player added. Also, you can now filter Top N by the chosen metric when the grouping is active. When you group by the custom values of the user card, the active grouping is obligatory. If you need to build a report not for the whole user set but for a user segment, you can click the "Segments" button. To build a report after you’ve defined all the settings, click the “View Results” button.
You can save the report for further, share it with teammates or on Slack. You can find these options in the top right corner under the “Menu” sign.

Conversion Funnels

The Conversion Funnel report allows you to create conversion funnels based on the sequence of custom events. With this report you get statistics on the number of unique users who completed these events.
To launch the report, choose up to 4 steps by clicking the "Add step" button. The sequence here is important: if you take A, B and C steps, first you will get the number of users who completed the A event, then the number of users who completed both A and B events, then the number of users who completed A, B and C events during a selected period of time.
To specify the value of step’s parameters, click "Add parameter" button to the right of the step, choose a parameter and set value’s condition. Choose dates when events are completed by modifying the date range menu on the top right of the page. Click "View result" to see the funnel.
You can also set a time limit between two steps ("Step time limit" check button), make a step optional ("Optional" check button; in this case, two funnels will be built: with users who have and haven't completed the step) or set a time limit for the whole funnel. In the last case, if the user completes only 2 of 5 steps for the selected time, they will be calculated on these 2 steps, even if they complete all steps but it takes more time than you set.
You can also select the type for the funnel and choose between a table or a chart.
Also, you will be able to set an ‘Aggregation period’ to see how users pass the steps on the specific days, weeks or months. This chart shows the conversion and number of users at different steps like if this funnel was built only for the data point (day/week/month) of the horizontal axis.
For example, if you select aggregation by days and report time frame from July 1 to July 7, then for July 1 on the chart you will see only those users who started and finished the steps on that day.
To set a filter based on app version, channel, device or some custom segment, click the "Filter" button on the top right of the page. Compare the funnel for different segments by clicking “Add comparison”. The funnel will be built after clicking “View result” or “Refresh” buttons.
The number of unique users that completed events during a chosen time period is presented in the vertical axis of the chart.
The funnel can be saved by clicking the "Save" button in the top right corner. It will be available in the funnels list in the “Conversion Funnel” section.
After the funnel is created, you can see a grey icon to the right of each funnel step. A click on this icon shows the menu with the following options:
    When the ‘Aggregation period’ is disabled, you will be able to see conversion dynamics for steps. It shows the distribution of the conversion by days between two neighboring steps. The denominator for this conversion always stays the same - it is the number of users who performed the funnel step. The numerator contains the number of users who converted on a specific day. For example, if you build a funnel from the 1st to the 7th of July, then for the 3rd of July you will see the users who performed the specific step on the 3rd of July related to users who performed this step for the whole period (1st to 7th of July).
    “Create segment” allows to create a static segment, which contains users who completed funnel steps to the current one inclusively
Also, the results of the funnel can be exported as a .csv file by clicking the “Export” button in the top right corner.
This report requires Custom Event integration. Learn more here

Custom Events

The Custom Event report allows you to analyze and keep track of user activity collected as custom events.
Custom events are used to track particular user actions, which you specified for your app, such as:
    Any action a user takes in the app (hits, shoots, moves, putting an item into the basket, etc.)
    Taps on certain menu elements.
    Users' search for items in a virtual shop, etc.
You can track both events and their parameters (properties) and you can set up to 20 parameters for each event. For example, if you have an event for battle creation, parameters can be duration, map, number of players, battle mode, etc.
When one or more events are integrated, you can start using the Custom Event report.
To build the report, select up to 3 events above the report, and to set a filter for event parameters, select a parameter and value.
You can change the following report settings:
    Metric type – what you want to calculate; and it can be one of the following:
      Events - total number of performed events.
      Users - count of unique users that perform events.
      % of active - is a proportion of unique users that perform events to active users in a period.
      Average and Median events per user - is how many times users perform events in a given period (in an average or median mean).
    Aggregation period – the time period over which the data are aggregated (5 min, hour, day, week, month, year). To use a 5 min aggregation report the time frame should be 2 days or less.
    View – chart type (chart, table or transposed table, area chart, and bar chart).
Also, there are powerful Grouping capabilities. You can select “on” in the Group by selector and then select up to 2 grouping levels. It can be user properties like app version, channel, country, language, device, paying capacity, paying status, campaign. For every grouping, you can select Top N filter to include into the report only Top N groups by events count.
And more complex grouping options such as Frequency and Parameter values grouping. Frequency grouping shows you how many users perform your events 1 time, 2 times, 3-5 times, and so on. So you can decide if they used it because it’s just a new button or feature in your app, or because it is a really useful feature. You can follow the frequency of use of any event dynamic and analyze how it’s changed over time or over app versions.
To analyze parameters of your events select “Parameter value” in a group by section then select the parameter and then one of the parameter functions. For numeric parameters it can be:
    Average and Median per event - is an average or median numeric parameter value for selected events.
    Sum - is a total sum of selected parameters for events (for example total sum of coins spent by users on every level).
    Distinct values - are unique values of the selected parameter. For every parameter value, you can calculate the total events count or unique users that perform an event with this parameter value (pick one of them in Metric view selector).
    Distribution - is a grouping option that allows you to analyze unlimited numeric parameter values that will be grouped into the bins; for each bin, you can calculate total events count or unique users that perform events within this parameter value bin.
Text parameters are always analyzed by distinct values, so for every text value, you can calculate the metric chosen in the Metric Type list.
To see results, choose the events and click the "View result" or “Refresh” button.
If you'd like to work with data on your own, click the "Export" button and data will be exported as a .csv file. Data in the exported file can be sorted by days.
Also, you can save the report by clicking the “Save” button. It will be available in the “Custom Events” section.
The default report period is the last 7 days; you can change it in the top right corner. You can configure a filter in the report, use an already created filter template or custom segment to get more detailed data. Compare different segments by clicking “Add comparison”. To apply changes tap the “Refresh” button.
This report requires Custom Event integration. Learn more here

SQL Wizard

SQL Wizard allows you to create SQL-like queries and extract any type of data related to your project from the devtodev database.
Click "Add column" to start editing your query, then select columns for your report. You can choose any data about:
    User data (install date, country, app version, etc.)
    Basic events (sessions, payments, in-app purchases, tutorial steps, etc.)
    Custom events (any parameters of any custom event that you've integrated)
After you select columns, the body of the query will be created. All connections (joins) between the tables are set, but you can change them if necessary.
Drag and drop column names to reorder them in the report. If you need to use an aggregate function (AVG, MAX, MIN, etc.), click the down arrow button right to the column name and select a function from the list.
To add conditions to your query, click "Add conditions" button and then add rules (or groups of rules and logical operations between them) by clicking "Add rule" / "Add group" buttons.
Finally, you can set the order of lines in the report by filling the "Order by" condition.
Click "View result" - and the results of your query will be shown in the table below.
Please note that only 200 lines are shown here, but you can get complete data by downloading results as a .csv file.
You can save this query to use it again in future by clicking the "Save report" button.
Last modified 7d ago