---
title: "Order data"
slug: "order-data"
updated: 2025-09-14T22:07:20Z
published: 2025-09-14T22:07:20Z
stale: true
---

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

# Order data

Supermetrics API supports two separate parameters to order data.

## Parameters

- **order_rows** (string | string[])
  - Optional. Common order instructions for data in rows. See [ordering rows](/v1-api/apidocs/order-data#ordering-rows).
- **order_columns** (string)
  - Optional. Order instruction for data in columns. See [ordering columns](/v1-api/apidocs/order-data#ordering-columns).

## Ordering rows

Use parameter order_rows to order returned rows. Limited to two instructions.

```plaintext
{"order_rows": ["[field_name] [asc|desc]", ...]}
```

Value can be provided either as a comma delimited string, or as a list of strings.

```plaintext
{"order_rows": "CampaignName asc, impressions desc"}
{"order_rows": ["CampaignName asc", "impressions desc"]}
```

## Ordering columns

Parameter order_columns only applies when query contains at least one field that splits the data by column, like in the following example.

```plaintext
{
    "fields": [{"id":"campaign", "split":"column"}],
    "order_columns": "alphabetic"
}
```

## Order column types

| Type | Description |
| --- | --- |
| met_desc | Order descending by first metric. Default. |
| alphabetic | Order dimension values alphabetical order |
| reverse_alphabetic | Order dimension values in reversed alphabetical order |