Construct ADQL Queries

Each ADQL event query begins with a SELECT statement that uses a FROM clause. Use the FROM clause to specify the data source you want to query. You can query one data source in each query.

Use the SELECT statement to further qualify the query using field_expressions and math_expressions. The WHERE clause adds conditions. For more details on specific ADQL syntax, keywords, functions, and operators, see the ADQL Reference.

Note: When you search Analytics data, the values shown for segment fields are from the originating tier segment. Data from downstream (non-originating) tier segments are not shown. Double-click on the transaction row to view downstream segment data. Then select the Transaction Data tab.

When you click Search for queries other than select all fields (SELECT *), the results display on the visualization tab where the table widget accurately renders your query.