> ## Documentation Index
> Fetch the complete documentation index at: https://devdocs.xbox.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Getting started with Data Explorer basic mode

> Use PlayFab Data Explorer basic mode to build event queries without code, combining conditions and clauses to explore player events and analytics.

<Info>
  The Data Explorer feature is in public preview. We anticipate ongoing changes to it as we continue gathering feedback
</Info>

and optimizing for customer use.

Data Explorer basic mode is designed to let you quickly discover insights in your event data without requiring query language knowledge. This non-technical query building experience enables users to explore their data quickly. To learn how to write more complex queries, see the [Getting Started with Data Explorer (advanced)](/services/playfab/data-analytics/learn-data/data-explorer/getting-started-with-data-explorer-advanced) tutorial.

## Authoring custom queries

To begin authoring your own queries in basic mode, it's important to first understand the shape of the data you're accessing.

### The events.all table

The `events.all` table is the default destination for all incoming events. It's a single semi-structured table with columns for common values such as time & event name. You'll quickly become familiar with the EventData column, which contains the full original JSON payload and is useful in almost all queries. You can read the following documentation on the [events.all table](/services/playfab/data-analytics/acting-data/schemas-events-all).

### Query

A query is composed of one or more **Conditions** that are combined via the 'OR' logical operator. A condition is composed of an **Event** from the event.all table.

Complex conditions can be created by adding one or more **Clauses**, which is a logical statement composed of a **Variable**, **Operator**, and **Value**, to a condition. Clauses are combined via the 'AND' logical operator. The Variables listed in the dropdown are populated based upon the Event selected when creating the Condition.

The timeframe of the query can be adjusted by modifying **Start date** and **End date**.

The output of the query can be modified further by adding **Group By** and **Aggregate Type**. Group By modifies how the output rows are grouped, whereas Aggregate Type modifies how the rows are counted, summed, or distinct by.

You can create queries in the Query panel. Note that Data Explorer (basic) queries will only reference the top 100 events. To view all events, run the query in [Data Explorer (advanced)](/services/playfab/data-analytics/learn-data/data-explorer/getting-started-with-data-explorer-advanced).

## Query Output

After running a query, you can see the output below in the Query Output panel. The output is in the format of a bar graph as well as a table.

The graph shows the results for the largest five groups. You can see the other groups by clicking the dropdown at the bottom of the graph.

The table shows the Event Name, Timestamp (UTC), Player ID, and Event Data (via JSON) for reach row.

## Sample Queries

### Single Condition Queries

#### What regions are players logging in from this week?

<img src="https://mintcdn.com/microsoft-4404708b/MjJ0-cTsb1bpaMcX/images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_1.png?fit=max&auto=format&n=MjJ0-cTsb1bpaMcX&q=85&s=1d3d2ac0bdbe5836d5cabb6ff6ac4bb0" alt="Player logins by region this week" width="638" height="552" data-path="images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_1.png" />

#### What devices are players logging in from this week?

<img src="https://mintcdn.com/microsoft-4404708b/MjJ0-cTsb1bpaMcX/images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_2.png?fit=max&auto=format&n=MjJ0-cTsb1bpaMcX&q=85&s=c3f7e3d581d6e32f46cbb27e926a0c85" alt="Player logins by device this week" width="638" height="522" data-path="images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_2.png" />

#### What's the sum of order totals this week?

<img src="https://mintcdn.com/microsoft-4404708b/MjJ0-cTsb1bpaMcX/images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_3.png?fit=max&auto=format&n=MjJ0-cTsb1bpaMcX&q=85&s=dd04e21de53c2cdb0d6a76ca1e2da8c7" alt="Order totals sum this week" width="638" height="448" data-path="images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_3.png" />

#### Are PlayFab limits being exceeded?

<img src="https://mintcdn.com/microsoft-4404708b/MjJ0-cTsb1bpaMcX/images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_4.png?fit=max&auto=format&n=MjJ0-cTsb1bpaMcX&q=85&s=a01177c5c9ed08bef16ddf36bb885d7d" alt="Title limits exceeded this week" width="638" height="522" data-path="images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_4.png" />

### Multi Condition Queries

#### What players and entities are logging in this week?

<img src="https://mintcdn.com/microsoft-4404708b/MjJ0-cTsb1bpaMcX/images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_5.png?fit=max&auto=format&n=MjJ0-cTsb1bpaMcX&q=85&s=b3ac1b0d2c1061a4db286b4d629d6091" alt="Player or entity logins this week" width="638" height="636" data-path="images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_5.png" />

#### What items are being purchased or added to inventory this week?

<img src="https://mintcdn.com/microsoft-4404708b/MjJ0-cTsb1bpaMcX/images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_6.png?fit=max&auto=format&n=MjJ0-cTsb1bpaMcX&q=85&s=d33116ecd73b456d6186f3a45eb057fd" alt="Item purchased or added this week" width="638" height="636" data-path="images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_6.png" />

### Complex Condition Queries with Clauses

#### How many "sword" items were purchased this week?

<img src="https://mintcdn.com/microsoft-4404708b/MjJ0-cTsb1bpaMcX/images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_7.png?fit=max&auto=format&n=MjJ0-cTsb1bpaMcX&q=85&s=784f9f4b3d0c79f9add867e5f410eb95" alt="Sword item purchased this week" width="638" height="652" data-path="images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_7.png" />

#### How many items worth between $1 and $5 were purchased this week?

<img src="https://mintcdn.com/microsoft-4404708b/MjJ0-cTsb1bpaMcX/images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_8.png?fit=max&auto=format&n=MjJ0-cTsb1bpaMcX&q=85&s=8c1e2d5f082fa87533565c5c237dbb40" alt="Item value range purchased this week" width="940" height="664" data-path="images/playfab/data-analytics/learn-data/data-explorer/ExplorerBasic_Query_8.png" />

Example queries can be loaded into the Data Explorer basic by selecting “What’s This” and selecting a sample query.

## Limits

There are two limits that govern Data Explorer query usage:

1. Max query runtime: An individual query isn't permitted to run longer than 30 seconds. If this limit is exceeded, the query will be terminated and you'll receive an error message.

2. Interval Usage: Each title is permitted a cumulative total runtime of three minutes per any given 10 minute interval. If this limit is exceeded, you'll receive an error message and will need to wait before running additional queries.

## Data Retention

By default, Explorer queries run on hot storage, which can be configured in the Management tool. Queries that search beyond the data stored in hot storage will have significantly longer run times and may time out.


## Related topics

- [Getting started with Data Explorer advanced mode](/services/playfab/data-analytics/learn-data/data-explorer/getting-started-with-data-explorer-advanced.md)
- [Data Explorer quickstart](/services/playfab/data-analytics/learn-data/data-explorer/quickstart.md)
- [Data Explorer](/services/playfab/data-analytics/learn-data/data-explorer/index.md)
- [Getting Started with PlayFab Explorer](/services/playfab/data-analytics/acting-data/schemas-events-all.md)
- [Linux getting started](/services/playfab/multiplayer/networking/linux-specific-requirements.md)
