Sorting
You can sort your results by any field in the query, ascending or descending. Up to three sort levels can be combined: rows are ordered by your first sort field, ties are broken by the second, and remaining ties by the third. A typical setup for a campaign report: sort byDate ascending first, then by Spend descending, so each day lists its biggest spenders on top.
Sorting is applied by Detrics before the data reaches your destination, so the rows arrive already ordered.
In Looker Studio, charts and tables usually re-sort data themselves. Set the sort inside the Looker report; the query-level sort mostly matters for Sheets, Claude, and BigQuery.
Column Order
Columns appear in the order you selected your fields, with dimensions first and metrics after. In the Google Sheets sidebar you can rearrange them by dragging fields before running the query. Column order is a presentation setting: changing it never changes the values, only where they land.Next Steps
Multi-Account Queries
Query several accounts of the same platform at once
Filters
Keep only the rows you care about