FAQ: Data Studio & Reports

How to analyze the fail rate in the communication channels

How can I export the data to Excel

Switch to the "Table" presentation of data and click on the "CSV" icon in the top area of the table. Be sure that you have the "Collapse rows" flag enabled in order to include grouped dimension columns and generate a flat table presentation without grouping.

Why is the Grand Total row hidden in the table?

When the "Collapse rows" option is active to present a flat table, the Grand Total row is automatically hidden in the interface. To inspect the Grand Total in the table view, turn off "Collapse rows". If you need totals for exported CSV files, you can calculate the sum directly in your spreadsheet software.

How to open CSV file in Excel

If you open CSV in Excel and the data is not set in the proper columns automatically, use the button "Text to columns" in the upper menu of Excel.

Format CSV file in the columns

I cannot find the specific record in the view, I only see 5 rows

When using dimensions, by default only 5 records are shown per group. Click on the dimension name in the split bar to select a higher row limit (such as 10, 25, 50, or 100) or sort by a specific metric.

Why do some values appear as "undefined" or blank in Data Studio reports?

When generating reports with multiple group-by dimensions across large volumes of data, the system queries each column sequentially. If processing limits are reached, later columns may stop populating, displaying "undefined" or empty values. To prevent this, reduce the number of simultaneous group-by dimensions, narrow your date range or filters, or use the Data Warehouse for large detailed exports.

What does the double tilde (≈) symbol mean next to metrics?

A double tilde ("≈") next to a metric indicates an estimated count rather than an exact value. This approximation is used for high-volume metrics such as unique active users, allowing the platform to calculate totals instantly across millions of records without scanning every individual transaction. The underlying data remains accurate.

How can I export raw player-level or event-level data?

Data Studio is optimized for aggregated analytics and multi-dimensional reporting. For granular row-level data—such as full event logs, player transaction histories, or user segment lists—use the Event History screen, the User Segments export in Back-Office, or query the Smartico Data Warehouse directly.