Get Report

Report OpenAI Ads (ChatGPT Ads) delivery, conversions, purchase sales and attributed events. Attribution windows and reporting clock are configurable in options. Event dimensions use event metrics. OpenAI Ads authenticates with an API key where each key maps to a single ad account, so there is no in-node list accounts or account selection — the connection itself determines the account. Use the list_connections tool to see which OpenAI Ads accounts the user’s connections have access to and pick the right connection_id.


App	OpenAI Ads
Operation ID	`openai_ads_get_report`
Type	Action
Connection	`openai_ads` (required)
Credits per run	1
Agent / MCP tool	Yes

Inputs

Field	Type	Required	Default	Description
`accounts`	null	No	-
`date_range`	DateRange	Yes	-	Date range for the report. Options: - Use preset=‘FIXED’ with start/end dates (YYYY-MM-DD) for specific date ranges - Use preset=‘CUSTOM’ with start/end dynamic values ({{nodeId__data.start_date}}) for dates from other nodes - Use other presets (TODAY, YESTERDAY, LAST_7_DAYS, etc.) for predefined ranges When using ‘FIXED’ or ‘CUSTOM’ presets, both start and end fields are required. For other presets, start and end will be ignored and calculated automatically.
`metrics`	array of string or SelectableOption	Yes	-	List of metrics to query. Don’t try to guess metric names, use the relevant tool to discover available metrics or prompt user to browse metrics in the UI.
`dimensions`	array of string or SelectableOption	No	-	List of dimensions to query. Don’t try to guess dimension names, use the relevant tool to discover available dimensions or prompt user to browse dimensions in the UI.
`filters`	array of FilterItem	No	-	List of filters to apply to the report. Each filter must have a field, operator, and value. Filters are combined using AND logic. If you want to use OR logic, use relevant operators like REGEXP_MATCH or IN_LIST.
`orders`	array of OrderItem	No	-	List of fields to sort the report by. Each order must have a `field` and `direction`. The field must be one of the current selected metrics or dimensions.
`limit`	integer	No	-	The maximum number of rows to return.
`options`	OpenAIAdsReportOptions	No	-	Formatting and attribution options, applied equally to both comparison periods. Zero-impression expansion supports unsegmented entities or product reports when enabled for the account.
`event_names`	array of string	No	-	Exact standard or custom event names to retrieve (1–500), as an array or JSON array. Only filters event details, not goal conversions or sales totals. Omit for all events.

DateRange

Field	Type	Required	Default	Description
`start`	string	No	-	The start date of the date range to query, format: YYYY-MM-DD or dynamic node reference like {{nodeId__data.start_date}}. Required when preset is ‘FIXED’ or ‘CUSTOM’.
`end`	string	No	-	The end date of the date range to query, format: YYYY-MM-DD or dynamic node reference like {{nodeId__data.end_date}}. Required when preset is ‘FIXED’ or ‘CUSTOM’.
`preset`	string	No	-	Predefined date ranges or input modes: - Use ‘FIXED’ or leave empty when you want to specify exact dates (YYYY-MM-DD format) in start/end fields - Use ‘CUSTOM’ when you want to use dynamic values from other nodes ({{nodeId__data.start_date}} format) in start/end fields - Use other presets (TODAY, YESTERDAY, LAST_7_DAYS, etc.) for predefined date ranges (start/end will be ignored) LAST_N_MONTHS and LAST_N_WEEKS are complete calendar periods ending with last month or last week, so they exclude the current month or week; for a rolling window up to yesterday use LAST_N_DAYS (for example LAST_90_DAYS) or a FIXED range. When using ‘FIXED’ or ‘CUSTOM’, both start and end fields are required.
`compare`	CompareOptions	No	-	Optional comparison date range settings. ALWAYS use this field for comparisons; DO NOT create additional requests or nodes, as the backend returns current, comparison, and delta metrics in a single call.

