> For the complete documentation index, see [llms.txt](https://help.smartico.ai/welcome/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.smartico.ai/welcome/products/tools-and-guides/faqs/faq-data-studio-and-reports.md).

# FAQ: Data Studio & Reports

### **How to analyze the fail rate in the communication channels**

{% embed url="<https://www.youtube.com/watch?v=zK99YkIHpBc>" %}

### **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.

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-4434d798b7d1fea0474966e00c99f97291669cb1%2F13d6f2b5c2-crop-1-8e5c5905-6d317b.png?alt=media" alt=""><figcaption></figcaption></figure></div>

### **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.

<div data-with-frame="true"><figure><img src="https://77049817-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FfS5hl0PiysHtKAKMsQTe%2Fuploads%2Fgit-blob-193356de31b6811002ccc273ddf6e663fa597b48%2Fe47887a007-crop-2-9ffef78f-a2a5e5.png?alt=media" alt=""><figcaption><p>Format CSV file in the columns</p></figcaption></figure></div>

### **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.

<div data-with-frame="true"><figure><img src="https://lh6.googleusercontent.com/tsOAHStunjznNs2ldgr0FxpaqCDXRRi8r0CSVvdOxMU9STr023sVRWJDmF-djVSkPfhkQuqkAO5May4fP9OxOrJtP23eNRtlA8LtW9DRHCAQ8xqRj-4JaYXmbIID0YDx5X4RNZYYqV8DpaD98HEhqGfg85y0jwOYqTw-SusMHeT0Ddg544IPoJlT" alt=""><figcaption></figcaption></figure></div>

### **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 (metrics that count distinct values, and percentile metrics), 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 **Events History** screen (**CRM → Info → Events History**), the User Segments export in Back-Office, or query the [Smartico Data Warehouse](/welcome/technical-guides/smartico-data-warehouse.md) directly.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://help.smartico.ai/welcome/products/tools-and-guides/faqs/faq-data-studio-and-reports.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.