> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/openai-ads/openai-ads-supported-columns.md).

# OpenAI Ads - Supported Columns

Every column the OpenAI Ads connector can download.

These are the columns available to a OpenAI Ads connector. The recommended template uses a small subset, listed on the [OpenAI Ads](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/openai-ads.md) page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates.

## Dimensions

| Column                       | Type     |
| ---------------------------- | -------- |
| `id`                         | String   |
| `start_time`                 | DateTime |
| `end_time`                   | DateTime |
| `metadata.readable_time`     | String   |
| `metadata.timezone`          | String   |
| `campaign.id`                | String   |
| `campaign.name`              | String   |
| `campaign.status`            | String   |
| `campaign.description`       | String   |
| `campaign.start_time`        | String   |
| `campaign.end_time`          | String   |
| `campaign.budget.daily`      | Decimal  |
| `campaign.budget.lifetime`   | Decimal  |
| `ad_group.id`                | String   |
| `ad_group.name`              | String   |
| `ad_group.status`            | String   |
| `ad_group.description`       | String   |
| `ad.id`                      | String   |
| `ad.name`                    | String   |
| `ad.status`                  | String   |
| `ad.review_status`           | String   |
| `ad.title`                   | String   |
| `ad.copy`                    | String   |
| `ad.link`                    | String   |
| `ad_account.id`              | String   |
| `ad_account.name`            | String   |
| `ad_account.url`             | String   |
| `ad_account.budget.daily`    | Decimal  |
| `ad_account.budget.lifetime` | Decimal  |

## Metrics

| Column                      | Type    |
| --------------------------- | ------- |
| `ad.impressions`            | Long    |
| `ad.clicks`                 | Long    |
| `ad.spend`                  | Decimal |
| `ad.ctr`                    | Decimal |
| `ad.cpc`                    | Decimal |
| `ad.cpm`                    | Decimal |
| `conversions`               | Long    |
| `click_through_conversions` | Long    |
| `view_through_conversions`  | Long    |