> 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.md).

# OpenAI Ads

How to connect OpenAI Ads to Roivenue, what the default setup downloads, and how the figures are put together.

OpenAI Ads. The Roivenue connector downloads daily impressions, clicks and spend per ad, plus the conversions OpenAI attributes to them.

## Setting up the connector

Add an OpenAI Ads connector in Roivenue and paste your Ads API key. You can generate one in the OpenAI dashboard, under the ad account you want to read. Each key is scoped to a single ad account.

## What the default setup downloads

One job, bringing back one row per ad and day.

### Where the values land

| OpenAI Ads field | Roivenue column |
| ---------------- | --------------- |
| `campaign.name`  | adCampaign      |
| `ad_group.name`  | adGroup         |
| `ad.name`        | adName          |
| `ad.impressions` | impressions     |
| `ad.clicks`      | clicks          |
| `ad.spend`       | cost            |
| conversions      | conversions     |

Conversion value is set to zero, so OpenAI Ads supports cost per acquisition but not return on spend.

An API key reaches exactly one ad account, so several ad accounts mean several connectors.

The job reprocesses the last 90 days on every run.

## Available columns

The table above is what the recommended template downloads. Every column this connector can bring back is listed on [OpenAI Ads - Supported Columns](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/openai-ads/openai-ads-supported-columns.md).

Adding one means editing the connector in the Advanced Editor, which stops that connector receiving template updates.

## How far back the data goes

The connector will request up to three years of history. How much arrives depends on what the platform holds for the account.

## Troubleshooting

<details>

<summary>Revenue is zero</summary>

The template brings conversion counts without their value, so conversion value is set to zero. Take revenue from your order data.

</details>

<details>

<summary>Only one ad account's data arrives</summary>

An OpenAI Ads API key is scoped to a single ad account. Add a connector per account.

</details>