Field	Type	Required	Default	Description
`field`	string or SelectableOption	Yes	-	The field to filter on, must be one of the current selected metrics or dimensions.
`operator`	string	Yes	-	The operator to use for filtering. Must be one of the supported values. Use REGEXP_MATCH to search/filter by multiple OR values like ’.(summer\|holiday).’
`value`	string	Yes	-	The value to filter by, always as a string: text, a number, or a regex. For IN_LIST and NOT_IN_LIST, pass the values as one comma-separated string such as ‘a,b,c’, not as an array. For regex values, escape backslashes once in the JSON string: write \b for a word boundary, not \b.

OpenAIAdsReportOptions

Field	Type	Required	Default	Description
`pretty_column_names`	boolean	No	-	whether to use pretty column names in the report (e.g., ‘Clicks’ instead of ‘clicks’).
`show_percent_sign`	boolean	No	-	whether to show percent sign for percentage metrics (e.g., ‘58%’ instead of ‘0.58’).
`currency_symbol`	string	No	-	the currency symbol to use for monetary values (e.g., ’$’).
`compact_numbers`	boolean	No	-	whether to use compact number format (e.g., ‘1K’) and round decimals. Takes priority over thousand_separators.
`thousand_separators`	boolean	No	-	whether to format numbers with thousand separators (e.g., ‘105,878’) and round decimals. Ignored if compact_numbers is enabled.
`pivot_dimensions`	array of string	No	-	the dimensions to pivot the report on. Must be one of the current selected dimensions.
`include_zero_impressions`	boolean	No	-	whether to include zero impressions in the report.
`attribution_window_days`	enum (`7`, `14`, `30`)	No	`30`	Click-through attribution window in days; default 30.
`view_through_attribution_window_days`	enum (`0`, `1`)	No	`1`	View-through attribution window: 1 day, or 0 to disable.
`attribution_time_basis`	enum (`ad_event_time`, `conversion_time`)	No	`ad_event_time`	Attribute to the ad interaction date or conversion date. Conversion-time non-goal event coverage may be limited.

OrderItem

Field	Type	Required	Default	Description
`field`	string or SelectableOption	Yes	-	The field to sort by. must be one of the current selected metrics or dimensions.
`direction`	string	Yes	-	The order to sort by, must be one of ‘ASC’, ‘DESC’

SelectableOption

Field	Type	Required	Default	Description
`value`	string	Yes	-
`label`	string	Yes	-

CompareOptions

Field	Type	Required	Default	Description
`start`	string	No	-	The start date of the comparison range, format: YYYY-MM-DD. Optional if preset is provided.
`end`	string	No	-	The end date of the comparison range, format: YYYY-MM-DD. Optional if preset is provided.
`preset`	string	No	-	Predefined comparison ranges. When provided, start and end will be ignored.
`comparison_format`	string	No	`rows`	Comparison output layout: ‘rows’ returns separate rows for current, comparison, and delta along with date ranges; ‘columns’ returns a single row with delta values only as additional _pct or _change columns depending on comparison_value_type.
`comparison_value_type`	string	No	`percentage`	Value type: ‘percentage’ or ‘absolute’

Output

Type: List[Dict] Returns list of rows. Each row is a dict with keys matching selected metrics/dimensions. If ‘pretty_column_names’ is enabled, keys are formatted. Fields: dynamic (depend on the inputs) Example:

[
  {
    "date": "2026-05-01",
    "campaignName": "Brand",
    "impressions": 12000,
    "clicks": 240,
    "spend": 85.0
  }
]

Get Started

Guides

Operations

Inputs

DateRange

FilterItem

OpenAIAdsReportOptions

OrderItem

SelectableOption

CompareOptions

Output

​Inputs

​DateRange

​FilterItem

​OpenAIAdsReportOptions

​OrderItem

​SelectableOption

​CompareOptions

​Output

Inputs

DateRange

FilterItem

OpenAIAdsReportOptions

OrderItem

SelectableOption

CompareOptions

Output