Day of the month Day of the year |
| ||||||
Day of the week Week of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Month of the year Month of the year |
| ||||||
Month and day Month and day |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Week of the year (start Sunday) Week of the year |
| ||||||
Year Year such as 2017. |
| ||||||
Year month Year and month. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year week Year and week. |
| ||||||
Ad — Created at Ad creation Unix timestamp. |
| ||||||
Ad — Destination URL Creative destination URL. |
| ||||||
Ad — ID Ad identifier. Example: ad_501 |
| ||||||
Ad — Name Internal ad name. |
| ||||||
Ad — Review status OpenAI ad review status. |
| ||||||
Ad — Status Ad delivery status. |
| ||||||
Ad — Text Customer-visible creative body text. |
| ||||||
Ad — Title Customer-visible creative title. |
| ||||||
Ad — Updated at Ad update Unix timestamp. |
| ||||||
Ad — Creative file ID Creative asset file identifier. |
| ||||||
Ad — Creative image URL Creative image URL. |
| ||||||
Ad — Creative type OpenAI creative type. |
| ||||||
Ad account — Currency code Account currency code. Example: USD |
| ||||||
Ad account — Daily budget Daily budget in the account currency, converted from OpenAI micros when available. |
| ||||||
Ad account — Daily budget micros Raw OpenAI daily budget in millionths of the account currency. |
| ||||||
Ad account — ID Ad account identifier. Example: act_123 |
| ||||||
Ad account — Lifetime budget Lifetime budget in the account currency, converted from OpenAI micros when available. |
| ||||||
Ad account — Lifetime budget micros Raw OpenAI lifetime budget in millionths of the account currency. |
| ||||||
Ad account — Name Ad account display name. Example: Acme Ads |
| ||||||
Ad account — Preview URL Account preview URL when returned. |
| ||||||
Ad account — Review status Brand review status returned by OpenAI. |
| ||||||
Ad account — Status OpenAI ad account status. |
| ||||||
Ad account — Timezone Timezone configured on the ad account. Example: UTC |
| ||||||
Ad account — URL Advertiser website URL. Example: https://www.acme.example |
| ||||||
Ad account currency code The currency code of the ad account. |
| ||||||
Ad account daily budget The daily budget of the ad account in its configured currency. |
| ||||||
Ad account ID The unique identifier of the ad account. |
| ||||||
Ad account lifetime budget The lifetime budget of the ad account in its configured currency. |
| ||||||
Ad account name The name of the ad account. |
| ||||||
Ad account URL The URL of the ad account. |
| ||||||
Ad destination URL The destination URL of the ad. |
| ||||||
Ad group — Created at Ad group creation Unix timestamp. |
| ||||||
Ad group — Description Ad group description. |
| ||||||
Ad group — ID Ad group identifier. Example: adgrp_301 |
| ||||||
Ad group — Name Ad group name. |
| ||||||
Ad group — Status Ad group delivery status. |
| ||||||
Ad group — Updated at Ad group update Unix timestamp. |
| ||||||
Ad group — Billing event type OpenAI bidding billing event type. |
| ||||||
Ad group — Maximum bid micros OpenAI maximum bid in micros. |
| ||||||
Ad group — Context hints JSON JSON-encoded context hints retained as configuration context. |
| ||||||
Ad group description The description of the ad group. |
| ||||||
Ad group ID The unique identifier of the ad group. |
| ||||||
Ad group name The name of the ad group. |
| ||||||
Ad group status The status of the ad group. |
| ||||||
Ad ID The unique identifier of the ad. |
| ||||||
Ad name The name of the ad. |
| ||||||
Ad review status The review status of the ad. |
| ||||||
Ad status The status of the ad. |
| ||||||
Ad text The text of the ad. |
| ||||||
Ad title The title of the ad. |
| ||||||
Aggregation level OpenAI entity level selected by the connector. |
| ||||||
Campaign — Created at Campaign creation Unix timestamp. |
| ||||||
Campaign — Daily budget Campaign daily budget in the account currency when available. |
| ||||||
Campaign — Daily budget micros Raw OpenAI campaign daily budget in micros when available. |
| ||||||
Campaign — Description Campaign description. |
| ||||||
Campaign — End time Campaign schedule end formatted as YYYY-MM-DD HH:MM:SS. |
| ||||||
Campaign — ID Campaign identifier. Example: cmpn_101 |
| ||||||
Campaign — Lifetime budget Campaign lifetime budget in the account currency. |
| ||||||
Campaign — Lifetime budget micros Raw OpenAI campaign lifetime budget in micros. |
| ||||||
Campaign — Name Campaign name. |
| ||||||
Campaign — Start time Campaign schedule start formatted as YYYY-MM-DD HH:MM:SS. |
| ||||||
Campaign — Status Campaign delivery status. |
| ||||||
Campaign — Updated at Campaign update Unix timestamp. |
| ||||||
Campaign — Excluded targeting JSON JSON-encoded excluded targeting countries retained as configuration context. |
| ||||||
Campaign — Included targeting JSON JSON-encoded included targeting countries retained as configuration context. |
| ||||||
Campaign daily budget The daily budget of the campaign in the account currency. |
| ||||||
Campaign description The description of the campaign. |
| ||||||
Campaign end time The scheduled end time of the campaign. |
| ||||||
Campaign ID The unique identifier of the campaign. |
| ||||||
Campaign lifetime budget The lifetime budget of the campaign in the account currency. |
| ||||||
Campaign name The name of the campaign. |
| ||||||
Campaign start time The scheduled start time of the campaign. |
| ||||||
Campaign status The status of the campaign. |
| ||||||
Clicks The total number of clicks on the ads. |
| ||||||
Conversions The total number of click-through conversions attributed to the ads. |
| ||||||
Country name The country of the reporting data as an ISO 3166-1 alpha-2 code. |
| ||||||
CPC Cost per click, recomputed after aggregation as spend divided by clicks. |
| ||||||
CPM Cost per thousand impressions, recomputed after aggregation. |
| ||||||
CTR Click-through rate, recomputed after aggregation as clicks divided by impressions. |
| ||||||
Device type The device type of the reporting data. |
| ||||||
End time End of the OpenAI reporting bucket as a Unix timestamp. |
| ||||||
Impressions The total number of times the ads were displayed. |
| ||||||
Insight row ID Opaque OpenAI identifier for the insight row. |
| ||||||
Product availability The availability of the product. |
| ||||||
Product body The body content of the product. |
| ||||||
Product brand The brand of the product. |
| ||||||
Product description The description of the product. |
| ||||||
Product feed ID The unique identifier of the product feed. |
| ||||||
Product image URL The image URL of the product. |
| ||||||
Product image URL (Google Sheets) The product image URL alias published for Google Sheets compatibility. |
| ||||||
Product item ID The unique identifier of the product item. |
| ||||||
Product price The price of the product. |
| ||||||
Product seller name The name of the product seller. |
| ||||||
Product target URL The target URL of the product. |
| ||||||
Product title The title of the product. |
| ||||||
OpenAI readable time Flat readable_time value returned by OpenAI. |
| ||||||
Spend The total amount spent on the ads in the account currency. |
| ||||||
Start time Start of the OpenAI reporting bucket as a Unix timestamp. |
| ||||||
Time granularity OpenAI time bucket selected by the connector. |
| ||||||
Reporting timezone The timezone of the reporting data. |
|