| App | Amazon Ads |
| Operation ID | amazon_ads_get_report |
| Type | Action |
| Connection | amazon_ads (required) |
| Credits per run | 1 |
Inputs
| Field | Type | Required | Default | Description |
|---|---|---|---|---|
accounts | array (also accepts a comma-separated string) | Yes | - | A list of accounts to query. Ask the user for it if not provided, or use other tools to fetch the accounts details first. You can select multiple accounts in one go, and if you want to break down the data by account, add ‘accountName’ to fields. |
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 | ReportOptions | No | - | Additional options for the report. |
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) 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. |
FilterItem
| 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. Can be a string, number, regex, or a list of strings. |
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’ |
ReportOptions
| 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. |
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 (e.g., ‘Clicks’ instead of ‘clicks’).
Fields: dynamic (depend on the inputs)
Example:
[
{
"campaignName": "Summer Sale",
"clicks": 150,
"impressions": 5000,
"cost": 75.0
}
]