Dynamic Reports in the DT Console provide a structured approach to data exploration and support decision-making through organized, customizable outputs. With Dynamic Reports, you can:
- Create custom reports with levels of detail using selected dimensions and metrics.
- Apply filters and splits to organize datasets into concise formats.
- Save reports for future access, share them with others, and download them.
To view reports on the DT Console:
- Log in to the DT Console.
- From the left navigation bar, click Dynamic Reports.
- Select the report you wish to view.
The selected report appears.
To view the report in different formats, do one or both of the following:
-
- Select a Dimension, as described in Dimensions.
- Select a Metric, as described in Metrics.
Key Concepts
The following table describes the main concepts of DT's Dynamic Reports.
Concept | DESCRIPTION |
---|---|
Dimension | Dimensions are descriptive attributes that add context to data. You can filter by a dimension to categorize information, such as Country, Device OS, or Publisher Name. For example, dimensions allow you to compare a device type and location to determine that interstitial ads perform better on Android in the United Kingdom. |
Metric | Metrics are numeric values that measure performance across Dimensions. Metrics provide measurable values for analysis, such as Revenue, Impressions, and Clicks. For example, metrics allow you to calculate the number of Clicks across different device types to identify which devices drive the most engagement. |
Filter | Filters allow you to present only the data that matches specific conditions while removing unwanted information. For example, if a report includes the Country and Device OS dimensions, you can filter Country to show data only for the United Kingdom, which removes results from other countries. You can also filter Device OS to present only iOS users within the United Kingdom and exclude data from other operating systems. |
Split | A Split groups a Dimension by a Metric and applies a maximum limit to create a structured data breakdown. For example, a report that splits a Country by Gross Revenue ranks the countries by total revenue. A second split by Device OS divides each country into iOS and Android and presents the revenue for each device separately. A report with a limit of 100 presents only 100 device combinations. |
Configuring Reports
Configure reports by selecting appropriate dimensions and metrics to analyze data based on specific criteria:
Dimensions
Dimensions group and segment data using attributes, such as Country or App Name. Some dimensions may be mandatory depending on the report type, as specified in the instructions on the DT Console. The following procedures describe how to use the Dimensions feature:
- Selecting a Date Range
- Comparing Dates
- Selecting Dimensions
- Filtering by Dimensions
- Splitting by Dimensions
- Using the Pinboard
Selecting a Date Range
The Date filter appears by default and is automatically set to today's date. A date range allows you to filter and analyze data within a specific time. To select a specific date range:
- In the Filter section, click the Date filter.
The calendar appears. - Do one of the following:
-
- Select an option from the Date Preset list.
- Manually select the required dates on the Date Selector.
- Click Ok.
The report updates with the selected date range.
Comparing Data over Date Periods
Comparing data over different periods allows you to identify changes and patterns. For example, analyze App ID performance across devices and locations over time. To compare data within a period:
- In the Filter section, click the Date filter.
The calendar appears. - Select the Compare to checkbox.
- Do one of the following:
-
- Manually select the required dates on the Date Selector.
- Select an option from the Date Preset list and click Previous Period or Custom.
Note
The Previous Period option selects the same date range immediately preceding the current selection. For example, if you choose Quarter to Date, the Previous Period is the corresponding date range from the previous quarter.
- Click Ok.
The report updates and shows a data comparison.
Selecting Dimensions
To select a dimension, use one of the following methods:
- Using the Search Feature
- Selecting Dimensions from Groups
- Selecting a Dimension from the Dimensions List
Note
Include a Dimension in the Filter or Split fields to generate a detailed report.
Using the Search Feature
The search feature allows you to locate specific dimensions within the Dimensions pane. To search for a dimension:
- In the Dimensions pane, click on the magnifying glass icon.
- Begin typing the name of the dimension you require.
A filtered list of matching dimensions appears. - To select the required dimension, do one of the following:
- Drag and drop the dimension into your report's Filter or Split section.
- Click on the dimension to view the available functions and select Filter or Split.
The report updates reflect the selected dimension.
Note
There are two Split options:
- To replace the current split, click the Split button with a frame (
).
- To add another split, click the Split button with a plus (
).
Selecting Dimensions from Groups
Dimension groups organize related dimensions into categories. To select a dimension from a group:
- In the Dimensions pane, click on the relevant Dimension group to expand and view the included dimensions.
A list appears. - To select the required dimension, do one of the following:
- Drag and drop the dimension into your report's Filter or Split section.
- Click on the dimension to view the available functions and select Filter or Split.
The report updates to reflect the selected dimension.
Selecting a Dimension from the Dimensions List
The Dimensions list allows you to browse and locate a dimension manually. To select a dimension:
- In the Dimensions pane, locate your desired dimension from the Dimensions list.
- To select the required dimension, do one of the following:
- Drag and drop the dimension into your report's Filter or Split section.
- Click on the dimension to view the available functions and select Filter or Split.
The report updates to reflect the selected dimension.
Filtering by Dimensions
Filtering by dimensions allows you to refine report data by applying specific conditions to present only relevant information. To filter by dimensions:
- In the Filter section, click the required Dimension.
A list appears. - To narrow the filtering criteria, select the required checkbox(es) from the drop-down list.
- Click OK.
- (Optional) To Include or Exclude data for the selected dimension in your results:
-
- Click the selected dimension, then click the Include/Exclude Filter drop-down list icon.
- Select the required checkbox.
- Click OK.
The report updates and reflects the selected dimension.
Tip
Brackets next to the dimension name show the number of selected items when you filter multiple dimensions.
Splitting by Dimensions
Splitting a report allows you to break down data into one or more dimensions and compare data across categories. To split data:
- In the Split section, click the selected dimension.
The Sort By and Limit drop-down lists appear. - Select the required option from each drop-down list.
- Click OK.
The report updates to reflect the selected dimension and appears in the central pane in the required format.
Using the Pinboard
The Pinboard allows you to save and access specific dimensions without re-applying filters or splits. It also displays ranked data based on a selected metric, even if that data does not appear in the main report. To use the Pinboard:
- From the Metrics drop-down list, select a Metric. See Metrics for more information.
- Select a Dimension, as described in Selecting Dimensions, and then do one of the following:
-
- Drag and drop the dimension into the Pinboard section.
- Click on the dimension to view the available functions and select Pin.
The dimension and its data appear.
- (Optional) To view the data with a different Metric, select a new metric from the drop-down list.
The Pinboard automatically updates, and the data appears.
Metrics
Metrics apply numerical data across dimensions to segment and analyze data based on specific criteria. These include quantitative values like Revenue, Clicks, or Impressions and help measure and assess performance in reports. Metrics are pre-selected and depend on the report type.
Adding Metrics
The following procedures describe how to add Metrics to your report:
- Using the Search Feature
- Selecting Metrics from Groups
- Selecting a Dimension from the Dimensions List
Using the Search Feature
The search feature allows you to locate specific metrics within the Metrics pane. To search for a metric:
- In the Metrics pane, click on the magnifying glass icon.
- Begin typing the name of the metric you require.
A filtered list of matching metrics appears. - Select the required metric and click the checkbox.
The report updates to reflect the selected metric.
Selecting Metrics from Groups
Metric groups organize related metrics into categories. To select a metric from a group:
- In the Metrics pane, click the relevant Metric group to expand and view the included metrics.
- Select the required metric and click the checkbox.
The report updates to reflect the selected metric.
Selecting a Metric from the Metrics List
The Metrics list allows you to browse and locate a dimension manually. To select a metric:
- In the Metrics pane, locate and select your desired metric from the Metrics list.
- Select the required metric and click the checkbox.
The report updates to reflect the selected metric.
Note
Include at least one metric to generate a report. Some reports have default metrics pre-selected.
Customizing Data Views
Dynamic Reports offer a lot of flexibility in terms of how you want to review your data by allowing multiple Data Views.
- Total: Metrics appear as overall sums or total values.
- Table: Metrics appear as columns in tables.
- Line Chart: Metrics appear as graph trend lines.
- Bar Chart: Metrics appear as bars.
Total
The Total view presents the overall sum or total value of selected metrics, which provides a summary of performance. This is the default view. To select a Total report:
- In the central pane, click Total.
The report appears.
Table
The Table organizes data into rows and columns, which presents selected metrics and dimensions for comparison. It provides a structured view and a detailed analysis across different categories. To select a Table report:
- In the central pane, click Table.
The report appears as a table.
Arranging a Table
You can customize the table layout by sorting, deleting, or rearranging columns to organize your data. To arrange a Table, do one or more of the following:
- To sort the information in ascending or descending order, click the arrow icon on the column header.
- To delete a column, click the column heading and the X icon.
- To rearrange columns, click the required column heading and drag it to the desired location.
The report updates and reflects the updated table.
Line Chart
Tip
Use a date range with line and bar charts for a comprehensive data view.The Line Chart presents data trends over time using a line graph, which allows you to track changes in metrics across different periods. To select a Line Chart report:
- In the central pane, click Line Chart.
The report appears as a line chart. -
(Optional) To view specific data, hover your mouse pointer over the date, and a data tooltip appears with additional details.
Bar Chart
The Bar Chart displays data as rectangular bars, the bar length reflects the value of the selected metric. This format allows you to compare values across different categories. To select a Bar Chart:
- In the central pane, click Bar Chart.
The report appears as a bar chart. - (Optional) To view more information, click on a bar, and a data tooltip appears with additional details.
Managing Reports
Managing and sharing reports allows you to save, revisit, and share your data. The following procedures describe how to save, share, and download reports:
Saving Reports
Save reports to keep them for future access. To save a report:
- In the top-right toolbar, click the Save icon.
The saved report appears in the Saved Reports drop-down list.
Opening Saved Reports
You can reopen a saved report to continue your analysis. To open a saved report:
- In the top-right toolbar, click the Saved Reports drop-down list.
- Double-click the selected report.
The report appears.
Managing Saved Reports
Update or remove saved reports to organize the Saved Reports list. To save or delete a report:
- In the top-right toolbar, click the Saved Reports drop-down list.
- Select a report and then click the Edit icon.
- Do one or both of the following:
-
- To rename a report, enter the new report name and click SAVE.
- To delete a report, click DELETE REPORT.
Downloading Reports
Download reports in various formats for use with external tools or further analysis. To download reports:
- In the top-right toolbar, click the Download icon.
- (Optional) Select one of the following formats: CSV or XSLX
The report downloads in the selected format.
Note
The CSV delimiter is comma.
Sharing Reports
Sharing reports via URL allows other DT Console users to view the report in the DT Console (provided they have the necessary DT Console permissions). To share a report:
- In the top-right toolbar, click the Share icon.
The report URL is copied into the clipboard. - Share the report URL as needed.